Benefits Billing Calculation Error: SET-DEDUCT-ARRAY(PSPBIENR) (Doc ID 609934.1)

Last updated on JUNE 07, 2023

Applies to:

Symptoms

The Benefits Billing Calculation process can fail with an end of fetch error as shown below.  

Application Program Failed
 In Pgm Section  : FETCH-PROGRAM                                        
 With Return Code: 00001
 Error Message   : ORA-06550: line 1, column 13: PLS-00201: identifier 'SQLCQR_LOGINCHECK' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Application Program Failed
 In Pgm Section  : SET-DEDUCT-ARRAY(PSPBIENR)                           
 With Return Code: 00001
 Error Message   : ORA-06550: line 1, column 13: PLS-00201: identifier 'SQLCQR_LOGINCHECK' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
 Application Program Failed
 In Pgm Section  : CALC-CHARGES(PSPBICAL)                                
 With Return Code: 00001
 Error Message   : ORA-06550: line 1, column 13: PLS-00201: identifier 'SQLCQR_LOGINCHECK' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
 
Application Program Failed
 In Pgm Section  : PROCESS-BILLING(PSPBIBIL)                           
 With Return Code: 00001
 Error Message   : ORA-06550: line 1, column 13: PLS-00201: identifier 'SQLCQR_LOGINCHECK' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
Billing did not finish at 12:53:51.23 !!!!!

Cause

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