Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error While ETL

Naeem Akhtar KhanFeb 27 2013 — edited Jul 31 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2013

Added on Feb 27 2013

#business-intelligence-applications

5 comments

1,725 views

Analytics Software

Error While ETL

Comments

Post Details