12.1.3: 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 APRIL 21, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

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:

-- FUNCTION
--  get_prd_cls_zeroval_option
--  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.

Solution

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