How to change the costing hook CSTOCHKB.pls in order to exclude zero value items in the Period Close Reconciliation Report?
(Doc ID 1568956.1)
Last updated on MAY 03, 2019
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
In Oracle Cost Management, the Period Close Reconciliation Report is facing performance issues because of huge data.
The following <Note 1456798.1>:
How to exclude items with zero Onhand, Accounted value from the Period Close Reconciliation Report ? [ID 1456798.1]
explains how to make the Period Close Reconciliation Report complete normally within a reasonable time frame. This is achieved by providing an option through the costing hooks which allows users to decide if they want to display zero value items or not.
Patch 14036099:R12.BOM.C needs to be applied and the option to exclude zero values in the current period is available through the costing hook.
The package body of CSTOCHKB.pls has to be modified and the instructions for doing so are explained in this new note.
The results will be as follows:
-- This function can be used to turn off the summarization
-- and display in period close reconciliation and summary
-- of items that have zero value in the current period.
-- By default the function returns a value of 0 which means
-- that all items will be included.
-- The return value can be modified to 1 to prevent the
-- zero value items from being included.
-- The behavior can also be customized based on the organization
-- and accounting period.
The objective is to explain step by step how to change the costing hook CSTOCHKB.pls in order to exclude zero value items in the Period Close Reconciliation Report.
This will provide users with a clearer readibility and a better report performance.
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