Search Results pa_cc_dist_lines_all




Overview
Explore in AI Chat

Overview

PA_CC_DIST_LINES_ALL is the Oracle Projects (PA) table that stores accounting distribution information related to transfer pricing for cross-charged expenditure items. Cross charging allows one project or task to recover the cost of expenditure items from another, and the transfer price mechanism applies a markup or rate to the recovered amount. This table records the resulting debit and credit accounting entries, the transfer price components, currency conversion details, and the intercompany or inter-project distribution lines that will ultimately be transferred to Oracle General Ledger.

In Oracle EBS 12.1.1 and 12.2.2 the table resides in the PA schema and is central to the Cross Charge Distribution and transfer price accounting process. The ETRM metadata characterizes this object with a heuristic Data Vault classification of satellite-leaning. In Data Vault modeling terms this suggests the table behaves primarily as a descriptive satellite attached to the expenditure item business key, though its numerous foreign keys to projects, tasks, currency, and accounting objects mean it also carries link-like relationships that should be modeled carefully rather than as a pure hub.

Key Information Stored

The table contains sixty-one documented columns. The most significant are outlined below.

Common Use Cases and Queries

Typical use cases include auditing cross-charge accounting entries, reconciling transfer price amounts against expenditure items, and monitoring the status of lines pending transfer to GL. A common query retrieves distribution lines for a specific expenditure item:

  • SELECT cc_dist_line_id, line_num, line_type, amount, dr_code_combination_id, cr_code_combination_id FROM pa.pa_cc_dist_lines_all WHERE expenditure_item_id = :p_item_id ORDER BY line_num;
  • Querying by TRANSFER_STATUS_CODE identifies lines not yet interfaced or those rejected during transfer to General Ledger.
  • Joining to PA_PROJECTS_ALL and PA_TASKS to report transfer price distributions by project and task reconciles the receiving project's cross-charge recoveries.

Related Objects

The following objects are most significant for joining and understanding this table.