Enhancement Request to Enable ChartField Overrides Feature for InterUnit/InterCompany Inventory Transactions

(Doc ID 1998147.1)

Last updated on JUNE 25, 2015

Applies to:

PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases >= 9.1.


The current design for the Override Chartfields feature on an Inventory transaction is to:

- disable it for InterUnit/InterCompany Inventory transactions,
- disable it for Express Issues,
- enable it for the other types of Material Stock Requests (MSR).

Although, with the current design it is possible to use the ChartField Overrides feature in the 'Maintain Stock Requests' page for:

- an InterUnit Transfer (non Express Issues),
- or even for a non-depleted Express InterUnit Transfer (only in certain transaction states).

The overrides are written to the PS_IN_DEMAND and PS_TRANSACTION_INV tables. But, in case of InterUnit/InterCompany Inventory transactions, the values from these tables are NOT used by the 'Cost Accounting Creation' process (CM_CSTACCTG) to generate Accounting Lines. For these transactions, the 'Cost Accounting Creation' process (CM_CSTACCTG) is using only the setup in the 'Transaction Accounting Rules page or 'Storage Area Accounting Rules' page or 'InterUnit/IntraUnit Template' page or 'InterUnit Pair' pages.

But, in this specific business case scenario, it is desired to use the ChartField Overrides feature mostly for reporting purposes, in relation to different type of transactions, in order to track certain aspects of the business. The user should be able to override the ChartFields in case of InterUnit/InterCompany Transfers (especifically the OPERATING_UNIT and CLASS_FLD fields) whenever the MSR includes a certain type of Item. This can vary, even for the same Item, depending on who and what was included in the MSR. This should be done by the user when saving the MSR. The 'Cost Accounting Creation' process (CM_CSTACCTG) should then apply the same logic as for regular MSR's and use the overridden ChartFields values in combination with the above mentioned pages to generate Accounting Lines




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