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

Last updated on AUGUST 29, 2023

Applies to:

Purpose

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

Scope

 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
Org_id
Order_Type_ID
Line_ID
Line_Detail_id
Picking_Line_Detail_id

UPDATES: none

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.

Details