Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Mass Allocation error
#2783
skyblue (User)
Senior Boarder
Posts: 48
graphgraph
User Offline Click here to see the profile of this user
Mass Allocation error 12 Years, 1 Month ago  
Generating Mass Allocation Batch I get the attached error. I set Profile Option MO:Operating Unit and also
GL:Number of Records to process at once to 1000 and Gl:Number of Accounts In Memory to 2500- since I got warning for these 2 profile options too. And then when I tried to Generate again I get the attached in View Log file.
Please help. Thank you.
File Attachment:
File Name: MassAllocationerr.doc
File Size: 93184
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2791
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Mass Allocation error 12 Years, 1 Month ago  
You could have ignored those warnings. Every other program will generate warnings in the log file. That is normal. You dont have to attend all the warnings unless you have good reasons to do so. The default settings were just fine. Error is something that you must attend.
I noticed that you have attached the log file but you have not mentioned why? Did you get an error? What was the outcome?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2795
skyblue (User)
Senior Boarder
Posts: 48
graphgraph
User Offline Click here to see the profile of this user
Re:Mass Allocation error 12 Years, 1 Month ago  
When I ran MassAllocation I got STATUS Error and MA Batch was not generated.Need help to figure out why MA Batch was not generated.Thank you.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2809
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Mass Allocation error 12 Years ago  
STATUS line is not the error. STATUS = 0 means success.
Your error line is this:
glamai() - fatal sql error

Usually the cause of this issue is missing database objects:
GL_ALLOC_INT_1
GL_ALLOC_INT_2
GL_ALLOC_INT_3.

Verify if the missing database objects exists.


You can create missing objects from the following xdf files:
gl_alloc_int_1.xdf
gl_alloc_int_2.xdf
gl_alloc_int_3.xdf

The xdf files are located under $GL_TOP/patch/115/xdf/
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop