Search Results source_percent




Overview
Explore in AI Chat

Overview

PA_ALLOC_AUDIT_GL_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) product family. It presents audit-level detail for General Ledger allocation runs executed within Oracle Projects, joining allocation run header information to the individual General Ledger detail lines produced by each run. The view is read-only and does not store data; it consolidates columns from two underlying allocation tables into a single denormalized result set suitable for inquiry screens, concurrent program output, and ad hoc reporting.

The view is particularly relevant to users searching on the column SOURCE_PERCENT, which is exposed directly by this view. Because the view flattens run-level attributes (such as pool percentage and organization identifier) against line-level attributes (such as source account, allocated amount, eligible amount, and source percentage), it provides a convenient single source for tracing how an allocation run distributed cost and revenue across General Ledger accounts.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base objects, both referenced through APPS synonyms:

The two objects are related with an inner join on RUN_ID (PAR.RUN_ID = PAGD.RUN_ID), meaning a row is returned only when a matching allocation run header exists for the detail line. Since the view is a simple two-table join with no aggregation, row cardinality equals the number of qualifying detail rows in PA_ALLOC_RUN_GL_DET. The definition is identical in Oracle EBS 12.1.1 and 12.2.2; the view carries a VALID status and is not among the objects affected by the multi-organization (MOAC) changes beyond the ORG_ID column already exposed.

Key Columns

  • RUN_ID — Identifier of the allocation run; the join key between header and detail.
  • LINE_NUM — Sequence number of the allocation detail line within the run.
  • SOURCE_CCID — Code combination identifier of the source account from which the allocation draws amounts. Joins to GL_CODE_COMBINATIONS for account derivation.
  • AMOUNT — Allocated amount posted to the target account for the line.
  • SOURCE_PERCENT — Percentage of the source amount that this line represents, used to audit the proportional basis applied to the source pool or source account.
  • POOL_PERCENT — Pool-level percentage carried from the allocation run header, indicating the share attributed to the run's pool.
  • ELIGIBLE_AMOUNT — Portion of the source balance considered eligible for allocation before distribution.
  • SUBTRACT_FLAG — Indicator of whether the line amount is subtracted from, rather than added to, the allocation basis.
  • ORG_ID — Operating unit identifier from PA_ALLOC_RUNS, supporting multi-organization data access.

Common Use Cases and Queries

The view is typically used to audit allocation run results, reconcile Projects allocations to General Ledger, and investigate how SOURCE_PERCENT and POOL_PERCENT combined to produce a given allocated amount. A representative query filtering on the column named in the search follows:

  • Audit a specific run: SELECT run_id, line_num, source_ccid, amount, source_percent, pool_percent, eligible_amount FROM pa_alloc_audit_gl_v WHERE run_id = :p_run_id ORDER BY line_num;
  • Review percentage distribution across lines: SELECT line_num, source_percent, pool_percent, amount FROM pa_alloc_audit_gl_v WHERE run_id = :p_run_id AND source_percent IS NOT NULL;
  • Multi-organization reporting: SELECT org_id, run_id, SUM(amount) FROM pa_alloc_audit_gl_v GROUP BY org_id, run_id;
  • Identify subtractive lines: SELECT run_id, line_num, amount FROM pa_alloc_audit_gl_v WHERE subtract_flag = 'Y';

Because the view exposes no operating unit context beyond ORG_ID and no ledger identifier of its own, joins to PA_ALLOC_RUNS, GL_CODE_COMBINATIONS, and GL_JE_LINES are commonly added when full accounting context is required.