FAQ How Cycle Counting Works and How to Ensure that Cycle Counts are Scheduled Based on Setup Class and Frequency to Meet Audit Requirements

(Doc ID 416149.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and laterInformation in this document applies to any platform.

Goal

Within Oracle Applications 11.5.10, Internal Audit requires some type of reporting (can be sql output) to provide assurance that cycle count is in fact scheduling per setup to frequency of the classes (that is, A items are scheduled 3 times/year, B items are scheduled 2 times/year, C items are scheduled 1 time/year).

Business process is to set up one header for the year. Update compile quarterly to pick up newly created items and apply to header. Counts are scheduled automatically and control items are not used. Our items are primarily under lot control.

At the end of the year, business needs to show to auditing that counts are being done according to finance policy. Need sql scripts proving that counts are being done as per the setups.

Internal auditing is questioning us to prove that the cycle counts are running as per the setup class frequency.

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