My Oracle Support Banner

Import Contract Life Cycle Awards Concurrent Program Fails With Error Ora-06510 Unhandled User-defined Exception (Doc ID 2405963.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Import CLM Error

Problem Description
---------------------------------------------------
We are receiving the following error when running the Import CLM concurrent program to create a basic CLM obligation.

ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at line 1


fnd debug log shows below error

";SQLERRM = ORA-06550: line 1, column 27:
PLS-00302: component 'PO_VALIDATE_HEADERS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
"Validation subroutine C_HEADER_GDF_ATTRIBUTES threw exception;SQLERRM = ORA-06550: line 1, column 27:
PLS-00302: component 'PO_VALIDATE_HEADERS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"

User-Defined Exception in Package po.plsql.PO_PDOI_HEADER_PROCESS_PVT. Procedure validate_headers.40;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_headers.40;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10;SQLERRM = User-Defined Exception
User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = User-Defined Exception

STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing CLM Responsibility .
2. Requests -> Run Import CLM Awards
3. Error occurs



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.