My Oracle Support Banner

Inventory To Projects: Invoice Price Variance and Exchange Rate Variance Transactions Hitting Different Accounts (Doc ID 2554078.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Project Manufacturing - Version 12.2.6 and later
Information in this document applies to any platform.


On :  12.2.6 version, Oracle Project Manufacturing


It was found that mismatched accounts are showing up on the Cost Distribution Lines (CDL) for the Invoice Price Variance (IPV) and Exchange Rate Variance (ERV) Project Cost transactions; the Debit and Credit accounts showing up on the Project CDL does not match with the source Subledger Accounts Payable (AP) or the final General Ledger (GL) accounting.

For example, below is the accounting on the source AP side:

Charge Account: Account_A (From AP Invoice Distribution)
Liability Account: Account_B (From Supplier Site setup)

Journal in the General Ledger has below accounting (Charge account was overridden in SLA):

Debit Account: Account_C
Credit Account: Account_B

While, the accounting on the CDL in Project Cost transaction shows as:

Debit Account: Account_A
Credit Account: Account_C

So, the accounting in projects does not match either source AP or final GL.

<Patch 19857144:R12.PJM.C> has been applied previously to have the accounting in GL show up on the Projects CDL instead of the AP Invoice Distribution accounting (in case it is overridden in SLA). The fix in patch 19857144:R12.PJM.C may not be working for some scenarios.

The accounting for the Project Cost transactions will match the GL accounts (or at the very least the source ledger distributions)

The issue can be reproduced at will with the following steps:

1. Create, Approve, and Receive PO
2. Create a AP Invoice. Match it to the PO
3. Validate the invoice and run 'Create Accounting'.
4. Run the 'Transfer Project Invoice Charges' program and import the IPV transaction.
5. Review accounts. Note: Charge account is overridden in SLA


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

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