My Oracle Support Banner

Federal Receivables and Costing Subledger Accounting changes (Doc ID 877933.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle U.S. Federal Financials - Version 12.0.6 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Details

IMPORTANT

For the Federal Receivables SLA JLTs to work:
Please change the Receivables AAD assignment for the Subledger Accounting Method that you are using, to:
Multi-Fund Federal Receivables Accrual - Account Method
(Please refer to Subledger Implementation/User Guide for information on how to change the above).

 

Federal Receivables Subledger Accounting changes

Transaction Category Mapping

Oracle Federal Financials added a new setup window in order to aid in creating Receivables SLA rules.

This new window is titled Transaction Category Mapping and the navigation path is: 

Setup –> Options –> Transactions Category Mapping

 

The Transaction Category Mapping window allows the user to map Transaction Types, Receipt Methods and Receivable Activities to Transaction Categories. The Transaction Category list of values comes from the AR Transaction Category Federal Financial lookup. Additional values can be created for this lookup if the user so chooses to create more categories.

Once this patch is applied, the Transaction Types, Receipt Methods and Receivable Activities should be mapped to the Transaction Categories as appropriate.

Seeding for Subledger Accounting

New SLA Journal Line Types and Account Derivation Rules for Receivables are seeded to create additional federal specific debits and credits and include conditions that refer to the Transaction Categories assigned on the Transaction Category Mapping window.

The following is the detail of the Transaction Categories that are seeded for Journal Line Types and/or Account Derivation Rules and the Event Class they are assigned:

Adjustment, Debit Memo, Credit Memo and Invoice Event Classes have conditions that refer to the following Transaction Categories:
- Reimbursable Earned with Advance
- Reimbursable Earned without Advance

Miscellaneous Receipt and Receipt Event Classes have conditions that refer to the following Transaction Categories:
- Advance Collection of Reimbursable Agreement
- Collection for Reimbursable Services
- Refund of Advance or Prepayment
- Refund

The Adjustment Event Class derives the Transaction Category from the mapping of the Receivable Activity.
The Debit Memo, Credit Memo and Invoice Event Classes derive the Transaction Category from the mapping of the Transaction Type.
The Miscellaneous Receipt and Receipt Event Classes derive the Transaction Category from the mapping of the Receipt Method.

As an example, if an invoice transaction is entered in Receivables with a transaction type that is assigned to Reimbursable Earned with Advance Transaction Category on the new Transaction Category Mapping window and the fund included on the transaction is a reimbursable fund, the SLA rules are seeded so that the invoice will create a debit to 425201 and a credit to 422201.

If the user chooses to create new categories, new Subledger accounting Journal Line Types and Account Derivation Rules can be created that refer to these new categories.

 

The following journal line definitions are no longer supported by Federal Receivables:
Federal Receivables Invoice Accrual All
Multi-Fund Federal Receivables Invoice - Balancing Method
Federal Miscellaneous Receipts
Multi-Fund Federal Receivables Miscellaneous Receipt - Balancing Method
Federal Receipts - Default Accrual
Multi-Fund Federal Receivables Receipt - Balancing Method

New journal line definitions used by Federal Receivables:
Multi-Fund Federal Receivables Adjustment - Account Method
Multi-Fund Federal Receivables Credit Memo - Account Method
Multi-Fund Federal Receivables Debit Memo - Account Method

Existing journal line definitions still used by Federal Receivables:
Multi-Fund Federal Receivables Invoice - Account Method
Multi-Fund Federal Receivables Miscellaneous Receipt - Account Method
Multi-Fund Federal Receivables Receipt - Account Method

The following journal line types are no longer supported by Federal Receivables:
Federal Invoice Reimbursement Advances CR
Federal Invoice Reimbursement Advances DR
Federal Misc Receipt Refunds Overpayments Expired Fund CR
Federal Misc Receipt Refunds Overpayments Expired Fund DR
Federal Misc Receipt Refunds Overpayments Unexpired Fund Current Year CR
Federal Misc Receipt Refunds Overpayments Unexpired Fund Current Year DR
Federal Misc Receipt Refunds Overpayments Unexpired Fund Prior Year CR
Federal Misc Receipt Refunds Overpayments Unexpired Fund Prior Year DR
Federal Misc Receipt Reimbursement without Advances CR
Federal Misc Receipt Reimbursement without Advances DR
Federal Receipt Refunds Overpmnts Advs Prepmnts Expired Fund CR
Federal Receipt Refunds Overpmnts Advs Prepmnts Expired Fund DR
Federal Receipt Refunds Overpmnts Advs Prepmnts Unexpired Fund Current Year CR
Federal Receipt Refunds Overpmnts Advs Prepmnts Unexpired Fund Current Year DR
Federal Receipt Refunds Overpmnts Advs Prepmnts Unexpired Fund Prior Year CR
Federal Receipt Refunds Overpmnts Advs Prepmnts Unexpired Fund Prior Year DR
Federal Receipt Reimbursement without Advances CR
Federal Receipt Reimbursement without Advances DR

New journal line types used by Federal Receivables:
FV ADJ Reimbursable Earned CR
FV ADJ Reimbursable Earned DR
FV CM Reimbursable Earned CR
FV CM Reimbursable Earned DR
FV DM Reimbursable Earned CR
FV DM Reimbursable Earned DR
FV Inv Reimbursable Earned CR
FV Inv Reimbursable Earned DR
FV MRct Appropriations CR
FV MRct Appropriations DR
FV MRct Refund CR
FV MRct Refund DR
FV MRct Reimbursable Collection CR
FV MRct Reimbursable Collection DR
FV CRct Appropriations CR
FV CRct Appropriations DR
FV CRct Refund CR
FV CRct Refund DR
FV CRct Reimbursable Collection CR
FV CRct Reimbursable Collection DR

The following account derivation rules are no longer supported by Federal Receivables:
Federal Invoice 422XOX Account CR
Federal Invoice 425XOX Account DR
Federal Miscellaneous Receipt 422101 Account CR
Federal Miscellaneous Receipt 425201 Account DR
Federal Miscellaneous Receipt 445001 Account CR
Federal Miscellaneous Receipt 465002 Account CR
Federal Miscellaneous Receipt 46X002 Account CR
Federal Miscellaneous Receipt 490201 Account DR
Federal Miscellaneous Receipt 497201 Account DR
Federal Receipt 425101 Account CR
Federal Receipt 425201 Account DR
Federal Receipt 445001 Account CR
Federal Receipt 465002 Account CR
Federal Receipt 46X002 Account CR
Federal Receipt 4X0201 Account DR
Federal Receipt 4X7201 Account DR

New account derivation rules used by Federal Receivables:
FV 3107 (Receivables)
FV 422X (Receivables)
FV 425X (Receivables)
FV 42X1 (Receivables)
FV 42X2 (Receivables)
FV 4450 or 46X0 (Receivables)
FV 48X2 or 49X2 (Receivables)
FV 5700 (Receivables)


The following sources are no longer supported by Federal Receivables:
Federal Account Rule
Federal Account Valid Flag
Federal Fund Time Frame
Federal Receivable With Advance

New sources used by Federal Receivables
FV Transaction Category

 

Federal Costing Subledger Accounting changes

Cost Management

The Following Changes are done to Journal Line Definition Assignments
for "Federal Deliver Expense":

Removed the following Journal Line Types:
Federal Reclassify appropriation CR
Federal Record Expended obligation DR
Federal Record Upward PYA CR
Federal Record Upward PYA DR
Federal Record expended obligation CR
Federal Reverse Paid Amt of Purchase Order DR
Federal Reverse Paid Unexpended Obligation CR
Federal Reverse Unexpended Obligation CR
Federal Reverse Unexpended Obligation Overflow CR
Federal Reverse Unpaid Amt of Purchase Order DR
Federal Reclassify appropriation DR

Added the following Journal Line Types:
FV DEL Anticipated Budget
FV DEL Expended Appropriations
FV DEL Paid Expenditure
FV DEL Paid Obligation
FV DEL Unanticipated Budget
FV DEL Unexpended Appropriations
FV DEL Unpaid Expenditure
FV DEL Unpaid Obligation
FV DEL Unpaid Obligation - PYA
FV DEL Unpaid Obligation - PYA Offset


The Following Changes are done to Journal Line Definition Assignments
for "Federal Delivery to Inventory":

Removed the following Journal Line Types:
Federal Reclassify appropriation CR on Delivery To Inventory
Federal Reclassify appropriation DR on Delivery To Inventory
Federal Record Expended obligation DR on Delivery To Inventory
Federal Record Upward PYA CR on DTI
Federal Record Upward PYA DR on Delivery To Inventory
Federal Record expended obligation CR on Delivery To Inventory
Federal Reverse Paid Amt of Purchase Order DR on Delivery To Inventory
Federal Reverse Unexpended Obligation CR on Delivery To Inventory
Federal Reverse Unexpended Obligation Overflow CR on Delivery To Inventory
Federal Reverse Unpaid Amt of Purchase Order DR on Delivery To Inventory

Added the following Journal Line Types:
FV INV Anticipated Budget
FV INV Expended Appropriations
FV INV Paid Expenditure
FV INV Paid Obligation
FV INV Unanticipated Budget
FV INV Unexpended Appropriations
FV INV Unpaid Expenditure
FV INV Unpaid Obligation
FV INV Unpaid Obligation - PYA
FV INV Unpaid Obligation - PYA Offset


For Application Accounting Definition "Federal Costing Application Accounting
Definition" Event Class "Delivery to Expense Destination":
Removed Journal Line Definition Assignments :

Delivery to Expense Destination
Federal Return to Receiving

Added Journal Line Definition Assignments:
FV Delivery to Expense Destination Proprietary


For Application Accounting Definition "Federal Costing Application Accounting
Definition" Event Class "PO Delivery into Inventory":
Removed Journal Line Definition Assignments:

PO Delivery into Inventory
Federal Return to Receiving from Inv

Added Journal Line Definition Assignments:
FV PO Delivery into Inventory Proprietary

 

The following sources are no longer supported:
unpaid_unexpended_obligation
paid_unexpended_obligation
unexpended_obligation
net_pya_adj_amt
Anticipation
Anticipated_amt
UnAnticipated_amt

New sources used by Federal Cost Management:
FV Charge Amount
FV Unpaid Obligation Amount
FV Unpaid Expenditure Amount
FV Paid Expenditure Amount
FV Unpaid Obligation PYA Amount
FV Unpaid Obligation PYA Offset Amount
FV Anticipated Budget Amount
FV Unanticipated Budget Amount

Actions

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Federal Receivables Subledger Accounting changes
 Federal Costing Subledger Accounting changes
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.