5 Replies Latest reply: Mar 21, 2011 6:36 AM by 849004 RSS

    R12.0.4: Error loading Accounting Setup

    763345
      Applied successfully the following mandatory patches on top of our 12.0.4 EBS source instance.
      8533775
      7608712
      8441573
      7413966
      8366676
      8445446

      When trying to load back the accounting setup extract file into the source instance (Yes the source instance is also the target) , I get the following error
      You must provide a valid, non-null value for <RetEarnSegments> attribute.

      No changes were made to the Accounting Setup between the extraction and the load.


      Do I need to apply another patch here? I will also file an SR.



      BTW, I have the same error when trying to load this accounting setup into a different target instance (R12.0.4) where the above mentionned patches were also applied.

      Following is the log file of the load process


      ---------------------------------------------------------------------------
      Application Implementation: Version : 12.0.0

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

      AZR12LOADER module: iSetup R12 Loader
      ---------------------------------------------------------------------------

      Current system time is 17-APR-2010 07:27:07

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

      Working Directory= /opt/oracle/htbv6/lab2/inst/apps/htblab2_qcmtlora02/logs/appl/conc/log/
      CP Request Directory=> /opt/oracle/htbv6/lab2/inst/apps/htblab2_qcmtlora02/logs/appl/conc/log/lreq357863

      Concurrent Request Parameters
      ******************************
      RELOAD_REQUEST_ID=
      SNAPSHOT_NAME=FinancialsFoundation:AccountingSetups_EX
      JOB_NAME=FinancialsFoundation:AccountingSetups_LD98
      DBC_FILE_NAME=
      SNAPSHOT_REQUEST_TYPE=E
      IS_REMOTE=N
      REQUEST_TYPE=L
      USER_NAME=SYSADMIN
      RELOAD_METHOD=


      Environment Parameters
      **********************
      TWO_TASK=htblab2
      APPLCSF=/opt/oracle/htbv6/lab2/inst/apps/htblab2_qcmtlora02/logs/appl/conc
      APPLLOG=log
      FNDTOP=/opt/oracle/htbv6/lab2/apps/apps_st/appl/fnd/12.0.0
      FNDSECURETOP=/opt/oracle/htbv6/lab2/inst/apps/htblab2_qcmtlora02/appl/fnd/12.0.0/secure

      Downloading the extract from central instance
      Successfully copied the Extract => /opt/oracle/htbv6/lab2/inst/apps/htblab2_qcmtlora02/logs/appl/conc/log/lreq357863/AZhtblab2357863.zip
      Time taken to download Extract and write as zip file = 0 seconds
      Validating Primary Extract...
      Parsing driver.xml
      Time taken to parse the Driver file and construct setup objects:32 milliseconds


      Sorting Apis based on their dependency...
      Time taken to sort the Apis=13 milliseconds




      Printing sorted Apis
      *********************
      Load Sequence 1
      *************
      1)GL_AccountingSetup
      Apr 17, 2010 7:27:20 AM oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
      INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found


      ******************************************
      Name: GL_AccountingSetup
      Type: BC4J
      Path: oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAM
      Time Taken(seconds): 19.0
      oracle.apps.fnd.framework.OAException: An exception occurred in API 'Accounting Setup Manager API'.
           at oracle.apps.az.fwk.BEUtil.wrapperException(BEUtil.java:381)
           at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:426)
           at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:414)
           at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:260)
           at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:803)
           at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:503)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OARowValException: An error occurred in API 'Accounting Setup Manager API'
      View Object 'GLLedgerConfigurationsVO_GLLedgersVO_GLConfigToLedgersVL_GLLedgersVO'
      FirstLedgerPeriodName = 'HTBPERIOD-09'
      ShortName = 'HTBLedger2021(USD)'
      AllowIntercompanyPostFlag = 'N'
      FutureEnterablePeriodsLimit = '1'
      EnableAutomaticTaxFlag = 'N'
      EnableBudgetaryControlFlag = 'N'
      SuspenseAllowedFlag = 'N'
      TranslateQatdFlag = 'N'
      Name = 'HTBLedger'
      TranslateYatdFlag = 'N'
      AlcLedgerTypeCode = 'NONE'
      TrackRoundingImbalanceFlag = 'N'
      SetManualFlag = 'N'
      LedgerCategoryCode = 'PRIMARY'
      ChartOfAccountsCode = 'ACCOUNTING_FLEXFIELD'
      PeriodSetName = 'HTBCAL'
      ConsolidationLedgerFlag = 'N'
      BalSegValueOptionCode = 'A'
      TranslateEodFlag = 'N'
      AutomaticallyCreatedFlag = 'N'
      LeLedgerTypeCode = 'L'
      RequireBudgetJournalsFlag = 'N'
      EnableAverageBalancesFlag = 'N'
      EnableJeApprovalFlag = 'N'
      CurrencyCode = 'USD'
      UserPeriodType = 'HTBPERIODTYPE'
      LedgerAttributes = 'L'
      MgtSegValueOptionCode = 'A'
      ObjectTypeCode = 'L'

           at oracle.apps.az.fwk.BEUtil.bundleToVOException(BEUtil.java:507)
           at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:893)
           at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1204)
           at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:1722)
           at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:591)
           at oracle.xml.parser.v2.XMLContentHandler.startElement(XMLContentHandler.java:181)
           at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
           at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
           at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
           at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:206)
           at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:387)
           at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:414)
           at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:260)
           at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:803)
           at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:503)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAAttrValException: An exception occurred in attribute 'RetEarnSegments'.
           at oracle.apps.az.fwk.BEUtil.wrapperAttrException(BEUtil.java:468)
           at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:875)
           at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1204)
           at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:1722)
           at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:591)
           at oracle.xml.parser.v2.XMLContentHandler.startElement(XMLContentHandler.java:181)
           at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
           at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
           at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
           at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:206)
           at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:387)
           at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:414)
           at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:260)
           at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:803)
           at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:503)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAException: You must provide a valid, non-null value for <RetEarnSegments> attribute.
           at oracle.apps.gl.ispeed.config.server.GLLedgersVORowImpl.setRetEarnSegments(GLLedgersVORowImpl.java:1214)
           at oracle.apps.gl.ispeed.config.server.GLLedgersVORowImpl.setAttrInvokeAccessor(GLLedgersVORowImpl.java:2683)
           at oracle.jbo.server.ViewRowImpl.setAttribute(ViewRowImpl.java:838)
           at oracle.apps.fnd.framework.server.OAViewRowImpl.setAttribute(OAViewRowImpl.java:239)
           at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:868)
           at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1204)
           at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:1722)
           at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:591)
           at oracle.xml.parser.v2.XMLContentHandler.startElement(XMLContentHandler.java:181)
           at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
           at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
           at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
           at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:206)
           at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:387)
           at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:414)
           at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:260)
           at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:803)
           at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:503)

      Importing rows from xml file, and validating rows ......

      Processed API:GL_AccountingSetup
      Status: ERROR
      ******************************************
      Cannot continue processing APIs as there are some errors.
      java.lang.Exception: Cannot continue processing APIs as there are some errors.
           at oracle.apps.az.r12.loader.cpserver.APILoader.executeApis(APILoader.java:259)
           at oracle.apps.az.r12.loader.cpserver.APILoader.loadAPIs(APILoader.java:206)
           at oracle.apps.az.r12.loader.cpserver.APILoader.callAPIs(APILoader.java:126)
           at oracle.apps.az.r12.loader.cpserver.LoaderContextImpl.load(LoaderContextImpl.java:66)
           at oracle.apps.az.r12.loader.cpserver.LoaderCp.runProgram(LoaderCp.java:65)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

      Concurrent program completed.
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


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


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 17-APR-2010 07:28:18

      ---------------------------------------------------------------------------
        • 1. Re: R12.0.4: Error loading Accounting Setup
          Hussein Sawwan-Oracle
          Hi,

          Please see if (Note: 605440.1 - FEM_IMPORT_DATA_LOCK_ERR Error Running Import Load for Mapping Rule in R12) is applicable.

          Regards,
          Hussein
          • 2. Re: R12.0.4: Error loading Accounting Setup
            763345
            Thanks for your reply Hussein.
            The note is refering to a different problem.

            I even tried an extract and load on the same instance with the Accounting Calendars object and with the Locations object without any errors.

            I did some research on this RetEarnSegment and found out that it has to do with an optional setting of the flexfield qualifier (Secondary Tracking Segment) for one of the segments in the General Ledger Accounting Key Flexfield. We do not need to use such a segment !

            Still investigating.

            Gaétan
            • 3. Re: R12.0.4: Error loading Accounting Setup
              Mosala Mochela
              Hi

              Did you manage to sort out this problem, If Yes I would really appreciate if you could tell me how as we experiencing the same problem using iSetup?

              Regards
              Andrew
              • 4. Re: R12.0.4: Error loading Accounting Setup
                Mosala Mochela
                Hi Gaétan

                Did you manage to sort out this problem, if yes could you provide some highlight as to how you managed to overcome this?

                Regards
                Andrew
                • 5. Re: R12.0.4: Error loading Accounting Setup
                  849004
                  Hi

                  did you manage to resolve ur error I am also experiencing the same error.

                  Entity Name: Accounting Setups
                  Type: BC4J
                  Executable Path: oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAM
                  Ignore Warnings and Continue: No
                  Update Existing Records: Yes
                  Time Taken(seconds): 1.0
                  oracle.apps.fnd.framework.OARowValException: An error occurred in API 'Accounting Setup Manager API'
                  View Object 'GLLedgerConfigurationsVO_GLLedgersVO_GLConfigToLedgersVL_GLLedgersVO'
                  Ledger Id = 'null'
                       at oracle.apps.az.fwk.BEUtil.bundleToVOException(BEUtil.java:651)
                       at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:1194)
                       at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1489)
                       at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:2094)
                       at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:590)
                       at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
                       at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
                       at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
                       at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:205)
                       at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:386)
                       at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:404)
                       at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:264)
                       at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:938)
                       at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:656)
                  ## Detail 0 ##
                  oracle.apps.fnd.framework.OAAttrValException: An exception occurred in attribute 'ShortName'.
                       at oracle.apps.az.fwk.BEUtil.wrapperAttrException(BEUtil.java:612)
                       at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:1176)
                       at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1489)
                       at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:2094)
                       at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:590)
                       at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
                       at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
                       at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
                       at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:205)
                       at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:386)
                       at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:404)
                       at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:264)
                       at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:938)
                       at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:656)
                  ## Detail 0 ##
                  oracle.apps.fnd.framework.OAAttrValException: A ledger, ledger set or reporting currency with this short name already exists. Please provide a unique name.
                       at oracle.apps.gl.asflow.ledger.server.GLLedgersEOImpl.validateShortNameUnique(GLLedgersEOImpl.java:703)
                       at oracle.apps.gl.asflow.ledger.server.GLLedgersEOImpl.setShortName(GLLedgersEOImpl.java:1715)
                       at oracle.apps.gl.asflow.ledger.server.GLLedgersEOImpl.setAttrInvokeAccessor(GLLedgersEOImpl.java:4395)
                       at oracle.jbo.server.EntityImpl.setAttribute(EntityImpl.java:996)
                       at oracle.jbo.server.ViewRowStorage.setAttributeValue(ViewRowStorage.java:1312)
                       at oracle.jbo.server.ViewRowStorage.setAttributeInternal(ViewRowStorage.java:1216)
                       at oracle.jbo.server.ViewRowImpl.setAttributeInternal(ViewRowImpl.java:1116)
                       at oracle.jbo.server.ViewRowServiceImpl.setAttributeInternal(Unknown Source)
                       at oracle.apps.gl.ispeed.config.server.GLLedgersVORowImpl.setShortName(GLLedgersVORowImpl.java:182)
                       at oracle.apps.gl.ispeed.config.server.GLLedgersVORowImpl.setAttrInvokeAccessor(GLLedgersVORowImpl.java:2474)
                       at oracle.jbo.server.ViewRowImpl.setAttribute(ViewRowImpl.java:838)
                       at oracle.apps.fnd.framework.server.OAViewRowImpl.setAttribute(OAViewRowImpl.java:239)
                       at oracle.apps.az.fwk.server.BEImport.setRowAttributeValues(BEImport.java:1169)
                       at oracle.apps.az.fwk.server.BEImport.insertOrUpdateRowWithAtts(BEImport.java:1489)
                       at oracle.apps.az.fwk.server.BEImport.processOneRecord(BEImport.java:2094)
                       at oracle.apps.az.fwk.server.BEImport.startElement(BEImport.java:590)
                       at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1288)
                       at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
                       at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
                       at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:205)
                       at oracle.apps.az.fwk.server.BEImport.importXML(BEImport.java:386)
                       at oracle.apps.az.fwk.server.BEApplicationModuleImpl.importFromXML(BEApplicationModuleImpl.java:404)
                       at oracle.apps.gl.ispeed.config.server.GLLedgerConfigurationsAMImpl.importFromXML(GLLedgerConfigurationsAMImpl.java:264)
                       at oracle.apps.az.r12.api.BC4JAPI.importAPI(BC4JAPI.java:938)
                       at oracle.apps.az.r12.loader.cpserver.APILoader$APIExecuter.run(APILoader.java:656)

                  Importing rows from xml file, and validating rows ......

                  Processed API:GL_AccountingSetup
                  Status: ERROR
                  ******************************************
                  Cannot continue processing APIs as there are some errors.
                  java.lang.Exception: Cannot continue processing APIs as there are some errors.
                       at oracle.apps.az.r12.loader.cpserver.APILoader.executeApis(APILoader.java:395)
                       at oracle.apps.az.r12.loader.cpserver.APILoader.loadAPIs(APILoader.java:340)
                       at oracle.apps.az.r12.loader.cpserver.APILoader.callAPIs(APILoader.java:143)
                       at oracle.apps.az.r12.loader.cpserver.LoaderContextImpl.load(LoaderContextImpl.java:66)
                       at oracle.apps.az.r12.loader.cpserver.LoaderCp.runProgram(LoaderCp.java:65)
                       at oracle.apps.fnd.cp.request.Run.main(Run.java:157)