Reporting - EBS (MOSC)

MOSC Banner

After execution of concurrent program, SQLException encounter while executing data trigger

edited Sep 12, 2025 4:35PM in Reporting - EBS (MOSC) 10 commentsAnswered

Source is Data Template and calling the data trigger source from pl/sql package and all the parameters are defined correctly bust still encountering the below error.

[091025_114246018][][EXCEPTION] SQLException encounter while executing data trigger....java.sql.SQLException: ORA-06550: line 2, column 26:PLS-00302: component 'P_BOOK' must be declaredORA-06550: line 2, column 1:PL/SQL: Statement ignoredORA-06550: line 3, column 26:PLS-00302: component 'P_PERIOD' must be declaredORA-06550: line 3, column 1:PL/SQL: Statement ignored.

Please help if anyone have sample script for data template and plsql package with procedures or functions!!!

                

                
      
            

        

    





    

        Howdy, Stranger!    

    

            


    

            


    
Log In
To view full details, sign in to My Oracle Support Community.
 Register
Don't have a My Oracle Support Community account? Click here to get started.
    


										

										
										

	

				


					

    
		
		

		
					

			

				

					
									

			

			

			

				

    
    
    

        
        

    



			

			

			

								
			

			


							

    
    
    

        
Category Leaderboard

         
Top contributors this month

        

    



			
			


			

				
			

			

				


					

    

            
EBS Reporting Tags

			
    








				

	



									

																


    
    

        

            
Instructions for posting

            ×
            

            

            
1. Select a discussion category from the picklist. 


            
2. Enter a title that clearly identifies the subject of your question.


            
3. In the body, insert detailed information, including Oracle product and version.


            
Please abide by the  Oracle Community guidelines  and refrain from posting any customer or personally identifiable information (PI/CI).


            
Cloud / Fusion customers - Our Cloud community has moved! Please go to  Cloud Customer Connect .


        

    



								
							

						

					

				

			

		

	







 



   






















	

		

			
New to My Oracle Support Community? Visit our Welcome Center

			MOSC Help Center