My Oracle Support Banner

Errors For PACKAGE BODY APPS.BEN_ENB_BUS and Other BEN Packages (Doc ID 2673916.1)

Last updated on MAY 29, 2020

Applies to:

Oracle Advanced Benefits - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

After trying to export and import to target database (same version & OS) there are  many Invalid objects related to BEN (Advanced Benefit module/product).


ERROR
Errors for PACKAGE APPS.BEN_ENB_BUS:

LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
64/1     PL/SQL: Declaration ignored                                            
64/36    PLS-00201: identifier 'BEN_ENB_SHD.G_REC_TYPE' must be declared        
99/1     PL/SQL: Declaration ignored                                            
99/36    PLS-00201: identifier 'BEN_ENB_SHD.G_REC_TYPE' must be declared        
134/1    PL/SQL: Declaration ignored                                            
134/36   PLS-00201: identifier 'BEN_ENB_SHD.G_REC_TYPE' must be declared        

Warning: Package Body altered with compilation errors.

Errors for PACKAGE BODY APPS.BEN_ENB_BUS:

LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
0/0      PL/SQL: Compilation unit analysis terminated                          
1/14     PLS-00304: cannot compile body of 'BEN_ENB_BUS' without its            
        specification                                                          
                                                                               
1/14     PLS-00905: object APPS.BEN_ENB_BUS is invalid                          

Warning: Package altered with compilation errors.

Errors for PACKAGE APPS.BEN_ENP_BUS:

LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
68/0     PLS-00103: Encountered the symbol "end-of-file" when expecting        
        one of the following:                                                  
        end function pragma procedure subtype type <an identifier>            
        <a double-quoted delimited-identifier> current cursor delete          
        exists prio  

                                                                                                                                                                                                                                                                                                    

...
STEPS

The issue can be reproduced at will with the following steps:
1. Manually compile the objects

Changes

 

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
References


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