My Oracle Support Banner

Afchrchk.Sql - In $FND_TOP/sql - How Can This Be Defined As A Concurrent Request? (Doc ID 1355917.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Goal


On various occasions errors are encountered which need afchrchk.sql to be run.
If possible, is this available as a concurrent request?

If not how can it be defined as a concurrent request so the user's can run the script from the application?

The script is used regularly to assist with FRM-40654 errors.

Solution

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
Goal
Solution
 Step 1 - Define the value sets for the parameters 'Table Name' and 'Column Name'
 Step 2 - Define your concurrent program executable
 Step 3 - Define your concurrent program
 Step 4 - Add the new concurrent request to the request set used by the responsibility.
 Step 5 - Modify a copy of the afchrchk.sql.
 Step 6 -  test the report from the Purchasing Responsibility.
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.