- OracleApps Epicenter - http://www.oracleappshub.com -

Sub Ledger Accounting – Technical perspective

SLA(Sub Ledger Accounting) -Characteristics

Process & Program for Subleder Accounting: Transfer to GL Process

Oracle EBS's accounting process is basically a 2 step process:

  1. Step 1. Create Accounting
  2. Step 2. Transfer Journal Entries to GL

Create Accounting :This is one step process for transferring accounting entries to GL from Sub ledgers like AR, AP,FA,CM...

  • You need to submit this concurrent programs
    1. Accounting Program. This creates Journals and generates output detailing the Transfer/Error details of events depending on input Parameters
    2. Journal Import. This transfers Journals to GL. May also post depending on Input Parameters
    3. Subledger Accounting Balances Update

Transfer Journal Entries to GL :The Transfer Journal Entries to GL program enables you to transfer any eligible journal entries to General Ledger, including those from previous batch runs that have not yet been transferred to General Ledger. This one also picks up online final accounted Transactions not transferred to GL

  • You need to submit this concurrent programs
    1. Journal Import. This transfers Journals to GL. May also post depending on Input Parameters

SLA Technical

As discussed in earlier post [1], all subledger table is tighten with SLA specific table. Here is one of the example of AR.

New Functionality in Release 12

Sub ledger Accounting Inquiry : where you can view Detailed Transaction and Full Journal Entry ,which can be exported to Excel. The form will display data under these three tabs:

  1. Subledger Journal Entries
  2. Accounting Events
  3. Supporting Reference Balances

Accounting Modes

In SLA Accounting created in two mode either Draft or Final mode, the difference between these two is ;

There is one Profile Option which you need to set ...‘SLA: Disable Journal Import’ set to No by default.

Important SLA Reports

Subledger Accounting provides the following reports

  1. Journal Entries Report
    • Seeded data extract provides over 100 columns of data
  2. Account Analysis Report
    • Seeded come with data extract over 100 columns of data.
    • This is based out of XML Publisher.
  3. Third Party Balances.
  4. Multiperiod Accounting Reports
  5. Open Account Balances (Trial Balance) :This report displays balances created by subledger transactions and detail transactions supporting the balance. A variety of seeded BI Publisher Templates are included to provide multiple representations/ summary levels of the data.
    • Open Balance Definitions are configurable.
    • Seeded data extracts provide over 90 columns of data.
    • Default templates are based out of Group by Account, Applied Transaction Detail
    • To Run an Open Account Balances Listing, check out old post [2] .
      • Create Open Account Balances Listing Definitions
      • Run Request: Open Account Balances Data Manager (automatically run as part of GL Posting)
      • Run Request: Open Account Balances Listing, select applicable parameters
  6. Period Close Exceptions Report -Review the subledger period close exceptions report when closing the GL period.You can define ‘roles and responsibilities’ for exceptions.

Will listout some other reporting requirement for Month end reconciliation in another post.

SLA Objects

There are more than 2,100 objects have been added to the E-Business Suite database due to SLA.

select object_type,count(*) from dba_objects
where object_namelike '%XLA%'
group by object_type;

SLA Diagnostics

SLA Diagnostics provides features to review the SLA journal entries created. This helps you to:

You can enable this features by:

Fig :Diagnostic Framework Business Process flow

You can run Transaction Objects Diagnostics Request directly from Oracle as shown below:

Similar Post

10 Comments (Open | Close)

10 Comments To "Sub Ledger Accounting – Technical perspective"

#1 Comment By Manish On October 9, 2008 @ 6:37 am

Great post as always.

A fundamental question that’s faced by companies that venture into implementing Oracle Financials is how best to convert/migrate legacy GL data into Oracle GL and then all the other subledgers.

Do you have any pointers to documentation and/or articles online which describe this process step by step?

If you look at the GL Users guide (for example for R12), there’s a chapter on using GL_INTERFACE, but that’s from a technical point of view and does not really talk about how to go about loading opening balances, whether to load by period, reconcile each period and close period before loading another period etc.

#2 Comment By Gareth Roberts On October 10, 2008 @ 1:53 am

Nice post!

#3 Comment By Nenad On May 25, 2009 @ 1:31 pm

Hi Sanjit,

Maybe you can help. We are experiencing a major showstopper using 12.0.4 with the RUP5 for Financials and CPC March 2009 applied and Oracle Support cannot solve more then a month. Here is the part of the log file for the Create Accounting program. Sometimes it works and sometimes it does not. Crazy!
XLAACCPB module: Create Accounting
+—————————————————————————+

Current system time is 24-APR-2009 14:46:55

+—————————————————————————+

XDO Data Engine Version No: 5.6.3
Resp: 50637
Org ID : 864
Request ID: 1062547
All Parameters: P_APPLICATION_ID=200:P_SOURCE_APPLICATION_ID=:P_DUMMY=:P_LEDGER_ID=2022:P_PROCESS_CATEGORY_CODE=:P_END_DATE=:P_CREATE_ACCOUNTING_FLAG=N:P_DUMMY_PARAM_1=:P_ACCOUNTING_MODE=:P_DUMMY_PARAM_2=:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO_GL_FLAG=Y:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=Y:P_GL_BATCH_NAME=:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=:P_REQUEST_ID=:P_ENTITY_ID=20023:P_SOURCE_APPLICATION_NAME=:P_APPLICATION_NAME=:P_LEDGER_NAME=:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=:P_ACCOUNTING_MODE_NAME=:P_ERRORS_ONLY=:P_ACCOUNTING_REPORT_LEVEL=:P_TRANSFER_TO_GL=:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=: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_INCLUDE_USER_TRX_ID_FLAG=:P_INCLUDE_USER_TRX_IDENTIFIERS=:P_USER_ID=:DebugFlag=
Data Template Code: XLAACCPB
Data Template Application Short Name: XLA
Debug Flag:
{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=, 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=}
Calling XDO Data Engine…
[042409_024657272][][EXCEPTION] SQLException encounter while executing data trigger….
java.sql.SQLException: ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_create_acct_rpt_pvt.BeforeReport . ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_accounting_pkg.accounting_program_document. ORA-01086: savepoint ‘SP_EVENTS’ never established
ORA-20001: -: XLA-95293:..
ORA-06512: at “APPS.APP_EXCEPTION”, line 72
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 110
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 289
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 162
ORA-06512: at “APPS.XLA_CREATE_ACCT_RPT_PVT”, line 262
ORA-06512: at line 4

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:699)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:255)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:205)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:237)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:364)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:236)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

#4 Comment By Sanjit Anand On May 25, 2009 @ 5:45 pm

the catch here is ORA-20001: -: XLA-95103:

If I am not wrong, this is known issue in Oracle which is caused by Profile Option SLA: Enable Trace.

Try this way:
Change the setup for the Profile Option SLA: Enable Trace and be set it to NULL at all levels: Site, Application, Responsibility, User.

If still getting error, I would advice raise an SR.

#5 Comment By Mustafa On June 8, 2009 @ 5:36 pm

Hi Sanjit,
thank you for your wonderful blog it is very useful to me.
can you please clarify how to disable Final Posting from subledgers. In many places only GL users are authorized for posting. I need to disable final posting from subledgers and also disable it in the create accounting program.
Thanks

#6 Comment By Vanitha On June 9, 2009 @ 4:13 am

Any idea on this warning message in Create Accounting Program ?

———————
ORA-20002: 3207: User ‘XXX’ does not have access to notification 51827. ORA-06512: at “APPS.WF_ADVANCED_WORKLIST”, line 82 ORA-06512: at line 1


Subledger Accounting: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

XLAACCPB module: Create Accounting
+———————————————————————–
—-+

Current system time is 05-JUN-2009 19:49:48

+———————————————————————–
—-+

XDO Data Engine Version No: 5.6.3
Resp: 50543
Org ID : 102
Request ID: 1922153
All Parameters:
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
=ZEBRA UK
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
Data Template Code: XLAACCPB
Data Template Application Short Name: XLA Debug Flag: 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/07 00: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=ZEBRA UK GBP, 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} Calling XDO Data Engine…
+———————————————————————–
—-+
Start of log messages from FND_FILE
+———————————————————————–
—-+
05-JUN-2009 19:50:02 – Beginning of the Report
05-JUN-2009 19:50:02 – Starting of the Parent Thread Starting main program for the source application = 200
05-JUN-2009 19:50:02 – Dynamic conditions built
05-JUN-2009 19:50:02 – Event Applications Determined
05-JUN-2009 19:50:02 – Security Context Set
05-JUN-2009 19:50:02 – Session Identifier Set
05-JUN-2009 19:50:02 – Setup for the ledger and Event applications Read
05-JUN-2009 19:50:02 – executing preaccounting hook event key =
4144-1922153
05-JUN-2009 19:50:02 – preaccounting hook executed successfully
05-JUN-2009 19:50:02 – Pre-Accounting steps performed
05-JUN-2009 19:50:02 – Queue Created = XLA.XLA_1922153_DOC_Q
05-JUN-2009 19:50:02 – Queue Created = XLA.XLA_1922153_COMP_Q
05-JUN-2009 19:50:02 – Queue Started = XLA.XLA_1922153_DOC_Q
05-JUN-2009 19:50:02 – Queue Started = XLA.XLA_1922153_COMP_Q
05-JUN-2009 19:50:02 – Global Context Initialized
05-JUN-2009 19:50:02 – Calling sequencing batch_init
05-JUN-2009 19:50:02 – Returned from sequencing batch_init
05-JUN-2009 19:50:02 – Begin enqueue
05-JUN-2009 19:50:02 – Ready to Enqueue documents in the queue
05-JUN-2009 19:50:02 – Spawning unit processors
05-JUN-2009 19:50:02 – Unit processors spawned
05-JUN-2009 19:50:09 – Ready to Enqueue documents in the queue
05-JUN-2009 19:50:46 – Ready to Enqueue documents in the queue
05-JUN-2009 19:50:46 – Ready to Enqueue documents in the queue
05-JUN-2009 19:50:51 – Ready to Enqueue documents in the queue
05-JUN-2009 19:50:51 – Enqueueing completed
05-JUN-2009 19:50:51 – Waiting for Unit Processor requests to complete
05-JUN-2009 19:51:51 – Child Threads completed
05-JUN-2009 19:51:51 – Global Context cleared
05-JUN-2009 19:51:51 – Queue stopped = XLA.XLA_1922153_DOC_Q
05-JUN-2009 19:51:51 – Queue stopped = XLA.XLA_1922153_COMP_Q
05-JUN-2009 19:51:51 – Queue dropped = XLA.XLA_1922153_DOC_Q
05-JUN-2009 19:51:51 – Queue dropped = XLA.XLA_1922153_COMP_Q
05-JUN-2009 19:51:51 – Calling sequencing batch_exit
05-JUN-2009 19:51:51 – Returned from sequencing batch_exit
05-JUN-2009 19:51:51 – Executed post-accounting routine
05-JUN-2009 19:51:51 – request for balance calulation submitted
05-JUN-2009 19:51:51 – Accounting Program completed successfully
05-JUN-2009 19:51:51 – executing postaccounting hook event key =
4144-1922153
05-JUN-2009 19:51:51 – postaccounting hook executed successfully
– Accounting Time = 108.25 secs
– Transfer Time = 0 secs
05-JUN-2009 19:51:51 – End of the Report
+—————————————

