R12: Interface Supplier Costs Fails Due to Rounding Differences With Error: The Transaction Failed Funds Check (Doc ID 2192256.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
PRC: Interface Supplier Costs, Funds Check, Exchange Rate Differences

Symptoms

When attempting to run PRC: Interface Supplier Costs to Projects, the following error is displayed in the output of AUD: Supplier Costs Interface Audit:

ERROR
-----------------------
"The transaction failed funds check"

Transaction records in Pa_Bc_Packets shows status_code = F112.


This happens for multiple Receipts , on several projects where transaction currency is different from project currency.
The issue arises every month.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create new Project
2. Create budget for the new project > Submit > Baseline the budget amount in project currency.
3. Create Purchase Order in foreign currency for the same project, which should get converted to the exact budget amount in project functional currency.
4. Approve  the PO.
5. Receipt the PO.
6. Submit Create Accounting.
7. Run PRC: Interface Supplier Costs


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot close PA period.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms