Created a new Item: 101872342

And created a Below Transaction Level item under it.

select * from item_master where item in('101872342','101872351');

select * from pos_mods where item in('101872342','101872351');

Note: There should be a record inserted with TRAN_TYPE-2 for the same item.

select * from ORPOS_PRELOAD_ITEM_TEMP where item in('101872342','101872351');

Note: No data in this table

Wiki : https://retailweb.us.oracle.com:8443/display/RGBUEnvironmentWiki/GRID+14.0.X+GDROLS06Created a new Item: 100046209And created a Below Transaction Level item under it.Select * from item_master where item in ('100046209','100046217');ITEMITEM_NUMBER_TYPEFORMAT_IDPREFIXITEM_PARENTITEM_GRANDPARENTPACK_INDITEM_LEVELTRAN_LEVELITEM_AGGREGATE_INDDIFF_1DIFF_1_AGGREGATE_INDDIFF_2DIFF_2_AGGREGATE_INDDIFF_3DIFF_3_AGGREGATE_INDDIFF_4DIFF_4_AGGREGATE_INDDEPTCLASSSUBCLASSSTATUSITEM_DESCITEM_DESC_SECONDARYSHORT_DESCDESC_UPPRIMARY_REF_ITEM_INDCOST_ZONE_GROUP_IDSTANDARD_UOMUOM_CONV_FACTORPACKAGE_SIZEPACKAGE_UOMMERCHANDISE_INDSTORE_ORD_MULTFORECAST_INDORIGINAL_RETAILMFG_REC_RETAILRETAIL_LABEL_TYPERETAIL_LABEL_VALUEHANDLING_TEMPHANDLING_SENSITIVITYCATCH_WEIGHT_INDWASTE_TYPEWASTE_PCTDEFAULT_WASTE_PCTCONST_DIMEN_INDSIMPLE_PACK_INDCONTAINS_INNER_INDSELLABLE_INDORDERABLE_INDPACK_TYPEORDER_AS_TYPECOMMENTSITEM_SERVICE_LEVELGIFT_WRAP_INDSHIP_ALONE_INDCREATE_DATETIMELAST_UPDATE_IDLAST_UPDATE_DATETIMECHECK_UDA_INDITEM_XFORM_INDINVENTORY_INDORDER_TYPESALE_TYPEDEPOSIT_ITEM_TYPECONTAINER_ITEMDEPOSIT_IN_PRICE_PER_UOMAIP_CASE_TYPEBANDED_ITEM_INDCATCH_WEIGHT_TYPEPERISHABLE_INDSOH_INQUIRY_AT_PACK_INDNOTIONAL_PACK_INDCATCH_WEIGHT_UOMPRODUCT_CLASSIFICATIONBRAND_NAMECREATE_IDCOMP_VAT100046209ITEMN1NNNNN1111ALine ItemLine ItemLINE ITEMN1000EAYEN120100NNYN15-MAY-15RMS01APP15-MAY-15NYNNRMS01APP100046217ITEM100046209N21NNNNN1111WLine Extension ItemLine Extension ItemLINE EXTENSION ITEMY1000EAYEN100NNYN15-MAY-15RMS01APP15-MAY-15NYNNRMS01APPSelect * from pos_mods where item in ('100046209','100046217');Note: There should be a record inserted with TRAN_TYPE-2 for the same item.This is because the below transaction level item was not 'Approved'.Once I approve the below transaction level item, data gets into the POS_MODS table correctly. Select * from item_master where item in ('100046209','100046217');ITEMITEM_NUMBER_TYPEFORMAT_IDPREFIXITEM_PARENTITEM_GRANDPARENTPACK_INDITEM_LEVELTRAN_LEVELITEM_AGGREGATE_INDDIFF_1DIFF_1_AGGREGATE_INDDIFF_2DIFF_2_AGGREGATE_INDDIFF_3DIFF_3_AGGREGATE_INDDIFF_4DIFF_4_AGGREGATE_INDDEPTCLASSSUBCLASSSTATUSITEM_DESCITEM_DESC_SECONDARYSHORT_DESCDESC_UPPRIMARY_REF_ITEM_INDCOST_ZONE_GROUP_IDSTANDARD_UOMUOM_CONV_FACTORPACKAGE_SIZEPACKAGE_UOMMERCHANDISE_INDSTORE_ORD_MULTFORECAST_INDORIGINAL_RETAILMFG_REC_RETAILRETAIL_LABEL_TYPERETAIL_LABEL_VALUEHANDLING_TEMPHANDLING_SENSITIVITYCATCH_WEIGHT_INDWASTE_TYPEWASTE_PCTDEFAULT_WASTE_PCTCONST_DIMEN_INDSIMPLE_PACK_INDCONTAINS_INNER_INDSELLABLE_INDORDERABLE_INDPACK_TYPEORDER_AS_TYPECOMMENTSITEM_SERVICE_LEVELGIFT_WRAP_INDSHIP_ALONE_INDCREATE_DATETIMELAST_UPDATE_IDLAST_UPDATE_DATETIMECHECK_UDA_INDITEM_XFORM_INDINVENTORY_INDORDER_TYPESALE_TYPEDEPOSIT_ITEM_TYPECONTAINER_ITEMDEPOSIT_IN_PRICE_PER_UOMAIP_CASE_TYPEBANDED_ITEM_INDCATCH_WEIGHT_TYPEPERISHABLE_INDSOH_INQUIRY_AT_PACK_INDNOTIONAL_PACK_INDCATCH_WEIGHT_UOMPRODUCT_CLASSIFICATIONBRAND_NAMECREATE_IDCOMP_VAT100046209ITEMN1NNNNN1111ALine ItemLine ItemLINE ITEMN1000EAYEN120100NNYN15-MAY-15RMS01APP15-MAY-15NYNNRMS01APP100046217ITEM100046209N21NNNNN1111ALine Extension ItemLine Extension ItemLINE EXTENSION ITEMY1000EAYEN100NNYN15-MAY-15RMS01APP15-MAY-15NYNNRMS01APPCheck that both items are now presnt in the POS_MODS table. Select * from pos_mods where item in ('100046209','100046217');TRAN_TYPEITEMITEM_NUMBER_TYPEFORMAT_IDPREFIXITEM_LONG_DESCITEM_SHORT_DESCREF_ITEMREF_ITEM_NUMBER_TYPEREF_FORMAT_IDREF_PREFIXPROM_ITEM_TYPEDEPTCLASSSUBCLASSSTORENEW_PRICENEW_SELLING_UOMOLD_PRICEOLD_SELLING_UOMSTART_DATENEW_MULTI_UNITSOLD_MULTI_UNITSNEW_MULTI_UNIT_RETAILNEW_MULTI_SELLING_UOMOLD_MULTI_UNIT_RETAILOLD_MULTI_SELLING_UOMSTATUSTAXABLE_INDPROMOTIONMIX_MATCH_NOMIX_MATCH_TYPETHRESHOLD_NOSTART_TIMEEND_TIMELAUNCH_DATEQTY_KEY_OPTIONSMANUAL_PRICE_ENTRYDEPOSIT_CODEFOOD_STAMP_INDWIC_INDPROPORTIONAL_TARE_PCTFIXED_TARE_VALUEFIXED_TARE_UOMREWARD_ELIGIBLE_INDELECT_MTK_CLUBSRETURN_POLICYSTOP_SALE_INDRETURNABLE_INDREFUNDABLE_INDBACK_ORDER_INDVAT_CODEVAT_RATECLASS_VAT_INDCREATE_DATETIMELAST_UPDATE_DATETIMELAST_UPDATE_IDCATCH_WEIGHT_INDSALE_TYPECONTAINER_ITEMUIN_TYPEUIN_LABELCAPTURE_TIMEEXT_UIN_INDRELATIONSHIP_IDRELATIONSHIP_NAMERELATIONSHIP_TYPEMANDATORY_INDRELATED_ITEMPRIORITYREL_START_DATEEND_DATECREATE_ID2100046209ITEMLine Item100046217ITEM11111111120EAAY15-MAY-15RMS01APPNRMS01APP1100046209ITEMLine Item11111111120EAAY15-MAY-15RMS01APPNNRMS01APP

???Page ??? (???)05/15/2015, 21:08:02Page /