1 Reply Latest reply on Aug 4, 2018 2:41 AM by Beauty_and_dBest

    MSCPDC: Planning ODS Load

    Beauty_and_dBest

      EBS 12.1.3 < Source

      APS 12.2.4 < Target

       

       

      Hi ALL,

       

      We are running MSCPDC: Planning ODS Load, but we are encountering error below

      Is it possible to open  the SQL program to understand what program is runs which encounters the error?

      04-AUG 06:41:50 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_1 WITH TABLE DELIVERY_DETAILS_FPC WITHOUT VALIDATION

      04-AUG 06:41:50 : ORA-00942: table or view does not exist

      04-AUG 06:41:50 :  Error while exchanging partition for table :MSC_ST_DELIVERY_DETAILS

      04-AUG 06:41:50 :  Please launch planning data pull again for following entities :

      04-AUG 06:41:50 : Delivery Details

       

      Please help....

      Thanks.

       

      +---------------------------------------------------------------------------+

      Advanced Supply Chain Planning: Version : 12.2

       

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

       

      MSCPDC: Planning ODS Load

      +---------------------------------------------------------------------------+

       

      Current system time is 04-AUG-2018 06:38:41

       

      +---------------------------------------------------------------------------+

       

      **Starts**04-AUG-2018 06:38:41

      **Ends**04-AUG-2018 06:41:50

      +---------------------------------------------------------------------------+

      Start of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      ************************************************************

      Parameters selected for planning data pull:

      ------------------------------------------------------------

      Recalculate Sourcing History: NO

      Purge Sourcing History      : NO

      ************************************************************

      04-AUG 06:38:41 : Recalculate NRA : 1

      04-AUG 06:38:41 : Monitor running in dsMode= 2

      04-AUG 06:38:41 : Monitor running in DSMODE =

      04-AUG 06:38:41 : pST_STATUS = MSC_UTIL.G_ST_COLLECTING

      04-AUG 06:38:41 :  st status is success

      04-AUG 06:38:41 : The MSC : Configuration profile option : 1

      04-AUG 06:38:41 : Responsibility_id = 23329

      04-AUG 06:38:41 : Application_id = 724

      04-AUG 06:38:41 : check4

      04-AUG 06:38:41 : eAM/cMRO integration disabled

      04-AUG 06:38:41 : Initializing v_partTblList1 and v_tempTblList.

      04-AUG 06:38:41 : tbl_count : 1 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 2 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 3 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 4 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 5 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 6 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 7 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 8 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 9 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 10 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 11 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 12 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 13 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 14 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 15 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 16 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 17 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 18 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : tbl_count : 19 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : Ignoring table: MSC_EAM_ACT_ASSOCIATIONS

      04-AUG 06:38:41 : Ignoring table: MSC_VISITS

      04-AUG 06:38:41 : Ignoring table: MSC_WO_ATTRIBUTES

      04-AUG 06:38:41 : Ignoring table: MSC_WO_TASK_HIERARCHY

      04-AUG 06:38:41 : Ignoring table: MSC_WO_MILESTONES

      04-AUG 06:38:41 : Ignoring table: MSC_WO_OPERATION_REL

      04-AUG 06:38:41 : Ignoring table: MSC_WORK_BREAKDOWN_STRUCT

      04-AUG 06:38:41 : Ignoring table: MSC_WO_SUB_COMP

      04-AUG 06:38:41 : Ignoring table: MSC_EAM_ASSET_EQUIP_DTLS

      04-AUG 06:38:41 : tbl_count : 20 . Extending temp PL/SQL tables

      04-AUG 06:38:41 : Variable tbl_count : 21

      04-AUG 06:38:41 : Truncating v_partTblList and v_tempTblList

      04-AUG 06:38:41 : Copying v_partTblList and v_tempTblList, from temp tables

      04-AUG 06:38:41 : Table count now is: 21

      04-AUG 06:38:41 : Initialized

      04-AUG 06:38:41 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:42 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:43 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:43 : CREATE VIEW SUPPLIES_T_V AS select PLAN_ID PLAN_ID, TRANSACTION_ID TRANSACTION_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, REVISION REVISION, UNIT_NUMBER UNIT_NUMBER, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, OLD_SCHEDULE_DATE OLD_SCHEDULE_DATE, NEW_WIP_START_DATE NEW_WIP_START_DATE, OLD_WIP_START_DATE OLD_WIP_START_DATE, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, DISPOSITION_ID DISPOSITION_ID, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE, ORDER_TYPE ORDER_TYPE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY, OLD_ORDER_QUANTITY OLD_ORDER_QUANTITY, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, OLD_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE, RESCHEDULE_DAYS RESCHEDULE_DAYS, RESCHEDULE_FLAG RESCHEDULE_FLAG, SCHEDULE_COMPRESS_DAYS SCHEDULE_COMPRESS_DAYS, NEW_PROCESSING_DAYS NEW_PROCESSING_DAYS, PURCH_LINE_NUM PURCH_LINE_NUM, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS, IMPLEMENT_DATE IMPLEMENT_DATE, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE, IMPLEMENT_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID, IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_SR_INSTANCE_ID, IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_ID, IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_SUPPLIER_SITE_ID, IMPLEMENT_AS IMPLEMENT_AS, RELEASE_STATUS RELEASE_STATUS, LOAD_TYPE LOAD_TYPE, PROCESS_SEQ_ID PROCESS_SEQ_ID, SCO_SUPPLY_FLAG SCO_SUPPLY_FLAG, ALTERNATE_BOM_DESIGNATOR#1 ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR#1 ALTERNATE_ROUTING_DESIGNATOR, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, BY_PRODUCT_USING_ASSY_ID BY_PRODUCT_USING_ASSY_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID SOURCE_SR_INSTANCE_ID, SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_SITE_ID, SOURCE_SUPPLIER_ID SOURCE_SUPPLIER_ID, SHIP_METHOD SHIP_METHOD, WEIGHT_CAPACITY_USED WEIGHT_CAPACITY_USED, VOLUME_CAPACITY_USED VOLUME_CAPACITY_USED, NEW_SHIP_DATE NEW_SHIP_DATE, NEW_DOCK_DATE NEW_DOCK_DATE, OLD_DOCK_DATE OLD_DOCK_DATE, LINE_ID LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID, IMPLEMENT_TASK_ID IMPLEMENT_TASK_ID, IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SCHEDULE_GROUP_ID, IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_BUILD_SEQUENCE, IMPLEMENT_ALTERNATE_BOM#1 IMPLEMENT_ALTERNATE_BOM, IMPLEMENT_ALTERNATE_ROUTING#1 IMPLEMENT_ALTERNATE_ROUTING, IMPLEMENT_UNIT_NUMBER IMPLEMENT_UNIT_NUMBER, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID, RELEASE_ERRORS RELEASE_ERRORS, NUMBER1 NUMBER1, SOURCE_ITEM_ID SOURCE_ITEM_ID, ORDER_NUMBER ORDER_NUMBER, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, BUILD_SEQUENCE BUILD_SEQUENCE, WIP_ENTITY_NAME WIP_ENTITY_NAME, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS, DELIVERY_PRICE DELIVERY_PRICE, LATE_SUPPLY_DATE LATE_SUPPLY_DATE, LATE_SUPPLY_QTY LATE_SUPPLY_QTY, LOT_NUMBER LOT_NUMBER, SUBINVENTORY_CODE SUBINVENTORY_CODE, QTY_SCRAPPED QTY_SCRAPPED, EXPECTED_SCRAP_QTY EXPECTED_SCRAP_QTY, QTY_COMPLETED QTY_COMPLETED, DAILY_RATE DAILY_RATE, SCHEDULE_GROUP_NAME SCHEDULE_GROUP_NAME, UPDATED UPDATED, SUBST_ITEM_FLAG SUBST_ITEM_FLAG, STATUS STATUS, APPLIED APPLIED, EXPIRATION_QUANTITY EXPIRATION_QUANTITY, EXPIRATION_DATE EXPIRATION_DATE, NON_NETTABLE_QTY NON_NETTABLE_QTY, IMPLEMENT_WIP_START_DATE IMPLEMENT_WIP_START_DATE, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, IMPLEMENT_DAILY_RATE IMPLEMENT_DAILY_RATE, NEED_BY_DATE NEED_BY_DATE, SOURCE_SUPPLY_ID SOURCE_SUPPLY_ID, SR_MTL_SUPPLY_ID SR_MTL_SUPPLY_ID, WIP_STATUS_CODE WIP_STATUS_CODE, DEMAND_CLASS DEMAND_CLASS, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, PO_LINE_ID PO_LINE_ID, LOAD_FACTOR_RATE LOAD_FACTOR_RATE, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, BILL_SEQUENCE_ID BILL_SEQUENCE_ID, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, CUSTOMER_ID CUSTOMER_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, OLD_NEED_BY_DATE OLD_NEED_BY_DATE, OLD_DAILY_RATE OLD_DAILY_RATE, OLD_FIRST_UNIT_START_DATE OLD_FIRST_UNIT_START_DATE, OLD_LAST_UNIT_COMPLETION_DATE OLD_LAST_UNIT_COMPLETION_DATE, OLD_NEW_SCHEDULE_DATE OLD_NEW_SCHEDULE_DATE, OLD_QTY_COMPLETED OLD_QTY_COMPLETED, OLD_NEW_ORDER_QUANTITY OLD_NEW_ORDER_QUANTITY, OLD_FIRM_QUANTITY OLD_FIRM_QUANTITY, OLD_FIRM_DATE OLD_FIRM_DATE, PLANNING_PARTNER_SITE_ID PLANNING_PARTNER_SITE_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, OWNING_PARTNER_SITE_ID OWNING_PARTNER_SITE_ID, OWNING_TP_TYPE OWNING_TP_TYPE, VMI_FLAG VMI_FLAG, EARLIEST_START_DATE EARLIEST_START_DATE, EARLIEST_COMPLETION_DATE EARLIEST_COMPLETION_DATE, MIN_START_DATE MIN_START_DATE, SCHEDULED_DEMAND_ID SCHEDULED_DEMAND_ID, EXPLOSION_DATE EXPLOSION_DATE, SCO_SUPPLY_DATE SCO_SUPPLY_DATE, RECORD_SOURCE RECORD_SOURCE, SUPPLY_IS_SHARED SUPPLY_IS_SHARED, ULPSD ULPSD, ULPCD ULPCD, UEPSD UEPSD, UEPCD UEPCD, EACD EACD, ORIGINAL_NEED_BY_DATE ORIGINAL_NEED_BY_DATE, ORIGINAL_QUANTITY ORIGINAL_QUANTITY, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, PROMISED_DATE PROMISED_DATE, WIP_START_QUANTITY WIP_START_QUANTITY, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, QUANTITY_ISSUED QUANTITY_ISSUED, UNBUCKETED_DEMAND_DATE UNBUCKETED_DEMAND_DATE, SHIPMENT_ID SHIPMENT_ID, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM, JUMP_OP_SEQ_NUM JUMP_OP_SEQ_NUM, SHIP_CALENDAR SHIP_CALENDAR, RECEIVING_CALENDAR RECEIVING_CALENDAR, INTRANSIT_CALENDAR INTRANSIT_CALENDAR, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, OLD_SHIP_DATE OLD_SHIP_DATE, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE, ORIG_SHIP_METHOD ORIG_SHIP_METHOD, ORIG_INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME, PARENT_ID PARENT_ID, DAYS_LATE DAYS_LATE, SCHEDULE_PRIORITY SCHEDULE_PRIORITY, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, WSM_FAULTY_NETWORK WSM_FAULTY_NETWORK, IMPLEMENT_DEST_ORG_ID IMPLEMENT_DEST_ORG_ID, IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_INST_ID, REQUESTED_START_DATE REQUESTED_START_DATE, REQUESTED_COMPLETION_DATE REQUESTED_COMPLETION_DATE, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER, ASSET_ITEM_ID ASSET_ITEM_ID, TOP_TRANSACTION_ID TOP_TRANSACTION_ID, UNBUCKETED_NEW_SCHED_DATE UNBUCKETED_NEW_SCHED_DATE, IMPLEMENT_SHIP_METHOD IMPLEMENT_SHIP_METHOD, ACTUAL_START_DATE ACTUAL_START_DATE, FIRM_SHIP_DATE FIRM_SHIP_DATE, SCHEDULE_ORIGINATION_TYPE SCHEDULE_ORIGINATION_TYPE, UNBUCKETED_START_DATE UNBUCKETED_START_DATE, SR_CUSTOMER_ACCT_ID SR_CUSTOMER_ACCT_ID, ITEM_TYPE_ID ITEM_TYPE_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, RO_STATUS_CODE RO_STATUS_CODE, SR_REPAIR_GROUP_ID SR_REPAIR_GROUP_ID, SR_REPAIR_TYPE_ID SR_REPAIR_TYPE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, ZONE_ID ZONE_ID, RO_CREATION_DATE RO_CREATION_DATE, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, FIRM_START_DATE FIRM_START_DATE, REQ_LINE_ID REQ_LINE_ID, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID, RELEASABLE RELEASABLE, BATCH_ID BATCH_ID, OTM_ARRIVAL_DATE OTM_ARRIVAL_DATE, PS_SUPPLY_FLAG PS_SUPPLY_FLAG, CTB_FLAG CTB_FLAG, CTB_COMP_AVAIL_PERCENT CTB_COMP_AVAIL_PERCENT, RTB_ORDER_QTY_PERCENT RTB_ORDER_QTY_PERCENT, CTB_EXPECTED_DATE CTB_EXPECTED_DATE, POTENTIAL_RTB_PERCENT POTENTIAL_RTB_PERCENT, CTB_PRIORITY CTB_PRIORITY, DESCRIPTION DESCRIPTION, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, PRODUCTION_SCHEDULE_ID PRODUCTION_SCHEDULE_ID, VISIT_ID VISIT_ID, PRODUCES_TO_STOCK PRODUCES_TO_STOCK, PRODUCT_CLASSIFICATION PRODUCT_CLASSIFICATION, MAINTENANCE_REQT MAINTENANCE_REQT, ACTIVITY_TYPE ACTIVITY_TYPE, ACTIVITY_NAME ACTIVITY_NAME, CLASS_CODE CLASS_CODE, SHUTDOWN_TYPE SHUTDOWN_TYPE, TO_BE_EXPLODED TO_BE_EXPLODED, OBJECT_TYPE OBJECT_TYPE, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE, ACTIVITY_ITEM_ID ACTIVITY_ITEM_ID, ORIG_FIRM_DATE ORIG_FIRM_DATE, ORIG_FIRM_QUANTITY ORIG_FIRM_QUANTITY, USE_WO_SUBSTITUTE USE_WO_SUBSTITUTE, ASSET_NUMBER ASSET_NUMBER, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, OPERATING_FLEET OPERATING_FLEET, MAINTENANCE_REQUIREMENT#1 MAINTENANCE_REQUIREMENT, COLL_ORDER_TYPE COLL_ORDER_TYPE, CTB_EXPECTED_DATE_BUY_COMPS CTB_EXPECTED_DATE_BUY_COMPS, SUBSTITUTE_COMPONENTS_USED SUBSTITUTE_COMPONENTS_USED from "MSC"."SUPPLIES_FPC"

      04-AUG 06:38:43 : CREATE OR REPLACE SYNONYM SUPPLIES_FPC FOR SUPPLIES_T_V

      04-AUG 06:38:43 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:43 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:44 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:44 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:44 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:45 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:45 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:45 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:46 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:46 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:46 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:47 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:47 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:47 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:48 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:48 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:48 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:48 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:49 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:49 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:49 : <<Create_Temp_Tab_PVT>>

      04-AUG 06:38:49 :  CREATE TEMP TABLES DONE

      04-AUG 06:38:49 :  Exchange Mode = 1

      04-AUG 06:38:49 : CREATE PARTITIONS DONE

      The name in GET_MY_COMPANY :My Company

      04-AUG 06:38:49 : MSC_X_SHOW_CONFIG (NAME=1)

      04-AUG 06:38:49 : MSC_X_SHOW_COMPANY (NAME=My Company)

      04-AUG 06:38:49 : before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS

      04-AUG 06:38:49 : CLEANSE DATA... OK!

      04-AUG 06:38:49 : Submitted request for Items and Category Sets Key Generation

      04-AUG 06:38:49 : Submitted request for Trading Parteners Key Generation

      04-AUG 06:39:49 : Request 523163 successful

      04-AUG 06:39:49 : Request 523164 successful

      04-AUG 06:39:49 : after MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS

      04-AUG 06:39:49 : Procedure MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER started.

      04-AUG 06:39:49 :    Procedure DELETE_MSC_TABLE:MSC_TRADING_PARTNER_SITES started.

      04-AUG 06:39:49 : MSC_TRADING_PARTNER_SITES:AND PARTNER_TYPE=3

      04-AUG 06:39:49 : debug2

      04-AUG 06:39:49 : debug22:250000

      04-AUG 06:39:49 : debug4

      04-AUG 06:39:49 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:49 :    Procedure DELETE_MSC_TABLE:MSC_PARTNER_CONTACTS started.

      04-AUG 06:39:49 : MSC_PARTNER_CONTACTS:

      04-AUG 06:39:49 : debug2

      04-AUG 06:39:49 : debug22:250000

      04-AUG 06:39:49 : debug4

      04-AUG 06:39:49 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:49 : after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER

      04-AUG 06:39:49 : Procedure MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER started.

      04-AUG 06:39:49 : Procedure MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR started.

      04-AUG 06:39:49 : Procedure MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS started.

      04-AUG 06:39:49 : Procedure MSC_CL_SETUP_ODS_LOAD.LOAD_UOM started.

      04-AUG 06:39:50 : Procedure MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP started.

      04-AUG 06:39:50 :    Procedure DELETE_MSC_TABLE:MSC_PERIOD_START_DATES started.

      04-AUG 06:39:50 : MSC_PERIOD_START_DATES:

      04-AUG 06:39:50 : debug2

      04-AUG 06:39:50 : debug22:250000

      04-AUG 06:39:50 : debug4

      04-AUG 06:39:50 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:50 :    Procedure DELETE_MSC_TABLE:MSC_CAL_YEAR_START_DATES started.

      04-AUG 06:39:50 : MSC_CAL_YEAR_START_DATES:

      04-AUG 06:39:50 : debug2

      04-AUG 06:39:50 : debug22:250000

      04-AUG 06:39:50 : debug4

      04-AUG 06:39:50 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:50 :    Procedure DELETE_MSC_TABLE:MSC_CAL_WEEK_START_DATES started.

      04-AUG 06:39:50 : MSC_CAL_WEEK_START_DATES:

      04-AUG 06:39:50 : debug2

      04-AUG 06:39:50 : debug22:250000

      04-AUG 06:39:50 : debug4

      04-AUG 06:39:50 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:50 :    Procedure DELETE_MSC_TABLE:MSC_CALENDARS started.

      04-AUG 06:39:50 : MSC_CALENDARS:

      04-AUG 06:39:50 : debug2

      04-AUG 06:39:50 : debug22:250000

      04-AUG 06:39:50 : debug4

      04-AUG 06:39:50 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:50 : cal code=FPC:FPPC CAL

      04-AUG 06:39:50 : cal code=FPC:FPPC CAL

      04-AUG 06:39:50 :    Procedure DELETE_MSC_TABLE:MSC_CALENDAR_ASSIGNMENTS started.

      04-AUG 06:39:50 : MSC_CALENDAR_ASSIGNMENTS:

      04-AUG 06:39:50 : debug2

      04-AUG 06:39:50 : debug22:250000

      04-AUG 06:39:50 : debug4

      04-AUG 06:39:50 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:51 :    Procedure DELETE_MSC_TABLE:MSC_NET_RESOURCE_AVAIL started.

      04-AUG 06:39:51 : MSC_NET_RESOURCE_AVAIL:

      04-AUG 06:39:51 : debug1

      04-AUG 06:39:51 : parameters passed to get_partiton_name are

      04-AUG 06:39:51 : p_plan_id-1

      04-AUG 06:39:51 : p_instance_id1

      04-AUG 06:39:51 : p_table_nameMSC_NET_RESOURCE_AVAIL

      04-AUG 06:39:51 : lv_is_plan2

      04-AUG 06:39:51 : lv_partition_nameNET_RESOURCE_AVAIL__1

      04-AUG 06:39:51 : lv_return_statusS

      04-AUG 06:39:51 : lv_msg_data

      04-AUG 06:39:51 : ALTER TABLE MSC_NET_RESOURCE_AVAIL TRUNCATE PARTITION NET_RESOURCE_AVAIL__1

      04-AUG 06:39:51 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:51 :    Procedure DELETE_MSC_TABLE:MSC_NET_RES_INST_AVAIL started.

      04-AUG 06:39:51 : MSC_NET_RES_INST_AVAIL:

      04-AUG 06:39:51 : debug1

      04-AUG 06:39:51 : parameters passed to get_partiton_name are

      04-AUG 06:39:51 : p_plan_id-1

      04-AUG 06:39:51 : p_instance_id1

      04-AUG 06:39:51 : p_table_nameMSC_NET_RES_INST_AVAIL

      04-AUG 06:39:51 : lv_is_plan2

      04-AUG 06:39:51 : lv_partition_nameNET_RES_INST_AVAIL__1

      04-AUG 06:39:51 : lv_return_statusS

      04-AUG 06:39:51 : lv_msg_data

      04-AUG 06:39:51 : ALTER TABLE MSC_NET_RES_INST_AVAIL TRUNCATE PARTITION NET_RES_INST_AVAIL__1

      04-AUG 06:39:51 :    0 minutes elapsed.

      ************************************************************

      Bad sqls for this session

      ------------------------------------------------------------

      ************************************************************

      04-AUG 06:39:51 : Planning ODS Load Worker( Request_ID=523165) is submitted.

      04-AUG 06:39:51 : Planning ODS Load Worker( Request_ID=523166) is submitted.

      04-AUG 06:39:51 : Planning ODS Load Worker( Request_ID=523167) is submitted.

      04-AUG 06:40:18 : Unpacked Task Number : 2

      04-AUG 06:40:18 : Unpacked Task Number : 3

      04-AUG 06:40:18 : Unpacked Task Number : 4

      04-AUG 06:40:18 : Unpacked Task Number : 5

      04-AUG 06:40:19 : Unpacked Task Number : 6

      04-AUG 06:40:19 : Unpacked Task Number : 7

      04-AUG 06:40:19 : Unpacked Task Number : 8

      04-AUG 06:40:19 : Unpacked Task Number : 9

      04-AUG 06:40:19 : Unpacked Task Number : 10

      04-AUG 06:40:19 : Unpacked Task Number : 11

      04-AUG 06:40:19 : Unpacked Task Number : 12

      04-AUG 06:40:19 : Unpacked Task Number : 13

      04-AUG 06:40:19 : Unpacked Task Number : 14

      04-AUG 06:40:27 : Unpacked Task Number : 15

      04-AUG 06:40:28 : Unpacked Task Number : 16

      04-AUG 06:40:30 : Unpacked Task Number : 1

      04-AUG 06:40:31 : Unpacked Task Number : 18

      04-AUG 06:40:31 : Unpacked Task Number : 19

      04-AUG 06:40:31 : Unpacked Task Number : 17

      04-AUG 06:40:32 : Unpacked Task Number : 21

      04-AUG 06:40:32 : Unpacked Task Number : 22

      04-AUG 06:40:32 : Unpacked Task Number : 23

      04-AUG 06:40:32 : Unpacked Task Number : 24

      04-AUG 06:40:32 : Unpacked Task Number : 25

      04-AUG 06:40:32 : Unpacked Task Number : 26

      04-AUG 06:40:33 : Unpacked Task Number : 27

      04-AUG 06:40:33 : Unpacked Task Number : 28

      04-AUG 06:40:33 : Unpacked Task Number : 29

      04-AUG 06:40:33 : Unpacked Task Number : 30

      04-AUG 06:40:33 : Unpacked Task Number : 31

      04-AUG 06:40:33 : Unpacked Task Number : 32

      04-AUG 06:40:33 : Unpacked Task Number : 33

      04-AUG 06:40:33 : Unpacked Task Number : 34

      04-AUG 06:40:33 : Unpacked Task Number : 20

      04-AUG 06:40:33 : Unpacked Task Number : 36

      04-AUG 06:40:33 : Unpacked Task Number : 37

      04-AUG 06:40:33 : Unpacked Task Number : 38

      04-AUG 06:40:33 : Unpacked Task Number : 39

      04-AUG 06:40:34 : Unpacked Task Number : 40

      04-AUG 06:40:34 : Unpacked Task Number : 35

      04-AUG 06:40:34 : Unpacked Task Number : 42

      04-AUG 06:40:34 : Unpacked Task Number : 43

      04-AUG 06:40:34 : Unpacked Task Number : 41

      04-AUG 06:40:34 : Unpacked Task Number : 44

      04-AUG 06:40:34 : Unpacked Task Number : 46

      04-AUG 06:40:34 : Unpacked Task Number : 47

      04-AUG 06:40:34 : Unpacked Task Number : 48

      04-AUG 06:40:34 : Unpacked Task Number : 49

      04-AUG 06:40:34 : Unpacked Task Number : 50

      04-AUG 06:40:34 : Unpacked Task Number : 51

      04-AUG 06:40:34 : Unpacked Task Number : 52

      04-AUG 06:40:34 : Unpacked Task Number : 53

      04-AUG 06:40:34 : Unpacked Task Number : 54

      04-AUG 06:40:34 : Unpacked Task Number : 55

      04-AUG 06:40:34 : Unpacked Task Number : 56

      04-AUG 06:40:34 : Unpacked Task Number : 45

      04-AUG 06:40:34 : Unpacked Task Number : 57

      04-AUG 06:40:34 : Unpacked Task Number : 58

      04-AUG 06:40:34 : Unpacked Task Number : 60

      04-AUG 06:40:34 : Unpacked Task Number : 61

      04-AUG 06:40:34 : Unpacked Task Number : 62

      04-AUG 06:40:34 : Unpacked Task Number : 63

      04-AUG 06:40:34 : Unpacked Task Number : 64

      04-AUG 06:40:34 : Unpacked Task Number : 65

      04-AUG 06:40:34 : Unpacked Task Number : 66

      04-AUG 06:40:34 : Unpacked Task Number : 67

      04-AUG 06:40:34 : Unpacked Task Number : 68

      04-AUG 06:40:34 : Unpacked Task Number : 69

      04-AUG 06:40:34 : Unpacked Task Number : 70

      04-AUG 06:40:34 : Unpacked Task Number : 71

      04-AUG 06:40:34 : Unpacked Task Number : 72

      04-AUG 06:40:34 : Unpacked Task Number : 73

      04-AUG 06:40:34 : Unpacked Task Number : 74

      04-AUG 06:40:34 : Unpacked Task Number : 75

      04-AUG 06:40:34 : Unpacked Task Number : 76

      04-AUG 06:40:34 : Unpacked Task Number : 59

      04-AUG 06:40:34 : All the Assigned Tasks are completed.

      04-AUG 06:40:34 : Index Dropping on Temp Supplies table successful.

      04-AUG 06:40:34 : Planning ODS Load process succeeded.

      04-AUG 06:40:34 :  pST_STATUS= MSC_UTIL.G_ST_READY

      04-AUG 06:40:34 : Telling the worker 1 to end.

      04-AUG 06:40:34 : Telling the worker 2 to end.

      04-AUG 06:40:34 : Telling the worker 3 to end.

      04-AUG 06:40:34 : 1 Worker(s) Completed.

      04-AUG 06:40:34 : 2 Worker(s) Completed.

      04-AUG 06:40:35 : 3 Worker(s) Completed.

      04-AUG 06:40:35 :  Index DEMANDS_NX_FPC created.

      04-AUG 06:40:35 :    0 minutes elapsed.

      04-AUG 06:40:35 : Linking of Sales Order line in MDS to its Parent Sales orders is successful.....

      04-AUG 06:40:35 :    0 minutes elapsed.

      04-AUG 06:40:35 : update of msc_supplies top_transaction_id for eam is successful.....

      04-AUG 06:40:35 : Index Dropping on Temp Tables successful.

      04-AUG 06:40:35 : Procedure alter_temp_table_by_monitor started.

      04-AUG 06:40:35 : Product short name - MSC

      04-AUG 06:40:35 : MSC schema - MSC

      04-AUG 06:41:35 : successfully altered phase 2 tables.

      04-AUG 06:41:35 : Profile value of MSC_REGEN_STATS: 1

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_SYSTEM_ITEMS EXCHANGE PARTITION SYSTEM_ITEMS__1 WITH TABLE SYSTEM_ITEMS_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_RESOURCE_REQUIREMENTS EXCHANGE PARTITION RESOURCE_REQUIREMENTS__1 WITH TABLE RESOURCE_REQUIREMENTS_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION SUPPLIES__1 WITH TABLE SUPPLIES_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_BOM_COMPONENTS EXCHANGE PARTITION BOM_COMPONENTS__1 WITH TABLE BOM_COMPONENTS_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_ITEM_CATEGORIES EXCHANGE PARTITION ITEM_CATEGORIES__1 WITH TABLE ITEM_CATEGORIES_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_ITEM_SUBSTITUTES EXCHANGE PARTITION ITEM_SUBSTITUTES__1 WITH TABLE ITEM_SUBSTITUTES_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_OPERATION_RESOURCES EXCHANGE PARTITION OPERATION_RESOURCES__1 WITH TABLE OPERATION_RESOURCES_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : exchange part:-ALTER TABLE MSC_OPERATION_RESOURCE_SEQS EXCHANGE PARTITION OPERATION_RESOURCE_SEQS__1 WITH TABLE OPERATION_RESOURCE_SEQS_FPC INCLUDING INDEXES WITHOUT VALIDATION

      04-AUG 06:41:36 : ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

      04-AUG 06:41:36 : Fatal Error in Exchange Partition.

      04-AUG 06:41:37 : DROP SYNONYM SUPPLIES_FPC

      04-AUG 06:41:37 : DROP VIEW SUPPLIES_T_V

      04-AUG 06:41:39 :  Calling Linking of Sales Order for 11i source ...

      04-AUG 06:41:39 : Procedure MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT started.

      04-AUG 06:41:48 : .. In procedure GET_START_END_OP ..

      04-AUG 06:41:50 : Truncated Source AD Tables Successfully

      04-AUG 06:41:50 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_1 WITH TABLE DELIVERY_DETAILS_FPC WITHOUT VALIDATION

      04-AUG 06:41:50 : ORA-00942: table or view does not exist

      04-AUG 06:41:50 :  Error while exchanging partition for table :MSC_ST_DELIVERY_DETAILS

      04-AUG 06:41:50 :  Please launch planning data pull again for following entities :

      04-AUG 06:41:50 : Delivery Details

      04-AUG 06:41:50 : Sourcing Rules

      04-AUG 06:41:50 : Sourcing Rules

      04-AUG 06:41:50 : Sourcing Rules

      04-AUG 06:41:50 :  Exchange partition failed

      +---------------------------------------------------------------------------+

      End of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      +---------------------------------------------------------------------------+

      No completion options were requested.

      Output file size:

      0

      Output is not being printed because:

      The print option has been disabled for this report.

      +---------------------------------------------------------------------------+

      Concurrent request completed

      Current system time is 04-AUG-2018 06:41:50

      +---------------------------------------------------------------------------+

        • 1. Re: MSCPDC: Planning ODS Load
          Beauty_and_dBest

          Per  Doc ID 340118.1

           

          B> FINDING MISSING INDEXES

          select

          ods.table_name

          , ai.index_name

          , substr(ods.table_name,5) || '__' || to_char(mip.instance_id) partition_name

          from msc_ods_table_v ods

          , msc_inst_partitions mip

          , all_indexes ai

          where ods.partition_type = 'R'

          and ods.table_name = ai.table_name

          MINUS

          select

          ods.table_name

          , aip.index_name

          , aip.partition_name

          from all_ind_partitions aip

          , all_indexes ai

          , msc_ods_table_v ods

          where ods.partition_type = 'R'

          and ods.table_name = ai.table_name

          and ai.index_name = aip.index_name

          and ai.owner = aip.index_owner;

           

           

           

          At SOURCE EBS:

          ==============

           

          At Target APS:

           

           

          Please help, which indexes to DROP

           

           

          Kind regards,