QP_MASS_ACTION_REQ_DETAILS

This table stores the entity details of the records processed by the mass action request definition in Pricing.

Details

  • Schema: FUSION

  • Object owner: QP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

QP_MASS_ACTION_REQ_DETAILS_PK

MASS_ACT_REQ_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
MASS_ACT_REQ_DETAIL_ID NUMBER 18 Yes Value that uniquely identifies the mass action request detail. Oracle Fusion Pricing automatically assigns this value.
MASS_ACTION_REQUEST_ID NUMBER 18 Yes Value that uniquely identifies the mass action request. Oracle Fusion Pricing automatically assigns this value.
MASS_ACTION_REQUEST_NUMBER NUMBER 18 Yes Indicates the sequence number for the mass action. Oracle Fusion Pricing automatically assigns this value.
DETAIL_ENTITY_TYPE_CODE VARCHAR2 30 Yes Abbreviation that indicates the pricing detail entity for the mass action. A list of valid values include ORA_PRICE_LIST_ITEM, ORA_PRICE_LIST_CHARGE. The accepted values are defined in the lookup type ORA_QP_DETAIL_ENTITY_TYPES.
DETAIL_ENTITY_KEY_COLUMN1 NUMBER 18 Yes Indicates the first key entity that mass action has to act on.
DETAIL_ENTITY_KEY_COLUMN2 NUMBER 18 Indicates the second key entity that mass action has to act on.
DETAIL_ENTITY_KEY_COLUMN3 NUMBER 18 Indicates the third key entity that mass action has to act on.
DETAIL_ENTITY_KEY_COLUMN4 NUMBER 18 Indicates the fourth key entity that mass action has to act on.
DETAIL_ENTITY_KEY_COLUMN5 NUMBER 18 Indicates the fifth key entity that mass action has to act on.
VALUE_STRING1 VARCHAR2 100 Indicates string value of mass action. Like in UOM conversion mass action, it stores the UOM it has to convert to.
VALUE_STRING2 VARCHAR2 100 Indicates the second string value for mass action. It is for future use.
ESS_CHILD_PROCESS_ID NUMBER 18 Value that indicates the ESS process identifier that is executing the mass action.
BATCH_ID NUMBER 9 Value that indicates the batch identifier that will be processed for mass action.
ACTION_STATUS_CODE VARCHAR2 30 Abbreviation that indicates status of the action performed on the pricing entity. A list of valid values include ORA_SUCCESS, ORA_ERROR, ORA_WARNING. The accepted values are defined in the lookup type ORA_QP_ACTION_STATUS_CODE.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.

Indexes

Index Uniqueness Tablespace Columns
QP_MASS_ACTION_REQ_DETAILS_N1 Non Unique DEFAULT ESS_CHILD_PROCESS_ID
QP_MASS_ACTION_REQ_DETAILS_N2 Non Unique DEFAULT MASS_ACTION_REQUEST_NUMBER, BATCH_ID
QP_MASS_ACTION_REQ_DETAILS_N3 Non Unique DEFAULT DETAIL_ENTITY_TYPE_CODE, DETAIL_ENTITY_KEY_COLUMN1, DETAIL_ENTITY_KEY_COLUMN2, DETAIL_ENTITY_KEY_COLUMN3, DETAIL_ENTITY_KEY_COLUMN4, DETAIL_ENTITY_KEY_COLUMN5
QP_MASS_ACTION_REQ_DETAILS_U1 Unique DEFAULT MASS_ACT_REQ_DETAIL_ID