Search Results receivable

The PA_UBR_UER_SUMM_ACCT table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Project Accounting (PA) module. It serves as a summary accounting table for Unbilled Receivables (UBR) and Unearned Revenue (UER) transactions, facilitating financial reporting, reconciliation, and revenue recognition processes. This table is part of Oracle's Project Foundation and plays a key role in tracking deferred revenue and unbilled amounts at a summarized level, ensuring accurate financial statements and compliance with accounting standards such as ASC 606 or IFRS 15. ### **Purpose and Functionality** The PA_UBR_UER_SUMM_ACCT table stores aggregated accounting entries for unbilled receivables and unearned revenue, which are essential for revenue recognition and accrual-based accounting. Unbilled Receivables (UBR) represent revenue earned but not yet invoiced, while Unearned Revenue (UER) refers to payments received in advance for services not yet rendered. This table consolidates transactional data from subsidiary tables like PA_TRANSACTIONS_INTERFACE, PA_CUST_REV_DIST_LINES_ALL, and PA_DRAFT_INVOICES_ALL, providing a summarized view for financial reporting. ### **Key Columns and Structure** The table includes columns that categorize and summarize financial data, such as: - PROJECT_ID: Links to the project in PA_PROJECTS_ALL. - TASK_ID: Associates with tasks in PA_TASKS. - EXPENDITURE_TYPE: Classifies revenue or cost types. - GL_PERIOD_NAME: Tracks the accounting period. - ACCOUNTED_AMOUNT: Stores the summarized accounting entry value. - CURRENCY_CODE: Specifies the transaction currency. - ORG_ID: Identifies the operating unit for multi-org setups. - REVENUE_CATEGORY_CODE: Distinguishes between UBR and UER entries. ### **Integration with Other Modules** The PA_UBR_UER_SUMM_ACCT table interacts with: 1. **General Ledger (GL):** Summarized entries are transferred via the PA_PERIOD_PROCESSING process for financial reporting. 2. **Accounts Receivable (AR):** Unbilled amounts are converted to invoices through the PA_INVOICE_GENERATION process. 3. **Revenue Management:** Supports revenue scheduling and recognition rules under ASC 606/IFRS 15. 4. **Subledger Accounting (SLA):** Ensures proper accounting entries are generated before posting to GL. ### **Process Flow** 1. **Transaction Entry:** Expenditures and revenue events are recorded in transactional tables. 2. **Summarization:** The PA_REVENUE_ACCRUAL process aggregates data into PA_UBR_UER_SUMM_ACCT. 3. **Revenue Recognition:** The PA_REV_ACC_RULES engine applies recognition rules. 4. **GL Transfer:** Summarized amounts are posted to GL via the PA_PERIOD_CLOSE process. ### **Customizations and Reporting** Organizations often create custom reports or BI extracts from this table to analyze deferred revenue, unbilled aging, and project profitability. Since it is a summary table, direct updates are rare; instead, data flows from underlying transaction tables. ### **Conclusion** The PA_UBR_UER_SUMM_ACCT table is a cornerstone of Oracle Project Accounting, ensuring accurate revenue recognition and financial compliance. Its integration with GL, AR, and SLA makes it indispensable for organizations managing project-based revenue and costs in Oracle EBS 12.1.1 and 12.2.2.

Lookup Type: INVOICE STATUS 12.2.2
product: PA - Projects , meaning: Invoice Status , description: Invoice Status ,
Lookup Type: INVOICE STATUS 12.1.1
product: PA - Projects , meaning: Invoice Status , description: Invoice Status ,
Table: PA_UBR_UER_SUMM_ACCT 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_UBR_UER_SUMM_ACCT, object_name:PA_UBR_UER_SUMM_ACCT, status:VALID, product: PA - Projects , description: The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue. , implementation_dba_data: PA.PA_UBR_UER_SUMM_ACCT ,
Table: PA_UBR_UER_SUMM_ACCT 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_UBR_UER_SUMM_ACCT, object_name:PA_UBR_UER_SUMM_ACCT, status:VALID, product: PA - Projects , description: The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue. , implementation_dba_data: PA.PA_UBR_UER_SUMM_ACCT ,
Concurrent Program: PARTAR 12.2.2
execution_filename: PARTAR , product: PA - Projects , user_name: PARTAR , description: Tieback Invoices from Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PATTAR 12.1.1
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PARTAR 12.1.1
execution_filename: PARTAR , product: PA - Projects , user_name: PARTAR , description: Tieback Invoices from Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PATTAR 12.2.2
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PATTARIC 12.1.1
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PATTAR-IC 12.1.1
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: No , execution_method: Spawned ,
Concurrent Program: PATTAR_IC 12.1.1
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: No , execution_method: Spawned ,
Concurrent Program: PATTAR_IC 12.2.2
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: No , execution_method: Spawned ,
Concurrent Program: PATTARIC 12.2.2
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PATTAR-IC 12.2.2
execution_filename: PATTAR , product: PA - Projects , user_name: PATTAR , description: Transfer Invoices to Accounts Receivable , argument_method: Database fetch , enabled: No , execution_method: Spawned ,
View: PA_UBR_UER_INV_PRJ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_INV_PRJ_V, object_name:PA_UBR_UER_INV_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER.This lists the Unearned Revenue and Unbilled Receivable for draft Invoices. , implementation_dba_data: APPS.PA_UBR_UER_INV_PRJ_V ,
View: PA_UBR_UER_INV_PRJ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_INV_PRJ_V, object_name:PA_UBR_UER_INV_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER.This lists the Unearned Revenue and Unbilled Receivable for draft Invoices. , implementation_dba_data: APPS.PA_UBR_UER_INV_PRJ_V ,
View: PA_UBR_UER_SUMM_PRJ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_SUMM_PRJ_V, object_name:PA_UBR_UER_SUMM_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER. This lists the Unbilled Receivable and Unearned Revenue balances by gl period for all projects. , implementation_dba_data: APPS.PA_UBR_UER_SUMM_PRJ_V ,
View: PA_UBR_UER_SUMM_PRJ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_SUMM_PRJ_V, object_name:PA_UBR_UER_SUMM_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER. This lists the Unbilled Receivable and Unearned Revenue balances by gl period for all projects. , implementation_dba_data: APPS.PA_UBR_UER_SUMM_PRJ_V ,
View: PA_UBR_UER_DR_PRJ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_DR_PRJ_V, object_name:PA_UBR_UER_DR_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER.This lists the Unearned Revenue and Unbilled Receivable for draft revenues. , implementation_dba_data: APPS.PA_UBR_UER_DR_PRJ_V ,
View: PA_UBR_UER_DR_PRJ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UBR_UER_DR_PRJ_V, object_name:PA_UBR_UER_DR_PRJ_V, status:VALID, product: PA - Projects , description: This view is being used for reporting purpose in UBR and UER.This lists the Unearned Revenue and Unbilled Receivable for draft revenues. , implementation_dba_data: APPS.PA_UBR_UER_DR_PRJ_V ,