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

Last updated on MARCH 02, 2023

Applies to:

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

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