My Oracle Support Banner

Getting error "ORA-20003: import1_prog:ORA-06508 When Running PRC: Interface Supplier Costs Process (Doc ID 1121055.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 11.5.10.0 and later
Information in this document applies to any platform.
***Checked for relevance on 05-MAR-2014***

PRC: Interface Supplier Costs Process


Symptoms


When running PRC: Interface Supplier Costs, the below error is shown in the log file:

ERROR
-----------------------
Error in import1 procedure
08:48:58: Import1: log_message: Stage=In OTHERS exception of import1
08:48:58: Import1: log_message: ORA-06508: PL/SQL: could not find program unit being called
08:48:58: transaction import failed with sqlcode =

08:48:58: -20003

08:48:58: ORA-20003: import1_prog:ORA-06508: PL/SQL: could not find program unit being calledIn OTHERS exception of import1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the PRC: Interface Supplier Costs process
2. Review the log file and see the error.

.


Checked and found PA_INTEGRATION package is invalid.  When trying to recompile the package, get the following error:

PACKAGE BODY APPS.PA_INTEGRATION
On line: 143
PLS-00306: wrong number or types of arguments in call to 'GET_INVOICE_STATUS'

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!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.