5 Replies Latest reply on Oct 15, 2009 9:40 AM by 554812

    Error when creating Final Accounting Post to GL in AR

    640175
      Hello,
      I currently getting an error while creating Final Accounting Post to GL

      I have changed the Profile Option SLA: Enable Trace to <null> as mentioned in the solution on metalink. But still I'm getting this error.
      If anyone has encountered the error(LOG) below; please reply me as soon as possible

      thanks
      mevin

      THE LOG

      ---------------------------------------------------------------------------
      Subledger Accounting: Version : 12.0.0

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

      XLAACCPB module: Create Accounting
      ---------------------------------------------------------------------------

      Current system time is 14-AUG-2009 09:36:54

      ---------------------------------------------------------------------------

      XDO Data Engine Version No: 5.6.3
      Resp: 50832
      Org ID : 102
      Request ID: 499751
      All Parameters: P_APPLICATION_ID=222:P_SOURCE_APPLICATION_ID=:P_DUMMY=:P_LEDGER_ID=2089: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=118514: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=118514, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=, P_LEDGER_ID=2089, 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...
      [081409_093744202][][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-95103: An internal
      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 java.lang.Throwable.<init>(Throwable.java:57)
           at java.lang.Throwable.<init>(Throwable.java:68)
           at java.sql.SQLException.<init>(SQLException.java:55)
           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)

      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      14-AUG-2009 09:37:19 - Beginning of the Report
      GL Inerface tablename = GL_INTERFACE
      GL Inerface tablename = GL_INTERFACE
      tablename = GL_INTERFACE
      14-AUG-2009 09:37:19- Submitting the Journal Import
      GL Inerface tablename = GL_INTERFACE
      GL Inerface tablename = GL_INTERFACE
      tablename = GL_INTERFACE
      14-AUG-2009 09:37:19- Submitting the Journal Import
      14-AUG-2009 09:37:44- Journal Import completed
      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-95103: An internal
      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

      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 14-AUG-2009 09:37:45

      ---------------------------------------------------------------------------