8 Replies Latest reply on Feb 7, 2012 5:43 AM by 911252

    Error when i create accounting

    911252
      frist of all sorry if i put this message in wrong subject or wrong thread.this is my frist time in forum

      dear all,

      i use ebs r12 12.1.2 os Linux x86-64

      when i create accounting i meet error this log :

      ---------------------------------------------------------------------------
      Application Object Library: Version : 12.0.0

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

      FNDWFBG module: Workflow Background Process
      ---------------------------------------------------------------------------

      Current system time is 15-APR-2011 01:39:37

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

      **Starts**15-APR-2011 01:39:37
      **Ends**15-APR-2011 01:39:37
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------
      Successfully resubmitted concurrent program FNDWFBG with request ID 450126 to start at 15-APR-2011 01:53:18 (ROUTINE=AFPSRS)


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


      Output is not being printed because:
      The print option has been disabled for this report.

      ------------- 1) PRINT   -------------
      --------------------------------------


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed successfully
      Current system time is 15-APR-2011 01:39:37

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

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

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

      Current system time is 16-JAN-2012 12:43:15

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

      XDO Data Engine Version No: 5.6.3
      Resp: 20639
      Org ID : 81
      Request ID: 450125
      All Parameters: P_APPLICATION_ID=200:P_SOURCE_APPLICATION_ID=200:P_DUMMY=Y:P_LEDGER_ID=2023:P_PROCESS_CATEGORY_CODE=PAYMENTS:P_END_DATE="2012/01/10 00:00:00":P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE=D:P_DUMMY_PARAM_2=:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=D:P_TRANSFER_TO_GL_FLAG=:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=:P_GL_BATCH_NAME=test11:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Payables:P_APPLICATION_NAME=Payables:P_LEDGER_NAME=SMI_PL:P_PROCESS_CATEGORY_NAME=Payments:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Draft:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=Detail:P_TRANSFER_TO_GL=:P_POST_IN_GL=: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_INCLUDE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:DebugFlag=Y:P_USER_ID=1110
      Data Template Code: XLAACCPB
      Data Template Application Short Name: XLA
      Debug Flag: Y
      {P_ACCOUNTING_REPORT_LEVEL=Detail, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Draft, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=D, P_GL_BATCH_NAME=test11, P_END_DATE=2012/01/10 00:00:00, 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=, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=1110, P_PROCESS_CATEGORY_NAME=Payments, P_ERRORS_ONLY=No, P_DUMMY_PARAM_3=, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=, P_ENTITY_ID=, P_PROCESS_CATEGORY_CODE=PAYMENTS, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=2023, P_POST_IN_GL_FLAG=, 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=SMI_PL, 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=D}
      Calling XDO Data Engine...
      [011612_124319140][][STATEMENT] oracle.jdbc.driver.OracleBlobInputStream@179f36b
      [011612_124319242][][STATEMENT] Logger.init(): *** DEBUG MODE IS OFF. ***
      [011612_124319244][][STATEMENT] DataTemplate.getTmpDir(): system-temp-dir property value from DATABASE: /usr/temp
      [011612_124319246][][STATEMENT] Template parsing started...
      [011612_124319389][][STATEMENT] Data Template ......
      [011612_124319389][][STATEMENT] oracle.xml.parser.v2.XMLDocument@19fdbcb
      [011612_124319525][][STATEMENT] Inside properties Parser...
      [011612_124319525][][STATEMENT] db_fetch_size=20
      [011612_124319526][][STATEMENT] Inside parameterParser...
      [011612_124319527][][STATEMENT] Parameter:P_REQUEST_ID Default value:
      [011612_124319527][][STATEMENT] Parameter:P_ENTITY_ID Default value:
      [011612_124319527][][STATEMENT] Parameter:P_SOURCE_APPLICATION_ID Default value:
      [011612_124319527][][STATEMENT] Parameter:P_SOURCE_APPLICATION_NAME Default value:
      [011612_124319527][][STATEMENT] Parameter:P_APPLICATION_ID Default value:
      [011612_124319527][][STATEMENT] Parameter:P_APPLICATION_NAME Default value:
      [011612_124319527][][STATEMENT] Parameter:P_DUMMY Default value:
      [011612_124319527][][STATEMENT] Parameter:P_LEDGER_ID Default value:
      [011612_124319527][][STATEMENT] Parameter:P_LEDGER_NAME Default value:
      [011612_124319527][][STATEMENT] Parameter:P_PROCESS_CATEGORY_CODE Default value:
      [011612_124319528][][STATEMENT] Parameter:P_PROCESS_CATEGORY_NAME Default value:
      [011612_124319528][][STATEMENT] Parameter:P_END_DATE Default value:
      [011612_124319528][][STATEMENT] Parameter:P_CREATE_ACCOUNTING_FLAG Default value:
      [011612_124319528][][STATEMENT] Parameter:P_CREATE_ACCOUNTING Default value:
      [011612_124319528][][STATEMENT] Parameter:P_DUMMY_PARAM_1 Default value:
      [011612_124319528][][STATEMENT] Parameter:P_ACCOUNTING_MODE Default value:
      [011612_124319528][][STATEMENT] Parameter:P_DUMMY_PARAM_2 Default value:
      [011612_124319528][][STATEMENT] Parameter:P_ERRORS_ONLY_FLAG Default value:
      [011612_124319528][][STATEMENT] Parameter:P_REPORT_STYLE Default value:
      [011612_124319528][][STATEMENT] Parameter:P_ACCOUNTING_MODE_NAME Default value:
      [011612_124319528][][STATEMENT] Parameter:P_ERRORS_ONLY Default value:
      [011612_124319528][][STATEMENT] Parameter:P_ACCOUNTING_REPORT_LEVEL Default value:
      [011612_124319529][][STATEMENT] Parameter:P_TRANSFER_TO_GL_FLAG Default value:
      [011612_124319529][][STATEMENT] Parameter:P_TRANSFER_TO_GL Default value:
      [011612_124319529][][STATEMENT] Parameter:P_DUMMY_PARAM_3 Default value:
      [011612_124319529][][STATEMENT] Parameter:P_POST_IN_GL_FLAG Default value:
      [011612_124319529][][STATEMENT] Parameter:P_POST_IN_GL Default value:
      [011612_124319529][][STATEMENT] Parameter:P_GL_BATCH_NAME Default value:
      [011612_124319529][][STATEMENT] Parameter:P_MIN_PRECISION Default value:
      [011612_124319529][][STATEMENT] Parameter:P_INCLUDE_ZERO_AMOUNT_LINES Default value:
      [011612_124319529][][STATEMENT] Parameter:P_INCLUDE_ZERO_AMT_LINES Default value:
      [011612_124319530][][STATEMENT] Parameter:P_VALUATION_METHOD_CODE Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_INT_1 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_INT_2 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_INT_3 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_CHAR_1 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_CHAR_2 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_SECURITY_CHAR_3 Default value:
      [011612_124319530][][STATEMENT] Parameter:P_CONC_REQUEST_ID Default value:
      [011612_124319531][][STATEMENT] Parameter:P_INCLUDE_USER_TRX_ID_FLAG Default value:
      [011612_124319531][][STATEMENT] Parameter:P_INCLUDE_USER_TRX_IDENTIFIERS Default value:
      [011612_124319531][][STATEMENT] Parameter:P_USER_ID Default value:
      [011612_124319531][][STATEMENT] Inside dataQueryParser...
      [011612_124319535][][STATEMENT] Inside dataStructureParser...
      [011612_124319540][][STATEMENT] Group ...report
      [011612_124319541][][STATEMENT] Group ...APPLICATION
      [011612_124319542][][STATEMENT] Group ...APPLICATION_FLAG
      [011612_124319543][][STATEMENT] Group ...NO_ACTION_EVT
      [011612_124319544][][STATEMENT] Group ...ACCT_PROG_ERRORS
      [011612_124319545][][STATEMENT] Group ...EVENT_CLASS_S
      [011612_124319545][][STATEMENT] Group ...LEDGER_S
      [011612_124319546][][STATEMENT] Group ...BALANCE_TYPE_S
      [011612_124319547][][STATEMENT] Group ...EVENT
      [011612_124319548][][STATEMENT] Group ...AE_HEADERS
      [011612_124319550][][STATEMENT] Group ...AE_LINES
      [011612_124319551][][STATEMENT] Group ...AE_ERRORS
      [011612_124319552][][STATEMENT] Group ...NO_ENTRY_EVENTS
      [011612_124319553][][STATEMENT] Template parsing completed...
      [011612_124319553][][STATEMENT] Setting Data Template
      [011612_124319553][][STATEMENT] Setting JDBC Connection
      [011612_124319576][][STATEMENT] Paramter :P_REQUEST_ID Value :
      [011612_124319642][][STATEMENT] Paramter :P_ENTITY_ID Value :
      [011612_124319642][][STATEMENT] Paramter :P_SOURCE_APPLICATION_ID Value :200
      [011612_124319642][][STATEMENT] Paramter :P_SOURCE_APPLICATION_NAME Value :Payables
      [011612_124319642][][STATEMENT] Paramter :P_APPLICATION_ID Value :200
      [011612_124319642][][STATEMENT] Paramter :P_APPLICATION_NAME Value :Payables
      [011612_124319642][][STATEMENT] Paramter :P_DUMMY Value :Y
      [011612_124319642][][STATEMENT] Paramter :P_LEDGER_ID Value :2023
      [011612_124319642][][STATEMENT] Paramter :P_LEDGER_NAME Value :SMI_PL
      [011612_124319643][][STATEMENT] Paramter :P_PROCESS_CATEGORY_CODE Value :PAYMENTS
      [011612_124319643][][STATEMENT] Paramter :P_PROCESS_CATEGORY_NAME Value :Payments
      [011612_124319658][][STATEMENT] Paramter :P_END_DATE Value :2012/01/10 00:00:00
      [011612_124319658][][STATEMENT] Paramter :P_CREATE_ACCOUNTING_FLAG Value :Y
      [011612_124319658][][STATEMENT] Paramter :P_CREATE_ACCOUNTING Value :Yes
      [011612_124319658][][STATEMENT] Paramter :P_DUMMY_PARAM_1 Value :Y
      [011612_124319658][][STATEMENT] Paramter :P_ACCOUNTING_MODE Value :D
      [011612_124319658][][STATEMENT] Paramter :P_DUMMY_PARAM_2 Value :
      [011612_124319658][][STATEMENT] Paramter :P_ERRORS_ONLY_FLAG Value :N
      [011612_124319658][][STATEMENT] Paramter :P_REPORT_STYLE Value :D
      [011612_124319658][][STATEMENT] Paramter :P_ACCOUNTING_MODE_NAME Value :Draft
      [011612_124319658][][STATEMENT] Paramter :P_ERRORS_ONLY Value :No
      [011612_124319658][][STATEMENT] Paramter :P_ACCOUNTING_REPORT_LEVEL Value :Detail
      [011612_124319658][][STATEMENT] Paramter :P_TRANSFER_TO_GL_FLAG Value :
      [011612_124319658][][STATEMENT] Paramter :P_TRANSFER_TO_GL Value :
      [011612_124319659][][STATEMENT] Paramter :P_DUMMY_PARAM_3 Value :
      [011612_124319659][][STATEMENT] Paramter :P_POST_IN_GL_FLAG Value :
      [011612_124319659][][STATEMENT] Paramter :P_POST_IN_GL Value :
      [011612_124319659][][STATEMENT] Paramter :P_GL_BATCH_NAME Value :test11
      [011612_124319750][][STATEMENT] Paramter :P_MIN_PRECISION Value :
      [011612_124319751][][STATEMENT] Paramter :P_INCLUDE_ZERO_AMOUNT_LINES Value :N
      [011612_124319751][][STATEMENT] Paramter :P_INCLUDE_ZERO_AMT_LINES Value :No
      [011612_124319751][][STATEMENT] Paramter :P_VALUATION_METHOD_CODE Value :
      [011612_124319772][][STATEMENT] Paramter :P_SECURITY_INT_1 Value :
      [011612_124319837][][STATEMENT] Paramter :P_SECURITY_INT_2 Value :
      [011612_124319891][][STATEMENT] Paramter :P_SECURITY_INT_3 Value :
      [011612_124319891][][STATEMENT] Paramter :P_SECURITY_CHAR_1 Value :
      [011612_124319891][][STATEMENT] Paramter :P_SECURITY_CHAR_2 Value :
      [011612_124319892][][STATEMENT] Paramter :P_SECURITY_CHAR_3 Value :
      [011612_124319958][][STATEMENT] Paramter :P_CONC_REQUEST_ID Value :
      [011612_124319958][][STATEMENT] Paramter :P_INCLUDE_USER_TRX_ID_FLAG Value :N
      [011612_124319958][][STATEMENT] Paramter :P_INCLUDE_USER_TRX_IDENTIFIERS Value :No
      [011612_124319958][][STATEMENT] Paramter :P_USER_ID Value :1110
      [011612_124319958][][STATEMENT] Setting Parameters
      [011612_124319958][][STATEMENT] Setting Parameters
      [011612_124319960][][STATEMENT] Start process Data
      [011612_124319960][][STATEMENT] Process Data ...
      [011612_124319966][][STATEMENT] Executing data triggers...
      [011612_124319966][][STATEMENT] BEGIN
      XLA_CREATE_ACCT_RPT_PVT.P_REQUEST_ID := :P_REQUEST_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_ENTITY_ID := :P_ENTITY_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_SOURCE_APPLICATION_ID := :P_SOURCE_APPLICATION_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_SOURCE_APPLICATION_NAME := :P_SOURCE_APPLICATION_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_APPLICATION_ID := :P_APPLICATION_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_APPLICATION_NAME := :P_APPLICATION_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_DUMMY := :P_DUMMY ;
      XLA_CREATE_ACCT_RPT_PVT.P_LEDGER_ID := :P_LEDGER_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_LEDGER_NAME := :P_LEDGER_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_PROCESS_CATEGORY_CODE := :P_PROCESS_CATEGORY_CODE ;
      XLA_CREATE_ACCT_RPT_PVT.P_PROCESS_CATEGORY_NAME := :P_PROCESS_CATEGORY_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_END_DATE := :P_END_DATE ;
      XLA_CREATE_ACCT_RPT_PVT.P_CREATE_ACCOUNTING_FLAG := :P_CREATE_ACCOUNTING_FLAG ;
      XLA_CREATE_ACCT_RPT_PVT.P_CREATE_ACCOUNTING := :P_CREATE_ACCOUNTING ;
      XLA_CREATE_ACCT_RPT_PVT.P_DUMMY_PARAM_1 := :P_DUMMY_PARAM_1 ;
      XLA_CREATE_ACCT_RPT_PVT.P_ACCOUNTING_MODE := :P_ACCOUNTING_MODE ;
      XLA_CREATE_ACCT_RPT_PVT.P_DUMMY_PARAM_2 := :P_DUMMY_PARAM_2 ;
      XLA_CREATE_ACCT_RPT_PVT.P_ERRORS_ONLY_FLAG := :P_ERRORS_ONLY_FLAG ;
      XLA_CREATE_ACCT_RPT_PVT.P_REPORT_STYLE := :P_REPORT_STYLE ;
      XLA_CREATE_ACCT_RPT_PVT.P_ACCOUNTING_MODE_NAME := :P_ACCOUNTING_MODE_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_ERRORS_ONLY := :P_ERRORS_ONLY ;
      XLA_CREATE_ACCT_RPT_PVT.P_ACCOUNTING_REPORT_LEVEL := :P_ACCOUNTING_REPORT_LEVEL ;
      XLA_CREATE_ACCT_RPT_PVT.P_TRANSFER_TO_GL_FLAG := :P_TRANSFER_TO_GL_FLAG ;
      XLA_CREATE_ACCT_RPT_PVT.P_TRANSFER_TO_GL := :P_TRANSFER_TO_GL ;
      XLA_CREATE_ACCT_RPT_PVT.P_DUMMY_PARAM_3 := :P_DUMMY_PARAM_3 ;
      XLA_CREATE_ACCT_RPT_PVT.P_POST_IN_GL_FLAG := :P_POST_IN_GL_FLAG ;
      XLA_CREATE_ACCT_RPT_PVT.P_POST_IN_GL := :P_POST_IN_GL ;
      XLA_CREATE_ACCT_RPT_PVT.P_GL_BATCH_NAME := :P_GL_BATCH_NAME ;
      XLA_CREATE_ACCT_RPT_PVT.P_MIN_PRECISION := :P_MIN_PRECISION ;
      XLA_CREATE_ACCT_RPT_PVT.P_INCLUDE_ZERO_AMOUNT_LINES := :P_INCLUDE_ZERO_AMOUNT_LINES ;
      XLA_CREATE_ACCT_RPT_PVT.P_INCLUDE_ZERO_AMT_LINES := :P_INCLUDE_ZERO_AMT_LINES ;
      XLA_CREATE_ACCT_RPT_PVT.P_VALUATION_METHOD_CODE := :P_VALUATION_METHOD_CODE ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_INT_1 := :P_SECURITY_INT_1 ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_INT_2 := :P_SECURITY_INT_2 ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_INT_3 := :P_SECURITY_INT_3 ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_CHAR_1 := :P_SECURITY_CHAR_1 ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_CHAR_2 := :P_SECURITY_CHAR_2 ;
      XLA_CREATE_ACCT_RPT_PVT.P_SECURITY_CHAR_3 := :P_SECURITY_CHAR_3 ;
      XLA_CREATE_ACCT_RPT_PVT.P_CONC_REQUEST_ID := :P_CONC_REQUEST_ID ;
      XLA_CREATE_ACCT_RPT_PVT.P_INCLUDE_USER_TRX_ID_FLAG := :P_INCLUDE_USER_TRX_ID_FLAG ;
      XLA_CREATE_ACCT_RPT_PVT.P_INCLUDE_USER_TRX_IDENTIFIERS := :P_INCLUDE_USER_TRX_IDENTIFIERS ;
      XLA_CREATE_ACCT_RPT_PVT.P_USER_ID := :P_USER_ID ;

      :XDO_OUT_PARAMETER := 1;
      END;

      [011612_124319966][][STATEMENT] 1:null :
      [011612_124319966][][STATEMENT] 2:null :
      [011612_124319967][][STATEMENT] 3:200 :
      [011612_124319967][][STATEMENT] 4:Payables :
      [011612_124319967][][STATEMENT] 5:200 :
      [011612_124319967][][STATEMENT] 6:Payables :
      [011612_124319967][][STATEMENT] 7:Y :
      [011612_124319967][][STATEMENT] 8:2023 :
      [011612_124319967][][STATEMENT] 9:SMI_PL :
      [011612_124319967][][STATEMENT] 10:PAYMENTS :
      [011612_124319967][][STATEMENT] 11:Payments :
      [011612_124319968][][STATEMENT] 12:2012-01-10 00:00:00.0 :
      [011612_124319968][][STATEMENT] 13:Y :
      [011612_124319968][][STATEMENT] 14:Yes :
      [011612_124319968][][STATEMENT] 15:Y :
      [011612_124319968][][STATEMENT] 16:D :
      [011612_124319968][][STATEMENT] 17: :
      [011612_124319968][][STATEMENT] 18:N :
      [011612_124319968][][STATEMENT] 19:D :
      [011612_124319968][][STATEMENT] 20:Draft :
      [011612_124319968][][STATEMENT] 21:No :
      [011612_124319968][][STATEMENT] 22:Detail :
      [011612_124319968][][STATEMENT] 23: :
      [011612_124319968][][STATEMENT] 24: :
      [011612_124319968][][STATEMENT] 25: :
      [011612_124319968][][STATEMENT] 26: :
      [011612_124319968][][STATEMENT] 27: :
      [011612_124319968][][STATEMENT] 28:test11 :
      [011612_124319969][][STATEMENT] 29:null :
      [011612_124319969][][STATEMENT] 30:N :
      [011612_124319969][][STATEMENT] 31:No :
      [011612_124319969][][STATEMENT] 32: :
      [011612_124319969][][STATEMENT] 33:null :
      [011612_124319969][][STATEMENT] 34:null :
      [011612_124319969][][STATEMENT] 35:null :
      [011612_124319969][][STATEMENT] 36: :
      [011612_124319969][][STATEMENT] 37: :
      [011612_124319969][][STATEMENT] 38: :
      [011612_124319969][][STATEMENT] 39:null :
      [011612_124319969][][STATEMENT] 40:N :
      [011612_124319969][][STATEMENT] 41:No :
      [011612_124319969][][STATEMENT] 42:1110 :
      [011612_124319971][][STATEMENT] Executing data triggers...
      [011612_124319971][][STATEMENT] Declare
      l_flag Boolean;
      BEGIN
      l_flag := XLA_CREATE_ACCT_RPT_PVT.BeforeReport ;
      if (l_flag) then
      :XDO_OUT_PARAMETER := 1;
      end if;
      end;

      [011612_124319994][][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.
      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.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           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:334)
           at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
           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, o0010400.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 1328
      ORA-06512: at line 1
      has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.+---------------------------------------------------------------------------+
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


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

      ------------- 1) PUBLISH -------------
      Beginning post-processing of request 450125 on node ORAAPPS at 16-JAN-2012 12:43:20.
      Post-processing of request 450125 failed at 16-JAN-2012 12:43:21 with the error message:
      One or more post-processing actions failed. Consult the OPP service log for details.
      --------------------------------------


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 16-JAN-2012 12:43:21

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


      anyone have same problem and already solving ??

      Thanks,
      Mahardika
        • 1. Re: Error when i create accounting
          Hussein Sawwan-Oracle
          [011612_124319994][][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.
          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
          Please make sure you have no invalid objects.

          Please also see these docs.

          R12: Ap Invoice Online Accounting with Final Post Ends With Errors ORA-20001 XLA-95103 [ID 853424.1]
          FAACCPB Create Accounting Internal Error xla_create_acct_rpt_pvt.BeforeReport [ID 783493.1]
          CSTCRACC Create Accounting Err ORA-20001 Xla-95103 Internal Error Occurred ORA-01400 [ID 1309124.1]
          CSTCRACC - Create Accounting - Cost Management Completes With Errors: java.sql.SQLException, ORA-20001, XLA-95103 [ID 1252703.1]
          Create Accounting Concurrent Program Errors - ORA-20001 XLA-95103 [ID 1392267.1]
          Create Accounting Error Due To Invalid Package Apps.Ap_payment_extract_details_v [ID 1366269.1]
          ------------- 1) PUBLISH -------------
          Beginning post-processing of request 450125 on node ORAAPPS at 16-JAN-2012 12:43:20.
          Post-processing of request 450125 failed at 16-JAN-2012 12:43:21 with the error message:
          One or more post-processing actions failed. Consult the OPP service log for details.
          --------------------------------------
          Also check OPP log file ($APPLCSF/$APPLLOG/FNDOPP* file).

          Thanks,
          Hussein
          • 2. Re: Error when i create accounting
            911252
            what mean of "no invalid object" ?

            i have ebs12 in PROD engine but at that's engine no errors.
            this error in CRP engine ( cloning from PROD engine ) i concern about patch..
            why must apply patch if in PROD engine doesn't have error like in CRP engine ?
            • 3. Re: Error when i create accounting
              Hussein Sawwan-Oracle
              what mean of "no invalid object" ?
              Troubleshooting Guide - invalid objects in the E-Business Suite Environment 11i and 12 [ID 1325394.1]
              i have ebs12 in PROD engine but at that's engine no errors.
              this error in CRP engine ( cloning from PROD engine ) i concern about patch..
              why must apply patch if in PROD engine doesn't have error like in CRP engine ?
              Is there a difference between the two instances in terms of applied patches?

              Thanks,
              Hussein
              • 4. Re: Error when i create accounting
                911252
                Hussein Sawwan wrote:
                what mean of "no invalid object" ?
                Troubleshooting Guide - invalid objects in the E-Business Suite Environment 11i and 12 [ID 1325394.1]
                i have ebs12 in PROD engine but at that's engine no errors.
                this error in CRP engine ( cloning from PROD engine ) i concern about patch..
                why must apply patch if in PROD engine doesn't have error like in CRP engine ?
                Is there a difference between the two instances in terms of applied patches?

                Thanks,
                Hussein
                there No difference between the two instance because i never apply patch before.
                • 5. Re: Error when i create accounting
                  Hussein Sawwan-Oracle
                  What is the difference between the two instances?

                  Have you reviewed all the docs referenced above?

                  Thanks,
                  Hussein
                  • 6. Re: Error when i create accounting
                    911252
                    this problem was solved.

                    i change tmp folder direct default is "usr/tmp" change into $APPL_TOP/log

                    and it's work but i dont know the causes. because in that server have 3 instance and only this instance problem.
                    i think this about permission but when i changed mod "chmod 777" and so change owner i doesnt work.

                    Thanks
                    • 7. Re: Error when i create accounting
                      Hussein Sawwan-Oracle
                      this problem was solved.

                      i change tmp folder direct default is "usr/tmp" change into $APPL_TOP/log

                      and it's work but i dont know the causes. because in that server have 3 instance and only this instance problem.
                      i think this about permission but when i changed mod "chmod 777" and so change owner i doesnt work.
                      3 instances mean? Do you have shared application file system (or shared APPL_TOP)? If yes, this explains why the above fixed the issue.

                      Thanks,
                      Hussein
                      • 8. Re: Error when i create accounting
                        911252
                        3 instance mean on my server i have 3 EBS running.