This discussion is archived
5 Replies Latest reply: Mar 21, 2011 4:36 AM by 849004 RSS

R12.0.4: Error loading Accounting Setup

763345 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    tshukudu Newbie
    Currently Being Moderated
    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
    tshukudu Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points