Search Results pa_cc_dist_lines_n2

Overview

PA.PA_CC_DIST_LINES_ALL is the core distribution-line table in the Oracle EBS Projects (PA) module that stores the accounting distributions generated by the cross-charge and transfer-price process. Each row represents a single debit or credit line produced when an expenditure is transferred between projects, tasks, or organizations using a cross-charge code, along with the transfer price, exchange-rate, and rate-type details used to value that transfer. The table is registered as a multi-org view (via ORG_ID) and resides in the APPS_TS_TX_DATA tablespace in both 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined FK structure classifies this object as satellite-leaning: it primarily carries descriptive and transactional attributes about a parent expenditure item rather than acting as an independent hub or as a pure many-to-many link.

Key Information Stored

The surrogate primary key is CC_DIST_LINE_ID. Two unique indexes define business-key candidates: PA_CC_DIST_LINES_U1 on CC_DIST_LINE_ID, and PA_CC_DIST_LINES_U2 on the concatenation (EXPENDITURE_ITEM_ID, LINE_TYPE, LINE_NUM). The presence of U2 is significant because a user searching on "pa_cc_dist_lines_u2" is typically tracing a uniqueness violation or examining how a single expenditure item is partitioned into distribution lines by type and sequence.

• CC_DIST_LINE_ID – surrogate PK for the distribution line.
• EXPENDITURE_ITEM_ID – FK to PA_EXPENDITURE_ITEMS_ALL; the expenditure item being distributed.
• LINE_NUM / LINE_TYPE – sequence and category of the distribution line; jointly part of the U2 business key.
• CROSS_CHARGE_CODE – the cross-charge rule applied to this line.
• AMOUNT / TP_BASE_AMOUNT – distributed amount and the transfer-price base amount.
• ACCT_CURRENCY_CODE, ACCT_TP_RATE_TYPE, ACCT_TP_RATE_DATE, ACCT_TP_EXCHANGE_RATE – accounting currency and the rate used to convert the transfer price.
• DR_CODE_COMBINATION_ID / CR_CODE_COMBINATION_ID – GL debit and credit accounts (FK to GL_CODE_COMBINATIONS).
• PROJECT_ID / TASK_ID – receiving project and task (FK to PA_PROJECTS_ALL and PA_TASKS).
• TRANSFER_STATUS_CODE, TRANSFERRED_DATE, TRANSFER_REJECTION_CODE – status of the transfer to GL, date transferred, and any rejection reason.
• REQUEST_ID, ACCT_EVENT_ID, GL_BATCH_NAME, GL_DATE, PA_DATE – process linkage and accounting/GL dates.
• ORG_ID – operating unit used by the multi-org view.

Common Use Cases and Queries

Typical scenarios include reconciling cross-charge distributions to expenditure items, diagnosing transfer-to-GL failures, and reporting transfer-price amounts by project or task. The nonunique index PA_CC_DIST_LINES_N2 (REQUEST_ID, TRANSFER_STATUS_CODE) supports status-based batch retrieval, while PA_CC_DIST_LINES_N1 (PROJECT_ID, TASK_ID) supports project reporting.

• Retrieve all distribution lines for an expenditure item, honoring the U2 key: SELECT * FROM pa_cc_dist_lines_all WHERE expenditure_item_id = :item_id ORDER BY line_type, line_num;
• Find untransferred or rejected lines: SELECT * FROM pa_cc_dist_lines_all WHERE transfer_status_code IN ('P','R') AND request_id = :request_id;
• Reconcile to GL accounts via joins on DR/CR_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS.
• Investigate U2 duplicate-key errors by grouping on (EXPENDITURE_ITEM_ID, LINE_TYPE, LINE_NUM) with HAVING COUNT(*) > 1.

Related Objects

Key dependencies and referencing objects, with join columns, include:

• PA_EXPENDITURE_ITEMS_ALL via EXPENDITURE_ITEM_ID (parent expenditure item).
• PA_PROJECTS_ALL via PROJECT_ID and PA_TASKS via TASK_ID.
• GL_CODE_COMBINATIONS via DR_CODE_COMBINATION_ID and CR_CODE_COMBINATION_ID.
• GL_DAILY_CONVERSION_TYPES via ACCT_TP_RATE_TYPE and related rate-type columns.
• FND_CURRENCIES via ACCT_CURRENCY_CODE, DENOM_TP_CURRENCY_CODE, PROJECT_TP_CURRENCY_CODE, and PROJFUNC_TP_CURRENCY_CODE.
• PER_JOBS via TP_JOB_ID.
• PA_CC_DIST_LINES_AR, PA_MC_CC_DIST_LINES_ALL, and PA_MC_CC_DIST_LINES_AR, which all reference CC_DIST_LINE_ID as child audit/multi-currency tables.