WIP Transaction Accounts Generated Do Not Match The Accounts Generated On The Requisition (Doc ID 1453993.1)

Last updated on MAY 08, 2023

Applies to:

Goal

The requisition account generator has been modified to build the charge account differently for WIP transactions. It was expected that the same will flow through into EAM in WIP_TRANSACTION_ACCOUNTS, reference_Account, but it is populated differently. Is there any other EAM hook that needs to be used.

WIP accounting classes screen shows:

Material account:  21.426.3040.1681.00000.
WIP Accounting Class 426.3040 has a Material Valuation value of 21.426.1681.0000.  Note that segment four (our Resource Element) has a value of 1681.

Note that our Requisition Account Generator has change the Resource Element (segment four) of the Charge Account from 1681 to 1691.

Checking the requisition distributions using our Purchasing Super User responsibility, the Charge Account has been correctly set by our Requisition Account Generator.  i.e.  Resource Element is
21.426.3040.1691.00000.

However, when we review the WO transactions (From WO Details page > View Costs button, click Actual Costs hyperlink, click View Transactions button), we can see that the EAM cost is still using the default material account from the WIP Accounting Class.  i.e.  Resource Element is 1681:
21.426.3040.1681.00000.

And finally, running Create Accounting from the Cost Management – SLA responsibility, the report shows that the incorrect account (the Asset/WO default) is passed to the GL:
21.426.3040.1681.00000.

Solution

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