R12: Purchase Order Approval Error - User Defined Exception PO_DOCUMENT_CHECKS_GRP Procedure PO_SUBMISSION_CHECK (Doc ID 1932864.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Purchasing - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to approve Purchase Order (PO) after migrating from 11i to R12 the following error occurs.

Error

User Defined Exception in package PO_DOCUMENT_CHECKS_GRP procedure PO_SUBMISSION_CHECK

When trying to compile the package the following errors will occur :


Errors for PACKAGE BODY APPS.PO_DOCUMENT_CHECKS_PVT:  
 

LINE/COL ERROR
-------- -----------------------------------------------------------------
1659/12  PL/SQL: SQL Statement ignored
1703/25  PL/SQL: ORA-00904: "POL"."CLM_UNDEF_FLAG": invalid identifier
14474/5  PL/SQL: SQL Statement ignored
14636/11 PL/SQL: ORA-00904: "SUPPLIER_NOTIF_METHOD": invalid identifier
14939/5  PL/SQL: SQL Statement ignored
15096/10 PL/SQL: ORA-00904: "CLM_EXHIBIT_NAME": invalid identifier
17847/7  PL/SQL: SQL Statement ignored
17997/10 PL/SQL: ORA-00904: "CLM_POP_DURATION_UOM": invalid identifier
18284/4  PL/SQL: SQL Statement ignored
18406/11 PL/SQL: ORA-00904: "GLOBAL_ATTRIBUTE20": invalid identifier
25044/5  PL/SQL: SQL Statement ignored
25088/22 PL/SQL: ORA-00904: "PLL"."CLM_DELIVERY_PERIOD_UOM": invalid identifier
25184/5  PL/SQL: SQL Statement ignored
25235/29 PL/SQL: ORA-00904: "POH"."CLM_PAYMENT_INSTR_CODE": invalid identifier
25246/5  PL/SQL: SQL Statement ignored
25276/12 PL/SQL: ORA-00904: "POL"."CLM_PAYMENT_INSTR_CODE": invalid identifier
25291/5  PL/SQL: SQL Statement ignored
25326/17 PL/SQL: ORA-00904: "POH"."CLM_PAYMENT_INSTR_CODE": invalid identifier
25340/5  PL/SQL: SQL Statement ignored
25378/33 PL/SQL: ORA-00904: "POH"."CLM_PAYMENT_INSTR_CODE":
invalid identifier

Steps to reproduce

1. Purchasing Responsibility > Purchase orders

2. Add header and line details >

3. Save > Try to approve the PO

Cause

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