PIN_REL Procedure Failure Post BRM15 Upgrade (Doc ID 3064859.1)

Last updated on DECEMBER 23, 2024

Applies to:

Symptoms

On : 15.0.0.0.0 version, Infranet Install

PIN_REL procedure failure post BRM 12PS4 to BRM15 upgrade


Error 08/27/24 9:32:43:0160 AM ( 1724747563161 ) T:PreUpdater SP Thread 6 REL RELPreUpdaterThread 3::UnknownProgramName:0:PreUpdater SP Thread 6:0:1724747563161000:2::::
  ORA-20010: Error -20010 occurred in the preupdate procedure
ORA-06512: at "PIN.PIN_REL", line 8356
ORA-20010: Failed to create item for account 345840878289, event poid is 1504097616947985332, i_bal_imp_rec_item_obj_db is 7, i_evt_bal_imp_rec_balgrp_poid is 345864356713, i_evt_bal_imp_rec_item_type is /item/voice_usage
ORA-06512: at "PIN.PIN_REL", line 5512
ORA-20001: Error selecting from account_t where poid_id0 = 345840878289 AND poid_db = 7
ORA-06512: at "PIN.PIN_REL", line 4898
ORA-20001: ERROR while getting schema name
ORA-06512: at "PIN.PIN_REL", line 10314
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "PIN.PIN_REL", line 10311
ORA-06512: at "PIN.PIN_REL", line 4889
ORA-06512: at "PIN.PIN_REL", line 5501
ORA-01403: no data found
ORA-06512: at "PIN.PIN_REL", line 5471
ORA-06512: at "PIN.PIN_REL", line 8014
ORA-06512: at "PIN.PIN_REL", line 8014
ORA-06512: at line 1

Error 08/27/24 9:32:50:0457 AM ( 1724747570457 ) T:main REL IREL 3::UnknownProgramName:0:main:1:1724747554634001:23:root.0.0.0.7::::-1
  Error encountered in the Preupdate Stored Procedure: 7010
The preupdate stored procedure could not find an item for an account.
Error 08/27/24 9:32:50:0458 AM ( 1724747570458 ) T:main REL IREL 3::UnknownProgramName:0:main:1:1724747554634001:23:root.0.0.0.7::::-1
  Exiting with return code: 7

Cause

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