Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.
Oracle Training

Thread Rating:
  • 18 Vote(s) - 2.67 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GL Trial Balance - closing balance not matching with opening balance...
#1
Hi,
We are using Oracle EBS Ver- 11.5.9 and are facing the below issue.
Trial balance - closing balance is not matching with the opening balance of the next month for few accounts. Does anyone know what could cause this and/or how this can be fixed.
Thank you in advance!
Reply
Thanks given by:
#2
Hi Rajshree
would suggest to go through following Oracle MOS note:
Period Close Advisor: E-Business Suite (EBS) (Doc ID 335.1)
EBS R11i Period Close Processes Overview (Doc ID 1481610.1)
What is the Behavior of the General Ledger Year End Closing Process (Doc ID 149999.1)
Further you need to check any Manual journal entries if you have made
Any correction made during the import process can also cause issue
Any batch that is not posted...
basically you have to go through step by step in GL and you will be able to find out.
thanks
Reply
Thanks given by:
#3
Thanks Kashif

(12-31-2013, 11:25 PM)Kashif Manzoor Wrote: Hi Rajshree
would suggest to go through following Oracle MOS note:
Period Close Advisor: E-Business Suite (EBS) (Doc ID 335.1)
EBS R11i Period Close Processes Overview (Doc ID 1481610.1)
What is the Behavior of the General Ledger Year End Closing Process (Doc ID 149999.1)
Further you need to check any Manual journal entries if you have made
Any correction made during the import process can also cause issue
Any batch that is not posted...
basically you have to go through step by step in GL and you will be able to find out.
thanks
Reply
Thanks given by:
#4
(01-02-2014, 12:23 PM)Rajshree Khetan Wrote: Hi Kashif
I checked account payables TB report but the accounts in which we have discrepency does not have any data in those reports. They are refunds accounts (liability). checking manual journals is very cumbersome as data is huge. Is there any query which can help me validate the journals data.
Thanks for the help in advance!

(12-31-2013, 11:25 PM)Kashif Manzoor Wrote: Hi Rajshree
would suggest to go through following Oracle MOS note:
Period Close Advisor: E-Business Suite (EBS) (Doc ID 335.1)
EBS R11i Period Close Processes Overview (Doc ID 1481610.1)
What is the Behavior of the General Ledger Year End Closing Process (Doc ID 149999.1)
Further you need to check any Manual journal entries if you have made
Any correction made during the import process can also cause issue
Any batch that is not posted...
basically you have to go through step by step in GL and you will be able to find out.
thanks
Reply
Thanks given by:
#5
(01-03-2014, 12:14 PM)Rajshree Khetan Wrote: Issue found: Journal batch posted on last day of the month after runing trial balance.
Thanks for the help.

(01-02-2014, 12:23 PM)Rajshree Khetan Wrote: Hi Kashif
I checked account payables TB report but the accounts in which we have discrepency does not have any data in those reports. They are refunds accounts (liability). checking manual journals is very cumbersome as data is huge. Is there any query which can help me validate the journals data.
Thanks for the help in advance!

(12-31-2013, 11:25 PM)Kashif Manzoor Wrote: Hi Rajshree
would suggest to go through following Oracle MOS note:
Period Close Advisor: E-Business Suite (EBS) (Doc ID 335.1)
EBS R11i Period Close Processes Overview (Doc ID 1481610.1)
What is the Behavior of the General Ledger Year End Closing Process (Doc ID 149999.1)
Further you need to check any Manual journal entries if you have made
Any correction made during the import process can also cause issue
Any batch that is not posted...
basically you have to go through step by step in GL and you will be able to find out.
thanks
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Duplicated entry in Oracle General Trial Balance eimis 0 1,177 03-06-2016, 06:11 AM
Last Post: eimis
  opening balances in Subledger Rubab Ali 1 569 01-11-2015, 06:40 PM
Last Post: Gordon Victor
  Retained earnings should be a balance sheet account Archita Jartin 1 2,236 09-02-2014, 06:21 PM
Last Post: M Irfan
  Steps for define Payables trial balance report in R12 Oracle payables.... sgtakwale 2 18,797 05-12-2013, 09:45 PM
Last Post: shirfanarshad
  Income statement and balance sheet accounts Sehowat 2 9,405 02-25-2013, 05:03 PM
Last Post: lonewolf777
  Accounts Payables- Trial Balance Sara Khan 1 13,252 05-31-2011, 05:16 PM
Last Post: shirfanarshad



Users browsing this thread: 1 Guest(s)
Get Oracle Tutorials, Tips! Post a Question!