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 DECEMBER 25, 2015

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

Uupgrade from EBS 11.5.10.2 to R12

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