Search Results gl_dr_amount

Overview

The PA_CC_GL_COST_XFER_AUDIT_V view in Oracle EBS (12.1.1 and 12.2.2) is a Projects (PA) module audit construct that reconciles cross charge cost distribution lines with their corresponding Oracle General Ledger accounting entries. Its documented description identifies it as a "View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger." It is owned by the APPS schema and is reported VALID.

The view answers a recurring reconciliation question: for every transferred cross charge distribution line, what amount was actually posted to each GL account? Because cross charge processing spans PA distribution lines, the Subledger Accounting (XLA) engine, and final GL journal entries, the view joins these layers into a single denormalized reporting surface. It is read-only, exposes no update semantics, and is consumed principally by audit reports, reconciliation extracts, and general ledger variance analysis. Users searching on "gl_dr_amount" reach this object because that column is the view's published debit amount, derived from XLA distribution links.

Underlying Base Objects

The documented metadata lists the following referenced objects, all synonyms in APPS except the noted view and package: GL_IMPORT_REFERENCES, GL_JE_HEADERS, GL_JE_LINES, HR_ALL_ORGANIZATION_UNITS_TL, HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PA_CC_DIST_LINES_ALL, PA_EXPENDITURES, PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_IMPLEMENTATIONS, PA_PROJECTS_ALL, PA_TASKS, PER_PEOPLE_F (view), XLA_ACCT_CLASS_ASSGNS, XLA_AE_HEADERS, XLA_AE_LINES, XLA_ASSIGNMENT_DEFNS_B, XLA_DISTRIBUTION_LINKS, and XLA_POST_ACCT_PROGS_B.

Functionally, PA_CC_DIST_LINES_ALL is the driving table, joined to PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_ITEMS_ALL, and PA_EXPENDITURES_ALL for project and expenditure context, and to PA_IMPLEMENTATIONS for the operating unit. The XLA tables (XLA_DISTRIBUTION_LINKS, XLA_AE_LINES, XLA_AE_HEADERS, XLA_ACCT_CLASS_ASSGNS, XLA_ASSIGNMENT_DEFNS_B, XLA_POST_ACCT_PROGS_B) link the PA distribution line to its subledger journal entry line and thus to the amount actually accounted. PER_PEOPLE_F, HR_ALL_ORGANIZATION_UNITS_TL, and the HR_GENERAL/HR_PERSON_NAME packages resolve the employee or organization associated with the line. GL_JE_HEADERS, GL_JE_LINES, and GL_IMPORT_REFERENCES provide the GL-side reconciliation path referenced in the view's purpose.

Key Columns

CC_DIST_LINE_ID / CC_DIST_LINE_NUM / CC_DIST_LINE_TYPE — Cross charge distribution line identity and type.
EXPENDITURE_ITEM_ID / EXPENDITURE_TYPE / EXPENDITURE_ITEM_DATE — Source expenditure context.
CODE_COMBINATION_ID — GL account combination from the XLA accounting line.
PROJECT_ID / PROJECT_NUMBER, TASK_ID / TASK_NUMBER — Project and task identifiers; the view filters PROJECT_NUMBER through SEGMENT1.
EMP_OR_ORG_NAME — Employee full name, falling back to organization name.
PERIOD_NAME, JE_HEADER_ID, JE_LINE_NUMBER — GL period and journal entry/line references.
GL_DATE / TRANSFERRED_DATE — Accounting date and transfer date of the distribution line.
GL_DR_AMOUNT / GL_CR_AMOUNT — Debit and credit amounts, sourced from XDL.UNROUNDED_ACCOUNTED_DR and XDL.UNROUNDED_ACCOUNTED_CR respectively. These are unrounded accounted values, so rounding differences against GL must be expected.

Common Use Cases and Queries

The dominant use case is cross charge audit by GL account — verifying that each transferred distribution line produced the expected debit or credit in GL. Because the view already constrains CCD.TRANSFER_STATUS_CODE to 'A' (accepted), CCD.ACCT_EVENT_ID IS NOT NULL, and the XLA post-accounting programs PA_POSTACCOUNTING_DEBIT/PA_POSTACCOUNTING_CREDIT with APPLICATION_ID 275, it returns only successfully accounted lines, which suits reconciliation rather than troubleshooting failed transfers.

Typical query pattern: SELECT project_number, task_number, expenditure_type, code_combination_id, gl_date, gl_dr_amount, gl_credit_amount FROM pa_cc_gl_cost_xfer_audit_v WHERE gl_dr_amount IS NOT NULL. Users commonly filter by period_name or project_number to reconcile a single GL period. A second pattern aggregates by code_combination_id to compare total debits against GL balances. A third selects lines where GL_DR_AMOUNT and GL_CR_AMOUNT are both zero or null to flag accounted lines lacking an amount. Because HR_SECURITY is among the referenced objects, row-level organization security may restrict results for non-privileged users.

View: PA_CC_GL_COST_XFER_AUDIT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CC_GL_COST_XFER_AUDIT_V, object_name:PA_CC_GL_COST_XFER_AUDIT_V, status:VALID, product: PA - Projects , description: View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger , implementation_dba_data: APPS.PA_CC_GL_COST_XFER_AUDIT_V ,
View: PA_GL_COST_AUDIT_REP_MRC_V 12.1.1
product: PA - Projects , description: View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger. This view shows the cost transactions in Oracle Projects and the corresponding GL Journal Entry batch numbers and , implementation_dba_data: Not implemented in this database ,
View: PA_GL_COST_AUDIT_REP_MRC_V 12.2.2
product: PA - Projects , description: View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger. This view shows the cost transactions in Oracle Projects and the corresponding GL Journal Entry batch numbers and , implementation_dba_data: Not implemented in this database ,
View: PA_GL_COST_XFER_AUDIT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_GL_COST_XFER_AUDIT_V, object_name:PA_GL_COST_XFER_AUDIT_V, status:VALID, product: PA - Projects , description: View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger. , implementation_dba_data: APPS.PA_GL_COST_XFER_AUDIT_V ,
View: PA_CC_GL_COST_AUDIT_REP_MRC_V 12.2.2
product: PA - Projects , description: View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger. This view shows the cross charge transactions in Oracle Projects for both GL Categories (Borrowed , implementation_dba_data: Not implemented in this database ,
View: PA_CC_GL_COST_AUDIT_REP_MRC_V 12.1.1
product: PA - Projects , description: View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger. This view shows the cross charge transactions in Oracle Projects for both GL Categories (Borrowed , implementation_dba_data: Not implemented in this database ,
View: PA_CC_GL_COST_XFER_AUDIT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CC_GL_COST_XFER_AUDIT_V, object_name:PA_CC_GL_COST_XFER_AUDIT_V, status:VALID, product: PA - Projects , description: View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger , implementation_dba_data: APPS.PA_CC_GL_COST_XFER_AUDIT_V ,
View: PA_GL_COST_XFER_AUDIT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_GL_COST_XFER_AUDIT_V, object_name:PA_GL_COST_XFER_AUDIT_V, status:VALID, product: PA - Projects , description: View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger. , implementation_dba_data: APPS.PA_GL_COST_XFER_AUDIT_V ,