This appendix documents the predefined setup that Oracle Projects provides for Oracle Subledger Accounting
This appendix covers the following topics:
Oracle Projects provides predefined data for Oracle Subledger Accounting that you can use to integrate the two applications. When you run the process to create draft or final subledger accounting for project-related accounting events, the process uses the predefined data to determine how to create the accounting. Oracle Projects predefines setup for Oracle Subledger Accounting so that the create accounting process accepts the default accounting information from Oracle Projects without change. Oracle Subledger Accounting transfers the final accounting to Oracle General Ledger.
You can optionally define your own subledger accounting rules to overwrite the default accounts from the accounting events. If you define your own setup in Oracle Subledger Accounting, then you cannot directly modify the predefined data that Oracle Projects provides in Oracle Subledger Accounting. Instead, you must copy the predefined data and make changes to the copy.
Note: Oracle Subledger Accounting uses intracompany balancing rules to create balancing lines on journal entries between balancing segment values. You set up this functionality in the Accounting Setup Manager in Oracle General Ledger. The Accounting Setup Manager centralizes the common setup steps for the Oracle financial applications. For additional information, see: Cross Entity Balancing Rules, Oracle Projects Implementation Guide.
Note: You must use an Oracle Projects responsibility to query predefined data that is associated with the Projects application.
The following sections describe the data that Oracle Projects predefines in Oracle Subledger Accounting:
Related Topics
Accounting Event Model Overview
Oracle Projects Navigation Paths
Post-Accounting Programs that Oracle Projects Defines for Oracle Subledger Accounting
Understanding Subledger Accounting Setup for Oracle Projects
Oracle Subledger Accounting Implementation Guide
Oracle Projects predefines one application in Oracle Subledger Accounting named Projects. Most of the data that Oracle Projects predefines for Oracle Subledger Accounting is associated with the Projects application.
Oracle Projects also provides data associated with the applications Purchasing and Oracle Payables. Oracle Purchasing and Oracle Payables predefine each respective application in Oracle Subledger Accounting. This data determines the subledger accounting for burden cost on project-related commitments in Oracle Purchasing and Oracle Payables.
The following table shows the attribute values that Oracle projects predefines for the Projects application. The first column lists the fields and the second column lists the values for each field.
| Field | Value |
|---|---|
| Application Name | Projects |
| Drilldown Procedure | PA_DRILLDOWN_PUB_PKG.DRILLDOWN |
| Use Security | Yes |
| Policy Function | XLA_SECURITY_POLICY_PKG.MO_POLICY |
| Journal Source | Projects |
| Third Party Control Account Type | None |
| Subject to Validation | No |
| Calculate Reporting Currency Amounts | Yes |
The following table lists the setup information that Oracle Projects predefines for the event entities.
Note: Oracle Projects does not enable gapless event processing for predefined event entities. If all event numbers for a set of accounting events for an event entity transaction are consecutive starting from number 1, and no events exist with a status of Incomplete, then there is no gap. A gap exists if an event is missing or has a status of Incomplete. Oracle Subledger Accounting processes all events, even if a gap in the event numbers exists, when gapless event processing is not enabled.
| Application | Entity Name | Description | Gapless Event Processing |
|---|---|---|---|
| Projects | Budgets | Project Budgets | No |
| Projects | Expenditures | Project Expenditures | No |
| Projects | Revenue | Project Revenue | No |
Oracle Projects predefines event classes and event types for each event entity that belongs to the Projects application. Oracle Projects also provides predefined event classes and event types for the Oracle Purchasing and Oracle Payables. These event classes and event types are for burden cost on project-related commitments in Oracle Purchasing and Oracle Payables.
The following table lists the event classes and event types that Oracle Projects predefines for the Projects application.
| Entity | Event Class Name | Event Type Name |
|---|---|---|
| Budgets | Budget | Budget Year End Rollover |
| Budgets | Budget | Budget Baseline |
| Expenditures | Borrowed and Lent | Borrowed and Lent Distribution |
| Expenditures | Borrowed and Lent Adjustment | Borrowed and Lent Adjustment |
| Expenditures | Burden Cost | Burden Cost Distribution |
| Expenditures | Inventory Cost | Inventory Cost Distribution |
| Expenditures | Inventory Cost Adjustment | Inventory Cost Adjustment |
| Expenditures | Labor Cost | Labor Cost Distribution |
| Expenditures | Labor Cost Adjustment | Labor Cost Adjustment |
| Expenditures | Miscellaneous Cost | Miscellaneous Cost Distribution |
| Expenditures | Miscellaneous Cost Adjustment | Miscellaneous Cost Adjustment |
| Expenditures | Provider and Receiver Reclass | Provider and Receiver Reclass |
| Expenditures | Provider and Receiver Reclass Adjustment | Provider and Receiver Reclass Adjustment |
| Expenditures | Supplier Cost | Expense Report Cost Distribution |
| Expenditures | Supplier Cost | Supplier Cost Distribution |
| Expenditures | Supplier Cost Adjustment | Expense Report Cost Adjustment |
| Expenditures | Supplier Cost Adjustment | Supplier Cost Adjustment |
| Expenditures | Total Burdened Cost | Total Burdened Cost Distribution |
| Expenditures | Total Burdened Cost Adjustment | Total Burdened Cost Adjustment |
| Expenditures | Usage Cost | Usage Cost Distribution |
| Expenditures | Usage Cost Adjustment | Usage Cost Adjustment |
| Expenditures | Work in Process Cost | Work in Process Cost Distribution |
| Expenditures | Work in Process Cost Adjustment | Work in Process Cost Adjustment |
| Revenue | Revenue | Revenue Generation |
| Revenue | Revenue Adjustment | Revenue Adjustment |
The following table lists the event classes and event types that Oracle Projects predefines for Oracle Purchasing.
| Entity | Event Class Name | Event Type Name |
|---|---|---|
| Purchase Order | Burden for Purchase Order | PO Burden Cancelled |
| Purchase Order | Burden for Purchase Order | PO Burden Credit Memo Cancelled |
| Purchase Order | Burden for Purchase Order | PO Burden Final Closed |
| Purchase Order | Burden for Purchase Order | PO Burden Invoice Cancelled |
| Purchase Order | Burden for Purchase Order | PO Burden Rejected |
| Purchase Order | Burden for Purchase Order | PO Burden Reopen Final Match |
| Purchase Order | Burden for Purchase Order | PO Burden Reserved |
| Purchase Order | Burden for Purchase Order | PO Burden Unreserved |
| Release | Burden for Release | Release Burden Cancelled |
| Release | Burden for Release | Release Burden Credit Memo Cancelled |
| Release | Burden for Release | Release Burden Finally Closed |
| Release | Burden for Release | Release Burden Invoice Cancelled |
| Release | Burden for Release | Release Burden Rejected |
| Release | Burden for Release | Release Burden Reopen Finally Closed |
| Release | Burden for Release | Release Burden Reserved |
| Release | Burden for Release | Release Burden Unreserved |
| Requisition | Burden for Requisition | Requisition Burden Adjusted |
| Requisition | Burden for Requisition | Requisition Burden Cancelled |
| Requisition | Burden for Requisition | Requisition Burden Finally Closed |
| Requisition | Burden for Requisition | Requisition Burden Rejected |
| Requisition | Burden for Requisition | Requisition Burden Reserved |
| Requisition | Burden for Requisition | Requisition Burden Returned |
| Requisition | Burden for Requisition | Requisition Burden Unreserved |
The following table lists the event classes and event types that Oracle Projects predefines Oracle Payables.
| Entity | Event Class Name | Event Type Name |
|---|---|---|
| AP Invoices | Burden for Invoices | Invoice Burden Adjusted |
| AP Invoices | Burden for Invoices | Invoice Burden Cancelled |
| AP Invoices | Burden for Invoices | Invoice Burden Validated |
| AP Invoices | Burden for Prepayments | Prepayment Adjusted Burden |
| AP Invoices | Burden for Prepayments | Prepayment Cancelled Burden |
| AP Invoices | Burden for Prepayments | Prepayment Validated Burden |
| AP Invoices | Burden for Prepayment Applications | Prepayment Applied Burden |
| AP Invoices | Burden for Prepayment Applications | Prepayment Unapplied Burden |
| AP Invoices | Burden for Prepayment Applications | Prepayment Application Adjusted Burden |
Oracle Projects predefines the following process categories:
Borrowed and Lent
Burden Cost
Budget
Inventory Cost
Labor Cost
Miscellaneous Cost
Provider Cost Reclassification
Revenue
Supplier Cost
Third Party Merge
Total Burdened Cost
Usage Cost
Work in Process Cost
Accounting event class options define attributes of an event class. Oracle Projects defines the accounting event class options for each predefined event class.
The accounting event class options include the following attributes:
Process Category: Process categories are collections of one or more logically related event classes. For additional information, see: Process Categories.
Default Journal Category: The Default Journal Category field stores the default journal category that Oracle Subledger Accounting uses when it creates journal entries for Oracle General Ledger.
Transaction View: Oracle Subledger Accounting displays information acquired from this view in reports and inquiries.
Balance Types: The balance types that the event class supports. Possible balance types are actual, budget, and encumbrance.
Currency Conversion Options: The currency conversion options specify whether Oracle Subledger Accounting calculates accounted amounts and gain or loss amounts for the accounting events with the event class.
Note: The Calculated Accounted Amounts and Calculate Gain or Loss Amounts currency conversion options are disabled for all accounting event options that Oracle Projects predefines.
The accounting event class options also specify user transaction identifiers and objects for each event class. Oracle Subledger Accounting displays user transaction identifiers on accounting event reports and inquiries. Source data from the transactions is stored in transaction objects (tables or views) for each eligible accounting event. Oracle Subledger Accounting selects the source values it needs from these transaction objects to successfully complete the processing of accounting events.
In addition to the accounting event class options that Oracle Projects predefines for the Projects application, Oracle Projects also provides predefined accounting event class options for Oracle Purchasing and Oracle Payables. These event classes are for burden costs on project-related commitments in Oracle Purchasing and Oracle Payables.
The following table lists the accounting event class options that Oracle Projects predefines for the Projects application.
| Event Class | Process Category | Default Journal Category | Transaction View | Balance Types |
|---|---|---|---|---|
| Budget | Budget | Budget | PA_XLA_BC_BUDGET_TXN_V | Budget, Encumbrance |
| Borrowed and Lent | Borrowed and Lent | Borrowed and Lent | PA_XLA_CROSSCHARGE_V | Actual |
| Borrowed and Lent Adjustment | Borrowed and Lent | Borrowed and Lent | PA_XLA_CROSSCHARGE_V | Actual |
| Burden Cost | Burden Cost | Burden Cost | PA_XLA_COST_V | Actual, Encumbrance |
| Inventory Cost | Inventory Cost | Inventory | PA_XLA_COST_V | Actual |
| Inventory Cost Adjustment | Inventory Cost | Inventory | PA_XLA_COST_V | Actual |
| Labor Cost | Labor Cost | Labor Cost | PA_XLA_COST_V | Actual |
| Labor Cost Adjustment | Labor Cost | Labor Cost | PA_XLA_COST_V | Actual |
| Miscellaneous Cost | Miscellaneous Cost | Miscellaneous Transaction | PA_XLA_COST_V | Actual |
| Miscellaneous Cost Adjustment | Miscellaneous Cost | Miscellaneous Transaction | PA_XLA_COST_V | Actual |
| Provider and Receiver Reclass | Provider Cost Reclassification | Prov Cost Reclass | PA_XLA_CROSSCHARGE_V | Actual |
| Provider and Receiver Reclass Adjustment | Provider Cost Reclassification | Prov Cost Reclass | PA_XLA_CROSSCHARGE_V | Actual |
| Supplier Cost | Supplier Cost | Purchase Invoices | PA_XLA_COST_V | Actual |
| Supplier Cost Adjustment | Supplier Cost | Purchase Invoices | PA_XLA_COST_V | Actual |
| Total Burdened Cost | Total Burdened Cost | Total Burdened Cost | PA_XLA_COST_V | Actual, Encumbrance |
| Total Burdened Cost Adjustment | Total Burdened Cost | Total Burdened Cost | PA_XLA_COST_V | Actual, Encumbrance |
| Usage Cost | Usage Cost | Usage Cost | PA_XLA_COST_V | Actual |
| Usage Cost Adjustment | Usage Cost | Usage Cost | PA_XLA_COST_V | Actual |
| Work in Process Cost | Work in Process Cost | WIP | PA_XLA_COST_V | Actual |
| Work in Process Cost Adjustment | Work in Process Cost | WIP | PA_XLA_COST_V | Actual |
| Revenue | Revenue | Revenue | PA_XLA_REV_V | Actual |
| Revenue Adjustment | Revenue | Revenue | PA_XLA_REV_V | Actual |
The following table lists the accounting event class options that Oracle Projects predefines for Oracle Purchasing.
| Event Class | Process Category | Default Journal Category | Transaction View | Balance Types |
|---|---|---|---|---|
| Burden for Purchase Order | Purchase Order | Purchases | PO_TRANSACTION_V | Encumbrance |
| Burden for Release | Purchase Order | Release | PO_RELEASE_TRANSACTION_V | Encumbrance |
| Burden for Requisition | Requisition | Requisitions | PO_REQ_TRANSACTION_V | Encumbrance |
The following table lists the accounting event class options that Oracle Projects predefines for Oracle Payables.
| Event Class | Process Category | Default Journal Category | Transaction View | Balance Types |
|---|---|---|---|---|
| Burden for Invoices | Invoices | Purchase Invoices | AP_SLA_INVOICES_TRANSACTION_V | Encumbrance |
| Burden for Prepayment Applications | Invoices | Purchase Invoices | AP_SLA_INVOICES_TRANSACTION_V | Encumbrance |
| Burden for Prepayments | Invoices | Purchase Invoices | AP_SLA_INVOICES_TRANSACTION_V | Encumbrance |
Oracle Projects predefines sources, source assignments, and accounting attribute assignments for Oracle Subledger Accounting.
You can use the Accounting Methods Builder to review the sources, source assignments, and accounting attribute assignments. You must access the Accounting Methods Builder using an Oracle Projects responsibility if you want to review the sources, source assignments, and accounting attribute assignments associated with the Projects application. Similarly, if you want to review the sources, source assignments, and accounting attribute assignments associated with Oracle Purchasing or Oracle Payables, you must access the Account Methods Builder using an Oracle Purchasing or Oracle Payables responsibility respectively.
Note: You cannot make changes to predefined sources, source assignments, or accounting attribute assignments. However, you can define your own custom sources. See: Custom Sources, Oracle Projects Implementation Guide.
If you choose to define your own journal line types or application accounting definitions, then you can override the default accounting attribute assignments.
Oracle Projects provides over 300 predefined sources. When you use the Sources window to review the predefined sources, you can optionally export the queried sources from the application to a Microsoft Excel spreadsheet.
To export a list of sources:
Log into Oracle Applications.
Select an Oracle Projects, Oracle Purchasing, or Oracle Payables responsibility, depending on the sources that you want to review.
Navigate to the Sources window.
From an Oracle Projects super user responsibility: Setup - Subledger Accounting - Accounting Methods Builder - Sources - Sources
From an Oracle Purchasing super user responsibility: Setup - Subledger Accounting Setups - Accounting Methods Builder - Sources - Sources
From an Oracle Payables super user responsibility: Accounting Setups - Subledger Accounting Setup - Accounting Methods Builder - Sources - Sources
Query the records you want to export.
Place your cursor in the multi-row block that contains the records to be exported.
Choose Export from the File menu.
Related Topics
Exporting Records to a File, Oracle Applications User's Guide
Oracle Projects predefines journal line types for each predefined event class. Oracle Projects specifies conditions for the use of each journal line type. Oracle Projects also predefines journal line types for Oracle Purchasing and Oracle Payables. These journal line types are for burden costs on project-related commitments in Oracle Purchasing and Oracle Payables.
Important: Oracle Projects recommends that you do not modify the predefined journal line types for encumbrance entries or define additional journal line types for encumbrance entries. Adding or modifying these journal line types can cause the funds check process to create additional encumbrance entries. The additional encumbrance entries can cause the funds check process to fail.
The following table lists the journal line types that Oracle Projects predefines for the Projects application.
| Event Class | Name | Balance Type | Side |
|---|---|---|---|
| Borrowed and Lent | Provider Cost | Actual | Credit |
| Borrowed and Lent | Provider Revenue | Actual | Credit |
| Borrowed and Lent | Receiver Cost | Actual | Debit |
| Borrowed and Lent | Receiver Revenue | Actual | Debit |
| Borrowed and Lent Adjustment | Provider Cost Adjustment | Actual | Credit |
| Borrowed and Lent Adjustment | Provider Revenue Adjustment | Actual | Credit |
| Borrowed and Lent Adjustment | Receiver Cost Adjustment | Actual | Debit |
| Borrowed and Lent Adjustment | Receiver Cost Adjustment | Actual | Debit |
| Budget | Project Cost Budget Journal | Budget | Debit |
| Budget | Project Encumbrance | Encumbrance | Debit |
| Budget | Project Revenue Budget Journal | Budget | Credit |
| Burden Cost | Burden Cost | Actual | Debit |
| Burden Cost | Burden Cost Clearing | Actual | Credit |
| Burden Cost | Reinstate Project Encumbrance | Encumbrance | Debit |
| Burden Cost | Relieve Cancelled Invoice Burden Encumbrance | Encumbrance | Credit |
| Burden Cost | Relieve Contingent Worker (rate based) Purchase Order Burden Encumbrance | Encumbrance | Credit |
| Burden Cost | Relieve Invoice Burden Encumbrance | Encumbrance | Credit |
| Burden Cost | Relieve Purchase Order Burden Encumbrance | Encumbrance | Credit |
| Burden Cost | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden Cost | Relieve Release Burden Encumbrance | Encumbrance | Credit |
| Inventory Cost | Raw Cost | Actual | Debit |
| Inventory Cost | Raw Cost Clearing | Actual | Credit |
| Inventory Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Inventory Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
| Labor Cost | Raw Cost | Actual | Debit |
| Labor Cost | Raw Cost Clearing | Actual | Credit |
| Labor Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Labor Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
| Miscellaneous Cost | Raw Cost | Actual | Debit |
| Miscellaneous Cost | Raw Cost Clearing | Actual | Credit |
| Miscellaneous Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Miscellaneous Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
| Provider and Receiver Reclass | Reclass Destination | Actual | Debit |
| Provider and Receiver Reclass | Reclass Source | Actual | Credit |
| Provider and Receiver Reclass Adjustment | Reclass Destination Adjustment | Actual | Debit |
| Provider and Receiver Reclass Adjustment | Reclass Source Adjustment | Actual | Credit |
| Revenue | Burden Cost Revenue | Actual | Credit |
| Revenue | Expense Report Revenue | Actual | Credit |
| Revenue | Event Revenue | Actual | Credit |
| Revenue | Event Write-Off Revenue | Actual | Debit |
| Revenue | Inventory Revenue | Actual | Credit |
| Revenue | Labor Revenue | Actual | Credit |
| Revenue | Miscellaneous Transaction Revenue | Actual | Credit |
| Revenue | Realized Gains | Actual | Credit |
| Revenue | Realized Losses | Actual | Debit |
| Revenue | Unbilled Receivable | Actual | Debit |
| Revenue | Unearned Revenue | Actual | Debit |
| Revenue | Usage Revenue | Actual | Credit |
| Revenue | Supplier Invoice Revenue | Actual | Credit |
| Revenue | WIP Revenue | Actual | Credit |
| Revenue Adjustment | Event Revenue Adjustments | Actual | Debit |
| Revenue Adjustment | Event Write-off Revenue Adjustment | Actual | Credit |
| Revenue Adjustment | Realized Gains Adjustments | Actual | Debit |
| Revenue Adjustment | Realized Losses Adjustments | Actual | Credit |
| Revenue Adjustment | Revenue Adjustments | Actual | Debit |
| Revenue Adjustment | Unbilled Receivable Adjustments | Actual | Credit |
| Revenue Adjustment | Unearned Revenue Adjustments | Actual | Credit |
| Supplier Cost | Exchange Rate Variance | Actual | Debit |
| Supplier Cost | Exchange Rate Variance Clearing | Actual | Credit |
| Supplier Cost | Raw Cost | Actual | Debit |
| Supplier Cost | Raw Cost Clearing | Actual | Credit |
| Supplier Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Supplier Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
| Supplier Cost Adjustment | Exchange Rate Variance | Actual | Debit |
| Supplier Cost Adjustment | Exchange Rate Variance Clearing | Actual | Credit |
| Total Burdened Cost | Total Burdened Cost | Actual | Debit |
| Total Burdened Cost | Total Burdened Cost Clearing | Actual | Credit |
| Total Burdened Cost | Reinstate Project Encumbrance | Encumbrance | Debit |
| Total Burdened Cost | Relieve Contingent Worker (rate based) Purchase Order Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost | Relieve Cancelled Invoice Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost | Relieve Invoice Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost | Relieve Purchase Order Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost | Relieve Project Encumbrance | Encumbrance | Credit |
| Total Burdened Cost | Relieve Release Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Total Burdened Cost Adjustment | Actual | Debit |
| Total Burdened Cost Adjustment | Total Burdened Cost Clearing Adjustment | Actual | Credit |
| Total Burdened Cost Adjustment | Relieve Cancelled Invoice Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Reinstate Project Encumbrance | Encumbrance | Debit |
| Total Burdened Cost Adjustment | Relieve Contingent Worker (rate based) Purchase Order Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Relieve Invoice Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Relieve Purchase Order Burdened Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Relieve Project Encumbrance | Encumbrance | Credit |
| Total Burdened Cost Adjustment | Relieve Release Burdened Encumbrance | Encumbrance | Credit |
| Usage Cost | Raw Cost | Actual | Debit |
| Usage Cost | Raw Cost Clearing | Actual | Credit |
| Usage Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Usage Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
| Work in Process Cost | Raw Cost | Actual | Debit |
| Work in Process Cost | Raw Cost Clearing | Actual | Credit |
| Work in Process Cost Adjustment | Raw Cost Adjustment | Actual | Debit |
| Work in Process Cost Adjustment | Raw Cost Clearing Adjustment | Actual | Credit |
The following table lists the journal line types that Oracle Projects predefines for Oracle Purchasing.
| Event Class | Name | Balance Type | Side |
|---|---|---|---|
| Burden for Purchase Orders | Cancel Burdened PO Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Cancel Burden PO Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Reinstate Requisition Burdened Encumbrance for PO Cancel | Encumbrance | Credit |
| Burden for Purchase Orders | Reinstate Requisition Burdened Encumbrance for PO Unreserve | Encumbrance | Debit |
| Burden for Purchase Orders | Reinstate Requisition Burden Encumbrance for PO Cancel | Encumbrance | Credit |
| Burden for Purchase Orders | Reinstate Requisition Burden Encumbrance for PO Unreserve | Encumbrance | Debit |
| Burden for Purchase Orders | Reinstate Unencumbered Requisition Burden Encumbrance for PO | Encumbrance | Debit |
| Burden for Purchase Orders | Reinstate Unencumbered Requisition Burdened Encumbrance for PO | Encumbrance | Debit |
| Burden for Purchase Orders | Relieve Burdened Requisition Encumbrance for PO | Encumbrance | Credit |
| Burden for Purchase Orders | Relieve Burden Requisition Encumbrance for PO | Encumbrance | Credit |
| Burden for Purchase Orders | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Purchase Orders | Relieve Unencumbered Burden Requisition Encumbrance for PO | Encumbrance | Credit |
| Burden for Purchase Orders | Relieve Unencumbered Burdened Requisition Encumbrance for PO | Encumbrance | Credit |
| Burden for Purchase Orders | Reopen Final Matched PO Burdened Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Reopen Final Matched PO Burden Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Reserve Burdened PO Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Reserve Burden PO Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Reserve Project Encumbrance | Encumbrance | Debit |
| Burden for Purchase Orders | Unreserve Burdened PO Encumbrance | Encumbrance | Credit |
| Burden for Purchase Orders | Unreserve Burden PO Encumbrance | Encumbrance | Credit |
| Burden for Release | Cancel Burdened Release Encumbrance | Encumbrance | Debit |
| Burden for Release | Cancel Burden Release Encumbrance | Encumbrance | Debit |
| Burden for Release | Reinstate PO Burdened Encumbrance for Release Cancel | Encumbrance | Credit |
| Burden for Release | Reinstate PO Burdened Encumbrance for Release Unreserve | Encumbrance | Debit |
| Burden for Release | Reinstate PO Burden Encumbrance for Release Cancel | Encumbrance | Credit |
| Burden for Release | Reinstate PO Burden Encumbrance for Release Unreserve | Encumbrance | Debit |
| Burden for Release | Reinstate Requisition Burdened Encumbrance for Release Cancel | Encumbrance | Credit |
| Burden for Release | Reinstate Requisition Burdened Encumbrance for Release Unreserve | Encumbrance | Debit |
| Burden for Release | Reinstate Requisition Burden Encumbrance for Release Cancel | Encumbrance | Credit |
| Burden for Release | Reinstate Requisition Burden Encumbrance for Release Unreserve | Encumbrance | Debit |
| Burden for Release | Relieve Burdened PO Encumbrance for Release | Encumbrance | Credit |
| Burden for Release | Relieve Burdened Requisition Encumbrance for Release | Encumbrance | Credit |
| Burden for Release | Relieve Burden PO Encumbrance for Release | Encumbrance | Credit |
| Burden for Release | Relieve Burden Requisition Encumbrance for Release | Encumbrance | Credit |
| Burden for Release | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Release | Reopen Final Closed Release Burden Encumbrance | Encumbrance | Debit |
| Burden for Release | Reopen Final Closed Release Burdened Encumbrance | Encumbrance | Debit |
| Burden for Release | Reserve Burdened Release Encumbrance | Encumbrance | Debit |
| Burden for Release | Reserve Burden Release Encumbrance | Encumbrance | Debit |
| Burden for Release | Reserve Project Encumbrance | Encumbrance | Debit |
| Burden for Release | Unreserve Burdened Release Encumbrance | Encumbrance | Credit |
| Burden for Release | Unreserve Burden Release Encumbrance | Encumbrance | Credit |
| Burden for Requisition | Cancel Burdened Requisition Encumbrance | Encumbrance | Debit |
| Burden for Requisition | Cancel Burden Requisition Encumbrance | Encumbrance | Debit |
| Burden for Requisition | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Requisition | Reserve Burdened Requisition Encumbrance | Encumbrance | Debit |
| Burden for Requisition | Reserve Burden Requisition Encumbrance | Encumbrance | Debit |
| Burden for Requisition | Reserve Project Encumbrance | Encumbrance | Debit |
| Burden for Requisition | Unreserve Burdened Requisition Encumbrance | Encumbrance | Credit |
| Burden for Requisition | Unreserve Burden Requisition Encumbrance | Encumbrance | Credit |
The following table lists the journal line types that Oracle Projects predefines for Oracle Payables.
| Event Class | Name | Balance Type | Side |
|---|---|---|---|
| Burden for Invoices | Burdened Invoice Encumbrance | Encumbrance | Debit |
| Burden for Invoices | Burden Invoice Encumbrance | Encumbrance | Debit |
| Burden for Invoices | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Invoices | Reserve Project Encumbrance | Encumbrance | Debit |
| Burden for Invoices | Reverse PO Burdened Encumbrance | Encumbrance | Credit |
| Burden for Invoices | Reverse PO Burden Encumbrance | Encumbrance | Credit |
| Burden for Invoices | Reverse Release Burdened Encumbrance | Encumbrance | Credit |
| Burden for Invoices | Reverse Release Burden Encumbrance | Encumbrance | Credit |
| Burden for Prepayment Applications | Prepayment Application Burdened Encumbrance | Encumbrance | Credit |
| Burden for Prepayment Applications | Prepayment Application Burden Encumbrance | Encumbrance | Credit |
| Burden for Prepayment Applications | Prepayment Application Encumbrance | Encumbrance | Credit |
| Burden for Prepayment Applications | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Prepayment Applications | Reserve Project Encumbrance | Encumbrance | Debit |
| Burden for Prepayments | Prepayment Burdened Encumbrance | Encumbrance | Debit |
| Burden for Prepayments | Prepayment Burden Encumbrance | Encumbrance | Debit |
| Burden for Prepayments | Prepayment Encumbrance | Encumbrance | Debit |
| Burden for Prepayments | Relieve Project Encumbrance | Encumbrance | Credit |
| Burden for Prepayments | Reserve Project Encumbrance | Encumbrance | Debit |
Oracle Projects predefines account derivation rules. When Oracle Subledger Accounting uses the predefined account derivation rules that Oracle Projects provides, it accepts the default accounting that Oracle Projects generates using AutoAccounting (costs and revenue) or the Project Budget Account Generation Workflow (budgets) without change.
You can optionally define your own account derivation rules for an Accounting Flex Flexfield or for a segment. In this case, Oracle Subledger Accounting overrides the default accounts that Oracle Projects generates, or individual segment values in the default accounts, when it creates the draft or final subledger accounting.
Oracle Projects also predefines account derivation rules for Oracle Purchasing and Oracle Payables. These account derivation rules are for burden costs on project-related commitments in Oracle Purchasing and Oracle Payables.
Note: All account derivation rules that Oracle Projects predefines have an Output Type of Flexfield.
The name account derivation rules that Oracle Projects predefines for the Projects application are as follows:
Event Revenue Account Rule
Project Budget Account Rule
Cost Account Rule
Cost Adjustment Account Rule
Cost Clearing Account Rule
Cost Clearing Adjustment Account Rule
Provider Cost/Revenue Account Rule
Provider Cost/Revenue Adjustment Account Rule
Receiver Cost/Revenue Account Rule
Receiver Cost/Revenue Adjustment Account Rule
Reclass Destination Account Rule
Reclass Destination Adjustment Account Rule
Reclass Source Account Rule
Reclass Source Adjustment Account Rule
Realized Gains Account Rule
Realized Losses Account Rule
Revenue Account Rule
UBR Account Rule
UER Account Rule
The account derivation rules that Oracle Projects predefines for Oracle Purchasing are as follows:
Burdened Encumbrance Account Rule
Burden Encumbrance Account Rule
The account derivation rules that Oracle Projects predefines for Oracle Payables are as follows:
Burdened Encumbrance Account Rule
Burden Encumbrance Account Rule
Project Prepayment Burdened Encumbrance Account Rule
Project Prepayment Burden Encumbrance Account Rule
Project Prepayment Encumbrance Account Rule
Oracle Projects predefines journal lines definitions that group the predefined journal line types and account derivation rules within each of the predefined event types. Oracle Projects assigns each predefined journal lines definition to all event types within an event class.
Oracle Projects also predefines journal lines definitions for Oracle Purchasing and Oracle Payables. These journal lines definitions are for burden costs on project-related commitments in Oracle Purchasing and Oracle Payables.
The following table lists the journal lines definitions that Oracle Projects predefines for the Projects application.
| Event Class | Journal Lines Definition Name | Budgetary Control | Journal Line Types |
|---|---|---|---|
| Borrowed and Lent | Projects Standard Accounting | No | Provider Cost, Provider Revenue, Receiver Cost, Receiver Revenue |
| Borrowed and Lent Adjustment | Projects Standard Accounting | No | Provider Cost Adjustment, Provider Revenue Adjustment, Receiver Cost Adjustment, Receiver Revenue Adjustment |
| Budget | Project Encumbrance Accounting | Yes | Project Encumbrance |
| Budget | Projects Standard Accounting | Yes | Project Cost Budget Journal, Project Revenue Budget Journal |
| Burden Cost | Project Encumbrance Reversal Accounting | No | Reinstate Project Encumbrance, Relieve Cancelled Invoice Burden Encumbrance, Relieve Contingent Worker (rate based) Purchase Order Burden Encumbrance, Relieve Invoice Burden Encumbrance, Relieve Project Encumbrance, Relieve Purchase Order Burden Encumbrance, Relieve Release Burden Encumbrance |
| Burden Cost | Projects Standard Accounting | No | Burden Cost, Burden Cost Clearing |
| Inventory Cost | Projects Standard Accounting | No | Raw Cost, Raw Cost Clearing |
| Inventory Cost Adjustment | Projects Standard Accounting | No | Raw Cost Adjustment, Raw Cost Clearing Adjustment |
| Labor Cost | Projects Standard Accounting | No | Raw Cost, Raw Cost Clearing |
| Labor Cost Adjustment | Projects Standard Accounting | No | Raw Cost Adjustment, Raw Cost Clearing Adjustment |
| Miscellaneous Cost | Projects Standard Accounting | No | Raw Cost, Raw Cost Clearing |
| Miscellaneous Cost Adjustment | Projects Standard Accounting | No | Raw Cost Adjustment, Raw Cost Clearing Adjustment |
| Provider and Receiver Reclass | Projects Standard Accounting | No | Reclass Destination, Reclass Source |
| Provider and Receiver Reclass Adjustment | Projects Standard Accounting | No | Reclass Destination Adjustment, Reclass Source Adjustment |
| Revenue | Projects Standard Accounting | No | Burden Cost Revenue, Event Revenue, Event Write-Off Revenue, Expense Report Revenue, Inventory Revenue, Labor Revenue, Miscellaneous Transaction Revenue, Realized Gains, Realized Losses, Supplier Invoice Revenue, Unbilled Receivable, Unearned Revenue, Usage Revenue, WIP Revenue |
| Revenue Adjustment | Projects Standard Accounting | No | Event Revenue Adjustments, Event Write-Off Revenue Adjustment, Realized Gains Adjustments, Realized Losses Adjustments, Revenue Adjustments, Unbilled Receivable Adjustments, Unearned Revenue Adjustments |
| Supplier Cost | Projects Standard Accounting | No | Exchange Rate Variance, Exchange Rate Variance Clearing, Raw Cost, Raw Cost Clearing |
| Supplier Cost Adjustment | Projects Standard Accounting | No | Exchange Rate Variance, Exchange Rate Variance Clearing, Raw Cost Adjustment, Raw Cost Clearing Adjustment |
| Total Burdened Cost | Project Encumbrance Reversal Accounting | No | Reinstate Project Encumbrance, Relieve Cancelled Invoice Burdened Encumbrance, Relieve Contingent Worker (rate based) Purchase Order Burdened Encumbrance, Relieve Invoice Burdened Encumbrance, Relieve Project Encumbrance, Relieve Purchase Order Burdened Encumbrance, Relieve Release Burdened Encumbrance |
| Total Burdened Cost | Projects Standard Accounting | No | Total Burdened Cost, Total Burdened Cost Clearing |
| Total Burdened Cost Adjustment | Project Encumbrance Reversal Accounting | No | Reinstate Project Encumbrance, Relieve Cancelled Invoice Burdened Encumbrance, Relieve Contingent Worker (rate based) Purchase Order Burdened Encumbrance, Relieve Invoice Burdened Encumbrance, Relieve Project Encumbrance, Relieve Purchase Order Burdened Encumbrance, Relieve Release Burdened Encumbrance |
| Total Burdened Cost Adjustment | Projects Standard Accounting | No | Total Burdened Cost Adjustment, Total Burdened Cost Clearing Adjustment |
| Usage Cost | Projects Standard Accounting | No | Raw Cost, Raw Cost Clearing |
| Usage Cost Adjustment | Projects Standard Accounting | No | Raw Cost Adjustment, Raw Cost Clearing Adjustment |
| Work in Process Cost | Projects Standard Accounting | No | Raw Cost, Raw Cost Clearing |
| Work in Process Cost Adjustment | Projects Standard Accounting | No | Raw Cost Adjustment, Raw Cost Clearing Adjustment |
The following table lists the journal lines definitions that Oracle Projects predefines for Oracle Purchasing.
| Event Class | Journal Lines Definition Name | Budgetary Control | Journal Line Types |
|---|---|---|---|
| Burden for Purchase Orders | Purchase Order Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Purchase Orders event class. See: Journal Line Types. |
| Burden for Release | Release Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Release event class. See: Journal Line Types. |
| Burden for Requisition | Requisition Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Requisition event class. See: Journal Line Types. |
The following table lists the journal lines definitions that Oracle Projects predefines for Oracle Payables.
| Event Class | Journal Lines Definition Name | Budgetary Control | Journal Line Types |
|---|---|---|---|
| Burden for Invoices | Invoice Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Invoices event class. See: Journal Line Types. |
| Burden for Prepayment Applications | Prepayment Application Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Prepayment Applications event class. See: Journal Line Types. |
| Burden for Prepayments | Prepayment Burden and Project Encumbrance ALL | Yes | All predefined journal line types for the Burden for Prepayments event class. See: Journal Line Types. |
Oracle Projects predefines the Projects Standard Accounting application accounting definition.
Oracle Purchasing and Oracle Payables also predefine application accounting definitions. The application accounting definitions for encumbrance accounting for Oracle Purchasing and Oracle Payables include the predefined setup components that Oracle Projects provides for burden cost on project-related commitments.
The following table lists the assignments for the Projects Standard Accounting application accounting definition that Oracle Projects predefines for the Projects application.
| Event Class Assignments | Event Type Assignments | Create Accounting | Journal Line Definition Assignments |
|---|---|---|---|
| Borrowed and Lent | All | Yes | Projects Standard Accounting |
| Borrowed and Lent Adjustment | All | Yes | Projects Standard Accounting |
| Budget | All | Yes | Project Encumbrance Accounting, Projects Standard Accounting |
| Burden Cost | All | Yes | Project Encumbrance Reversal Accounting, Projects Standard Accounting |
| Inventory Cost | All | Yes | Projects Standard Accounting |
| Inventory Cost Adjustment | All | Yes | Projects Standard Accounting |
| Labor Cost | All | Yes | Projects Standard Accounting |
| Labor Cost Adjustment | All | Yes | Projects Standard Accounting |
| Miscellaneous Cost | All | Yes | Projects Standard Accounting |
| Miscellaneous Cost Adjustment | All | Yes | Projects Standard Accounting |
| Provider and Receiver Reclass | All | Yes | Projects Standard Accounting |
| Provider and Receiver Reclass Adjustment | All | Yes | Projects Standard Accounting |
| Revenue | All | Yes | Projects Standard Accounting |
| Revenue Adjustment | All | Yes | Projects Standard Accounting |
| Supplier Cost | All | Yes | Projects Standard Accounting |
| Supplier Cost Adjustment | All | Yes | Projects Standard Accounting |
| Total Burdened Cost | All | Yes | Project Encumbrance Reversal Accounting, Projects Standard Accounting |
| Total Burdened Cost Adjustment | All | Yes | Project Encumbrance Reversal Accounting, Projects Standard Accounting |
| Usage Cost | All | Yes | Projects Standard Accounting |
| Usage Cost Adjustment | All | Yes | Projects Standard Accounting |
| Work in Process Cost | All | Yes | Projects Standard Accounting |
| Work in Process Cost Adjustment | All | Yes | Projects Standard Accounting |
Oracle Subledger Accounting provides predefined subledger accounting methods that group the predefined application accounting definitions for subledger applications. You can optionally create your own subledger accounting methods.
Oracle Projects assigns the predefined Projects Standard Accounting application accounting definition to the predefined Standard Accrual, Accrual with Encumbrance Accounting, and Standard Cash subledger accounting methods. You can assign these subledger accounting methods to your ledgers.
Subledger applications use post-accounting programs to transfer transaction data between subledgers based on the accounting generated from the transaction data. Oracle Subledger Accounting uses accounting classes to classify journal entry lines. The post-accounting programs distinguish journal lines for processing based on the accounting class assigned to each journal entry line.
Oracle Projects provides two post-accounting programs, one for debits and one for credits. Oracle Projects provides the post-accounting programs to obtain final accounting information from Oracle Subledger Accounting because the accounting that Oracle Projects creates using AutoAccounting may not be the same as the final accounting that Oracle Subledger Accounting transfers to Oracle General Ledger.
Oracle Projects uses post-accounting programs to determine which journal entry lines to retrieve from Oracle Subledger Accounting when Oracle Projects performs the following activities:
Groups asset lines on capital projects
Generates audit reports
Creates a reversing entry for expenditure items that you imported into Oracle Projects from other applications, such as Oracle Purchasing, Oracle Payables, or Oracle Inventory
Creates a reversing entry for expenditure items when you split an expenditure item, transfer an expenditure item, or change transaction attributes for an expenditure item (for example, change whether the expenditure item is billable or capitalizable)