My Oracle Support Banner

TESTCOGS.SQL Diagnostic Script for R11.0.x (Doc ID 169553.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Order Entry
Oracle Shipping
Oracle Shipping Execution
Information in this document applies to any platform.


 This script is used to test the COGS Account Generator. It generates debugging information that is used to troubleshoot COGS issues.


 You should run this script whenever you are facing problems surrounding the
COGS account generation during RMA/Inventory Interface process.

RELEASE: R11.0.x

PARAMETERS: Order Number


OUTPUT: testcogs_RDA.lst

DISCLAIMER: This script is developed and maintained by Oracle Development and Oracle
Support Services. It has been tested internally and should work as documented.

WARNING: This script is being updated periodically. Please download it from Metalink
every time you need to run it in order to have the latest version.

USAGE: Download the zip file containing the testcogs.sql script via the link above.
Run the script from SQL*Plus, connected as APPS user.
NOTE: It is safest to exit SQL*Plus after each test run since values from
the previous run may be kept in memory.


To view full details, 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 a vibrant support community of peers and Oracle experts.