Sub Ledger Accounting - Technical Perspective PDF
Sub Ledger Accounting - Technical Perspective PDF
Sub Ledger Accounting - Technical Perspective PDF
http://www.oracleappshub.com/release12/subledger-accou...
Create Accounting:ThisisonestepprocessfortransferringaccountingentriestoGLfromSubledgers likeAR,AP,FA,CM... Youneedtosubmitthisconcurrentprograms 1. AccountingProgram.ThiscreatesJournalsandgeneratesoutputdetailingthe Transfer/ErrordetailsofeventsdependingoninputParameters 2. JournalImport.ThistransfersJournalstoGL.MayalsopostdependingonInput Parameters 3. SubledgerAccountingBalancesUpdate Transfer Journal Entries to GL :TheTransferJournalEntriestoGLprogramenablesyouto transferanyeligiblejournalentriestoGeneralLedger,includingthosefrompreviousbatchruns thathavenotyetbeentransferredtoGeneralLedger.Thisonealsopicksuponlinefinal accountedTransactionsnottransferredtoGL Youneedtosubmitthisconcurrentprograms 1. JournalImport.ThistransfersJournalstoGL.MayalsopostdependingonInput Parameters SLA Technical Asdiscussedinearlierpost,allsubledgertableistightenwithSLAspecifictable.Hereisoneoftheexample ofAR.
515
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
New Functionality in Release 12 SubledgerAccountingInquiry:whereyoucanviewDetailedTransactionandFullJournalEntry,whichcan beexportedtoExcel.Theformwilldisplaydataunderthesethreetabs: 1. SubledgerJournalEntries 2. AccountingEvents 3. SupportingReferenceBalances Accounting Modes InSLAAccountingcreatedintwomodeeitherDraftorFinalmode,thedifferencebetweenthesetwois; Draft:whereyoucanReviewReportandCorrecterrors Final:whereyoucandirectlytransfertoGLandPostinGL ThereisoneProfileOptionwhichyouneedtoset...SLA:DisableJournalImportsettoNobydefault. Important SLA Reports SubledgerAccountingprovidesthefollowingreports 1. JournalEntriesReport Seededdataextractprovidesover100columnsofdata 2. AccountAnalysisReport Seededcomewithdataextractover100columnsofdata. ThisisbasedoutofXMLPublisher. 3. ThirdPartyBalances. 4. MultiperiodAccountingReports 5. OpenAccountBalances(TrialBalance):Thisreportdisplaysbalancescreatedbysubledger transactionsanddetailtransactionssupportingthebalance.AvarietyofseededBIPublisher Templatesareincludedtoprovidemultiplerepresentations/summarylevelsofthedata. OpenBalanceDefinitionsareconfigurable.
615
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
Seededdataextractsprovideover90columnsofdata. DefaulttemplatesarebasedoutofGroupbyAccount,AppliedTransaction JINMAO KOWA Detail Implant ToRunanOpenAccountBalancesListing,checkoutoldpost. www.kowa-dental CreateOpenAccountBalancesListingDefinitions Global RunRequest:OpenAccountBalancesDataManager(automatically dentists;Insurance runaspartofGLPosting) payment Good RunRequest:OpenAccountBalancesListing,selectapplicable masticatory parameters function 6. PeriodCloseExceptionsReport-Reviewthesubledgerperiodcloseexceptions reportwhenclosingtheGLperiod.Youcandefinerolesandresponsibilities forexceptions.
WilllistoutsomeotherreportingrequirementforMonthendreconciliationin anotherpost.
SLA Objects Therearemorethan2,100objectshavebeenaddedtotheE-BusinessSuite databaseduetoSLA.
Fig:DiagnosticFrameworkBusinessProcessflow
YoucanrunTransactionObjectsDiagnosticsRequestdirectlyfromOracleasshownbelow:
715
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
815
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou... PrintThisPost
PostedinSubledgerAccounting|10Comments EmailThisPost|
Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today 10Responses 1. ManishSays:
October9th,2008at6:37am
Greatpostasalways. AfundamentalquestionthatsfacedbycompaniesthatventureintoimplementingOracleFinancials ishowbesttoconvert/migratelegacyGLdataintoOracleGLandthenalltheothersubledgers. Doyouhaveanypointerstodocumentationand/orarticlesonlinewhichdescribethisprocessstepby step? IfyoulookattheGLUsersguide(forexampleforR12),theresachapteronusingGL_INTERFACE, butthatsfromatechnicalpointofviewanddoesnotreallytalkabouthowtogoaboutloading openingbalances,whethertoloadbyperiod,reconcileeachperiodandcloseperiodbeforeloading anotherperiodetc. 2. GarethRobertsSays:
October10th,2008at1:53am
Nicepost! 3. NenadSays:
May25th,2009at1:31pm
HiSanjit, Maybeyoucanhelp.Weareexperiencingamajorshowstopperusing12.0.4withtheRUP5for FinancialsandCPCMarch2009appliedandOracleSupportcannotsolvemorethenamonth.Hereis thepartofthelogfilefortheCreateAccountingprogram.Sometimesitworksandsometimesitdoes not.Crazy! XLAACCPBmodule:CreateAccounting ++ Currentsystemtimeis24-APR-200914:46:55 ++ XDODataEngineVersionNo:5.6.3 Resp:50637 OrgID:864 RequestID:1062547 AllParameters: P_APPLICATION_ID=200:P_SOURCE_APPLICATION_ID=:P_DUMMY=:P_LEDGER_ID=2022:P_PROCESS_CAT DataTemplateCode:XLAACCPB DataTemplateApplicationShortName:XLA DebugFlag: {P_ACCOUNTING_REPORT_LEVEL=,P_DUMMY=,P_ACCOUNTING_MODE_NAME=, P_ERRORS_ONLY_FLAG=N,P_REPORT_STYLE=D,P_GL_BATCH_NAME=,P_END_DATE=, P_SECURITY_INT_3=,P_SECURITY_INT_2=,P_SECURITY_INT_1=,P_VALUATION_METHOD_CODE=, P_POST_IN_GL=,P_TRANSFER_TO_GL=,P_TRANSFER_TO_GL_FLAG=Y, P_INCLUDE_USER_TRX_IDENTIFIERS=,P_USER_ID=,P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=,P_DUMMY_PARAM_3=,P_SECURITY_CHAR_3=,P_DUMMY_PARAM_2=, P_SECURITY_CHAR_2=,P_DUMMY_PARAM_1=,P_SECURITY_CHAR_1=,P_ENTITY_ID=20023, P_PROCESS_CATEGORY_CODE=,P_INCLUDE_ZERO_AMT_LINES=,P_LEDGER_ID=2022, P_POST_IN_GL_FLAG=Y,P_APPLICATION_ID=200,P_INCLUDE_USER_TRX_ID_FLAG=, P_APPLICATION_NAME=,P_REQUEST_ID=,P_CONC_REQUEST_ID=,P_LEDGER_NAME=, 2013/4/1611:26
915
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
P_SOURCE_APPLICATION_ID=,P_CREATE_ACCOUNTING=,P_CREATE_ACCOUNTING_FLAG=N, P_MIN_PRECISION=,P_SOURCE_APPLICATION_NAME=,P_INCLUDE_ZERO_AMOUNT_LINES=, P_ACCOUNTING_MODE=} CallingXDODataEngine [042409_024657272][][EXCEPTION]SQLExceptionencounterwhileexecutingdatatrigger. java.sql.SQLException:ORA-20001:-:XLA-95103:Aninternalerroroccurred.Pleaseinformyour systemadministratororsupportrepresentativethat: Aninternalerrorhasoccurredintheprogramxla_create_acct_rpt_pvt.BeforeReport.ORA-20001:-: XLA-95103:Aninternalerroroccurred.Pleaseinformyoursystemadministratororsupport representativethat: Aninternalerrorhasoccurredintheprogramxla_accounting_pkg.accounting_program_document. ORA-01086:savepointSP_EVENTSneverestablished ORA-20001:-:XLA-95293:.. ORA-06512:atAPPS.APP_EXCEPTION,line72 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line110 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line289 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line162 ORA-06512:atAPPS.XLA_CREATE_ACCT_RPT_PVT,line262 ORA-06512:atline4 atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) atoracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215) atoracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) atoracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445) atoracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394) atoracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:699) atoracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:255) atoracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205) atoracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237) atoracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364) atoracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236) atoracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293) atoracle.apps.fnd.cp.request.Run.main(Run.java:157) 4. SanjitAnandSays:
May25th,2009at5:45pm
1015
2013/4/1611:26
http://www.oracleappshub.com/release12/subledger-accou...
AnyideaonthiswarningmessageinCreateAccountingProgram? ORA-20002:3207:UserXXXdoesnothaveaccesstonotification51827.ORA-06512:at APPS.WF_ADVANCED_WORKLIST,line82ORA-06512:atline1 SubledgerAccounting:Version:12.0.0 Copyright(c)1979,1999,OracleCorporation.Allrightsreserved. XLAACCPBmodule:CreateAccounting + -+ Currentsystemtimeis05-JUN-200919:49:48 + -+ XDODataEngineVersionNo:5.6.3 Resp:50543 OrgID:102 RequestID:1922153 AllParameters: P_SOURCE_APPLICATION_ID=200:P_APPLICATION_ID=200:P_DUMMY=Y:P_LEDGER_ID=2 033:P_PROCESS_CATEGORY_CODE=:P_END_DATE=2009/06/07 00:00:00:P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE =F:P_DUMMY_PARAM_2=Y:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO _GL_FLAG=Y:P_DUMMY_PARAM_3=Y:P_POST_IN_GL_FLAG=Y:P_GL_BATCH_NAME=:P_MIN_ PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SO URCE_APPLICATION_NAME=Payables:P_APPLICATION_NAME=Payables:P_LEDGER_NAME =ZEBRAUK GBP:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_N AME=Final:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=Detail:P_TRANSFER_T O_GL=Yes:P_POST_IN_GL=Yes:P_INCLUDE_ZERO_AMT_LINES=No:P_VALUATION_METHOD _CODE=:P_SECURITY_INT_1=:P_SECURITY_INT_2=:P_SECURITY_INT_3=:P_SECURITY_ CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLU DE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:P_USER_ID=0:Debu gFlag=N DataTemplateCode:XLAACCPB DataTemplateApplicationShortName:XLADebugFlag:N{P_ACCOUNTING_REPORT_LEVEL=Detail, P_DUMMY=Y,P_ACCOUNTING_MODE_NAME=Final,P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=D,P_GL_BATCH_NAME=,P_END_DATE=2009/06/0700:00:00,P_SECURITY_INT_3=, P_SECURITY_INT_2=,P_SECURITY_INT_1=,P_VALUATION_METHOD_CODE=,P_POST_IN_GL=Yes, P_TRANSFER_TO_GL=Yes,P_TRANSFER_TO_GL_FLAG=Y,P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=0,P_PROCESS_CATEGORY_NAME=,P_ERRORS_ONLY=No,P_DUMMY_PARAM_3=Y, P_SECURITY_CHAR_3=,P_DUMMY_PARAM_2=Y,P_SECURITY_CHAR_2=,P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=,P_ENTITY_ID=,P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=No,P_LEDGER_ID=2033,P_POST_IN_GL_FLAG=Y, P_APPLICATION_ID=200,P_INCLUDE_USER_TRX_ID_FLAG=N,P_APPLICATION_NAME=Payables, P_REQUEST_ID=,P_CONC_REQUEST_ID=,P_LEDGER_NAME=ZEBRAUKGBP, P_SOURCE_APPLICATION_ID=200,P_CREATE_ACCOUNTING=Yes,P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=,P_SOURCE_APPLICATION_NAME=Payables, P_INCLUDE_ZERO_AMOUNT_LINES=N,P_ACCOUNTING_MODE=F}CallingXDODataEngine
1115
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
+ -+ StartoflogmessagesfromFND_FILE + -+ 05-JUN-200919:50:02BeginningoftheReport 05-JUN-200919:50:02StartingoftheParentThreadStartingmainprogramforthesource application=200 05-JUN-200919:50:02Dynamicconditionsbuilt 05-JUN-200919:50:02EventApplicationsDetermined 05-JUN-200919:50:02SecurityContextSet 05-JUN-200919:50:02SessionIdentifierSet 05-JUN-200919:50:02SetupfortheledgerandEventapplicationsRead 05-JUN-200919:50:02executingpreaccountinghookeventkey= 4144-1922153 05-JUN-200919:50:02preaccountinghookexecutedsuccessfully 05-JUN-200919:50:02Pre-Accountingstepsperformed 05-JUN-200919:50:02QueueCreated=XLA.XLA_1922153_DOC_Q 05-JUN-200919:50:02QueueCreated=XLA.XLA_1922153_COMP_Q 05-JUN-200919:50:02QueueStarted=XLA.XLA_1922153_DOC_Q 05-JUN-200919:50:02QueueStarted=XLA.XLA_1922153_COMP_Q 05-JUN-200919:50:02GlobalContextInitialized 05-JUN-200919:50:02Callingsequencingbatch_init 05-JUN-200919:50:02Returnedfromsequencingbatch_init 05-JUN-200919:50:02Beginenqueue 05-JUN-200919:50:02ReadytoEnqueuedocumentsinthequeue 05-JUN-200919:50:02Spawningunitprocessors 05-JUN-200919:50:02Unitprocessorsspawned 05-JUN-200919:50:09ReadytoEnqueuedocumentsinthequeue 05-JUN-200919:50:46ReadytoEnqueuedocumentsinthequeue 05-JUN-200919:50:46ReadytoEnqueuedocumentsinthequeue 05-JUN-200919:50:51ReadytoEnqueuedocumentsinthequeue 05-JUN-200919:50:51Enqueueingcompleted 05-JUN-200919:50:51WaitingforUnitProcessorrequeststocomplete 05-JUN-200919:51:51ChildThreadscompleted 05-JUN-200919:51:51GlobalContextcleared 05-JUN-200919:51:51Queuestopped=XLA.XLA_1922153_DOC_Q 05-JUN-200919:51:51Queuestopped=XLA.XLA_1922153_COMP_Q 05-JUN-200919:51:51Queuedropped=XLA.XLA_1922153_DOC_Q 05-JUN-200919:51:51Queuedropped=XLA.XLA_1922153_COMP_Q 05-JUN-200919:51:51Callingsequencingbatch_exit 05-JUN-200919:51:51Returnedfromsequencingbatch_exit 05-JUN-200919:51:51Executedpost-accountingroutine 05-JUN-200919:51:51requestforbalancecalulationsubmitted 05-JUN-200919:51:51AccountingProgramcompletedsuccessfully 05-JUN-200919:51:51executingpostaccountinghookeventkey= 4144-1922153 05-JUN-200919:51:51postaccountinghookexecutedsuccessfully -AccountingTime=108.25secs -TransferTime=0secs 05-JUN-200919:51:51EndoftheReport + 7. RolandDockingSays:
July14th,2010at2:27am
1215
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
OrgID:82 RequestID:4915573 AllParameters: P_APPLICATION_ID=222:P_SOURCE_APPLICATION_ID=:P_DUMMY=:P_LEDGER_ID=2021:P_PROCESS_CAT DataTemplateCode:XLAACCPB DataTemplateApplicationShortName:XLA DebugFlag: {P_ACCOUNTING_REPORT_LEVEL=,P_DUMMY=,P_ACCOUNTING_MODE_NAME=, P_ERRORS_ONLY_FLAG=N,P_REPORT_STYLE=D,P_GL_BATCH_NAME=,P_END_DATE=, P_SECURITY_INT_3=,P_SECURITY_INT_2=,P_SECURITY_INT_1=,P_VALUATION_METHOD_CODE=, P_POST_IN_GL=,P_TRANSFER_TO_GL=,P_TRANSFER_TO_GL_FLAG=Y, P_INCLUDE_USER_TRX_IDENTIFIERS=,P_USER_ID=,P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=,P_DUMMY_PARAM_3=,P_SECURITY_CHAR_3=,P_DUMMY_PARAM_2=, P_SECURITY_CHAR_2=,P_DUMMY_PARAM_1=,P_SECURITY_CHAR_1=,P_ENTITY_ID=698930, P_PROCESS_CATEGORY_CODE=,P_INCLUDE_ZERO_AMT_LINES=,P_LEDGER_ID=2021, P_POST_IN_GL_FLAG=Y,P_APPLICATION_ID=222,P_INCLUDE_USER_TRX_ID_FLAG=, P_APPLICATION_NAME=,P_REQUEST_ID=,P_CONC_REQUEST_ID=,P_LEDGER_NAME=, P_SOURCE_APPLICATION_ID=,P_CREATE_ACCOUNTING=,P_CREATE_ACCOUNTING_FLAG=N, P_MIN_PRECISION=2,P_SOURCE_APPLICATION_NAME=,P_INCLUDE_ZERO_AMOUNT_LINES=, P_ACCOUNTING_MODE=} CallingXDODataEngine [071410_101331390][][EXCEPTION]SQLExceptionencounterwhileexecutingdatatrigger. java.sql.SQLException:ORA-20001:-:XLA-95103:Aninternalerroroccurred.Pleaseinformyour systemadministratororsupportrepresentativethat: Aninternalerrorhasoccurredintheprogramxla_create_acct_rpt_pvt.BeforeReport.ORA-20001:-: XLA-95103:Aninternalerroroccurred.Pleaseinformyoursystemadministratororsupport representativethat: AninternalerrorhasoccurredintheprogramXLA_CREATE_ACCT_RPT_PVT.print_logfile.ORA-20100: Error:FND_FILEfailure.Unabletocreatefile,o0219474.tmpinthedirectory,/usr/tm ORA-06512:atAPPS.APP_EXCEPTION,line72 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line110 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line289 ORA-06512:atAPPS.XLA_EXCEPTIONS_PKG,line162 ORA-06512:atAPPS.XLA_CREATE_ACCT_RPT_PVT,line275 ORA-06512:atline4 atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) atoracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215) atoracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) atoracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445) atoracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4395) atoracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650) atoracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263) atoracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215) atoracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254) atoracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390) atoracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355) atoracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:348) atoracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293) atoracle.apps.fnd.cp.request.Run.main(Run.java:157) Oracleerror20100:java.sql.SQLException:ORA-20100:Error:FND_FILEfailure.Unabletocreatefile, o0219474.tmpinthedirectory,/usr/tmp.
1315
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
GLTransferDatafixes883557.1 LeaveaComment
Name Mail(willnotbepublished) Website
AllcontentpresentonthiswebsiteispropertyofOracleappsHub.comandsubjecttointernational
1415
2013/4/1611:26
SubLedgerAccountingTechnicalperspective|OracleApp...
http://www.oracleappshub.com/release12/subledger-accou...
copyrightlaws. 2006-2011CopyrightOracleAppsEpicenter.AllRightsreserved.
1515
2013/4/1611:26