OBIA 796 Informatica mapping, SDE_PSFT_PROJECTCOSTLINEFACT, fails with ORA-26002 (Doc ID 987714.1)

Last updated on JANUARY 31, 2017

Applies to:

Siebel CRM Analytics - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Symptoms

In OBIA 7.9.6, Informatica mapping  SDE_PSFT_PROJECTCOSTLINEFACT, fails with following error during ETL:

WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-26002: Table BAW.W_PROJ_COST_LINE_FS has index defined upon it.

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_PROJ_COST_LINE_FS(PROJECT_ID,TASK_ID,FINANCIAL_RESOURCE_ID,GL_ACCOUNTING_DT,PROJ_ACCOUNTING_DT,EXPENDITURE_DT,JOB_ID,PROJ_ROLE_ID,TRANSFER_STATUS_ID,RESOURCE_CLASS_ID,RESOURCE_ORGANIZATION_ID,EXPENDITURE_ORGANIZATION_ID,EXPENDITURE_OPER_UNIT_ID,INCURRED_BY_ORGANIZATION_ID,COST_GL_ACCOUNT_ID,INVENTORY_ITEM_ID,PRODUCT_ID,INCURRED_BY_EMP_ID,VENDOR_ID,EXPENDITURE_ITEM_ID,LINE_NUM,BILLABLE_FLG,CAPITALIZABLE_FLG,UOM,QUANTITY,DOC_RAW_COST,DOC_BURDENED_COST,LOC_RAW_COST,LOC_BURDENED_COST,PROJ_RAW_COST,PROJ_BURDENED_COST,DOC_CURR_CODE,LOC_CURR_CODE,PROJ_CURR_CODE,LOC_EXCH_RATE_TYPE,LOC_EXCH_RATE_DATE,LOC_EXCHANGE_RATE,PROJ_EXCH_RATE_TYPE,PROJ_EXCH_RATE_DATE,PROJ_EXCHANGE_RATE,TRANSACTION_SOURCE,BURDEN_COST_RATE,RAW_COST_RATE,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_PROJ_COST_LINE_FS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Dec 15 13:35:31 2009]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_PROJ_COST_LINE_FS]]
WRITER_1_*_1> WRT_8168 End loading table [W_PROJ_COST_LINE_FS] at: Tue Dec 15 13:35:31 2009
WRITER_1_*_1> WRT_8035 Load complete time: Tue Dec 15 13:35:31 2009

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

WRT_8036 Target: W_PROJ_COST_LINE_FS (Instance Name: [W_PROJ_COST_LINE_FS])
WRT_8044 No data loaded for this target

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms