Post date: Jan 11, 2011 3:50:33 AM
Checked for relevance on 31-Dec-2010
· goal: How to Correct Posting Functional Error6
·
· fact: Oracle General Ledger
·
· fact: GLPPOS - Posting
·
· fact: GLXJEPST - Post Journals
·
·
fix:
The meaning of Error6 is: Showing an unbalanced journal entry, and suspense
posting is not allowed.
Execute the following SQL statements using the APPS user to identify the
unbalanced journal.
1.The following statement helps to identify the batch id of the
corresponding batch. Replace the Batch name value by the batch name with Error6.
Select je_batch_id, name
from gl_je_batches
where name like '%&Batch_Name%';
2.The following statement helps to identify the out of balance situation in a
specific journal.
The statement returns the following data:
Total_acc_dr -- Total of debits in base currency
Total_acc_cr -- Total of credits in base currency
Total_ent_dr -- Total of debits in entered currency
Total_ent_dr -- Total of credits in entered currency
Amounts in columns Total_acc_dr and Total_acc_cr should be equal.
Replace the je_batch_id value by the value found in the previous step.
Set linesize 120
col Header_id format 999999999
col Category format a20
col Journal format a20
col Currency format a15
col status format a10
col Total_acc_dr format 999,999,999,999.99
col Total_acc_cr format 999,999,999,999.99
col Total_ent_dr format 999,999,999,999.99
col Total_ent_cr format 999,999,999,999.99
Select je_header_id Header_id,
je_category Category ,
Name Journal,
Currency_code Currency,
Status,
running_total_accounted_dr Total_acc_dr ,
running_total_accounted_cr Total_acc_cr,
running_total_dr Total_ent_dr,
running_total_cr Total_ent_dr
from gl_je_headers
where je_batch_id = &Je_batch_id;
3.The following statement helps to indentify the journal line number that
shows Error6. Review all the lines in the unbalanced Journal Header
identified in the previous step.
Set linesize 120
col Header_id fotmat 999999999
col status format a10
col je_line_num format 999999999
col code_combination_id format 999999999
col ent_dr format 999,999,999,999.99
col ent_cr format 999,999,999,999.99
col acc_dr format 999,999,999,999.99
col acc_cr format 999,999,999,999.99
Select
je_header_id Header_id,
status,
je_line_num,
code_combination_id,
Entered_dr ent_dr,
Entered_cr ent_cr,
Accounted_dr acc_dr,
Accounted_cr acc_cr
from gl_je_lines
where je_header_id= &Header_id;
The entered_dr should equal the entered_cr and the accounted_dr should equal
the accounted_cr
Note: if you cannot edit the journal this is usually because the source is frozen.
navigate to Setup Journal source in the GL superuser resposibility and query back the source. Untick the Freeze box.
Remember to refreeze after the journal is fixed. If the journal has funds reserved
or the journal is approved it is neccesary to unreserve funds and or unapprove
the journal before you can modify the journal.
Note: If the accounted amount is wrong on a foreign currency journal you will only be
able to change the converted columns if the profile
'Journals: Allow Multiple Exchange rates' is set to Yes
4. Correct the unbalanced lines.
5. Change the status of the batch to UNPOSTED.
Related
Products
Oracle E-Business Suite > Financial Management > Financial Control and Reporting > Oracle General Ledger
Article Rating
Comments
Provide feedback for this article. Please use 'Contact Us' for other feedback.
Important Note: this feedback is anonymously visible to other customers until processed by Oracle Support.