Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: GL Trial Balance - closing balance not matching with opening balance...
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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!
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
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
(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
(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

viggora

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingultramaficrockultraviolettesting

viggora

сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт