DPP — Oracle Price Protection
23 documented tables · 9 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
DPP_LOG_MESSAGES |
This table will be used to log debug messages | standalone |
DPP_TXN_HEADERS_INT_ALL |
This interface table will store the Price Protection Transaction header level details received from the suppli | standalone |
DPP_TRANSACTION_CLAIMS_ALL |
This table will link the Trade Management claims to Price Protection Transaction. | standalone |
DPP_TRANSACTION_LINES_ALL |
This table will store the Price Protection Transaction Line level details | standalone |
DPP_XLA_LINES |
This table will be used to store transaction extract lines information | standalone |
DPP_TRANSACTION_LINES_LOG |
This table will store history information for the Price Protection Transaction Line level details. | standalone |
DPP_CUSTOMER_CLAIMS_ALL |
This table will store the customer inventory & claim information for a Price Protection Transaction. | standalone |
DPP_TRANSACTION_STATUS_MAP |
This seeded table will store the mapping of transaction statuses for the purpose of allowing correct transacti | standalone |
DPP_APPROVAL_ACCESS |
This table will be used to manage approval access | standalone |
DPP_TRANSACTION_HEADERS_ALL |
This table will store the Price Protection Transaction Header level details | standalone |
DPP_XLA_HEADERS |
This table will be used to store transaction extract header information. | standalone |
DPP_INVENTORY_DETAILS_ADJ_ALL |
This table will store the information inventory receipts for all Products on the Transaction. | standalone |
DPP_EXECUTION_PROCESSES |
This table stores the list of all DPP processes | standalone |
DPP_TXN_LINES_INT_ALL |
This interface table will store the Price Protection Transaction line level details received from the supplier | standalone |
DPP_TRANSACTION_HEADERS_LOG |
This table will store history information for changes done to the Price Protection Transaction Header. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
DPP_XLA_EVENT_PUB |
PUB | 6 | 4 packages |
DPP_SLA_CLAIM_EXTRACT_PUB |
PUB | 1 | 1 packages |
DPP_EXECUTIONPROCESS_PUB |
PUB | 1 | 0 packages |
DPP_VENDORMERGE_GRP |
GRP | 1 | 0 packages |
DPP_TRANSACTION_PUB |
PUB | 0 | 0 packages |