Results for “invproc_exchange_rate”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view PA_CUST_EVENT_REV_DIST_LINES_V is an Oracle E-Business Suite Projects (PA) single-org view owned by the APPS schema. It exposes customer event revenue distribution lines generated by the Revenue Processing (RevProc) and Invoicing Processing (InvProc) engines. In ETRM 12.1.1 and 12.2.2 the object is documented as VALID and resolves to a single organization context, meaning ORG_ID is carried as a column rather than being supplied implicitly through a multi-org secured synonym.

The view is primarily consumed by revenue and invoicing reporting, reconciliation, and integration routines that need to inspect the currency, rate type, rate date, and exchange rate values applied when amounts were converted between the bill transaction, revenue processing, invoicing processing, project, project functional, and funding currencies. For users searching on revproc_rate_type, this view is the repository of that attribute, surfaced as REVPROC_RATE_TYPE and accompanied by the related RevProc currency, rate date, and exchange rate columns.

Underlying Base Objects

The documented base objects referenced by this view are:

• PA_CUST_EVENT_REV_DIST_LINES (SYNONYM) — the primary source of customer event revenue distribution lines.
• PA_MULTI_CURRENCY (PACKAGE) — invoked through PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE to translate the stored user conversion type into a displayable rate type value.

The view is essentially a projection over PA_CUST_EVENT_REV_DIST_LINES, with selected columns passed through unchanged and several rate type columns wrapped by the multi-currency package function. The synonym supplies the physical distribution line attributes, while the package supplies the derivation logic for user-facing conversion type descriptions. No joins to additional tables are documented in the supplied excerpt; currency rate data is therefore assumed to be denormalized onto the distribution line itself.

Key Columns

• REVPROC_RATE_TYPE, REVPROC_CURRENCY_CODE, REVPROC_RATE_DATE, REVPROC_EXCHANGE_RATE — the revenue processing currency conversion context, including the rate type the user searched for.
• INVPROC_RATE_TYPE, INVPROC_CURRENCY_CODE, INVPROC_RATE_DATE, INVPROC_EXCHANGE_RATE — the invoicing processing conversion context.
• PROJECT_REV_RATE_TYPE, PROJFUNC_REV_RATE_TYPE, FUNDING_REV_RATE_TYPE — project, project functional, and funding currency rate types. Each is also exposed through PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE for readable output.
• REVTRANS_AMOUNT, REVTRANS_CURRENCY_CODE, REVPROC_REVTRANS_RATE_TYPE — revenue transaction currency amounts and their associated rate type.
• PROJECT_ID, TASK_ID, EVENT_NUM, LINE_NUM, ORG_ID — identifiers linking each line to its project, task, event, and operating unit.
• CODE_COMBINATION_ID, AMOUNT, DRAFT_REVENUE_NUM, DRAFT_INVOICE_NUM, BATCH_NAME, REVERSED_FLAG, LINE_NUM_REVERSED — accounting distribution, amounts, and reversal tracking.
• OUTPUT_VAT_TAX_ID, OUTPUT_TAX_CLASSIFICATION_CODE, OUTPUT_TAX_EXEMPT_FLAG — tax output attributes for the distribution line.
• RETENTION_RULE_ID, RETAINED_AMOUNT, RETN_DRAFT_INVOICE_NUM — retention handling.

Common Use Cases and Queries

Typical usage includes reconciling revenue processing conversion rates, auditing which rate type was applied to a distribution line, and feeding downstream revenue extracts.

• Retrieve RevProc rate type and rates for a project:

  SELECT project_id, event_num, line_num, revproc_currency_code,
         revproc_rate_type, revproc_rate_date, revproc_exchange_rate
  FROM   apps.pa_cust_event_rev_dist_lines_v
  WHERE  project_id = :project_id;

• Compare RevProc and InvProc rate types on the same line:

  SELECT event_num, line_num, revproc_rate_type, invproc_rate_type,
         project_rev_rate_type, funding_rev_rate_type
  FROM   apps.pa_cust_event_rev_dist_lines_v
  WHERE  org_id = :org_id
  AND    reversed_flag = 'N';

• Report user-facing conversion types using the package wrapper:

  SELECT project_id, project_rev_rate_type,
         pa_multi_currency.get_user_conversion_type(project_rev_rate_type) display_type
  FROM   apps.pa_cust_event_rev_dist_lines_v;

Because the view carries ORG_ID, queries should filter by operating unit where multi-org isolation is required.