Category Archives: API’s/Interfaces

Create Items (SKU’s) and Revisions using MTL_SYSTEM_ITEMS_INTERFACE

Create Item and Item Revisions using MTL_SYSTEM_ITEMS_INTERFACE

Interface Tables used:

  • MTL_SYSTEM_ITEMS_INTERFACE: temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.

Continue reading

Related posts:

Split Delivery Detail API

Standard API to Split the Delivery detail:

 

Related posts:

Auto create Delivery using WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES

Auto create Delivery

Auto Create a delivery for a Delivery Detail.

Find the delivery detail id from the booked sales order line and pass as a parameter.

Sample script to Auto create deliveries:

Script to verify the script:

 

Related posts:

Debugging Shipping API’s

Debugging Shipping API’s:

Debugging Shipping API:

In some cases the API’s may not be successful might be because of setup issues or code issues.
In such cases calling the shipping debugger package(WHS_DEBUG_SV) in the wrapper file will result in the creation of a detailed debug log file based on the various debug profiles setup for shipping module  .
The steps given below will show the step by step approach to generate debug log file during the call to Shipping Public API’s.

Add the following lines into the Wrapper file  before making a call to the shipping:

 Sample API Code with Debug ON:

 

Set the Profiles
OM: Debug Level – set to 5
      INV: Debug Level – set to 10
      WSH: Debug Enabled – set to Yes
      WSH: Debug Level – set to Statement
      WSH: Debug Log Directory – set to a valid writeable directory path

Execute the shipping action via API

Navigate  to the respective directories specified using the profile
“WSH: Debug Log Directory”

Obtain the Debug

Referred from Oracle Metalink.

 

Related posts: