3 Replies Latest reply: Jul 5, 2011 4:08 AM by Andrew Samoshkin RSS

    iSetup API for Financials Setups -> Fixed Assets -> Asset Categories buggy

    578014
      When migrating Asset Categories from one system to the other, on the same patch set, this API, using api_code FA_Category and path oracle.apps.fa.ispeed.category.server.CategoryAM, does not properly obtain the CCID in the new instance and does not store it in the loaded record in FA_CATEGORY_BOOKS table for the following two accounts:

      Depreciation Expense Account
      Bonus Expense Account

      but it does successfully store these two accounts:

      Asset Cost Account

      Reserve Account

      All four of these accounts are set up identically in the data as shown here:

      <AssetCostAcct>6710.900011</AssetCostAcct>
      <AssetCostAccountCcid>2011</AssetCostAccountCcid>
      <AssetCostAccountSegments>0-0-0-0-0-6710.900011-0-0-0-0-0-0-0-0-0</AssetCostAccountSegments>
                               
      <DeprnReserveAcct>6710.900011</DeprnReserveAcct>
      <ReserveAccountCcid>2011</ReserveAccountCcid>
      <ReserveAccountSegments>0-0-0-0-0-6710.900011-0-0-0-0-0-0-0-0-0</ReserveAccountSegments>

      <DeprnExpenseAcct>6710.900011</DeprnExpenseAcct>
      <DeprnExpenseAccountCcid>2011</DeprnExpenseAccountCcid>
      <DeprnExpenseAccountSegments>0-0-0-0-0-6710.900011-0-0-0-0-0-0-0-0-0</DeprnExpenseAccountSegments>
                               
      <BonusDeprnExpenseAcct>6710.900011</BonusDeprnExpenseAcct>
      <BonusExpenseAccountCcid>2011</BonusExpenseAccountCcid>
      <BonusExpenseAccountSegments>0-0-0-0-0-6710.900011-0-0-0-0-0-0-0-0-0</BonusExpenseAccountSegments>

      And I can see in the code where it calls the procedure getCodeCombinationID, for all the other accounts but never calls this procedure for these two accounts. This leads me to believe that the proper identification of the CCID of these two accounts was omitted from the code either accidentally or on purpose. See this code snippet from CategoryBookEOImpl.java:

      // CLASS: oracle.apps.fa.ispeed.category.server.CategoryBookEOImpl:
      public void resolveCcids( )
      {
      // ...
      aNumber41=this.getCodeCombinationId(aNumber40,this.getAssetCostAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getAssetClearingAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getWipCostAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getWipClearingAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getReserveAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getRevalAmortAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getRevalReserveAccountSegments());
      // ...
      aNumber41 =this.getCodeCombinationId(aNumber40,this.getBonusReserveAcctSegments());
      // ...
      // but never calls getCodeCombination with:
      //getDeprnExpenseAccountSegments()
      //getBonusExpenseAccountSegments()
      return;
      }

      Is there possibly already a bug fix for this omission, or can I get one? Should I open an SR?

      My version of oracle.apps.fa.ispeed.category.server.CategoryBookEOImpl is: "$Header: CategoryBookEOImpl.java 120.5.12000000.4 2007/08/10 16:03:26 spooyath ship $"

      Please help.

      Thanks,
      Gary