BizTech Blog

R12.1.3: New Functionality Added for Financials

Posted by Lee Briggs

Find me on:

Apr 6, 2011 1:01:13 PM

BizTech has analyzed the following modules, and has determined that significant functionality has been added in R12.1.3. Some of the more significant functionality has been backported to older releases, and where appropriate, BizTech has identified the necessary patches.


Work Confirmation Correction

At times, there may be a need to correct a previously approved work confirmation in order to adjust a payment to a supplier. Such a capability allows a buyer to reduce the scope of the original work confirmation, when an error is made during data entry for the work confirmation. Work Confirmation Correction is possible via Purchasing Professional Buyers Work Center and iSupplier Portal internal view. Buyers can be granted the additional authority to make corrections as needed. Buyers that are granted this authority will be able to make corrections to an approved Work Confirmation.


Landed Cost Management (LCM) Integration

Oracle Landed Cost Management gives organizations financial visibility into their extended supply chain costs including transportation, handling fees, regulatory duties and taxes and helps them to determine the landed cost of the material for transactional purposes. This allows organizations to have better control over procurement costs, maximize profits, increase competitiveness, and ensures that complex trade activities are compliant with regulatory mandates.

This integration further allows purchasing users to simulate the Landed Costs at the creation time of purchase orders, allowing better procurement decisions based on the estimated Landed Cost of the items.

Asset Lifecycle Management (ALM) Integration

In EBS Release 12.1.2, the implementation of encumbrance reversal for SCM was limited to Inventory and Expense Receiving transactions. Now in Release 12.1.3, this functionality has been extended to ‘Shop Floor’ destination Purchase Orders, where the distributions will be created under WIP transactions. Purchasing will support encumbering funds for Purchase Orders generated from eAM (with a ‘Shop Floor’ destination) during the approval process.

All public sector organizations, such as municipal, state, provincial and federal government organizations are required to encumber or reserve funds that have been committed to a supply purchase order. Therefore, prior to approval of any purchasing document, the available funds must be checked and reserved against the available budget for the specified account code combination. This enhancement is key for budgetary control.

Advanced Collections

Staged Dunning

In addition to the Aged Dunning method that is available on a customer’s oldest aged invoice, Collections organizations may now use Staged Dunning method. The Staged Dunning method ensures the dunning notices sent to a customer are automatically incremented, based upon the collection score and pre-defined number of days between letters being sent.

Cash Management

Manual Entry in Cash Position

The cash position functionality has been enhanced to allow cash managers the ability to manually enter cash flows into their cash positions allowing for greater flexibility in their decision making process.

Credit Management

Configurable Analyst Assignment Rules

In addition to the seeded assignment rules, Oracle Credit Management can now assign a credit analyst to case folders based on user-defined assignment rules and parameters.

This offers greater flexibility in addressing customer specific work load management needs.

General Ledger

Synchronize Reversing Journals between Primary and Secondary Ledgers

Oracle General Ledger now streamlines the propagation of journal reversals from the primary ledger to the associated secondary ledgers. The manual reversal of primary ledger journal entries now automatically reverses the corresponding journal entries in the secondary ledger.

Limit Accounts in Budget Wizard

In prior releases, users could only use specific account code combinations ranges in the Oracle General Ledger Budget Wizard to limit accounts for the budget entry process. The Budget Wizard now allows users to use low and high values for one or more segments in the account range.

Internet Expenses

Expense Receipt Management Enhancements

Oracle Internet Expenses has been enhanced to provide users the ability to define rules to accept, track and route imaged receipts to the appropriate auditor work queue. Faxed receipts and/or emailed scanned receipts can now be associated with expense reports as receipt images.

User defined rules can be setup to enforce receipt submission and reimbursement thresholds in addition to highlight missing receipts for expense lines.

Duplicate Expense Detection

Duplicate Expense Detection Rules are now available to detect duplicate expense claims aiding customers in decreasing administration costs by ensuring only reimbursement of valid expense claims.

Legal Entity Configurator

Enhanced Legal Addresses

In prior releases, when defining the address for a new legal entity, users could only select from existing locations identified as legal addresses. Users can now select any existing location as an address for a legal entity.

This feature has been backported to the following releases:

Release Patch Number
R12.0.6 6116752: R12.XLE.A
R12.1 6116752: R12.XLE.B

Multiple Disbursements during Loan Servicing

In prior releases, direct loans could only be adjusted using multiple disbursements with disbursement amount, percentage and a specific target date freeze before the approval, activation or funding of the loan. Now, loan managers can perform adjustments to the loan amount in active and multiple disbursements of the loan after the loan is activated, funded or in the servicing stage.

Additionally, for Extended Repayment Schedule (ERS) loans, loan managers can now add and convert additional receivables transactions to existing loans in the servicing stage. Managers can also modify the outstanding amount of receivables or adjust the receivables amount based on the payment terms.

Subledger Accounting

New Control Accounts Qualifier

“Restrict Manual Journals” has been added as a new qualifier on the natural accounts segment to provide users the ability to specify the control accounts that do not require third party control for posting.


Reconcile Treasury Transactions of all Deal Types

Oracle Treasury now allows use of Retail Term Money Market deal transactions within the Oracle Cash Management Bank Statement reconciliation. With this enhancement, users can view and use all treasury deal type transactions when reconciling bank statements within Oracle Cash Management, providing a single point for reconciliation.

This feature has been backported to the following releases:

Release Patch Number
R12.0.6 9491322: R12.XTR.A
R12.1.1 9393372: R12.CE.B
R12.1.3: New Functionality Added for US Federal Financials

Updates to Year-End Close Processing

The Federal Year End Close process has been modified to add a Closing Method to accommodate configuration of Pre-Closing as well as Closing accounting entries. Closing Method and Closing Period have been added as parameters to the Year End closing process.

Extract File Changes for Central Contractor Registration (CCR)

CCR enhancements include:

  • Placing specific named holds (instead of supplier site holds) on invoices and scheduled payments when the supplier’s registration status becomes inactive, and automatically releasing the hold when the registration becomes active.
  • Masking the CCR account user identifier and password information on concurrent request parameters and log file output.
  • Providing validation on the Payables Assignment page to prevent the association of a CCR vendor to an existing supplier when their TINS do not match
  • Updating unpaid invoices with the latest bank account information from CCR when the bank information has changed for a CCR registration.

Topics: E-Business Suite, Oracle Application Services