Results for “accumulated_flag”

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

Overview

PA_DRAFT_REVENUES_ALL_MRC_V2 is a multi-org, single-currency view owned by the APPS schema in Oracle E-Business Suite, belonging to the Projects (PA) product family. In Oracle EBS 12.1.1 and 12.2.2, the view presents draft revenue records maintained in the operating unit's functional currency after conversion from the reporting set of books. Its name reflects its role: "MRC" denotes Multi-Reporting Currency, while "V2" designates a later-generation view aligned with the multi-org architecture introduced in Release 12. The view is a reporting and integration access point rather than a transactional store; no direct DML should be performed against it. Because the WHERE clause restricts rows by SET_OF_BOOKS_ID derived from USERENV('CLIENT_INFO'), the view returns only the currency-denominated rows appropriate to the reporting context established by the session. Multiple organizations are supported through the PA_DRAFT_REVENUES_ALL base table, which carries the ORG_ID column.

Underlying Base Objects

The view is defined over two APPS synonyms: PA_DRAFT_REVENUES_ALL and PA_MC_DRAFT_REVS_ALL. PA_DRAFT_REVENUES_ALL stores the base draft revenue records in the functional currency of the operating unit, including the accounting attributes required for subledger accounting and General Ledger transfer. PA_MC_DRAFT_REVS_ALL stores the multicurrency counterpart records keyed by set of books, holding the converted amounts, transferred status, batch names, and realized gain/loss information. The join is performed on PROJECT_ID and DRAFT_REVENUE_NUM, matching one converted record to its base draft revenue row. The joined SET_OF_BOOKS_ID is constrained by NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-99), which extracts the reporting set of books from the session client information. The view therefore does not expose conversion-rate detail directly; it exposes the resulting balances and the reconciliation attributes maintained on both sides of the join.

Key Columns

Identifying and control columns include PROJECT_ID, DRAFT_REVENUE_NUM, ORG_ID, EVENT_ID, and DRAFT_REVENUE_NUM_CREDITED. Accounting columns include UNBILLED_RECEIVABLE_DR and UNEARNED_REVENUE_CR for the unconverted side, UNBILLED_CODE_COMBINATION_ID and UNEARNED_CODE_COMBINATION_ID for the base-side code combinations, and REALIZED_GAINS_CCID and REALIZED_LOSSES_CCID for the converted side, with corresponding REALIZED_GAINS_AMOUNT and REALIZED_LOSSES_AMOUNT. Period and date columns include PA_DATE, GL_DATE, ACCRUE_THROUGH_DATE, RELEASED_DATE, GL_PERIOD_NAME, and PA_PERIOD_NAME. Processing status is carried by TRANSFER_STATUS_CODE, TRANSFER_REJECTION_REASON, TRANSFERRED_DATE, GENERATION_ERROR_FLAG, RESOURCE_ACCUMULATED_FLAG, ACCUMULATED_FLAG, ADJUSTING_REVENUE_FLAG, PJI_SUMMARIZED_FLAG, and the column for which this object is frequently queried: UBR_UER_PROCESS_FLAG. UBR_SUMMARY_ID and UER_SUMMARY_ID link to the unbilled receivable and unearned revenue summary records. MC-side columns such as UNBILLED_BATCH_NAME and REALIZED_GAINS_BATCH_NAME identify the General Ledger interface batches. Concurrency columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY are present, though LAST_UPDATE_LOGIN in this view reflects the MC record.

Common Use Cases and Queries

The view is typically queried to reconcile converted draft revenue in a reporting currency, to review the processing state of unbilled receivable and unearned revenue generation, and to audit transfer activity into General Ledger. A representative query filtering on the process flag is:

• SELECT PROJECT_ID, DRAFT_REVENUE_NUM, UBR_SUMMARY_ID, UER_SUMMARY_ID, UBR_UER_PROCESS_FLAG, TRANSFER_STATUS_CODE FROM APPS.PA_DRAFT_REVENUES_ALL_MRC_V2 WHERE PROJECT_ID = :project_id ORDER BY DRAFT_REVENUE_NUM;
• SELECT DRAFT_REVENUE_NUM, UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR, REALIZED_GAINS_AMOUNT, REALIZED_LOSSES_AMOUNT FROM APPS.PA_DRAFT_REVENUES_ALL_MRC_V2 WHERE GL_PERIOD_NAME = :period AND ORG_ID = :org_id;
• SELECT DRAFT_REVENUE_NUM, TRANSFER_REJECTION_REASON, UNBILLED_BATCH_NAME FROM APPS.PA_DRAFT_REVENUES_ALL_MRC_V2 WHERE TRANSFER_STATUS_CODE = 'R' AND GENERATION_ERROR_FLAG = 'Y';

Since the SET_OF_BOOKS_ID predicate derives from CLIENT_INFO, queries should be issued through sessions where the reporting context is correctly initialized, typically via the standard EBS responsibility or by explicitly setting CLIENT_INFO before executing the query.