Predefined Setup for Oracle Subledger Accounting

Predefined Data for Oracle Subledger Accounting

Oracle US Federal Financials (Federal Financials) provides predefined data for setting up accounting in Federal Financials using Oracle Subledger Accounting (Subledger Accounting). The predefined data enables you to integrate the two applications. When you create accounting events in Federal Financials, Subledger Accounting uses the predefined data to determine how to create the accounting. The Create Accounting process in Subledger Accounting accepts the default accounting information without change and 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 Subledger Accounting, then you cannot directly modify the predefined data that Federal Financials provides in Subledger Accounting. Instead, you must copy the predefined data and make changes to the copy.

Note: You must use an Oracle US Federal Financials responsibility to query the predefined data that is associated with Federal Financials.

The following sections describe the data that Oracle US Federal Financials predefines in Oracle Subledger Accounting:

Related Topics

Accounting Event Model Overview

Understanding Subledger Accounting Setup for Oracle US Federal Financials

Oracle Subledger Accounting Implementation Guide

Applications

Oracle US Federal Financials predefines data associated with the Federal Financials application for Oracle Subledger Accounting. Additionally, it predefines data associated with the following applications:

The data associated with these applications determines the subledger accounting for the procure-to-pay and order-to-costing business processes in Federal Financials.

The following table shows the attribute values that Oracle US Federal Financials predefines for the Federal Financials application.

Predefined Federal Financials Application
Field Value
Application Federal Financials
Drilldown Procedure FV_DRILLDOWN_PUB_PKG.DRILLDOWN
Use Security No
Security Function None
Journal Source Budget Execution
Control Account Type Code None
Subject to Validation No
Calculate Reporting Currency Amounts Yes

The following table shows the attribute values that Oracle US Federal Financials predefines for the Oracle Purchasing application.

Predefined Oracle Purchasing Application
Field Value
Application  
Drilldown Procedure  
Use Security  
Security Function  
Journal Source  
Control Account Type Code  
Subject to Validation  
Calculate Reporting Currency Amounts  

The following table shows the attribute values that Oracle US Federal Financials predefines for the Oracle Payables application.

Predefined Oracle Payables Application
Field Value
Application Oracle Payables
Drilldown Procedure AP_DRILLDOWN_PUB_PKG.DRILLDOWN
Use Security Yes
Security Function XLA_SECURITY_POLICY_PKG.MO_POLICY
Journal Source Payables
Control Account Type Code Supplier
Subject to Validation No
Calculate Reporting Currency Amounts Yes

The following table shows the attribute values that Oracle US Federal Financials predefines for the Oracle Receivables application.

Predefined Oracle Receivables Application
Field Value
Application Oracle Receivables
Drilldown Procedure AR_DRILLDOWN_PUB_PKG.DRILLDOWN
Use Security Yes
Security Function XLA_SECURITY_POLICY_PKG.MO_POLICY
Journal Source Receivables
Control Account Type Code Customer
Subject to Validation No
Calculate Reporting Currency Amounts Yes

The following table shows the attribute values that Oracle US Federal Financials predefines for the Oracle Cost Management application.

Predefined Oracle Cost Management Application
Field Value
Application Cost Management
Drilldown Procedure CST_DRILLDOWN_PUB_PKG.DRILLDOWN
Use Security No
Security Function None
Journal Source Cost Management
Control Account Type Code None
Subject to Validation No
Calculate Reporting Currency Amounts Yes

Event Entities

The following table lists the setup information that Oracle US Federal Financials predefines for the event entities for the Federal Financials application.

Note: Federal Financials 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 number exists, when gapless event processing is not enabled.

Predefined Event Entities for Federal Financials
Application Entity Name Description Gapless Event Processing
Federal Financials BE_RPR_TRANSACTIONS Reprogram Budget Execution Transactions No
Federal Financials BE_TRANSACTIONS Budget Execution Transactions No
Federal Financials TREASURY_CONFIRMATION Treasury confirmation transactions No

The following table lists the setup information that Oracle US Federal Financials predefines for the event entities for the Oracle Purchasing application.

Predefined Event Entities for Oracle Purchasing
Application Entity Name Description Gapless Event Processing
Oracle Purchasing Purchase Order Purchase Orders and Agreements No
Oracle Purchasing Release Releases No
Oracle Purchasing Requisition Purchase Requisitions and Internal Requisitions No

The following table lists the setup information that Oracle US Federal Financials predefines for the event entities for the Oracle Payables application.

Predefined Event Entities for Oracle Payables
Application Entity Name Description Gapless Event Processing
Oracle Payables AP Invoices Invoices No
Oracle Payables AP Payments Payments No

The following table lists the setup information that Oracle US Federal Financials predefines for the event entities for the Oracle Receivables application.

Predefined Event Entities for Oracle Receivables
Application Entity Name Description Gapless Event Processing
Oracle Receivables Adjustments Adjustments No
Oracle Receivables Receipts Receipts No
Oracle Receivables Transactions Transactions No

The following table lists the setup information that Oracle US Federal Financials predefines for the event entities for the Oracle Cost Management application.

Predefined Event Entities for Costing
Application Entity Name Description Gapless Event Processing
Oracle Cost Management Material Accounting Events Material Accounting Events No
Oracle Cost Management Receiving Accounting Events Receiving Accounting Events No

Event Classes and Event Types

Oracle US Federal Financials predefines event classes and event types for each event entity that belongs to the following applications:

These event classes and event types are for US federal-related procure-to-pay and order-to-costing business processes.

The following table lists the predefined event classes and event types that Oracle US Federal Financials predefines for the Federal Financials application:

Predefined Event Classes and Event Types for Federal Financials
Entity Event Class Name Event Type Name
Budget Execution Transactions Budget Execution Transactions Budget Authority Reserve
Budget Execution Transactions Budget Execution Transactions All
Budget Execution Transactions Budget Execution Transactions Fund Distribution Reserve
Reprogram Budget Execution Transactions Reprogram Budget Execution Transactions Reprogram Budget Authority Reserve
Reprogram Budget Execution Transactions Reprogram Budget Execution Transactions All
Reprogram Budget Execution Transactions Reprogram Budget Execution Transactions Reprogram Fund Distribution Reserve
Treasury Confirmation Treasury Confirmation Transactions All
Treasury Confirmation Treasury Confirmation Transactions Treasury Backout
Treasury Confirmation Treasury Confirmation Transactions Treasury Confirm
Treasury Confirmation Treasury Confirmation Transactions Treasury Void

The following table lists the predefined event classes and event types that Oracle US Federal Financials predefines for the Oraclel Purchasing application:

Predefined Event Classes and Event Types for Oracle Purchasing
Entity Event Class Name Event Type Name
Purchase Order Purchase Order and Agreement All
Purchase Order Purchase Order and Agreement PO PA Cancelled
Purchase Order Purchase Order and Agreement PO PA Created
Purchase Order Purchase Order and Agreement PO PA Credit Memo Cancelled
Purchase Order Purchase Order and Agreement PO PA Deleted
Purchase Order Purchase Order and Agreement PO PA Distributed
Purchase Order Purchase Order and Agreement PO PA Finally Closed
Purchase Order Purchase Order and Agreement PO PA Invoice Cancelled
Purchase Order Purchase Order and Agreement PO PA Redistributed
Purchase Order Purchase Order and Agreement PO PA Rejected
Purchase Order Purchase Order and Agreement PO PA Reopen Final Match
Purchase Order Purchase Order and Agreement PO PA Reserved
Purchase Order Purchase Order and Agreement PO PA Unreserved
Purchase Order Purchase Order and Agreement PO Reopen Final Match
Release Release All
Release Release Release Cancelled
Release Release Release Created
Release Release Release Credit Memo Cancelled
Release Release Release Deleted
Release Release Release Distributed
Release Release Release Finally Closed
Release Release Release Invoice Cancelled
Release Release Release Redistributed
Release Release Release Rejected
Release Release Release Reopen Finally Closed
Release Release Release Reserved
Release Release Release Unreserved
Requisition Requisition All
Requisition Requisition Requisition Adjusted
Requisition Requisition Requistion Cancelled
Requisition Requisition Requsition Created
Requisition Requisition Requsition Deleted
Requisition Requisition Requsition Distributed
Requisition Requisition Requisition Finally Closed
Requisition Requisition Requisition Rejected
Requisition Requisition Requisition Reserved
Requisition Requisition Requisition Returned
Requisition Requisition Requisition Unreserved

The following table lists the predefined event classes and event types that Oracle US Federal Financials predefines for the Oracle Payables application:

Predefined Event Classes and Event Types for Oracle Payables
Entity Event Class Name Event Type Name
AP Invoices Standard Validated Tax Invoice Validated
AP Invoices Credit Memo Adjusted Credit Memo Adjusted
AP Invoices Credit Memo Cancelled Credit Memo Cancelled
AP Invoices Credit Memo Validated Credit Memo Validated
AP Invoices All  
AP Invoices Debit Memo Adjusted Debit Memo Adjusted
AP Invoices Debit Memo Cancelled Debit Memo Cancelled
AP Invoices Debit Memo Validated Debit Memo Validated
AP Invoices All  
AP Invoices Expense Report Cancelled Tax Expense Report Cancelled
AP Invoices Expense Report Created Expense Report Created
AP Invoices Expense Report Distribute Distribute Tax Lines
AP Invoices Expense Report Frozen Tax Lines Frozen
AP Invoices Expense Report Holds Released Tax Holds Released
AP Invoices Expense Report Override Dist Override Tax Distributions
AP Invoices Expense Report Override Tax Override Tax Lines
AP Invoices Expense Report Redistribute Redistribute Tax Lines
AP Invoices Expense Report Unfrozen Tax Lines Unfrozen
AP Invoices Expense Report Updated Expense Report Updated
AP Invoices Expense Report Validated Tax Expense Report Validated
AP Invoices All  
AP Invoices Invoice Adjusted Invoice Adjusted
AP Invoices Invoice Cancelled Invoice Cancelled
AP Invoices Invoice Validated Invoice Validated
AP Invoices All  
AP Invoices Prepayment Application Adjusted Prepayment Application Adjusted
AP Invoices All  
AP Invoices Prepayment Applied Prepayment Applied
AP Invoices Prepayment Unapplied Prepayment Unapplied
AP Invoices Prepayment Cancelled Tax Prepayment Invoice Cancelled
AP Invoices Prepayment Created Prepayment Invoice Created
AP Invoices Prepayment Distribute Distribute Tax Lines
AP Invoices Prepayment Frozen Tax Lines Frozen
AP Invoices Prepayment Holds Released Tax Holds Released
AP Invoices All  
AP Invoices Prepayment Override Dist Override Tax Distributions
AP Invoices Prepayment Override Tax Override Tax Lines
AP Invoices Prepayment Redistribute Redistribute Tax Lines
AP Invoices Prepayment Unfrozen Tax Lines Unfrozen
AP Invoices Prepayment Updated Prepayment Invoice Updated
AP Invoices Prepayment Validated Tax Prepayment Invoice Validated
AP Invoices Prepayment Adjusted Prepayment Adjusted
AP Invoices Prepayment Cancelled Prepayment Cancelled
AP Invoices Prepayment Validated Prepayment Validated
AP Invoices All  
AP Invoices Standard Cancelled Tax Invoice Cancelled
AP Invoices Standard Created Invoice Created
AP Invoices Standard Distribute Distribute Tax Lines
AP Invoices Standard Frozen Tax Lines Frozen
AP Invoices Standard Fully Reversed Invoice Reversed
AP Invoices Standard Holds Released Tax Holds Released
AP Invoices All  
AP Invoices Standard Override Dist Override Tax Distributions
AP Invoices Standard Override Tax Override Tax Lines
AP Invoices Standard Redistribute Redistribute Tax Lines
AP Invoices Standard Unfrozen Tax Lines Unfrozen
AP Invoices Standard Updated Invoice Updated
AP Payments All  
AP Payments Payment Matured Payment Matured
AP Payments All  
AP Payments Refund Recorded Refund Recorded
AP Payments Payment Maturity Adjusted Payment Maturity Adjusted
AP Payments Payment Maturity Reversed Payment Maturity Reversed
AP Payments Manual Payment Adjusted Manual Payment Adjusted
AP Payments Payment Adjusted Payment Adjusted
AP Payments Payment Cancelled Payment Cancelled
AP Payments Payment Created Payment Created
AP Payments All  
AP Payments Payment Cleared Payment Cleared
AP Payments Payment Clearing Adjusted Payment Clearing Adjusted
AP Payments Payment Uncleared Payment Uncleared
AP Payments All  
AP Payments Refund Adjusted Refund Adjusted
AP Payments Refund Cancelled Refund Cancelled

The following table lists the predefined event classes and event types that Oracle US Federal Financials predefines for the Oracle Receivables application:

Predefined Event Classes and Event Types for Oracle Receivables
Entity Event Class Name Event Type Name
Transactions Invoice Invoice Created
Transactions Invoice Invoice Updated
Receipts Receipt Receipt Applied
Receipts Receipt Receipt Created
Receipts Receipt Receipt Rate Adjusted
Receipts Receipt Receipt Reverse
Receipts Receipt Receipt Unapplied
Receipts Receipt Receipt Updated
Receipts Misc_Receipt Miscellaneous Receipt Created
Receipts Misc_Receipt Miscellaneous Receipt Rate Adjust
Receipts Misc_Receipt Miscellaneous Receipt Reverse
Receipts Misc_Receipt Miscellaneous Receipt Updated

The following table lists the predefined event classes and event types that Oracle US Federal Financials predefines for the Oracle Cost Management application:

Predefined Event Classes and Event Types for Oracle Cost Management
Entity Event Class Name Event Type Name
Receiving Accounting Events Deliver Expense Delivery to Expense Destination
Material Accounting Events Purchase Order PO Delivery into Inventory

Process Categories

Oracle US Federal Financials predefines the following process categories for the Federal Financials application:

Oracle US Federal Financials predefines the following process categories for the Oracle Purchasing application:

Oracle US Federal Financials predefines the following process categories for the Oracle Payables application:

Oracle US Federal Financials predefines the following process categories for the Oracle Receivables application:

Oracle US Federal Financials predefines the following process categories for the Oracle Cost Management application:

Accounting Event Class Options

Accounting event class options define attributes of an event class. Oracle US Federal Financials defines the accounting event class options for each predefined event class for the following applications:

The accounting event class options include the following attributes:

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.

The following table lists the accounting event class options that Oracle US Federal Financials predefines for the Federal Financials application.

Predefined Accounting Event Class Options for the Federal Financials Application
Event Class Process Category Journal Category Transaction View Balance Types
Reprogram Budget Execution Transactions Reprogram Budget Execution Transactions Budget Reprogram FV_BE_RPR_XLA_V Actual
Budget Execution Transactions Budget Execution Transactions Budget Distribution FV_BE_XLA_V Actual
Treasury Accomplishment Treasury Confirmation Treasury Confirm FV_TREAS_PMTS_TRANSACTION_V Actual

The following table lists the accounting event class options that Oracle US Federal Financials predefines for the Oracle Purchasing application.

Predefined Accounting Event Class Options for the Oracle Purchasing Application
Event Class Process Category Journal Category Transaction View Balance Types
Purchase Order and Agreement Purchase Order Purchases PO_TRANSACTION_V Actual, Encumbrance
Release Release Release PO_RELEASE_TRANSACTION_V Actual, Encumbrance
Requisition Requisition Requisitions PO_REQ_TRANSACTION_V Actual, Encumbrance

The following table lists the accounting event class options that Oracle US Federal Financials predefines for the Oracle Payables application.

Predefined accounting Event Class Options for the Oracle Payables Application
Event Class Process Category Journal Category Transaction View Balance Types
Credit Memos Invoices Purchase Invoices AP_SLA_INVOICES_TRANSACTION_V Actual, Encumbrance
Debit Memos Invoices Purchase Invoices AP_SLA_INVOICES_TRANSACTION_V Actual, Encumbrance
Invoices Invoices Purchase Invoices AP_SLA_INVOICES_TRANSACTION_V Actual, Encumbrance
Prepayment Applications Invoices Purchase Invoices AP_SLA_INVOICES_TRANSACTION_V Actual, Encumbrance
Prepayments Invoices Purchase Invoices AP_SLA_INVOICES_TRANSACTION_V Actual, Encumbrance
Future Dated Payments Payments Payments AP_SLA_PAYMENTS_TRANSACTION_V Actual
Payments Payments Payments AP_SLA_PAYMENTS_TRANSACTION_V Actual, Encumbrance
Reconciled Payments Payments Reconciled Payments AP_SLA_PAYMENTS_TRANSACTION_V Actual, Encumbrance
Refunds Payments Payments AP_SLA_PAYMENTS_TRANSACTION_V Actual, Encumbrance

The following table lists the accounting event class options that Oracle US Federal Financials predefines for the Oracle Receivables application.

Predefined Accounting Event Class Options for the Oracle Receivables Application
Event Class Process Category Journal Category Transaction View Balance Types
Adjustments Adjustments Adjustment AR_ADJ_INF_V Actual
Miscellaneous Receipt Miscellaneous Receipts Misc Receipts AR_CR_INF_V Actual
Receipts Standard Receipts Receipts AR_CR_INF_V Actual
Credit Memo Transactions Credit Memos AR_TRX_INF_V Actual
Debit Memo Transactions Debit Memos AR_TRX_INF_V Actual
Invoice Transactions Sales Invoices AR_TRX_INF_V Actual

The following table lists the accounting event class options that Oracle US Federal Financials predefines for the Oracle Cost Management application.

Predefined Accounting Event Class Options for Oracle Cost Management
Event Class Process Category Journal Category Transaction View Balance Types
PO Delivery into Inventory Inventory Inventory CST_XLA_INV_PO_V Actual, Encumbrance
Delivery to Expense Destination Receiving Receiving CST_XLA_RCV_V Actual, Encumbrance
Receipt into Receiving Inspection Receiving Receiving CST_XLA_RCV_V Actual

Sources, Source Assignments, and Accounting Attribute Assignments

Oracle US Federal Financials 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 US Federal Financials responsibility if you want to review the sources, source assignments, and accounting attribute assignments associated with the Federal applications.

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, <PR to add xref>. If you choose to define your own journal line types or application accounting definitions, then you can override the default accounting attribute assignments.

Oracle US Federal Financials provides many 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:

  1. Log into Oracle Applications.

  2. Select an Oracle US Federal Financials, Oracle Purchasing, Oracle Payables, Oracle Receivables, or Oracle Cost Management responsibility, depending on the sources that you want to review.

  3. Navigate to the Sources window.

    • From a Oracle US Federal Financials superuser responsibility: Setup - Subledger Accounting - Accounting Methods Builder - Sources - Sources

    • From an Oracle Purchasing superuser responsibility: Setup - Subledger Accounting Setups - Accounting Methods Builder - Sources - Sources

    • From an Oracle Payables superuser responsibility: Accounting Setups - Subledger Accounting Setup - Accounting Methods Builder - Sources - Sources

    • From an Oracle Receivables superuser responsibility: Accounting Setups - Subledger Accounting Setup - Accounting Methods Builder - Sources - Sources

    • From an Oracle Cost Management superuser responsibility: Accounting Setups - Subledger Accounting Setup - Accounting Methods Builder - Sources - Sources

  4. Query the records you want to export.

  5. Place your cursor in the multi-row block that contains the records to be exported.

  6. Choose Export from the File menu.

Related Topics

Exporting Records to a File, Oracle Applications User’s Guide

Journal Line Types

Oracle US Federal Financials predefines journal line types for each predefined event class for the following applications:

Additionally, Oracle US Federal Financials specifies conditions for the use of each journal line type.

The following table lists the journal line types that Oracle US Federal Financials predefines for the Federal Financials application:

Predefined Journal Line Types for the Federal Financials Application
Event Class Name Description Side
Budget Execution Transactions Budget Execution Transaction Credit Budget Execution Transaction Credit Credit
Budget Execution Transactions Budget Execution Transaction Debit Budget Execution Transaction Debit Debit
Budget Execution Transactions RPR From Budget Execution Transaction Credit RPR From Budget Execution Transaction Credit Credit
Budget Execution Transactions RPR From Budget Execution Transaction Debit RPR From Budget Execution Transaction Debit Debit
Budget Execution Transactions RPR To Budget Execution Transaction Credit RPR To Budget Execution Transaction Credit Credit
Budget Execution Transactions RPR To Budget Execution Transaction Debit RPR To Budget Execution Transaction Debit Debit
Treasury Accomplishment Federal Treasury Cash Account – DR Federal Treasury Cash Account – DR Debit
Treasury Accomplishment Federal Treasury Cash Account Reversal – CR Federal Treasury Cash Account Reversal – CR Credit
Treasury Accomplishment Federal Disbursement in Transit Account - CR Federal Disbursement in Transit Account - CR Credit
Treasury Accomplishment Federal Disbursement in Transit Account Reversal - DR Federal Disbursement in Transit Account Reversal - DR Credit
Treasury Accomplishment Federal Treasury Confirmation Paid Account - CR Federal Treasury Confirmation Paid Account - CR Credit
Treasury Accomplishment Federal Treasury Confirmation Paid Account Reversal - DR Federal Treasury Confirmation Paid Account Reversal – DR Debit
Treasury Accomplishment Federal Treasury Confirmation Unpaid Account Reversal – CR Federal Treasury Confirmation Unpaid Account Reversal – CR Credit

The following table lists the journal line types that Oracle US Federal Financials predefines for the Oracle Purchasing application:

