This discussion is archived
5 Replies Latest reply: Jul 31, 2013 4:46 PM by user955280 RSS

Error While ETL

naeem akhtar Newbie
Currently Being Moderated
I got following error while running ETL for Oracle Financials.

Can someone help in this problem?

I am using OBIA 7.9.6.4 with EBS R12.1.3 Vision.

Following is the session log.
2013-02-27 15:28:21 : DEBUG : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : DBG_21082 : Upd_Strategy_W_ORA_PRODUCT_DS_TMP_Ins_Upd (Input Group 0): : Current Input data:
2013-02-27 15:28:21 : INFO : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : CMN_1053 : Input row from EXPTRANS: Rowdata: ( RowType=0(insert but dropped due to abort) Src Rowid=2 Targ Rowid=2
DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1000.000000000000"
INVENTORY_ITEM_ID (INVENTORY_ITEM_ID:Double:): "936.0000000000000"
ORGANIZATION_ID (ORGANIZATION_ID:Double:): "204.0000000000000"
PROD_NAME (PROD_NAME:Char.100:): "Formed Sheet Metal Shell Bottom"
PRODUCT_TYPE_CODE (PRODUCT_TYPE_CODE:Char.50:): "P"
PRODUCT_TYPE_DESC (PRODUCT_TYPE_DESC:Char.255:): "Purchased item"
PR_PROD_LN (PR_PROD_LN:Char.100:): "Unspecified"
PR_PROD_LN_DESC (PR_PROD_LN_DESC:Char.255:): "(NULL)"
CONFIG_CAT_CODE (CONFIG_CAT_CODE:Char.50:): "(NULL)"
CONFIG_CAT_DESC (CONFIG_CAT_DESC:Char.80:): "(NULL)"
PRICE_TYPE_CD (PRICE_TYPE_CD:Char.30:): "(NULL)"
BASIC_PRODUCT (BASIC_PRODUCT:Char.30:): "(NULL)"
PR_EQUIV_PROD_NAME (PR_EQUIV_PROD_NAME:Char.100:): "(NULL)"
CONFIG_PROD_IND (CONFIG_PROD_IND:Char.1:): "(NULL)"
CONTAINER_CODE (CONTAINER_CODE:Char.50:): "(NULL)"
CONTAINER_DESC (CONTAINER_DESC:Char.80:): "(NULL)"
INDUSTRY_CODE (INDUSTRY_CODE:Char.50:): "(NULL)"
INDUSTRY_NAME (INDUSTRY_NAME:Char.80:): "(NULL)"
INDUSTRY_STD_DESC (INDUSTRY_STD_DESC:Char.255:): "(NULL)"
INTRODUCTION_DT (INTRODUCTION_DT:Date:): "(NULL)"
LOW_LEVEL_CODE (LOW_LEVEL_CODE:Char.50:): "(NULL)"
MAKE_BUY_IND (MAKE_BUY_IND:Char.1:): "B"
PROD_LIFE_CYCL_CD (PROD_LIFE_CYCL_CD:Char.30:): "(NULL)"
PROD_REPRCH_PERIOD (PROD_REPRCH_PERIOD:Double:): "(NULL)"
PROD_STRUCTURE_TYPE (PROD_STRUCTURE_TYPE:Char.30:): "(NULL)"
PROD_GRP_CODE (PROD_GRP_CODE:Char.50:): "(NULL)"
PROD_GRP_DESC (PROD_GRP_DESC:Char.80:): "(NULL)"
STORAGE_TYPE_CODE (STORAGE_TYPE_CODE:Char.50:): "(NULL)"
STORAGE_TYPE_DESC (STORAGE_TYPE_DESC:Char.80:): "(NULL)"
BATCH_IND (BATCH_IND:Char.1:): "(NULL)"
BRAND (BRAND:Char.30:): "(NULL)"
COLOR (COLOR:Char.30:): "(NULL)"
CUSTOM_PROD_FLG (CUSTOM_PROD_FLG:Char.1:): "(NULL)"
PACKAGED_PROD_FLG (PACKAGED_PROD_FLG:Char.1:): "(NULL)"
RTRN_DEFECTIVE_FLG (RTRN_DEFECTIVE_FLG:Char.1:): "Y"
SALES_PROD_FLG (SALES_PROD_FLG:Char.1:): "(NULL)"
SALES_SRVC_FLG (SALES_SRVC_FLG:Char.1:): "N"
SERIALIZED_FLG (SERIALIZED_FLG:Char.1:): "N"
NRC_FLG (NRC_FLG:Char.1:): "Y"
FRU_FLG (FRU_FLG:Char.1:): "(NULL)"
ITEM_SIZE (ITEM_SIZE:Double:): "(NULL)"
LEAD_TIME (LEAD_TIME:Char.30:): "(NULL)"
MTBF (MTBF:Double:): "(NULL)"
MTTR (MTTR:Double:): "(NULL)"
PART_NUM (PART_NUM:Char.50:): "CM23597"
VENDOR_LOC (VENDOR_LOC:Char.50:): "(NULL)"
VENDOR_NAME (VENDOR_NAME:Char.100:): "Unspecified"
VENDR_PART_NUM (VENDR_PART_NUM:Char.50:): "(NULL)"
DISCONTINUATION_DT (DISCONTINUATION_DT:Date:): "(NULL)"
HAZARD_MTL_DESC (HAZARD_MTL_DESC:Char.80:): "(NULL)"
HAZARD_MTL_CODE (HAZARD_MTL_CODE:Char.50:): "(NULL)"
SALES_UOM_CODE (SALES_UOM_CODE:Char.50:): "Ea"
SALES_UOM_DESC (SALES_UOM_DESC:Char.80:): "Each"
SERIALIZED_COUNT (SERIALIZED_COUNT:Double:): "(NULL)"
SHELF_LIFE (SHELF_LIFE:Double:): "1.000000000000000"
SHIP_MTHD_GRP_CODE (SHIP_MTHD_GRP_CODE:Char.50:): "(NULL)"
SHIP_MTHD_GRP_DESC (SHIP_MTHD_GRP_DESC:Char.80:): "(NULL)"
SHIP_MTL_GRP_CODE (SHIP_MTL_GRP_CODE:Char.50:): "(NULL)"
SHIP_MTL_GRP_DESC (SHIP_MTL_GRP_DESC:Char.80:): "(NULL)"
SHIP_TYPE_CODE (SHIP_TYPE_CODE:Char.50:): "(NULL)"
SHIP_TYPE_DESC (SHIP_TYPE_DESC:Char.80:): "(NULL)"
SOURCE_OF_SUPPLY (SOURCE_OF_SUPPLY:Char.30:): "(NULL)"
SPRT_WITHDRAWL_DT (SPRT_WITHDRAWL_DT:Date:): "(NULL)"
UOM (UOM:Char.30:): "(NULL)"
UOM_I (UOM_I:Char.50:): "(NULL)"
BASE_UOM_CODE (BASE_UOM_CODE:Char.50:): "Ea"
BASE_UOM_DESC (BASE_UOM_DESC:Char.80:): "Each"
UNIT_GROSS_WEIGHT (UNIT_GROSS_WEIGHT:Double:): "0.1000000000000000"
UNIT_NET_WEIGHT (UNIT_NET_WEIGHT:Double:): "0.1000000000000000"
UNIT_VOLUME (UNIT_VOLUME:Double:): "0.1000000000000000"
UNIV_PROD_CODE (UNIV_PROD_CODE:Char.50:): "(NULL)"
UNIV_PROD_DESC (UNIV_PROD_DESC:Char.80:): "(NULL)"
UOV_CODE (UOV_CODE:Char.50:): "FT3"
UOV_DESC (UOV_DESC:Char.80:): "Cubic foot"
UOW_CODE (UOW_CODE:Char.50:): "Lbs"
UOW_DESC (UOW_DESC:Char.80:): "Pounds"
APPLICATION_FLG (APPLICATION_FLG:Char.1:): "(NULL)"
BODY_STYLE_CD (BODY_STYLE_CD:Char.30:): "(NULL)"
BODY_STYLE_CD_I (BODY_STYLE_CD_I:Char.50:): "(NULL)"
CASE_PACK (CASE_PACK:Double:): "(NULL)"
CTLG_CAT_ID (CTLG_CAT_ID:Char.30:): "(NULL)"
DEALER_INV_PRICE (DEALER_INV_PRICE:Double:): "(NULL)"
DETAIL_TYPE (DETAIL_TYPE:Char.30:): "(NULL)"
DOORS_TYPE_CD (DOORS_TYPE_CD:Char.30:): "(NULL)"
DRIVE_TRAIN_CD (DRIVE_TRAIN_CD:Char.30:): "(NULL)"
ENGINE_TYPE_CD (ENGINE_TYPE_CD:Char.30:): "(NULL)"
FUEL_TYPE_CD (FUEL_TYPE_CD:Char.30:): "(NULL)"
GROSS_MRGN (GROSS_MRGN:Double:): "(NULL)"
INVENTORY_FLG (INVENTORY_FLG:Char.1:): "Y"
MAKE_CD (MAKE_CD:Char.30:): "(NULL)"
MODEL_CD (MODEL_CD:Char.30:): "(NULL)"
MODEL_YR (MODEL_YR:Double:): "(NULL)"
MSRP (MSRP:Double:): "(NULL)"
ORDERABLE_FLG (ORDERABLE_FLG:Char.1:): "(NULL)"
PROD_NDC_ID (PROD_NDC_ID:Char.30:): "(NULL)"
PROD_TYPE (PROD_TYPE:Char.30:): "(NULL)"
PROFIT_RANK (PROFIT_RANK:Char.30:): "(NULL)"
REFERRAL_FLG (REFERRAL_FLG:Char.1:): "(NULL)"
RX_AVG_PRICE (RX_AVG_PRICE:Double:): "(NULL)"
SERVICE_TYPE (SERVICE_TYPE:Char.30:): "(NULL)"
STATUS (STATUS:Char.30:): "(NULL)"
R_TYPE (R_TYPE:Char.30:): "(NULL)"
SUB_TYPE (SUB_TYPE:Char.30:): "(NULL)"
SUB_TYPE_CD (SUB_TYPE_CD:Char.30:): "(NULL)"
TGT_CUST_TYPE (TGT_CUST_TYPE:Char.30:): "(NULL)"
TRANSMISSION_CD (TRANSMISSION_CD:Char.30:): "(NULL)"
TRIM_CD (TRIM_CD:Char.30:): "(NULL)"
UNIT_CONV_FACTOR (UNIT_CONV_FACTOR:Double:): "(NULL)"
VER_DT (VER_DT:Date:): "(NULL)"
PAR_INTEGRATION_ID (PAR_INTEGRATION_ID:Char.30:): "(NULL)"
CREATED_ON_DT (CREATED_ON_DT:Date:): "12/09/1997 15:59:47.000000000"
CHANGED_ON_DT_OUT (CHANGED_ON_DT:Date:): "02/27/2013 15:28:19.000000000"
AUX1_CHANGED_ON_DT (AUX1_CHANGED_ON_DT:Date:): "(NULL)"
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)"
SRC_EFF_FROM_DT (SRC_EFF_FROM_DT:Date:): "01/01/1899 00:00:00.000000000"
SRC_EFF_TO_DT (SRC_EFF_TO_DT:Date:): "(NULL)"
DELETE_FLG (DELETE_FLG:Char.1:): "N"
INTEGRATION_ID (INTEGRATION_ID:Char.80:): "936"
TENANT_ID (TENANT_ID:Char.80:): "DEFAULT"
X_CUSTOM (X_CUSTOM:Char.10:): "(NULL)"
CREATED_BY_ID (CREATED_BY_ID:Char.80:): "(NULL)"
CHANGED_BY_ID (CHANGED_BY_ID:Char.80:): "(NULL)"
UPDATE_FLG (UPDATE_FLG:Char.10:): "U"
)

