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.