Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definitions (IS-to-Oracle 10.7SC) | INVDemand
 
INVDemand
Use this transaction to integrate an external Order Entry with an Oracle Applications Inventory. You can add a demand, add and modify a reservation, query the on‐hand quantity, change available quantities to reserve quantities, change available quantities to promised quantities, and reserve on‐hand quantities.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory.
Open Interface
Demand Transaction.
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
*MTL_DEMAND_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
*MTL_DEMAND_INTERFACE
*MFG_LOOKUPS
*FND_USER
Inputs
Field
Description
WM_USER
User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction.
Outputs
Field
Description
SCHEDULE_GROUP_ID
Group ID.
DEMAND_SOURCE_TYPE
Origination of the demand or reservation (e.g. 2‐Sales Order).
ACTION_CODE
Code used to identify what action has to be taken with this record.
ORGANIZATION_ID
Organization ID.
INVENTORY_ITEM_ID
Item ID.
ERROR
Error message.
USER_NAME
User name.
Usage Comments
*To import demand information, run the Process Demand Interface request, which is under the Background module.
*In MTL_DEMAND_INTERFACE there are cases when an error_code is generated that does not provide an error_explanation.