Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, 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 and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 34 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GL Trial Balance - closing balance not matching with opening balance...
12-31-2013, 05:07 PM,
#1
GL Trial Balance - closing balance not matching with opening balance...
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
01-01-2014, 12:25 AM,
#2
RE: GL Trial Balance - closing balance not matching with opening balance...
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
01-02-2014, 01:23 PM,
#3
RE: GL Trial Balance - closing balance not matching with opening balance...
Thanks Kashif

(01-01-2014, 12:25 AM)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
01-03-2014, 01:14 PM,
#4
RE: GL Trial Balance - closing balance not matching with opening balance...
(01-02-2014, 01: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!

(01-01-2014, 12:25 AM)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
01-07-2014, 03:09 PM,
#5
RE: GL Trial Balance - closing balance not matching with opening balance...
(01-03-2014, 01: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, 01: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!

(01-01-2014, 12:25 AM)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
10-16-2019, 06:00 AM,
#6
RE: GL Trial Balance - closing balance not matching with opening balance...
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingultramaficrockultraviolettesting
Reply
12-24-2019, 02:32 AM,
#7
RE: GL Trial Balance - closing balance not matching with opening balance...
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Duplicated entry in Oracle General Trial Balance eimis 2 19,337 12-24-2019, 12:27 PM
Last Post: viggora
  opening balances in Subledger Rubab Ali 3 3,905 12-24-2019, 08:17 AM
Last Post: viggora
  Retained earnings should be a balance sheet account Archita Jartin 3 8,229 12-24-2019, 04:31 AM
Last Post: viggora
  Income statement and balance sheet accounts Sehowat 4 16,323 12-24-2019, 01:14 AM
Last Post: viggora
  Steps for define Payables trial balance report in R12 Oracle payables.... sgtakwale 4 30,066 12-24-2019, 01:02 AM
Last Post: viggora
  Accounts Payables- Trial Balance Sara Khan 1 17,444 05-31-2011, 06:16 PM
Last Post: shirfanarshad



Users browsing this thread: 3 Guest(s)