Search Results qp_debug_req_ldets

Overview

QP_DEBUG_REQ_LDETS is a table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores debugging and trace information about the line details processed by the pricing engine during a pricing request. Each row corresponds to a single line detail generated or evaluated while pricing an order, quote, or other pricing document, and the table captures the adjustments and discounts applied to that line — including adjustments and discounts that the pricing engine ultimately eliminates from the final price. As a result, the table is diagnostic in nature: it records the full evaluation path of the pricing engine rather than only the surviving, applied modifiers.

From a Data Vault modeling perspective, the FK structure suggests this table behaves as a link: it associates a pricing request (via REQUEST_ID) with list headers, list lines, price formulas, and pricing phases, recording the relationships and evaluation results that occur between those entities at pricing time. It is not a hub of independent business entities, nor a pure satellite, because each row ties together several distinct referenced objects in a transactional context.

Key Information Stored

The table is documented with 53 columns in ETRM 12.2.2. The most significant columns are:

REQUEST_ID — identifies the pricing debug request to which the row belongs; the primary grouping key for any query.
LINE_DETAIL_INDEX — sequence/index of the line detail within the request.
LINE_DETAIL_TYPE_CODE and LINE_INDEX — classify the detail and tie it to the originating document line.
CREATED_FROM_LIST_HEADER_ID and CREATED_FROM_LIST_LINE_ID — the price list header and line from which the modifier was derived.
CREATED_FROM_LIST_LINE_TYPE and CREATED_FROM_LIST_TYPE_CODE — the type context of the source list line.
ADJUSTMENT_AMOUNT and OPERAND_VALUE — the calculated adjustment and the operand used.
LINE_QUANTITY, GROUP_QUANTITY, and GROUP_AMOUNT — quantities and amounts used in qualification and benefit calculation.
PRICE_FORMULA_ID and PRICING_PHASE_ID — the formula and phase under which the detail was evaluated.
APPLIED_FLAG, PRICING_STATUS_CODE, and PRICING_STATUS_TEXT — whether the modifier survived, and its status/reason.
PROCESSED_FLAG, UPDATED_FLAG, and AUTOMATIC_FLAG, OVERRIDE_FLAG — processing-state indicators used during engine execution.

No surrogate single-column primary key is documented in the provided metadata; the practical composite identity is (REQUEST_ID, LINE_DETAIL_INDEX) together with the line context. Business-key candidates are the FK columns linking to QP_LIST_HEADERS_B and QP_LIST_LINES, which identify the source list and line.

Common Use Cases and Queries

Typical uses include troubleshooting why a promotion or discount did not apply, auditing which modifiers were eliminated and why, and reproducing the pricing engine's evaluation logic for a given order. A common access pattern filters by REQUEST_ID and joins to source lists:

SELECT d.REQUEST_ID, d.LINE_INDEX, d.LINE_DETAIL_TYPE_CODE, d.ADJUSTMENT_AMOUNT, d.APPLIED_FLAG, d.PRICING_STATUS_TEXT FROM QP.QP_DEBUG_REQ_LDETS d WHERE d.REQUEST_ID = :request_id ORDER BY d.LINE_DETAIL_INDEX;
Join to QP_LIST_HEADERS_B and QP_LIST_LINES on CREATED_FROM_LIST_HEADER_ID and CREATED_FROM_LIST_LINE_ID to resolve the originating price list and line.
Join to QP_PRICE_FORMULAS_B on PRICE_FORMULA_ID and QP_PRICING_PHASES on PRICING_PHASE_ID to identify the formula and phase in effect.
Reporting: count of eliminated versus applied adjustments per request, using APPLIED_FLAG and PRICING_STATUS_CODE.

Related Objects

QP_LIST_HEADERS_B — referenced via QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_HEADER_ID.
QP_LIST_LINES — referenced via QP_DEBUG_REQ_LDETS.CREATED_FROM_LIST_LINE_ID.
QP_PRICE_FORMULAS_B — referenced via QP_DEBUG_REQ_LDETS.PRICE_FORMULA_ID.
QP_PRICING_PHASES — referenced via QP_DEBUG_REQ_LDETS.PRICING_PHASE_ID.
Pricing engine debug tables — companion QP_DEBUG_REQ_* objects that share REQUEST_ID and provide header- and request-level context.

These relationships make QP_DEBUG_REQ_LDETS a central diagnostic link for pricing evaluation, joining requests to the lists, formulas, and phases that determine applied adjustments and discounts.

Table: QP_DEBUG_REQ_LDETS 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_DEBUG_REQ_LDETS, object_name:QP_DEBUG_REQ_LDETS, status:VALID, product: QP - Advanced Pricing , description: This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates. , implementation_dba_data: QP.QP_DEBUG_REQ_LDETS ,
Table: QP_DEBUG_REQ_LDETS 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_DEBUG_REQ_LDETS, object_name:QP_DEBUG_REQ_LDETS, status:VALID, product: QP - Advanced Pricing , description: This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates. , implementation_dba_data: QP.QP_DEBUG_REQ_LDETS ,
View: QP_DEBUG_REQ_RLTD_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES_V, object_name:QP_DEBUG_REQ_RLTD_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the related lines. , implementation_dba_data: APPS.QP_DEBUG_REQ_RLTD_LINES_V ,
View: QP_DEBUG_REQ_RLTD_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES_V, object_name:QP_DEBUG_REQ_RLTD_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the related lines. , implementation_dba_data: APPS.QP_DEBUG_REQ_RLTD_LINES_V ,
View: QP_DEBUG_REQ_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_DEBUG_REQ_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
Table: QP_LIST_LINES 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_LINES, object_name:QP_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_LIST_LINES ,
Table: QP_LIST_LINES 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_LINES, object_name:QP_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_LIST_LINES ,
Table: QP_LIST_HEADERS_B 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_HEADERS_B, object_name:QP_LIST_HEADERS_B, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. , implementation_dba_data: QP.QP_LIST_HEADERS_B ,
Table: QP_LIST_HEADERS_B 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_HEADERS_B, object_name:QP_LIST_HEADERS_B, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. , implementation_dba_data: QP.QP_LIST_HEADERS_B ,