MSC_ATP_ORDER_PROMISING

This table stores the header information of the payloads of GOP flows.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_ATP_ORDER_PROMISING_PK

UNIQUE_ORDER_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
UNIQUE_ORDER_NUMBER VARCHAR2 32 Yes Header level attribute that indicates the unique order identifier for the request.
CALLING_MODULE VARCHAR2 32 A string that indicates the identifier of the module from which the order promising service request originated.
CALLING_INSTANCE VARCHAR2 32 A string that indicates the unique identifier of the source system from which the order promising service request originated.
RELEASE_NUMBER VARCHAR2 32 The release number of the Oracle Fusion Distributed Order Orchestration application that is invoking Oracle Fusion Global Order Promising services.
PROMISE_DATE DATE A date and time when the promise is generated by DOO-OP.
PROMISING_SYSTEM VARCHAR2 32 A string identifier for the order promising system that performed the availability check.
PROMISING_INSTANCE VARCHAR2 32 Unique identifier for the source system in which order promising is performed.
SALES_ORDER_NUMBER VARCHAR2 64 A string unique identifier for the sales order for which the fulfillment line is created.
NUMBER_OF_ALT_OPTIONS NUMBER A number that indicates the total number of availability options generated for the fulfillment line service request.
REQUESTED_CREATION_DATE DATE Date and time when the check availability request was created for the fulfillment line.
SET_IDENTIFIER VARCHAR2 32 A string unique identifier for the fulfillment line set.
ROOT_PARENT_FULFILL_ID VARCHAR2 64 Response attribute that indicates the unique fulfillment line identifier for the root parent CTO model. Applicable only for configured to order items.
SET_TYPE VARCHAR2 32 A string that indicates the type of fulfillment line set sent for promising. The valid values are ship, arrival, pickup and consolidation. Only ship sets are currently supported.
MODEL_TYPE VARCHAR2 32 Contains one of the following ATO, PTO-SMC, PTO-NSMC. A string that indicates they type of configure to order communicated in the service request.
OPERATION_NAME VARCHAR2 255 A string that indicates the type of request that needs to be performed for the fulfillment line.
EXPECTED_GROUP_SHIP_DATE DATE A date attribute that indicates the date on which the set of fulfillment lines are expected to be shipped together from the shipping organization.
EXPECTED_GROUP_ARRIVAL_DATE DATE A date attribute that indicates the date on which the set of fulfillment lines are expected to arrive at the customer ship-to site.
ERROR_CODE VARCHAR2 10 A string that indicates the error code returned by Oracle Fusion Global Order Promising for the fulfillment line availability request.
ERROR_MESSAGE VARCHAR2 255 ErrorMessages of corresponding ErrorCode.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ENGINE_NAME VARCHAR2 6 This column is used to capture the system by which the request is processed
IS_PROCESSED NUMBER 1 This column is used to mark the records which needs to be picked by ESS job for processing .

Indexes

Index Uniqueness Tablespace Columns
MSC_ATP_ORDER_PROMISING_U1 Unique Default UNIQUE_ORDER_NUMBER
MSC_ATP_ORDER_PROMISING_N1 Non Unique Default LAST_UPDATE_DATE