Hello,

I am getting an error while trying to Generate Mass allocation Journal. I have attached the log file and below is the output file. I do not know what is causing the error but likely it is a table space issue. can you tell me what is causing it and what steps should I take to resolve it?

" MassAllocations Execution Report Date: 02-MAY-10 22:08
Username: ARUN_S Page: 1
Request ID: 6120379


Batch Name: Mass Allocation 1
Batch Description:
Type: Actual


Formula Name: Photocopier Maint Alloc
Formula Description: Photocopier Maintenance Allocation amongst departments
Formula Status: Validated


MassAllocation Batch Name: Mass Allocation 1 From Period: Apr-10 To Period: Apr-10

Period: Apr-10

Failure detected. Please see log file. "



Arun

Hi Arun,
The error is not due to tablespace issue. It is because of some database GL_ALLOC_JE_ID_INT objects missing.
Please check the metalink ID 857664.1
Hope this helps you.
Regards,
Abhigyan

I do not have access to Metalink.


Arun

-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/.

Thank you very much. This should be done by the DBA or SYSADMIN. Is it not?

Arun

DBA would run OS level scripts.