WIP jobs not being collected in new environment
· Had the DBA’s drop and re-create the snapshots
· Recreated the snapshots lookups.
· Seen data in below tables except for msc_supplies and msc_st_supplies
Base Table | Source Snapshot | Source Synonym | Source View | Staging Table | Planning Table |
WIP_DISCRETE_JOBS | WIP_DISCRETE_JOBSWIP_DISCRETE_JOBS | WIP_DISCRETE_JOBS | MRP_AP_WIP_JOB_SUPPLIES_V | MSC_ST_SUPPLIES |