This discussion is archived
4 Replies Latest reply: Jan 29, 2013 12:27 PM by 966242 RSS

W_AP_XACT_FS INSERTS FAILING for mplt_SA_ORA_APTransaction_Fact_Payment

966242 Newbie
Currently Being Moderated
Hi All - I am experiencing an error repeatedly even after changing the precision and Date data type to TimeStamp - Can you guys look into it :)

LKPDP_1:TRANSF_1_1> DBG_21294 Lookup cache creation completed : (Tue Jan 29 12:09:32 2013)
LKPDP_1:TRANSF_1_1> CMN_1671 Created new cache files PMLKUP1951_262148_0_5702W32.[dat/idx] in directory C:\Informatica\9.0.1\server\infa_shared\Cache for Lookup [mplt_SA_ORA_APTransaction_Fact_Payment.LKP_LOC_CURRENCY].
LKPDP_1:TRANSF_1_1> DBG_21641 mplt_SA_ORA_APTransaction_Fact_Payment.LKP_LOC_CURRENCY: Index cache size = [1392640], Data cache size = [2097152]
LKPDP_1:TRANSF_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_SA_ORA_APTransaction_Fact_Payment.LKP_LOC_CURRENCY{{DSQ}}]. Total errors [0]
WRITER_1_*_1> WRT_8167 Start loading table [W_AP_XACT_FS] at: Tue Jan 29 12:09:31 2013
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Jan 29 12:09:32 2013]
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: [Tue Jan 29 12:09:32 2013]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Jan 29 12:09:32 2013]
WRITER_1_*_1> WRT_8114
Row # [1] in bad file

WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=1 Targ Rowid=1
GL_ACCOUNT_ID (GL_ACCOUNT_ID:UniChar.240:): "2005"
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:): "1106"
SPLR_ACCT_ID (SPLR_ACCT_ID:UniChar.80:): "1163"
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~APPLICATION~STANDARD"
CLRNG_DOC_TYPE_ID (CLRNG_DOC_TYPE_ID:UniChar.80:): "ACCT_DOC~PAYABLES~PAYMENT~WIRE"
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~CLEARED~UNPOSTED"
BANK_ID (BANK_ID:UniChar.80:): "I~10002"
TAX_TYPE_ID (TAX_TYPE_ID:UniChar.80:): "(NULL)"
PAY_TERMS_ID (PAY_TERMS_ID:UniChar.80:): "10024"
PAY_METHOD_ID (PAY_METHOD_ID:UniChar.80:): "AP~WIRE"
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:): "(NULL)"
TRANSACTION_DT (TRANSACTION_DT:Date:): "01/04/2008 17:55:56.000000000"
POSTED_ON_DT (POSTED_ON_DT:Date:): "01/04/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/03/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/03/2008 15:03:41.000000000"
CLEARED_ON_DT (CLEARED_ON_DT:Date:): "01/04/2008 00:00:00.000000000"
CLEARING_DOC_DT (CLEARING_DOC_DT:Date:): "01/04/2008 00:00:00.000000000"
BASELINE_DT (BASELINE_DT:Date:): "(NULL)"
PLANNING_DT (PLANNING_DT:Date:): "01/04/2008 00:00:00.000000000"
PAYMENT_DUE_DT (PAYMENT_DUE_DT:Date:): "03/03/2008 00:00:00.000000000"
AP_DOC_AMT (AP_DOC_AMT:Double:): "5534.900000000001"
AP_LOC_AMT (AP_LOC_AMT:Double:): "5534.900000000001"
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:): "DEBIT"
ACCT_DOC_ID (ACCT_DOC_ID:UniChar.80:): "AP_PMT_DIST~LIABILITY~12062"
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:): "9000018"
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:): "HE010408"
PURCH_INVOICE_ITEM (PURCH_INVOICE_ITEM:Double:): "(NULL)"
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:): "10074~1"
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:): "(NULL)"
ALLOCATION_NUM (ALLOCATION_NUM:UniChar.80:): "(NULL)"
GL_BALANCE_ID (GL_BALANCE_ID:UniChar.320:): "2021~2005~81"
BALANCE_ID (BALANCE_ID:UniChar.320:): "2021~2005~1163~81~1106"
FED_BALANCE_ID (FED_BALANCE_ID:UniChar.320:): "2005~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:): "01/04/2008 00:00:00.000000000"
CREATED_BY_ID (CREATED_BY_ID:UniChar.80:): "1261"
CHANGED_BY_ID (CHANGED_BY_ID:UniChar.80:): "1261"
CREATED_ON_DT (CREATED_ON_DT:Date:): "01/04/2008 17:55:56.000000000"
CHANGED_ON_DT (CHANGED_ON_DT:Date:): "01/04/2008 17:55:56.000000000"
AUX1_CHANGED_ON_DT (AUX1_CHANGED_ON_DT:Date:): "01/04/2008 19:00:28.000000000"
AUX2_CHANGED_ON_DT (AUX2_CHANGED_ON_DT:Date:): "01/04/2008 17:55:56.000000000"
AUX3_CHANGED_ON_DT (AUX3_CHANGED_ON_DT:Date:): "01/04/2008 17:55:56.000000000"
AUX4_CHANGED_ON_DT (AUX4_CHANGED_ON_DT:Date:): "01/04/2008 17:55:56.000000000"
DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1000.000000000000"
INTEGRATION_ID (INTEGRATION_ID:UniChar.80:): "PMT~10074~10067~10093~12062"
TENANT_ID (TENANT_ID:UniChar.80:): "DEFAULT"
X_CUSTOM (X_CUSTOM:UniChar.10:): "(NULL)"
)

WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Jan 29 12:09:32 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: [Tue Jan 29 12:09: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]

Legend

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