2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : CMN_1086 : Upd_Strategy_W_ORA_PRODUCT_DS_TMP_Ins_Upd: Number of errors exceeded threshold [1].
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [EXPTRANS], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [EXPTRANS], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.FILTRANS], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.FILTRANS], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.EXP_W_ORA_PRODCUT_DS_TMP_INS_REJ], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.EXP_W_ORA_PRODCUT_DS_TMP_INS_REJ], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.Lkp_W_ORA_PRODUCT_DS_TMP], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.Lkp_W_ORA_PRODUCT_DS_TMP], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE], and the session is terminating.
2013-02-27 15:28:21 : ERROR : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TM_6085 : A fatal error occurred at transformation [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE], and the session is terminating.
2013-02-27 15:28:21 : DEBUG : (4696 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : DBG_21511 : TE: Fatal Transformation Error.
2013-02-27 15:28:21 : INFO : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8167 : Start loading table [W_ORA_PRODUCT_DS_TMP] at: Wed Feb 27 15:28:21 2013
2013-02-27 15:28:21 : INFO : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8333 : Rolling back all the targets due to fatal session error.
2013-02-27 15:28:21 : INFO : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8325 : Final rollback executed for the target [W_ORA_PRODUCT_DS_TMP] at end of load
2013-02-27 15:28:21 : ERROR : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8170 : Writer run terminated: Abort Session request received from the DTM
2013-02-27 15:28:21 : INFO : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8168 : End loading table [W_ORA_PRODUCT_DS_TMP] at: Wed Feb 27 15:28:21 2013
2013-02-27 15:28:21 : INFO : (4696 | WRITER_1_*_1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8035 : Load complete time: Wed Feb 27 15:28:21 2013

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

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



2013-02-27 15:28:21 : INFO : (4696 | WRITER_1__1) : (IS | BIA_IS) : node01_BIAPPS : WRT_8043 : ****END LOAD SESSION*****
2013-02-27 15:28:21 : INFO : (4696 | MANAGER) : (IS | BIA_IS) : node01_BIAPPS : PETL_24031 :
***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
Thread [READER_1_1_1] created for [the read stage] of partition point [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE] has completed.
     Total Run Time = [1.109375] secs
     Total Idle Time = [0.500000] secs
     Busy Percentage = [54.929577]
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE] has completed.
     Total Run Time = [0.531250] secs
     Total Idle Time = [0.468750] secs
     Busy Percentage = [11.764706]
     Transformation-specific statistics for this thread were not accurate enough to report.
Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_ORA_PRODUCT_DS_TMP] has completed. The total run time was insufficient for any meaningful statistics.

2013-02-27 15:28:21 : INFO : (4696 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : CMN_1793 : The index cache size that would hold [5170] rows in the lookup table for [mplt_BC_ORA_ProductCategories_Resolve.Lkp_W_ORA_PRODUCT_DS_TMP], in memory, is [186000] bytes
2013-02-27 15:28:21 : INFO : (4696 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : CMN_1792 : The data cache size that would hold [5170] rows in the lookup table for [mplt_BC_ORA_ProductCategories_Resolve.Lkp_W_ORA_PRODUCT_DS_TMP], in memory, is [180224] bytes
2013-02-27 15:28:21 : INFO : (4696 | MANAGER) : (IS | BIA_IS) : node01_BIAPPS : PETL_24005 : PETL_24005 Starting post-session tasks. : (Wed Feb 27 15:28:21 2013)
2013-02-27 15:28:22 : INFO : (4696 | MANAGER) : (IS | BIA_IS) : node01_BIAPPS : PETL_24029 : PETL_24029 Post-session task completed successfully. : (Wed Feb 27 15:28:22 2013)
2013-02-27 15:28:22 : INFO : (4696 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7216 : Deleting cache files [PMLKUP22595_262151_0_588W64] for transformation [mplt_BC_ORA_ProductCategories_Resolve.Lkp_W_ORA_PRODUCT_DS_TMP].
2013-02-27 15:28:22 : INFO : (4696 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7216 : Deleting cache files [PMLKUP22595_3_0_588W64] for transformation [Lkp_W_USER_D_get_id].
2013-02-27 15:28:22 : INFO : (4696 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TM_6018 : The session completed with [2] row transformation errors.
2013-02-27 15:28:22 : INFO : (4696 | MANAGER) : (IS | BIA_IS) : node01_BIAPPS : PETL_24002 : Parallel Pipeline Engine finished.
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : PETL_24013 : Session run completed with failure.
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : TM_6022 :

SESSION LOAD SUMMARY
================================================

2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : TM_6252 : Source Load Summary.
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : CMN_1740 : Table: [SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE] (Instance Name: [mplt_BC_ORA_ProductCategories_Resolve.SQ_W_ORA_PRODUCT_CATEGORIES_RESOLVE])
     Output Rows [252], Affected Rows [252], Applied Rows [252], Rejected Rows [0]
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : TM_6253 : Target Load Summary.
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : CMN_1740 : Table: [W_ORA_PRODUCT_DS_TMP] (Instance Name: [W_ORA_PRODUCT_DS_TMP])
     Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : TM_6023 :
===================================================

2013-02-27 15:28:22 : INFO : (4696 | DIRECTOR) : (IS | BIA_IS) : node01_BIAPPS : TM_6020 : Session [SDE_ORA_ProductCategories_Resolve] completed at [Wed Feb 27 15:28:22 2013].

Regards
Naeem Akhtar

Legend

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