Enhancement Request to Limit Updates in the Production Cost Tables by 'Revalue Inventory and WIP' Process (SFPREVAL)
Last updated on AUGUST 12, 2016
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
PeopleSoft Enterprise SCM Manufacturing - Version 9.1 and later
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
Currently the 'Revalue Inventory and WIP' process (SFPREVAL) (navigation: Cost Accounting, Item Costs, Update Costs, Cost Update/Revalue) run for ALL Items is updating the Production Cost tables (PS_CM_PRODCOST, PS_CM_PRODCOSTH, and PS_CM_PRODCOST_DET):
1) when the Cost per Cost Element per level is the same between the previous and the new Effective Date.
2) when Items are inactive or disconstinued.
In a manufacturing environment where Items which are mainly Standard Costs, the above behavior leads to having Production Cost tables updated with thousands/millions of useless rows.
This enhancement request is to request a change of the SFPREVAL process so that it is not updating the Production Cost tables in the 2 scenarios above. For inactive or discontinued Items, since transactions can still be created (Transfers, Adjustments, RMA and RTV, and Receipts) (per PeopleBooks) it's better to add an option on the Run Control page of the SFPREVAL process (for example called 'Exclude Inactive Items' and 'Exclude Discontinued Items' so that customers can decide whether or not they want to update the costs for their inactive or discontinued Items when running the SFPREVAL process for all Items or per Cost Group.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms