R12 In 12.2, $FND_TOP/sql/afchrchk.sql Gives ORA-00942: table or view does not exist for All Fields when Run. How Can this Script be Fixed? (Doc ID 1997346.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

 When running $FND_TOP/sql/afchrchk.sql in 12.2 from 'How to get the afchrchk.sql Script to Resolve FRM-40654 Error (Doc ID 960115.1)', the following is returned for all table columns, i.e.

Checking PA_PROJECTS_ALL#.ADJ_ON_STD_INV
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ADW_NOTIFY_FLAG
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ALLOW_CROSS_CHARGE_FLAG
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ALLOW_MULTI_PROGRAM_ROLLUP
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.AR_REC_NOTIFY_FLAG
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ASSET_ALLOCATION_METHOD
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ASSIGN_PRECEDES_TASK
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ATTRIBUTE1
***ORA-00942: table or view does not exist
Checking PA_PROJECTS_ALL#.ATTRIBUTE10
***ORA-00942: table or view does not exist

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