1 2 Previous Next 16 Replies Latest reply: Jan 8, 2013 11:18 PM by Hussein Sawwan-Oracle RSS

    AP Create Accounting - Error ORA-06512, XLA-95103, ORA-20001, ORA-20100

    982348
      *Hello all you patient Oracle Champs - I know issues like this are floating around the forum and web but I still can't seem to fine a match.*

      *> OA R12.1.3*
      *> Orcale Database Server 11.2.0.2*

      [010613_011550898][][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, o0104058.tmp in the directory, /usr/tm
      ORA-06512: at "APPS.APP_EXCEPTION", line 72

      *> Note the directory path cited: +/usr/tm+*
      *> A later error:*
      Oracle error 20100: java.sql.SQLException: ORA-20100: Error: FND_FILE failure.
      Unable to create file, o0104058.tmp in the directory, /usr/tmp.

      *> Note the directory: +/usr/tmp+*

      SQL> show parameter utl_file_dir
      utl_file_dir
      string /usr/tmp, /usr/tmp, /Develop_DB/DEV/11.2.0.2/appsutil/outbound/DEV_orcl-dev-db, /usr/tmp


      $ echo $APPLTMP
      /Develop_Appl/DEV/inst/apps/DEV_orcl-dev-appl/appltmp
      *> has read/write permissions (777)*

      $ echo $APPLPTMP
      /usr/tmp
      *> has read/write permissions (777)*


      *> There is plenty of space in /usr, /Develop_Appl*
      *> Patch 10131305 already applied per note: 1392267.1*
      *> SLA: Enable Diagnostics set to a null value (blank)*
      *> the file o0104058.tmp does not exist in either $APPLTMP or $APPLPTMP (i.e. note 460643.1)*
      *> I confirmed that note 749491.1 was not an issue*
      *> note 261693.1 did not seem to apply*
      *> note 148262.1 did not seem to apply*

      I can provide the concurrent & FND debug output if needed.

      Thank you all*

      Zippy the P
        1 2 Previous Next