PS_CM_ACCTG_GRP_D Wrongly Associates Transaction Group 302 to the System Transaction Code CMUIT (Doc ID 1680690.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Manufacturing - Version 9.1 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases 9.1 and 9.2

Symptoms

The System Transaction Map, by default, ties both the Cost Management InterUnit Transfer and the Cost Management Ship on Behalf to INTRANS. However, you are allowed to change this so they reference different Transaction Codes. Changing the Transaction Code on the System Transaction Map highlights a problem in the setup data. Specifically Transaction Group 302 (Ship on Behalf Gain/Loss) points to the System Transaction code CMUIT instead of CMSHB. This is on the PS_CM_ACCTG_GRP_D table.

The Ship on Behalf of transaction normally generates 3 entries from the Interunit Template. They are the Accounts Payable, the Accounts Receivable and the Cost of Goods Sold. However, only the first 2 is available in the Interunit Template unless the Ship on Behalf of transaction is tied to the same Transaction Code as the InterUnit Transfer. Thus, it is impossible to direct the Cost of Goods Sold on a Ship on Behalf of transaction to a different set of ChartFields than those that are defined for the InterUnit Transfer.

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