Predefined Journal Line Types for the Oracle Purchasing Application
Event Class Name Description Side
Purchase Order and Agreement Federal BPA Cancel CR Federal Budgetary BPA Cancel Entry Credit
Purchase Order and Agreement Federal BPA Cancel DR Federal Budgetary BPA Cancel Entry Debit
Purchase Order and Agreement Federal BPA Relieve CR Federal Budgetary BPA Relieve Entry Credit
Purchase Order and Agreement Federal BPA Relieve DR Federal Budgetary BPA Relieve Entry Debit
Purchase Order and Agreement Federal BPA Reserve CR Federal Budgetary BPA Reserve Entry Credit
Purchase Order and Agreement Federal BPA Reserve DR Federal Budgetary BPA Reserve Entry Debit
Purchase Order and Agreement Federal BPA Unreserve CR Federal Budgetary BPA Unreserve Entry Credit
Purchase Order and Agreement Federal BPA Unreserve DR Federal Budgetary BPA Unreserve Entry Debit
Purchase Order and Agreement Federal Purchasing Reserve CR Federal Budgetary Purchasing Reserve Entry Credit
Purchase Order and Agreement Federal Purchasing Reserve DR Federal Budgetary Purchasing Reserve Entry Debit
Purchase Order and Agreement Federal Purchasing PYA Diff Reserve CR Federal Budgetary PYA Diff Reserve Entry Credit
Purchase Order and Agreement Federal Purchasing PYA Diff Reserve DR Federal Budgetary PYA Diff Reserve Entry Debit
Purchase Order and Agreement Federal Purchasing PYA Downward Anticipated Reserve CR Federal Budetary PYA Downward Anticipated Entry Credit
Purchase Order and Agreement Federal Purchasing PYA Downward Unanticipated Reserve CR Federal Budgetray PYA Downward Unanticipated Entry Credit
Purchase Order and Agreement Federal Purchasing PYA Final Close CR Federal Purchasing PYA Final Close CR Credit
Purchase Order and Agreement Federal Purchasing PYA Final Close DR Federal Purchasing PYA Final Close DR Debit
Purchase Order and Agreement Federal Purchasing PYA Reserve CR Federal Budgetray PYA Reserve Entry Credit
Purchase Order and Agreement Federal Purchasing PYA Reserve DR Federal Budgetary PYA Reserve Entry Debit
Purchase Order and Agreement Federal Purchasing Cancel PYA CR Federal Purchasing PYA Cancel CR Credit
Purchase Order and Agreement Federal Reinstate BPA Purchasing Unreserve CR Federal Budgetary Reinstate BPA Entry Credit
Purchase Order and Agreement Federal Reinstate BPA Purchasing Unreserve DR Federal Budgetray Reinstate BPA Entry Debit
Purchase Order and Agreement Federal Reinstate Requisition Purchasing Unreserve CR Federal Budgetary Reinstate Requisition Entry Credit
Purchase Order and Agreement Federal Reinstate Requisition Purchasing Unreserve DR Federal Budgetary Reinstate Requisition Entry Debit
Purchase Order and Agreement Federal Purchasing Cancel CR Federal Budgetary Purchasing Reverse Entry Credit
Purchase Order and Agreement Federal Purchasing Cancel DR Federal Budgetary Purchasing Reverse Entry Debit
Purchase Order and Agreement Federal Purchasing Cancel PYA DR Federal Purchasing Cancel PYA DR Debit
Purchase Order and Agreement Federal Purchasing Unreserve CR Federal Budgetary Purchasing Unreserve Entry Credit
Purchase Order and Agreement Federal Purchasing Unreserve DR Federal Budgetary Purchasing Unreserve Entry Debit
Purchase Order and Agreement Federal Reinstate BPA Purchasing Reverse CR Federal Budgetary Purchasing Reverse Entry Credit
Purchase Order and Agreement Federal Reinstate BPA Purchasing Reverse DR Federal Budgetary Purchasing Reverse Entry Debit
Purchase Order and Agreement Federal Reinstate Requisition Purchasing Reverse CR Federal Budgetary Purchasing Reverse Entry Credit
Purchase Order and Agreement Federal Reinstate Requisition Purchasing Reverse DR Federal Budgetary Purchasing Reverse Entry Debit
Purchase Order and Agreement Federal Purchase order Reopen Final Match Credit Federal Purchase order Reopen Final Match Credit Credit
Purchase Order and Agreement Federal Purchase Order Reopen Final Match Debit Federal Purchase Order Reopen Final Match Debit Debit
Purchase Order and Agreement Federal Relieve Requisition CR Federal Budgetary Requisition Relieve Entry Credit
Purchase Order and Agreement Federal Relieve RequsitionDR Federal Budgetary Requisition Relieve Entry Debit
Release Federal Release Cancel CR Federal Release Cancel CR Credit
Release Federal Release Cancel DR   Debit
Release Federal Release PYA Cancel DR Federal Release PYA Cancel DR Debit
Release Federal Release Cancel Reinstate PO PA CR Federal Budgetary Release Cancel Entry Credit
Release Federal Release Cancel Reinstate PO PA DR Federal Budgetary Release Cancel Entry Debit
Release Federal Release Cancel Reinstate Req CR Federal Budgetary Release Cancel Entry Credit
Release Federal Release Cancel Reinstate Req DR Federal Bugdetart Release Cancel Entry Debit
Release Federal Release PYA Cancel CR Federal Release PYA Cancel CR Credit
Release Federal Release PYA Diff Reserve CR Federal Release PYA Diff Reserve CR Credit
Release Federal Release PYA Diff Reserve DR Federal Release PYA Diff Reserve DR Debit
Release Federal Release PYA Downward Anticipated CR Federal Release PYA Downward Anticipated CR Credit
Release Federal Release PYA Downward Unanticipated CR Federal Release PYA Downward Unanticipated CR Credit
Release Federal Release PYA Final Close CR Federal Release PYA Final Close CR Credit
Release Federal Release PYA Final Close DR Federal Release PYA Final Close DR Debit
Release Federal Release PYA Reserve CR Federal Release PYA Reserve CR Credit
Release Federal Release PYA Reserve DR Federal Release PYA Reserve DR Debit
Release Federal Release Reinstate PO PA CR Federal Release Reinstate PO PA CR entry Credit
Release Federal Release Reinstate PO PA DR Federal Release Reinstate PO PA DR entry Debit
Release Federal Release Reinstate Req CR Federal Bugetary Release Unreserve Entry Credit
Release Federal Release Reinstate Req DR Federa; Budgetary Release Unreserve Entry Debit
Release Federal Release Relieve PO PA CR Federal Budgetary Release Relieve Entry Credit
Release Federal Release Relieve PO PA DR Federal Budgetary Release Relieve Entry Debit
Release Federal Release Relieve Req CR Federal Budgetary Release Relieve Entry Credit
Release Federal Release Relieve Req DR Federal Budgetary Release Relieve Entry Debit
Release Federal Release Reopen Finally Closed CR Federal Budgetary Release Reopen Entries Credit
Release Federal Release Reopen Finally Closed DR Federal Budgetary Release Reopen Entry Debit
Release Federal Release Reserve CR Federal Budgetary Release Reserve Entry Credit
Release Federal Release Reserve DR Federal Budgetary Release Reserve Entry Debit
Release Federal Release Reverse CR Federal Budgetary Release Reverse Entry Credit
Release Federal Release Reverse DR Federal Budgetary Release Reverse Entry Debit
Requisition Federal Requisition CancelCR Federal Budgetary Requisition Cancel Entry Credit
Requisition Federal Requisition CancelDR Federal Budgetary Requisition Cancel Entry Debit
Requisition Federal Requisition Reserve CR Federal Budgetary Requisition Accounting Credit
Requisition Federal Requisition Reserve DR Federal Budgetary Requisition Accounting Debit
Requisition Federal Requisition UnReserve CR Federal Budgetary Reversal Requisition Entry Credit
Requisition Federal Requisition UnReserve DR Federal Bugetary Reversal Requisition Entry Debit