#7 Comment By Roland Docking On July 14, 2010 @ 2:27 am

Hi maybe You can help me, im getting the following creating accounting

XDO Data Engine Version No: 5.6.3
Resp: 50562
Org ID : 82
Request ID: 4915573
All Parameters: P_APPLICATION_ID=222:P_SOURCE_APPLICATION_ID=:P_DUMMY=:P_LEDGER_ID=2021:P_PROCESS_CATEGORY_CODE=:P_END_DATE=:P_CREATE_ACCOUNTING_FLAG=N:P_DUMMY_PARAM_1=:P_ACCOUNTING_MODE=:P_DUMMY_PARAM_2=:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO_GL_FLAG=Y:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=Y:P_GL_BATCH_NAME=:P_MIN_PRECISION=2:P_INCLUDE_ZERO_AMOUNT_LINES=:P_REQUEST_ID=:P_ENTITY_ID=698930:P_SOURCE_APPLICATION_NAME=:P_APPLICATION_NAME=:P_LEDGER_NAME=:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=:P_ACCOUNTING_MODE_NAME=:P_ERRORS_ONLY=:P_ACCOUNTING_REPORT_LEVEL=:P_TRANSFER_TO_GL=:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=: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_INCLUDE_USER_TRX_ID_FLAG=:P_INCLUDE_USER_TRX_IDENTIFIERS=:P_USER_ID=:DebugFlag=
Data Template Code: XLAACCPB
Data Template Application Short Name: XLA
Debug Flag:
{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=}
Calling XDO Data Engine…
[071410_101331390][][EXCEPTION] SQLException encounter while executing data trigger….
java.sql.SQLException: ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_create_acct_rpt_pvt.BeforeReport . ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_CREATE_ACCT_RPT_PVT.print_logfile. ORA-20100: Error: FND_FILE failure. Unable to create file, o0219474.tmp in the directory, /usr/tm
ORA-06512: at “APPS.APP_EXCEPTION”, line 72
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 110
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 289
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 162
ORA-06512: at “APPS.XLA_CREATE_ACCT_RPT_PVT”, line 275
ORA-06512: at line 4

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4395)
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:348)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Oracle error 20100: java.sql.SQLException: ORA-20100: Error: FND_FILE failure. Unable to create file, o0219474.tmp in the directory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at “APPS.FND_FILE”, line 417
ORA-06512: at “APPS.FND_FILE”, line 526
ORA-06512: at “APPS.FND_CONCURRENT”, line 1326
ORA-06512: at line 1
has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.+—————————————————————————+
Start of log messages from FND_FILE

#8 Comment By Naveen On August 18, 2010 @ 5:21 pm

Hi Sanjit,

Nice post as always.I would like to know what is the interface program for Sub ledger. Like the one we have for GL e.g .GL INTERFACE.

DO you where i can find the documnet related to that. We need to change the interface from third party to Sub ledger for R12 which is going to GL in 11i.

Thanks,
Naveen

#9 Comment By SivaSankar C On September 13, 2010 @ 10:54 am

Dear,

Create Accounting ran with Transfer to GL and Post in Final Mode,
Could you please reply, how do we revers the accounting entries created but not transfered to GL due to table space problem…

Thanks in Advance…

#10 Comment By Vamsi Kasina On January 11, 2011 @ 1:34 pm

GL Transfer Datafixes 883557.1