DPP Tables (23)
DPP - Oracle Price Protection — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
DPP_APPROVAL_ACCESS |
17 | This table will be used to manage approval access |
DPP_CUSTOMER_CLAIMS_ALL |
58 | This table will store the customer inventory & claim information for a Price Protection Transaction. |
DPP_CUSTOMER_CLAIMS_GT |
14 | |
DPP_CUSTOMER_CLAIMS_LOG |
52 | This table will store updates to the customer claim information for a Price Protection Transaction |
DPP_EXECUTION_DETAILS |
18 | |
DPP_EXECUTION_PROCESSES |
7 | This table stores the list of all DPP processes |
DPP_INVENTORY_DETAILS_ADJ_ALL |
46 | This table will store the information inventory receipts for all Products on the Transaction. |
DPP_INVENTORY_DETAILS_ALL |
48 | This table will store the Covered Inventory breakup by warehouse details for all products on the Transaction. |
DPP_LOG_MESSAGES |
2 | This table will be used to log debug messages |
DPP_NOTIFICATION_BLOBS |
9 | This table will store the notification attachments |
DPP_OUTPUT_XML_GT |
13 | |
DPP_TRANSACTION_CLAIMS_ALL |
11 | This table will link the Trade Management claims to Price Protection Transaction. |
DPP_TRANSACTION_HEADERS_ALL |
61 | This table will store the Price Protection Transaction Header level details |
DPP_TRANSACTION_HEADERS_LOG |
52 | This table will store history information for changes done to the Price Protection Transaction Header. |
DPP_TRANSACTION_LINES_ALL |
72 | This table will store the Price Protection Transaction Line level details |
DPP_TRANSACTION_LINES_GT |
2 | |
DPP_TRANSACTION_LINES_LOG |
58 | This table will store history information for the Price Protection Transaction Line level details. |
DPP_TRANSACTION_STATUS_MAP |
9 | This seeded table will store the mapping of transaction statuses for the purpose of allowing correct transaction status changes |
DPP_TXN_HEADERS_INT_ALL |
63 | This interface table will store the Price Protection Transaction header level details received from the supplier |
DPP_TXN_LINES_INT_ALL |
57 | This interface table will store the Price Protection Transaction line level details received from the supplier. |
DPP_XLA_EVENT_MAP |
10 | This table will be used as a lookup table during regular Price Protection SLA accounting process to determine what XLA event class and type |
DPP_XLA_HEADERS |
10 | This table will be used to store transaction extract header information. |
DPP_XLA_LINES |
10 | This table will be used to store transaction extract lines information |