The following table lists the journal line types that Oracle US Federal Financials predefines for the Oracle Payables application:

Predefined Journal Line Types for the Oracle Payables Application
Event Class Name Description Side
Credit Memos Federal Credit Memo Downward Anticipated PYA Credit Federal Credit Memo Downward Anticipated PYA Credit Credit
Credit Memos Federal Credit Memo DownwardPYA Debit Federal Credit Memo DownwardPYA Debit Debit
Credit Memos Federal Credit Memo Downward Unanticipated PYA Credit Federal Credit Memo Downward Unanticipated PYA Credit Credit
Credit Memos Federal Credit Memo Upward PYA Credit Federal Credit Memo Upward PYA Credit Credit
Credit Memos Federal Credit Memo Upward PYA Debit Federal Credit Memo Upward PYA Debit Debit
Credit Memos Federal Direct Fund Credit Memos Credit Federal Direct Fund Credit Memos Credit Credit
Credit Memos Federal Direct Fund Credit Memos Debit Federal Direct Fund Credit Memos Debit Debit
Credit Memos Federal Direct Fund Reversal Credit Memos Credit Federal Direct Fund Reversal Credit Memos Credit Credit
Credit Memos Federal Direct Fund Reversal Credit Memos Debit Federal Direct Fund Reversal Credit Memos Debit Debit
Credit Memos Federal Credit Memos Expenditure Credit Federal Credit Memos Expenditure Credit Credit
Credit Memos Federal Credit Memos Expenditure Debit Federal Credit Memos Expenditure Debit Debit
Debit Memos Federal Debit Memos Expenditure Credit Federal Debit Memos Expenditure Credit Credit
Debit Memos Federal Debit Memos Expenditure Debit Federal Debit Memos Expenditure Debit Debit
Debit Memos Federal Debit Memo Downward Anticipated PYA Credit Federal Debit Memo Downward Anticipated PYA Credit Credit
Debit Memos Federal Debit Memo DownwardPYA Debit Federal Debit Memo DownwardPYA Debit Debit
Debit Memos Federal Debit Memo Downward Unanticipated PYA Credit Federal Debit Memo Downward Unanticipated PYA Credit Credit
Debit Memos Federal Debit Memo Upward PYA Credit Federal Debit Memo Upward PYA Credit Credit
Debit Memos Federal Debit Memo Upward PYA Debit Federal Debit Memo Upward PYA Debit Debit
Debit Memos Federal Direct Fund Debit Memos Credit Federal Direct Fund Debit Memos Credit Credit
Debit Memos Federal Direct Fund Debit Memos Debit Federal Direct Fund Debit Memos Debit Debit
Debit Memos Federal Direct Fund Reversal Debit Memos Credit Federal Direct Fund Reversal Debit Memos Credit Credit
Debit Memos Federal Direct Fund Reversal Debit Memos Debit Federal Direct Fund Reversal Debit Memos Debit Debit
Invoices Federal Direct Expenditure Invoice Credit Federal Direct Expenditure Invoice Credit Credit
Invoices Federal Direct Expenditure Invoice Debit Federal Direct Expenditure Invoice Debit Debit
Invoices Federal Invoice Downward Anticipated PYA Credit Federal Invoice Downward Anticipated PYA Credit Credit
Invoices Federal Invoice DownwardPYA Debit Federal Invoice Downward PYA Debit Debit
Invoices Federal Invoice Downward Unanticipated PYA Credit Federal Invoice Downward Unanticipated PYA Credit Credit
Invoices Federal Invoice Upward PYA Credit Federal Invoice Upward PYA Credit Credit
Invoices Federal Invoice Upward PYA Debit Federal Invoice Upward PYA Debit Debit
Invoices Federal Direct Fund Invoice Credit Federal Direct Fund Invoice Credit Credit
Invoices Federal Direct Fund Invoice Debit Federal Direct Fund Invoice Debit Debit
Invoices Federal Direct Fund Reverse Invoice Credit Federal Direct Fund Reverse Invoice Credit Debit
Invoices Federal Direct Fund Reverse Invoice Debit Federal Direct Fund Reverse Invoice Debit Debit
Invoices Federal Paid Obligation Reversal Credit Federal Paid Obligation Reversal Credit Credit
Invoices Federal Paid Obligation Reversal Debit Federal Paid Obligation Reversal Debit Debit

