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?
Re:Error While Generating Mass Allocation (1 viewing) (1) Guest
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:Error While Generating Mass Allocation
#3972
saadali110 (User)
Fresh Boarder
Posts: 12
graphgraph
User Offline Click here to see the profile of this user
Error While Generating Mass Allocation 11 Years, 4 Months ago  
I an not able to run the mass allocation.i am attaching the image and error file, plzz help me..
File Attachment:
File Name: Run_MassAllocations_261212.txt
File Size: 29654
File Attachment:
File Name: Run_MassAllocations_261212.txt
File Size: 29654
http://handsonerp.com/images/fbfiles/images/massAllocErr.png
 
Report to moderator   Logged Logged  
 
Last Edit: 2012/12/28 01:08 By handsonerp.
  The administrator has disabled public write access.
#3983
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error While Generating Mass Allocation 11 Years, 4 Months ago  
Following objects might be missing in your database GL_ALLOC_INT_1,GL_ALLOC_INT_2 and GL_ALLOC_INT_3.
Please verify if this is the case first before proceeding further.

Create the missing objects GL_ALLOC_INT_1,GL_ALLOC_INT_2 and GL_ALLOC_INT_3.

The missing object should be created from the xdf file gl_alloc_int_1.xdf,gl_alloc_int_2.xdf and
gl_alloc_int_3.xdf

The xdf file is placed under $GL_TOP/patch/115/xdf/.

Usage of the Utility adodfcmp :

adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \
userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3986
saadali110 (User)
Fresh Boarder
Posts: 12
graphgraph
User Offline Click here to see the profile of this user
Re:Error While Generating Mass Allocation 11 Years, 4 Months ago  
I have these objects created in the database, I am attaching the image for those objects. http://handsonerp.com/images/fbfiles/images/int.png
 
Report to moderator   Logged Logged  
 
Last Edit: 2012/12/31 13:15 By handsonerp.
  The administrator has disabled public write access.
#3994
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error While Generating Mass Allocation 11 Years, 4 Months ago  
The image you have attached simply shows that the files are there in the filesystem. That does not tell you if the objects are there in the database or not.

Please run the following command in sqlplus as "apps" user. The output will tell you if the objects are there or not.

select object_name from all_objects
where object_name like 'GL_ALLOC_INT%'
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4006
saadali110 (User)
Fresh Boarder
Posts: 12
graphgraph
User Offline Click here to see the profile of this user
Re:Error While Generating Mass Allocation 11 Years, 3 Months ago  
Thankyou, you were right, i run the query as you have given, it doesn't shows the objects. So, what should i do now, as you told in the previous post to run the adodfcmp utility,

adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \ userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>

In above, what should i write in odffile and mode?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4029
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error While Generating Mass Allocation 11 Years, 3 Months ago  
First of all sorry for the late reply.
The attached document shows you the usage of the utility.
File Attachment:
File Name: 551325.txt
File Size: 1299
 
Report to moderator   Logged Logged  
 
Last Edit: 2013/01/08 03:56 By handsonerp.
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop