My Oracle Support Banner

R12 AP: Creating New Branch on New Bank, Errors With ORA-06508: PL/SQL: Could Not Find Program Unit Being Called; HZ_RELATIONSHIPS_PKG (Doc ID 1291931.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
ARHRELTS.pls 120.2
ARHRELTB.pls 120.4
ARH2RGVB.pls
ARH2RGVS.pls
HZ_RELATIONSHIPS_PKG
HZ_REGISTRY_VALIDATE_V2PUB

***Checked for relevance on 25-Dec-2015***

Symptoms

In Payables, when trying to save a new bank branch on a newly created bank, users are getting the following online error message:

The following SQL error occurred: ORA-06508: PL/SQL: could not find program unit being called.


Payables Manager > Setup: Payment Banks and Bank Branches
Bank Branches Tab > Create
Enter Bank Name, Number and Country
Branch Options > Create New Branch
Enter Branch Name and Branch Type
Click on Save and Next or Finish

The following SQL error appears

ORA-06508: PL/SQL: could not find program unit being called.

Log shows that HZ_RELATIONSHIPS_PKG is the missing program. 

After executing the files in SQL*Plus to create the database package,

SQLPlus apps/<password>
@ARHRELTS.pls
@ARHRELTB.pls

FND log shows the following error

ORA-04065: not executed, altered or dropped stored procedure "APPS.HZ_RELATIONSH

ar.hz.plsql.HZ_Package.HZ_Module 5 SQL ERROR-The following SQL error occurred:

ORA-06508: PL/SQL: could not find program unit being called.
16481 ----- PL/SQL Call Stack ----- ORA-04065: not executed, altered or dropped stored procedure "APPS.HZ_RELATIONSH

Changes

Upgrade from EBS 11.5.10.2 to R12

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
Changes
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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