The following table lists the journal line types that Oracle US Federal Financials predefines for the Oracle Receivables application:

Predefined Journal Line Types for the Oracle Receivables Application
Event Class Name Description Side
Adjustment FV ADJ Reimbursable Earned CR FV ADJ Reimbursable Earned CR Credit
Adjustment FV ADJ Reimbursable Earned DR FV ADJ Reimbursable Earned DR Debit
Credit Memo FV CM Reimbursable Earned CR FV CM Reimbursable Earned CR Credit
Credit Memo FV CM Reimbursable Earned DR FV CM Reimbursable Earned DR Debit
Debit Memo FV DM Reimbursable Earned CR FV DM Reimbursable Earned CR Credit
Debit Memo FV DM Reimbursable Earned DR FV DM Reimbursable Earned DR Credit
Invoice FV Inv Reimbursable Earned CR FV Inv Reimbursable Earned CR Credit
Invoice FV Inv Reimbursable Earned DR FV Inv Reimbursable Earned DR Debit
Miscellaneous Receipt FV MRct Appropriations CR FV MRct Appropriations CR Credit
Miscellaneous Receipt FV MRct Appropriations DR FV MRct Appropriations DR Debit
Miscellaneous Receipt FV MRct Refund CR FV MRct Refund CR Credit
Miscellaneous Receipt FV MRct Refund DR FV MRct Refund DR Debit
Miscellaneous Receipt FV MRct Reimbursable Collection CR FV MRct Reimbursable Collection CR Credit
Miscellaneous Receipt FV MRct Reimbursable Collection DR FV MRct Reimbursable Collection DR Debit
Receipt FV CRct Appropriations CR FV CRct Appropriations CR Credit
Receipt FV CRct Appropriations DR FV CRct Appropriations DR Debit
Receipt FV CRct Refund CR FV CRct Refund CR Credit
Receipt FV CRct Refund DR FV CRct Refund DR Debit
Receipt FV CRct Reimbursable Collection CR FV CRct Reimbursable Collection CR Credit
Receipt FV CRct Reimbursable Collection DR FV CRct Reimbursable Collection DR Debit

The following table lists the journal line types that Oracle US Federal Financials predefines for the Oracle Cost Management application:

Predefined Journal Line Types for the Oracle Cost Management Application
Event Class Name Description Side
Delivery to Expense Destination FV DEL Anticipated Budget FV DEL Anticipated Budget Debit
Delivery to Expense Destination FV DEL Expended Appropriations FV DEL Expended Appropriations Credit
Delivery to Expense Destination FV DEL Paid Expenditure FV DEL Paid Expenditure Credit
Delivery to Expense Destination FV DEL Paid Obligation FV DEL Paid Obligation Debit
Delivery to Expense Destination FV DEL Unanticipated Budget FV DEL Unanticipated Budget Credit
Delivery to Expense Destination FV DEL Unexpended Appropriations FV DEL Unexpended Appropriations Debit
Delivery to Expense Destination FV DEL Unpaid Expenditure FV DEL Unpaid Expenditure Credit
Delivery to Expense Destination FV DEL Unpaid Obligation FV DEL Unpaid Obligation Debit
Delivery to Expense Destination FV DEL Unpaid Obligation - PYA FV DEL Unpaid Obligation - PYA Credit
Delivery to Expense Destination FV DEL Unpaid Obligation - PYA Offset FV DEL Unpaid Obligation - PYA Offset Debit
PO Delivery into Inventory FV INV Anticipated Budget FV INV Anticipated Budget Debit
PO Delivery into Inventory FV INV Expended Appropriations FV INV Expended Appropriations Credit
PO Delivery into Inventory FV INV Paid Expenditure FV INV Paid Expenditure Credit
PO Delivery into Inventory FV INV Paid Obligation FV INV Paid Obligation Debit
PO Delivery into Inventory FV INV Unanticipated Budget FV INV Unanticipated Budget Credit
PO Delivery into Inventory FV INV Unexpended Appropriations FV INV Unexpended Appropriations Debit
PO Delivery into Inventory FV INV Unpaid Expenditure FV INV Unpaid Expenditure Credit
PO Delivery into Inventory FV INV Unpaid Obligation FV INV Unpaid Obligation Debit
PO Delivery into Inventory FV INV Unpaid Obligation - PYA FV INV Unpaid Obligation - PYA Credit
PO Delivery into Inventory FV INV Unpaid Obligation - PYA Offset FV INV Unpaid Obligation - PYA Offset Debit

Account Derivation Rules

Oracle US Federal Financials predefines account derivation rules for the following applications:

Oracle Subledger Accounting uses the predefined rules for creating accounting for events in these federal applications, it accepts the default accounting without change. You can optionally define your own account derivation rules for an accounting flexfield or for a segment. In this case, Oracle Subledger Accounting overrides the default accounts that Oracle US Federal Financials generates, or individual segment values in the default accounts, when it creates the draft or final subledger accounting.

The account derivation rules that Oracle US Federal Financials predefines for the Federal Financials application are as follows:

