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 JUNE 25, 2024
Applies to:
Oracle Project Foundation - Version 12.2.3 and laterOracle Application Object Library - Version 12.2.6 to 12.2.6 [Release 12.2]
Oracle Bills of Material - Version 12.2.3 to 12.2.3 [Release 12.2]
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
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 |
| References |