6 Replies Latest reply: May 14, 2013 1:49 AM by 635583 RSS

    Dac fails when trying to load a Table in BI Apps 7964

    Ashish Gupta
      Hi Experts,

      When i am trying to run the ETL Load through DAC, one of the the workflow is failing ie SDE_ORA_APTransactionFact_Distributions_Full

      When i look into the session log i see the below error...
      i went through this post also http://www.oraworld.co.uk/tag/informatica/

      I am not able to find out from session log which column is causing the issue.

      WRITER_1_*_1> WRT_8229 Database errors occurred:
      ORA-01438: value larger than specified precision allowed for this column

      Database driver error...
      Function Name : Execute Multiple
      SQL Stmt : INSERT INTO W_AP_XACT_FS(GL_ACCOUNT_ID,BUDGET_ORG_ID,CUSTOMER_ID,CUSTOMER_FIN_PROFL_ID,SUPPLIER_ID,SPLR_ACCT_ID,SALES_REP_ID,SERVICE_REP_ID,ACCT_REP_ID,PURCH_REP_ID,PRODUCT_ID,SALES_PROD_ID,INVENTORY_PROD_ID,SUPPLIER_PROD_ID1,COMPANY_LOC_ID,PLANT_LOC_ID,OPERATING_UNIT_ORG_ID,PAYABLES_ORG_ID,LEDGER_ID,COMPANY_ORG_ID,BUSN_AREA_ORG_ID,CTRL_AREA_ORG_ID,FIN_AREA_ORG_ID,SALES_ORG_ID,PURCHASE_ORG_ID,ISSUE_ORG_ID,DOC_TYPE_ID,CLRNG_DOC_TYPE_ID,REF_DOC_TYPE_ID,POSTING_TYPE_ID,CLRNG_POST_TYPE_ID,COST_CENTER_ID,PROFIT_CENTER_ID,DOC_STATUS_ID,BANK_ID,TAX_TYPE_ID,PAY_TERMS_ID,PAY_METHOD_ID,PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,EXPENDITURE_ORG_ID,SOURCE_ID,TRANSACTION_DT,POSTED_ON_DT,CONVERSION_DT,ORDERED_ON_DT,INVOICED_ON_DT,PURCH_ORDER_DT,SPLR_ORDER_DT,INVOICE_RECEIPT_DT,CLEARED_ON_DT,CLEARING_DOC_DT,BASELINE_DT,PLANNING_DT,PAYMENT_DUE_DT,AP_DOC_AMT,AP_LOC_AMT,AP_REMAINING_DOC_AMT,AP_REMAINING_LOC_AMT,XACT_QTY,UOM_CODE,DB_CR_IND,ACCT_DOC_ID,ACCT_DOC_NUM,ACCT_DOC_ITEM,ACCT_DOC_SUB_ITEM,CLEARING_DOC_NUM,CLEARING_DOC_ITEM,SALES_ORDER_NUM,SALES_ORDER_ITEM,SALES_SCH_LINE,SALES_INVOICE_NUM,SALES_INVOICE_ITEM,PURCH_ORDER_NUM,PURCH_ORDER_ITEM,PURCH_INVOICE_NUM,PURCH_INVOICE_ITEM,CUST_PUR_ORD_NUM,CUST_PUR_ORD_ITEM,SPLR_ORDER_NUM,SPLR_ORDER_ITEM,REF_DOC_NUM,REF_DOC_ITEM,DOC_HEADER_TEXT,LINE_ITEM_TEXT,ALLOCATION_NUM,GL_BALANCE_ID,BALANCE_ID,FED_BALANCE_ID,DELETE_FLG,DOC_CURR_CODE,LOC_CURR_CODE,EXCHANGE_DT,CREATED_BY_ID,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:31 2013]
      WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:31 2013]
      WRITER_1_*_1> WRT_8114
      Row # [1] in bad file

      WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=225688 Targ Rowid=225688
      GL_ACCOUNT_ID (GL_ACCOUNT_ID:UniChar.240:): "2006"
      BUDGET_ORG_ID (BUDGET_ORG_ID:UniChar.80:): "BUDGET~"
      CUSTOMER_ID (CUSTOMER_ID:UniChar.80:): "(NULL)"
      CUSTOMER_FIN_PROFL_ID (CUSTOMER_FIN_PROFL_ID:UniChar.80:): "(NULL)"
      SUPPLIER_ID (SUPPLIER_ID:UniChar.80:): "4865"
      SPLR_ACCT_ID (SPLR_ACCT_ID:UniChar.80:): "1223"
      SALES_REP_ID (SALES_REP_ID:UniChar.80:): "(NULL)"
      SERVICE_REP_ID (SERVICE_REP_ID:UniChar.80:): "(NULL)"
      ACCT_REP_ID (ACCT_REP_ID:UniChar.80:): "(NULL)"
      PURCH_REP_ID (PURCH_REP_ID:UniChar.80:): "(NULL)"
      PRODUCT_ID (PRODUCT_ID:UniChar.80:): "(NULL)"
      SALES_PROD_ID (SALES_PROD_ID:UniChar.80:): "(NULL)"
      INVENTORY_PROD_ID (INVENTORY_PROD_ID:UniChar.80:): "(NULL)"
      SUPPLIER_PROD_ID1 (SUPPLIER_PROD_ID1:UniChar.80:): "(NULL)"
      COMPANY_LOC_ID (COMPANY_LOC_ID:UniChar.80:): "(NULL)"
      PLANT_LOC_ID (PLANT_LOC_ID:UniChar.80:): "(NULL)"
      OPERATING_UNIT_ORG_ID (OPERATING_UNIT_ORG_ID:UniChar.80:): "81"
      PAYABLES_ORG_ID (PAYABLES_ORG_ID:UniChar.80:): "81"
      LEDGER_ID (LEDGER_ID:UniChar.80:): "2021"
      COMPANY_ORG_ID (COMPANY_ORG_ID:UniChar.80:): "COMPANY~23273"
      BUSN_AREA_ORG_ID (BUSN_AREA_ORG_ID:UniChar.80:): "(NULL)"
      CTRL_AREA_ORG_ID (CTRL_AREA_ORG_ID:UniChar.80:): "(NULL)"
      FIN_AREA_ORG_ID (FIN_AREA_ORG_ID:UniChar.80:): "(NULL)"
      SALES_ORG_ID (SALES_ORG_ID:UniChar.80:): "81"
      PURCHASE_ORG_ID (PURCHASE_ORG_ID:UniChar.80:): "81"
      ISSUE_ORG_ID (ISSUE_ORG_ID:UniChar.80:): "(NULL)"
      DOC_TYPE_ID (DOC_TYPE_ID:UniChar.80:): "ACCT_DOC~PAYABLES~DISTRIBUTION~INVDIST~PREPAY"
      CLRNG_DOC_TYPE_ID (CLRNG_DOC_TYPE_ID:UniChar.80:): "(NULL)"
      REF_DOC_TYPE_ID (REF_DOC_TYPE_ID:UniChar.80:): "(NULL)"
      POSTING_TYPE_ID (POSTING_TYPE_ID:UniChar.80:): "(NULL)"
      CLRNG_POST_TYPE_ID (CLRNG_POST_TYPE_ID:UniChar.80:): "(NULL)"
      COST_CENTER_ID (COST_CENTER_ID:UniChar.80:): "(NULL)"
      PROFIT_CENTER_ID (PROFIT_CENTER_ID:UniChar.80:): "(NULL)"
      DOC_STATUS_ID (DOC_STATUS_ID:UniChar.80:): "ACCT_DOC_STATUS~OPEN~UNPOSTED"
      BANK_ID (BANK_ID:UniChar.80:): "(NULL)"
      TAX_TYPE_ID (TAX_TYPE_ID:UniChar.80:): "(NULL)"
      PAY_TERMS_ID (PAY_TERMS_ID:UniChar.80:): "10002"
      PAY_METHOD_ID (PAY_METHOD_ID:UniChar.80:): "AP~CHECK"
      PROJECT_ID (PROJECT_ID:UniChar.80:): "(NULL)"
      TASK_ID (TASK_ID:UniChar.80:): "(NULL)"
      FINANCIAL_RESOURCE_ID (FINANCIAL_RESOURCE_ID:UniChar.80:): "EXPENDITURE_TYPE~"
      EXPENDITURE_ORG_ID (EXPENDITURE_ORG_ID:UniChar.80:): "(NULL)"
      SOURCE_ID (SOURCE_ID:UniChar.80:): "AP~MANUAL INVOICE ENTRY"
      TRANSACTION_DT (TRANSACTION_DT:Date:): "06/11/2008 10:26:23.000000000"
      POSTED_ON_DT (POSTED_ON_DT:Date:): "06/01/2008 00:00:00.000000000"
      CONVERSION_DT (CONVERSION_DT:Date:): "(NULL)"
      ORDERED_ON_DT (ORDERED_ON_DT:Date:): "(NULL)"
      INVOICED_ON_DT (INVOICED_ON_DT:Date:): "01/30/2008 00:00:00.000000000"
      PURCH_ORDER_DT (PURCH_ORDER_DT:Date:): "(NULL)"
      SPLR_ORDER_DT (SPLR_ORDER_DT:Date:): "(NULL)"
      INVOICE_RECEIPT_DT (INVOICE_RECEIPT_DT:Date:): "01/30/2008 18:26:21.000000000"
      CLEARED_ON_DT (CLEARED_ON_DT:Date:): "(NULL)"
      CLEARING_DOC_DT (CLEARING_DOC_DT:Date:): "(NULL)"
      BASELINE_DT (BASELINE_DT:Date:): "01/30/2008 00:00:00.000000000"
      PLANNING_DT (PLANNING_DT:Date:): "(NULL)"
      PAYMENT_DUE_DT (PAYMENT_DUE_DT:Date:): "(NULL)"
      AP_DOC_AMT (AP_DOC_AMT:Double:): "-2.29942034647008e+037"
      AP_LOC_AMT (AP_LOC_AMT:Double:): "-2.29942034647008e+037"
      AP_REMAINING_DOC_AMT (AP_REMAINING_DOC_AMT:Double:): "0.00000000000000"
      AP_REMAINING_LOC_AMT (AP_REMAINING_LOC_AMT:Double:): "0.00000000000000"
      XACT_QTY (XACT_QTY:Double:): "(NULL)"
      UOM_CODE (UOM_CODE:UniChar.50:): "(NULL)"
      DB_CR_IND (DB_CR_IND:UniChar.30:): "CREDIT"
      ACCT_DOC_ID (ACCT_DOC_ID:UniChar.80:): "AP_PREPAY~EXPENSE~25371"
      ACCT_DOC_NUM (ACCT_DOC_NUM:UniChar.80:): "(NULL)"
      ACCT_DOC_ITEM (ACCT_DOC_ITEM:Double:): "(NULL)"
      ACCT_DOC_SUB_ITEM (ACCT_DOC_SUB_ITEM:Double:): "(NULL)"
      CLEARING_DOC_NUM (CLEARING_DOC_NUM:UniChar.80:): "(NULL)"
      CLEARING_DOC_ITEM (CLEARING_DOC_ITEM:Double:): "(NULL)"
      SALES_ORDER_NUM (SALES_ORDER_NUM:UniChar.80:): "(NULL)"
      SALES_ORDER_ITEM (SALES_ORDER_ITEM:Double:): "(NULL)"
      SALES_SCH_LINE (SALES_SCH_LINE:Double:): "(NULL)"
      SALES_INVOICE_NUM (SALES_INVOICE_NUM:UniChar.80:): "(NULL)"
      SALES_INVOICE_ITEM (SALES_INVOICE_ITEM:Double:): "(NULL)"
      PURCH_ORDER_NUM (PURCH_ORDER_NUM:UniChar.80:): "(NULL)"
      PURCH_ORDER_ITEM (PURCH_ORDER_ITEM:Double:): "(NULL)"
      PURCH_INVOICE_NUM (PURCH_INVOICE_NUM:UniChar.80:): "303716A"
      PURCH_INVOICE_ITEM (PURCH_INVOICE_ITEM:Double:): "1.000000000000000"
      CUST_PUR_ORD_NUM (CUST_PUR_ORD_NUM:UniChar.80:): "(NULL)"
      CUST_PUR_ORD_ITEM (CUST_PUR_ORD_ITEM:Double:): "(NULL)"
      SPLR_ORDER_NUM (SPLR_ORDER_NUM:UniChar.80:): "(NULL)"
      SPLR_ORDER_ITEM (SPLR_ORDER_ITEM:Double:): "(NULL)"
      REF_DOC_NUM (REF_DOC_NUM:UniChar.80:): "12649"
      REF_DOC_ITEM (REF_DOC_ITEM:Double:): "(NULL)"
      DOC_HEADER_TEXT (DOC_HEADER_TEXT:UniChar.255:): "(NULL)"
      LINE_ITEM_TEXT (LINE_ITEM_TEXT:UniChar.255:): "PrePayment for outstanding invoices"
      ALLOCATION_NUM (ALLOCATION_NUM:UniChar.80:): "(NULL)"
      GL_BALANCE_ID (GL_BALANCE_ID:UniChar.320:): "2021~2006~81"
      BALANCE_ID (BALANCE_ID:UniChar.320:): "2021~2006~1223~81~4865"
      FED_BALANCE_ID (FED_BALANCE_ID:UniChar.320:): "2006~COMPANY~23273~BUDGET~~2021~~"
      DELETE_FLG (DELETE_FLG:UniChar.1:): "N"
      DOC_CURR_CODE (DOC_CURR_CODE:UniChar.30:): "USD"
      LOC_CURR_CODE (LOC_CURR_CODE:UniChar.30:): "USD"
      EXCHANGE_DT (EXCHANGE_DT:Date:): "06/01/2008 00:00:00.000000000"
      CREATED_BY_ID (CREATED_BY_ID:UniChar.80:): "1280"
      CHANGED_BY_ID (CHANGED_BY_ID:UniChar.80:): "1280"
      CREATED_ON_DT (CREATED_ON_DT:Date:): "01/30/2008 18:31:19.000000000"
      CHANGED_ON_DT (CHANGED_ON_DT:Date:): "06/11/2008 10:26:23.000000000"
      AUX1_CHANGED_ON_DT (AUX1_CHANGED_ON_DT:Date:): "11/06/2008 10:41:34.000000000"
      AUX2_CHANGED_ON_DT (AUX2_CHANGED_ON_DT:Date:): "(NULL)"
      AUX3_CHANGED_ON_DT (AUX3_CHANGED_ON_DT:Date:): "(NULL)"
      AUX4_CHANGED_ON_DT (AUX4_CHANGED_ON_DT:Date:): "(NULL)"
      DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1000.000000000000"
      INTEGRATION_ID (INTEGRATION_ID:UniChar.80:): "INVDIST~PREPAY~12649~3~1~31220~25371"
      TENANT_ID (TENANT_ID:UniChar.80:): "DEFAULT"
      X_CUSTOM (X_CUSTOM:UniChar.10:): "(NULL)"
      )

      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:31 2013]
      WRITER_1_*_1> WRT_8164 Error loading into target [W_AP_XACT_FS] : Bad rows exceeded Session Threshold [1]
      WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      WRITER_1_*_1> CMN_1022 Database driver error...
      CMN_1022 [

      ORA-24795: Illegal ROLLBACK attempt made


      Database driver error...

      Function Name : Commit

      Database driver error...

      Function Name : Rollback]

      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      WRITER_1_*_1> WRT_8183 Rollback failed for the target [W_AP_XACT_FS]
      WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      WRITER_1_*_1> WRT_8080 Writer run terminated. [Error loading data and error threshold reached]
      WRITER_1_*_1> WRT_8168 End loading table [W_AP_XACT_FS] at: Sat May 11 18:17:31 2013
      WRITER_1_*_1> WRT_8035 Load complete time: Sat May 11 18:17:31 2013

      LOAD SUMMARY
      ============

      WRT_8036 Target: W_AP_XACT_FS (Instance Name: [W_AP_XACT_FS])
      WRT_8038 Inserted rows - Requested: 225688 Applied: 225687 Rejected: 1 Affected: 225687


      WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [W_AP_XACT_FS], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_APTransactionFact_Distributions.EXP_SAI_AP_XACTS], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_APTransactionFact_Distributions.EXP_SAI_AP_XACTS], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.Union], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.Union], and the session is terminating.
      TRANSF_1_1_1> DBG_21082 mplt_BC_ORA_APTransaction_Fact_Distributions.Union (Input Group 2): : Current Input data:
      TRANSF_1_1_1> CMN_1053 Input row from mplt_BC_ORA_APTransaction_Fact_Distributions.EXPTRANS: Rowdata: ( RowType=0(insert) Src Rowid=113144 Targ Rowid=113144
      INVOICE_ID (INVOICE_ID1:Double:): "12651.00000000000"
      INVOICE_NUM (INVOICE_NUM1:UniChar.50:): "303717A"
      SET_OF_BOOKS_ID (SET_OF_BOOKS_ID1:Double:): "2021.000000000000"
      INVOICE_CURRENCY_CODE (INVOICE_CURRENCY_CODE1:UniChar.15:): "USD"
      VENDOR_ID (VENDOR_ID1:Double:): "4865.000000000000"
      VENDOR_SITE_ID (VENDOR_SITE_ID1:Double:): "1223.000000000000"
      INVOICE_DATE (INVOICE_DATE1:Date:): "12/05/2007 00:00:00.000000000"
      INVOICE_TYPE_LOOKUP_CODE (INVOICE_TYPE_LOOKUP_CODE1:UniChar.25:): "STANDARD"
      TERMS_ID (TERMS_ID1:Double:): "10002.00000000000"
      PAYMENT_METHOD_CODE (PAYMENT_METHOD_CODE2:UniChar.25:): "CHECK"
      ACCTS_PAY_CODE_COMBINATION_ID (ACCTS_PAY_CODE_COMBINATION_ID1:Double:): "2005.000000000000"
      INVOICE_RECEIVED_DATE (INVOICE_RECEIVED_DATE1:Date:): "(NULL)"
      INVOICE_CREATION_DATE (INVOICE_CREATION_DATE1:Date:): "01/30/2008 18:58:20.000000000"
      EXCHANGE_RATE (EXCHANGE_RATE1:Double:): "(NULL)"
      ORG_ID (ORG_ID1:Double:): "81.00000000000000"
      LEGAL_ENTITY_ID (LEGAL_ENTITY_ID1:Double:): "23273.00000000000"
      ACCOUNTING_DATE (ACCOUNTING_DATE1:Date:): "02/01/2008 00:00:00.000000000"
      DISTRIBUTION_LINE_NUMBER (DISTRIBUTION_LINE_NUMBER1:Double:): "1.000000000000000"
      DIST_CODE_COMBINATION_ID (DIST_CODE_COMBINATION_ID1:Double:): "2006.000000000000"
      LAST_UPDATED_BY (LAST_UPDATED_BY1:Double:): "1090.000000000000"
      LAST_UPDATE_DATE (LAST_UPDATE_DATE1:Date:): "02/29/2008 11:49:19.000000000"
      LINE_TYPE_LOOKUP_CODE (LINE_TYPE_LOOKUP_CODE1:UniChar.25:): "PREPAY"
      AMOUNT (AMOUNT1:Double:): "-1969.170000000000"
      BASE_AMOUNT (BASE_AMOUNT1:Double:): "-1969.170000000000"
      CREATED_BY (CREATED_BY1:Double:): "1280.000000000000"
      CREATION_DATE (CREATION_DATE1:Date:): "01/30/2008 19:00:06.000000000"
      DESCRIPTION (DESCRIPTION1:UniChar.240:): "PrePayment for outstanding invoices"
      INVOICE_DISTRIBUTION_ID (INVOICE_DISTRIBUTION_ID1:Double:): "31225.00000000000"
      INVOICE_LINE_NUMBER (INVOICE_LINE_NUMBER1:Double:): "3.000000000000000"
      SEGMENT1 (SEGMENT11:UniChar.20:): "(NULL)"
      CREATION_DATE1 (CREATION_DATE111:Date:): "(NULL)"
      AUX1_CHANGED_ON_DT (AUX1_CHANGED_ON_DT1:Date:): "11/06/2008 10:12:52.000000000"
      AUX2_CHANGED_ON_DT (AUX2_CHANGED_ON_DT1:Date:): "(NULL)"
      AUX3_CHANGED_ON_DT (AUX3_CHANGED_ON_DT1:Date:): "(NULL)"
      LINE_NUM (LINE_NUM1:Double:): "(NULL)"
      PROJECT_ID (PROJECT_ID1:Double:): "(NULL)"
      TASK_ID (TASK_ID1:Double:): "(NULL)"
      EXPENDITURE_TYPE (EXPENDITURE_TYPE1:UniChar.30:): "(NULL)"
      EXPENDITURE_ORGANIZATION_ID (EXPENDITURE_ORGANIZATION_ID1:Double:): "(NULL)"
      SOURCE (SOURCE1:UniChar.25:): "Manual Invoice Entry"
      EXPENSE_DISTRIBUTION_TYPE (DISTRIBUTION_TYPE1:UniChar.10:): "EXPENSE"
      PREPAY_APP_DIST_ID (PREPAY_APP_DIST_ID2:Double:): "11363.00000000000"
      )

      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> CMN_1086 mplt_BC_ORA_APTransaction_Fact_Distributions.Union: Number of errors exceeded threshold [1].
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.Union], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.EXPTRANS], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.EXPTRANS], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.SQ_AP_INVOICE_DISTRIBUTIONS_ALL_1], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.SQ_AP_INVOICE_DISTRIBUTIONS_ALL_1], and the session is terminating.
      TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat May 11 18:17:32 2013]
      TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_APTransaction_Fact_Distributions.SQ_AP_INVOICE_DISTRIBUTIONS_ALL_1], and the session is terminating.
      TRANSF_1_1_1> DBG_21511 TE: Fatal Transformation Error.

      Thanks
      Ashish
        • 1. Re: Dac fails when trying to load a Table in BI Apps 7964
          Veeresh Rayan
          Its bad data which is causing this mapping to fails as you have correctly identified.

          AP_DOC_AMT (AP_DOC_AMT:Double:): "-2.29942034647008e+037"
          AP_LOC_AMT (AP_LOC_AMT:Double:): "-2.29942034647008e+037"

          These columns seems to be having larger value then the target column size..Correct this in source system/Skip this in source system and try to re-run.

          Mark correct or helpful if it helps,

          Regards,
          Veeresh Rayan
          • 2. Re: Dac fails when trying to load a Table in BI Apps 7964
            Ashish Gupta
            I changed the datatype from Number(28,10) to just Number for the below 5 columns in the SDE and SIL mappings and now the error is not coming. ( i changed it in Datawarehouse tables as well)

            1) AP_DOC_AMT,
            2) AP_LOC_AMT,
            3) AP_REMAINING_DOC_AMT,
            4) AP_REMAINING_LOC_AMT,
            5) XACT_QTY

            but Is it a good pracitice to change the datatype in the out of the box Informatica mappings?
            If not what should i have done ( note : i dont want to change data in source EBS)

            Thanks
            Ashish
            • 3. Re: Dac fails when trying to load a Table in BI Apps 7964
              Veeresh Rayan
              Its not a good practice to change the datatype in the SDE and SIL mapping.

              How ever if you dont want to correct the EBS data then you dont have any other option changing the column size in warehouse.

              Priority wise EBS data (if there is junk data) needs to be corrected then in ETL.

              Regards,
              Veeresh Rayan
              • 4. Re: Dac fails when trying to load a Table in BI Apps 7964
                Ashish Gupta
                I have heard that we should create a custom_folder and then do the changes there .

                I am not sure of the method cause copying the mappings there and changing it there would require some changes to be done in DAC as well ( like building the execution plan again) of which i m not sure.

                Need some guidance on this Custom_folder stuff.

                Thanks
                Ashish
                • 5. Re: Dac fails when trying to load a Table in BI Apps 7964
                  Veeresh Rayan
                  Yes custom folders needs to be created and mapping needs to be copied and changed.

                  How ever in your instance you are just changing the size of the datatype ,so I dont see the necessity of creating the same.

                  When you create custom folders there is an effort involved.
                  Like
                  1)Create custom folders in Informatica repository.
                  2)Copy the required mappings.
                  3)Develop/customize mappings.
                  4)Create logical folders in DAC.
                  5)Assign the mappings to these folders.
                  5)Setup the connection parameters.
                  6)Needs Subject area to be assebmled
                  7)EP to be built again.
                  8)Also generate parameter to your custom folder as well.

                  I would suggest only there is any customziation(any new table addition,SQL change,adding more columns,changing the inbuilt logic etc) go with custom folder approach.

                  Mark correct or helpful if it helps,

                  Regards,
                  Veeresh Rayan

                  Edited by: Veeresh Rayan on May 12, 2013 12:04 PM
                  • 6. Re: Dac fails when trying to load a Table in BI Apps 7964
                    635583
                    Hi, but if you fix it in the OOTB folder, you need to be careful during next upgrade as you might loose your changes. Hence I suggest to have it changed in the custom folder.

                    Thanks,
                    Prabu.V