The account derivation rules that Oracle US Federal Financials predefines for the Oracle Purchasing application are as follows:

The account derivation rules that Oracle US Federal Financials predefines for the Oracle Payables application are as follows:

The account derivation rules that Oracle US Federal Financials predefines for the Oracle Receivables application are as follows:

The account derivation rules that Oracle US Federal Financials predefines for the Oracle Cost Management application are as follows:

Journal Lines Definitions

Oracle US Federal Financials predefines journal lines definitions that group the predefined journal line types and account derivation rules within each of the predefined event types. The application assigns each predefined journal lines definition to all event types within an event class.

Oracle US Federal Financials predefines journal lines definitions for the following applications:

The following table lists the journal line definitions that Oracle US Federal Financials predefines for the Federal Financials application:

Predefined Journal Line Definitions for the Federal Financials Application
Entity Event Class Budgetary Control
Treasury Confirmation Treasury Accomplishment No
Budget Execution Transactions Budget Execution Transactions Yes
Reprogram Budget Execution Transactions Reprogram Budget Execution Transactions Yes

The following table lists the journal line definitions that Oracle US Federal Financials predefines for the Oracle Purchasing application:

Predefined Journal Line Definitions for the Oracle Purchasing Application
Entity Event Class Budgetary Control
Purchase Order Purchase Order and Agreement Yes
Release Release Yes
Requisition Requisition Yes

The following table lists the journal line definitions that Oracle US Federal Financials predefines for the Oracle Payables application:

Predefined Journal Line Definitions for the Oracle Payables Application
Entity Event Class Budgetary Control
AP Invoices Debit Memos Yes
AP Invoices Credit Memos Yes
AP Invoices Invoices Yes

The following table lists the journal line definitions that Oracle US Federal Financials predefines for the Oracle Receivables application:

Predefined Journal Line Definitions for the Oracle Receivables Application
Entity Event Class Budgetary Control
Adjustments Adjustments No
Receipts Miscellaneous Receipt No
Receipts Receipt No
Transactions Credit Memo No
Transactions Debit Memo No
Transactions Invoice No

The following table lists the journal line definitions that Oracle US Federal Financials predefines for the Oracle Cost Management application:

Predefined Journal Line Definitions for the Oracle Cost Management Application
Entity Event Class Budgetary Control
Receiving Accounting Events Delivery to Expense Destination Yes
Material Accounting Events PO Delivery into Inventory Yes
Receiving Accounting Events Receipt into Receiving Inspection No

Application Accounting Definitions

Oracle US Federal Financials predefines the application accounting definition for the following applications:

The following table lists the assignments for the Federal Financials application accounting definition that Oracle US Federal Financials predefines for the Federal Financials application.

Assignments for the Predefined Federal Financials Application Accounting Definition
Event Class Assignments Event Type Assignments Create Accounting Journal Line Definition Assignments
Budget Execution Transactions All Yes Budget Execution Journal Line Definitions
Reprogram Budget Execution Transactions All Yes Reprogram Budget Execution Journal Line Definitions
Treasury Accomplishment All Yes Federal Treasury Payments All

The following table lists the assignments for the Federal Purchasing application accounting definition that Oracle US Federal Financials predefines for the Oracle Purchasing application.

Assignments for the Predefined Federal Purchasing Application Accounting Definition
Event Class Assignments Event Type Assignments Create Accounting Journal Line Definition Assignments
Purchase Order and Agreement All Yes Federal Purchasing
Release All Yes Federal Release
Requisition All Yes Federal Requisition

The following table lists the assignments for the Federal Payables application accounting definition that Oracle US Federal Financials predefines for the Oracle Payables application.

Assignments for the Predefined Federal Payables Application Accounting Definition
Event Class Assignments Event Type Assignments Create Accounting Journal Line Definition Assignments
Credit Memos All Yes US Federal Credit Memos All
Debit Memos All Yes US Federal Debit Memos All
Invoices All Yes US Federal Invoices All

The following table lists the assignments for the Federal Receivables application accounting definition that Oracle US Federal Financials predefines for the Oracle Receivables application.

Assignments for the Predefined Federal Receivables Application Accounting Definition
Event Class Assignments Event Type Assignments Create Accounting Journal Line Definition Assignments
Adjustment All Yes Multi-Fund Federal Receivables Adjustment - Account Method
Credit Memo All Yes Multi-Fund Federal Receivables Credit Memo - Account Method
Debit Memo All Yes Multi-Fund Federal Receivables Debit Memo - Account Method
Invoice All Yes Multi-Fund Federal Receivables Invoice - Account Method
Miscellaneous Receipt All Yes Multi-Fund Federal Receivables Miscellaneous Receipt - Account Method
Receipt All Yes Multi-Fund Federal Receivables Receipt - Account Method

The following table lists the assignments for the Federal Costing application accounting definition that Oracle US Federal Financials predefines for the Oracle Cost Management application.

Assignments for the Predefined Federal Costing Application Accounting Definition
Event Class Assignments Event Type Assignments Create Accounting Journal Line Definition Assignments
Delivery to Expense Destination All Yes Federal Deliver Expense
Delivery to Expense Destination All Yes FV Delivery to Expense Destination Proprietary
PO Delivery into Inventory All Yes Federal Delivery to Inventory
PO Delivery into Inventory All Yes FV PO Delivery into Inventory Proprietary
Receipt into Receiving Inspection All Yes FV Receipt into Receiving Inspection Proprietary

Subledger Accounting Methods

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 US Federal Financials assigns the predefined Federal Financials application accounting definition to the predefined US Federal Accounting subledger accounting method. You can assign these subledger accounting methods to your ledgers.