atp data collection parameters

Table of Contents

Lists the Parameters for Planning Data Pull and ODS Load

Discusses options for each parameter and conditions for each parameter

Shows the value set of the parameters and how to view value sets

Includes Performance implications for parameter settings

Lists all profiles that must be considered for setup of Data Collections

Includes Performance implications for profiles

Shows Profiles that need to be considered for ATP Data Collections

Taken from visgn02 instance - base 12.1 release.

Requests launched for Setup Requests - used Targeted Refresh of only Forecasts to gather this info

Requests launched for Complete Refresh with Default Parameters

Screen shots of the parameters

Programs are A> Setup Request B> Launched on EBS Source and C> New programs for R12 and/or 12.1

Taken from copernicus instance - on CU7 Rollup patch for Collection




Programs are A> Setup Request B> Launched on EBS Source and C> New programs for R12 and/or 12.1

Example of ATP Data Collections

Taken from APS instance - on Data Collections RUP #30




Taken from visgn02 12.1 instance

shows what is launched for Complete Refresh with Default Parameters

shows screen shots of the parameters

Shows Source and Destination objects for different entities that are collected

Source tables / views

Snapshots

Data collections Views

Staging tables populated by Planning Data Pull

Final Destination tables that store the ODS data

Shows the snapshots and SQL used to gather the information for 12.1.1, 12.0.6, 11.5.10 and 11.5.9

shows the SQL used to get the snapshots

shows the file names where the snapshots are stored in the file system

Shows list of views for 12.1,3.3, 12.1.1, 12.0.6 and 11.5.10

The SQL used to get the views

SQL that can be used to view the text used to build the view

The file names where the views are stored in the file system

shows MLOGs used for Data Collections Snapshots

Show MRP_AD tables used for Data Collections to manage data that must be deleted.

Lists the SQL statements used for providing the information in this spreadsheet

List all the fixes included for data collections in 12.1.3.3

RevisionsRev 2.1 27-APR-2010 - initial publicationRev 2.2 14-JUL-2010 - revised to add internal links and Setup Request log file information, other minor edits/correctionsRev 2.3 07-Oct-2010 - updates to the parameters and profile options to provide more detailed information.Rev 2.4 03-May-2011 - implement comments on noteRev 2.5 09-May-2011 - updates for profile options, updates for new parameters in 12.1.3.3, new views, fixes for 12.1.3.3 added in a new tab.Rev 2.6 01-Jul-2011 - added Entity Mapping sheet

Attachment for Note 179522.1 Rev 2.6 01-Jul-2011

Parameters Overview

Profile Setups

12.1 visgn02

12.0.6 - NIC CU7

11.5.10 - APS RUP #30

ATP Data Collections

Table starting in H59 - shows parameters info and parameters to use to run Standard Data Collections to mimic ATP Data Collections

Entity Mapping

Snapshots All Releases

Views All Releases

MLOG Information

MRP_AD Tables

SQL Statements

12.1.3.3 Data Collections fixes

https://support.oracle.com/CSP/main/article?cmd=show&id=179522.1&type=NOT

Data Collections Parameters OverviewThese parameters where gathered from R12.1.1 base release.Some Parameters may have different values in other releases

Column M shows how to view parameters in Sys Admin responsibility

** If you choose Net Change, and then set Yes for an entity that cannot be collected in Net change Mode, then the parameter is ignored

Seq

Parameter Name Options Comments 11.5.10 R12.1 Value Set SQL statement for Value set

Planning Data Pull5 Instance Instance code MSC_SRS_COLL_INST_CODE Value set - see screen shot in Column L

7 Collection Group Default All MSC_ORG_STRINGS

10 Number of Workers Default 2 Increase to 4 - 8 workers to improve performance FND_NUMBER12 Timeout (Minutes) Default 180 For initial run on a new instance - may require setting of 600-1400 FND_NUMBER14 Language Default Language FND_LANGUAGES select userenv('LANG') from dual

16 Purge Previously Collected Data Default = Yes / No Set to No to allow Net Change or Targeted Collections n/a - Not used for ATP MSC_SRS_CMP_PURGE_YES_NO

18 Collection Method Default = Complete / Targeted / Net Change n/a - Not used for ATP MSC_SRS_CMP_TRGT_YES_NO

20 Analyze Staging Tables Default = No / Yes No is fine, should only set to Yes if directed by DEV n/a - Not used for ATP MRP_SRS_SYS_YES_NO

22 Approved Supplier Lists Default = Yes / No X X X X n/a - Not used for ATP MSC_X_ASL_SYS_YES_NO

24 ATP Rules Default = Yes / No X X X Complete MRP_SRS_SYS_YES_NO

26 Bills of Materials / Routings / Resources Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO28 Bill Of Resources Default = Yes / No X X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO30 Calendars Default = Yes / No Collects Calendars and also Calendar Assignments X X X Complete MRP_SRS_SYS_YES_NO32 Demand Class Default = Yes / No X X X Complete MRP_SRS_SYS_YES_NO33 End Item Substitutions Default = Yes / No X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO34 Forecasts Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO36 Items Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO38 Key Performance Indicator Targets Default = Yes / No X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO40 Master Demand Schedules Default = Yes / No X X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO42 Master Production Schedules Default = Yes / No X R12.1.1 Default = No X X X Net Change / Complete MRP_SRS_SYS_YES_NO44 On Hand Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO46 Planning Parameters Default = Yes / No X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO48 Planners Default = Yes / No X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

49 PO Receipts Default = No / Yes X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

50 Projects/Tasks Default = Yes / No X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO52 Purchase Orders/Purchase Requisitions Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO54 Reservations Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO

56 Resources Availability X X X n/a - Not used for ATP MSC_NET_RES_AVAIL

58 Safety Stock Default = Yes / No Only for User Defined Safety Stock from Inventory Application X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

60 Sales Orders X X X X

Net Change / Complete

MSC_SRS_CMP_CT_SO_YES_NO

62 Sourcing History Default = No / Yes X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

64 Sourcing Rules Default = Yes / No X X X Complete

66 Sub Inventories Default = Yes / No X X X Complete67 Supplier Responses Default = Yes / No For Collab Planning - No Net Change, Complete or Targeted only X X X n/a - Not used for ATP

68 Suppliers/Customers/Orgs Default = Yes / No X X X Complete

71 Transportation Details Default = Yes / No X Shipping Details from WSH tables / used in DRP Plans X X X No

Can be used in Net Change Refresh? **

R12.0.4 / 12.0.6

ATP Data Collections - Preset Parameters

Set up collection group in the Admin / Instances form in the Organization screen

select org_group,org_string from msc_org_groups_v where instance_id is null

select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 1

select meaning from mfg_lookups where lookup_type = 'PARTIAL_YES_NO' and lookup_code = DECODE(:$FLEX$.MSC_SRS_CMP_PURGE_YES_NO, 1, 1, 2, 3)


select meaning from mfg_lookups where lookup_type = 'MSC_X_ASL_SYS_YES_NO' and lookup_code = 1


Its a redundant parameter, but not yet removed from parameter list. Was originally part of the Sourcing history collections.

Collect Existing Data - 12.0 defaultDo Not Collect DataRegenerate and Collect Data - 12.1 default

MEANING: Collect Existing Data - Collect OPM Data only (If discrete data is already present in ASCP, it is not touched)Regenerate and Collect Data - Collect OPM Data AND Discrete Data

In 11.5.10, this is Yes/No - Default - Yes"Yes will collect both OPM and Discrete dataWhen Yes, then use Recalculate Resource Availability - Yes in ODS Load parameters for calculating discrete resource availability

Net change - Discrete Orgs

OPM orgs require

Complete Refresh

MRP: Cutoff Date Offset MonthsUsed for Discrete Orgs onlyDetermines how many months of resource availability should be computed for resources and simulation sets. No resource availability is calculated beyond this horizon. For constrained plans beyond this horizon, resource capacity is viewed as infinite. Set this value to your plan horizon. A large setting i.e. > 12 months could have performance implications during ODS Load when we calculate the resource availability for each resource for each day.

select meaning from mfg_lookups where lookup_type='MSC_NRA_ENABLED' and lookup_code=1

Default = No / Yes

Parameter = No and Complete Refresh - we collect Sales Order in Net Change Mode - this is done for Performance reasons and to reduce ATP downtime during Complete Refresh

Profile MSC: Sales Order Offset Days - determines how many days back we collect Closed Sales orders to be used for forecast consumption in ASCP.- Set to 0 if not required - HOWEVER, in 11.5.10, you must be on latest 11.5.10 collection rollup to prevent bug 5347354.during Net Change CollectionsProfile only applicable for Complete Refresh

select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = DECODE(:$FLEX$.MSC_SRS_CMP_TRGT_YES_NO, 1, 2, 3, 2, 1)

Not used anymore - See ODS Load parameter - Recalculate Sourcing History

Collects Sourcing Rules, BOD's, Assignment Sets, Region to Site Mapping also triggered by this parameter

Collects 4 partner types to MSC_TRADING_PARTNERS and related tablesPARTNER_TYPE1 = Supplier / 2 = Customer3 = Organization / 4 = Buyer

A B C D E F G H I J K

1

2345678

9

10

11

12

131415

16

17

18

19

20

21222324252627282930313233

34

353637

38

39

40

41

42

4344

45

46

72 Unit Numbers Default = Yes / No Used for Project MFG for unit effectivity(serial #) in BOM's X X X n/a - Not used for ATP 74 Unit of Measures (UOM) Default = Yes / No X X X Complete

75 User Company Association Used For Collaborative Planning Only X X X n/a - Not used for ATP MSC_X_USER_COMPANY

76 User Supplies and Demands Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO

78 Work in Process Default = Yes / No X X X X Net Change / Complete MRP_SRS_SYS_YES_NO

80 Sales Channel Default = No / Yes Used for Demantra only X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO85 Fiscal Calendar Default = No / Yes Used for Demantra only X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO90 Internal Repair Orders Default = No / Yes X Depot Repair integration - Service Parts Planning (SRP/SPP) X n/a - Not used for ATP MRP_SRS_SYS_YES_NO95 External Repair Orders Default = No / Yes X Depot Repair integration - Service Parts Planning (SRP/SPP) X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

100 Payback Demand/Supply Default = No / Yes X X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

105 Currency Conversion Default = No / Yes Used for Demantra only X X n/a - Not used for ATP MRP_SRS_SYS_YES_NO110 Delivery Details Default = No / Yes Used for OTM integration (Oracle Transportation Mgmt) X n/a - Not used for ATP MRP_SRS_SYS_YES_NO

115 Install Base under Contracts Default = No / Yes in 12.1.3.2 n/a - Not used for ATP MRP_SRS_SYS_YES_NO

120 Notes (Attachments) Default = No / Yes in 12.1.3.2 n/a - Not used for ATP MRP_SRS_SYS_YES_NO

Planning ODS LoadInstance Same as above for Planning Data Pull defaults from Planning Data Pull

Timeout (Minutes) Default = 60 FND_NUMBER

Number of Workers Default = 3 Increase to 4 - 8 workers to improve performance FND_NUMBER

Recalculate Resource Availability Default = No / Yes Always No MRP_SRS_SYS_YES_NO

Recalculate Sourcing History Default = No / Yes Always No MRP_SRS_SYS_YES_NO

Purge Sourcing History Default = No / Yes Always No MRP_SRS_SYS_YES_NO

Default = No / Yes

Legacy CollectionsPurge Legacy Data Runs MSCPPURB.pls - MSC_PURGE_LID

Purge Interface Tables Runs MSCCLPSB.pls - MSC_CL_PURGE_STAGING

Create Users and Enable User Company Association - Default for R12.1.1Enable User Company AssociationNo - Default for R12.0 and 11.5.10

select meaning from fnd_lookups where lookup_type = 'MSC_X_USER_COMPANY' and lookup_code = 1

When manually populating MTL_USER_SUPPLY and/or MTL_USER_DEMAND

We collect jobs that are in staus Unreleased, Released, Complete and On Hold wip_discrete_jobs.status_type in (1.3.4.6)

Used for Proejct MFG - requires later 11.5.10 collections code ORR12.0.4 with Collections CU3 or higher

Added in VCP 12.1.3.2 - Tracks install base under contracts - this and Notes below were Internal customer specific enhancements

Added in VCP 12.1.3.2 - Tied to BOM notes created by users - both were customer specific enhancements

For new instances or when using Recalculate options below, then this may require a higher value

Required to be Yes when A. 12.0.x - you have set Data Pull parameter Resources Availability - Collect Existing Data OR Regenerate and Collect DataB. 11.5.10 - you have set Data Pull parameter Resources Availability - Yes

Removed in 12.1.1 - honors the setting of the Data Pull parameterRef Bug 5534236


MSC: Sourcing History Start Date Offset (in months)-- Set this on APS Destination in a distributed installation

Defaults as Null - Collects ALL Data! - must be set to prevent performance problems when setting Yes for this parameter.Offsets the starting date of sourcing history calculations and is used in conjunction with ODS Load parameters Purge Sourcing History

These settings delete, then calculate Sourcing History from the Start date determined by the profile option value.System performance can be degraded when there is a high value for this profile option and a high volume of source transaction data.

Reference Note 399468.1 and Noe 780883.1 to understand Sourcing Splits in ASCP Planning

This will remove all previous history in the base table

If Sourcing history needs to be removed for business reasonsThen you can set this to Yes and Recalculate Sourcing History to NoThis will effectively remove all Sourcing History in the system

Refresh Collected Data in APCC repository

Added in 12.1.3.2 - to provide update for Advanced Planning Command Center - part of performance improvements for this new application

MSC_SRS_INSTANCE_CODE_ODS is used to get instance code

List of Tables comes from SELECT DISTINCT (LV.ATTRIBUTE1) TABLE_NAME FROM FND_LOOKUP_VALUES LV WHERE LV.ENABLED_FLAG = 'Y' AND LV.VIEW_APPLICATION_ID = 700 AND SUBSTR (LV.ATTRIBUTE1, 1, 3) = 'MSC' AND nvl(LV.ATTRIBUTE4,2) = 2 AND LV.LOOKUP_TYPE = 'MSC_X_SETUP_ENTITY_CODE';

A B C D E F G H I J K4748

49

50

51

52535455

56

5758

59

60

6162636465

66

67

68

69

70

71

72

73

7475

76

77

78

Profiles for Data CollectionsDepending on your release, you may not have all these profile optionsProfiles that effect PerformanceUsing ATP Data Collections? - then see Column G for profiles that effect your implementation

Set Profile in

Profile Name EBS Source Values Comments Performance Considerations Profile DB Name Details

MSC: Share Plan Partitions x Yes / No (No is required setting)

BOM: Hour UOM x x HR is usual setting Used for collecting Resource Requirements x BOM:HOUR_UOM_CODE

CRP:Spread discrete requirements x x Yes / No CRP_SPREAD_LOAD

INV:Capable to promise x x x INV_CTP

MRP:Purchasing By Revision x x Yes / No ASCP Planning -Release from workbench x MRP_PURCHASING_BY_REVISION

x Yes / No x MRP_EXPLODE_ATO

MRP: Consume MPS x Yes / No x MRP_MPS_CONSUMPTION

MRP: Cutoff Date Offset Months x x MRP_CUTOFF_HISTORY_DAYS

MRP: Purge Batch Size x x Integer -default 75000 x MRP_PURGE_BATCH_SIZE

x x x MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY

APS Destination

Used for ATP Data Collections

Installed a NULLNo is required for all implementationsYes can only be used in small test instances

Yes- will cause performance issues in any implementation where any volume testing is required.

Not used for collections, but used in ASCP for resource horizontal plan

ATP Based on Collected DataORATP/CTP Based on Planning Data

ATP Based on Collected Data (default) - if ASCP is not installed or if the ATP will not be using ASCP planning data.ATP/CTP Based on Planning Data - if ASCP is installed and the ATP will be using ASCP planning data.

MRP: Compute Standard Mandatory Components for ATO Models

Determines whether to call the CTO API to calculate the dependent demand for ATO items during the Refresh Snapshots process.This will cause performance to be slower when YES.Setting this to YES would be normal if ATO Models are present in the system. Collections code will default this profile to YES if it is NULL.

CTO BOM not found for the itemORCTO_API was exploding the BOM and returns a warning -

We print the following for CTO BOM not found - this is a setup violation - since the requirement for CTO is to configure and create the <STAR> item using CTO Auto-Create or by progressing the sales orderWarning: Item_ID = 781553, ORG_ID=5002 ; No BOM found for configured item in ship-from org.

You may safely disregard this warning if the configured item is transferred across orgs, and the warning points to an org in which no assembly of the configured item takes place.

If you are using ODS based ATP, please check that you have the BOM in shipping org. If you are using PDS based ATP, please check that item attribute "Create Configured Item, BOM" equals "Based on Model" and BOM exists in ship-from org.

Default - YesWhen Yes. then Planning Manager must be running in EBS Source instance.When No, then Planning Manager is not required to be running in EBS Source instance.-- review Note 790125.1 for more information on this functionality

Integer - Defaults as NULL

NULL is seen as 99999, this should be set between 12-24 in most cases, consult with the business for requirements

Determines how many months of resource availability should be computed for resources and simulation sets. No resource availability is calculated beyond this horizon. For constrained plans beyond this horizon, resource capacity is viewed as infinite.

System performance can be degraded when there is a high value for this profile option and a high volume of source transaction data

Default is 75000. This setting is used in Data Collections:1. When MSC: Purge Stg Tbl Cntrl = No. 2. For non-partitioned tables re-populated with data during ODS Load for a Complete Refresh Generally, there is no reason to change this profile from the default setting.

In some circumstances, we may find a delete process taking too much time due to millions of rowsIn case of millions of records, suggest a setting of maybe 250000 (250K)We would not recommend using higher value since we also use this profile option value as a limit for BULK FETCH in ODS Load and a higher value could cause errors if memory limit is reached

MRP:Retain Dates Within Calendar Boundary

Yes / No (default) - Set this to YES

This will avoid failures related to dates that are outside the calendars defined in the system. Some applications do not look at the calendar assigned to the org and allow you to enter a date that is outside the calendar date. Example: Latest Acceptable Date in Order Management application.

A B C D E F G H I

1

2

3

4

567

8

9

10

11

12

13

14

15

16

17

18

MRP:Use Ship Arrived Flag x Yes / No x MRP_SHIP_ARRIVE_FLAG

MSC: Collect Completed Jobs x Yes / No x MSC_COLLECT_COMPLETED_JOBS

x Yes / No x MSC_COLLECT_COSTS_FOR_ITEM

MSC: Collect Routing x Yes / No x MSC_COLLECT_ROUTING Introduced in 11.5.10 in Collections Rollup #25

x Yes / No (Default - No) MSC_CMRO_WO_DEMAND_PS

x Integer - Defaults as NULL x

MSC: Collections Snapshot Threshold x x MSC_SNAPSHOT_THRESHOLD

This profile is used when collecting Instransit SuppliesIf Yes, then we check the wsh_new_deliveries.ultimate_dropoff_date to populate MRP_AP_INTRANSIT_SUPPLIES_V.ARRIVED_FLAG If Arrived, then we do not collect this supplyIf No, Then we collect the intransit supply. NULL = No

If 'wsh_new_deliveries.ultimate_dropoff_date' is NOT NULL, then arrived_flag = 1 in mrp_ap_intransit_supplies_v.If this column is NULL, then the arrived_flag is 2.

If the profile 'MRP:Use Ship Arrived Flag' is set to Yes, then we do NOT collect the records which have arrived_flag = 1.If the profile is set to No, then we do not look at arrived_flag and always collect the supply.

Null seen as YesCollect completes jobs will collect requirements from jobs that are in status completed.- example: job is in status completed, but some component demands have not been fully issues to the job, then these component demands are collected and will be seen in the ASCP plan and for ATP.

No - we do not collect requirements for completed jobs. Profile was created to stop the collection of requirements left when job is completed and not yet set to Complete - No Charges Allowed or Closed.

MSC: Collect Item, Material and Resource Costs

Null seen as YesYes - will join with CST_ITEM_COSTS table OR for OPM items will launch OPM package to get costs from OPM tables.- item cost is seen in MSC_SYSTEM_ITEMS table.No - uses different view and collects costs as 0If using Inventory Optimization or Constrained Optmized plan, then Yes is required.

Using No can be faster for collections to complete, so if not required, set No

Null seen as YesIF profile INV: Capable to Promise = ATP/CTP based on Planning output, Then will always be seen as Yes and collect data.Useful to avoid collecting routing information when using ATP based on Collected Data and having large routing tables.

Using No can be faster for collections to complete, so if not required, set No

Currently in 11.5.10 onlyFP bugs are R12 7164877 and R12.1 7164884

MSC: Collect CMRO Work Order Demand for PS

Added in 12.1.2 - to support PS-CMRO integration.(Production Scheduling application and Complex Maintenance, Repair and Overhaul)

MSC: Collection Window for Trading Partner Changes (Days)

Used when Suppliers, Customers, Orgs - YesFor Collections when using ATP and for when running ASCP Plans.Specifies the number of days backwards to check for changes in customer names, customer sites, vendors, and vendor sites are collected. If null, then all records are collected

NULL or 0 (ZERO) Setting can cause performance issuesHowever, NULL or 0 is required for the first run of data collections so that all records are collected.THEN, the suggested setting is number of days between runs of Complete Refresh of Data CollectionsExample:Complete Refresh is run once per week, then a setting of 8 should be sufficient

MSC_COLLECTION_WINDOW_FOR_TP_CHANGES

NULL is default - seen as 40Integer 0 - 100

In Refresh Snapshots request, we checks the number of rows in table and number of rows in the MLOGIF ratio exceeds the threshold, then we will launch Complete Refresh of the Snapshot

We do not recommend setting this profile unless directed by DEVWe will perform a complete refresh when a large number of rows exist in the MLOG, since this would be faster than referencing the MLOG table for a fast refreshThis profile would usually be triggered when a large data load was performed to load data into setup tables.

A B C D E F G H I

19

20

21

22

23

24

25

MSC: Configuration x x MSC_X_CONFIGURATION

x Integer - default = 0 / Max value 10 x MSC_INDEX_PARALLEL_THREADS

MSC: Enable ATP Summary Mode x Yes / No x MSC_ENABLE_ATP_SUMMARY

MSC: Operator Company Name x x x MSC_X_COMPANY_NAME

x

x

x Yes / No MSC_PURGE_ST_CONTROL

APSAPS & CPCP

APS - Will not launch Collaboration ODS Load for Collaborative Planning

CP - Will launch Collaboration ODS Load for Collaborative Planning - only used for standalone implementation of CP

APS & CP - NOTE: Required for Demantra! - Ref Note 603228.1-- also will launch Collaboration ODS Load for Collaborative Planning

The Collaboration ODS Load launches at the end of Data Collections for ASCPThis process does not effect ASCP Planning. You can launch the ASCP plan while this process is still running.If using CP, then the process does need to complete before you can launch any other CP processes

MSC: Degree of Parallelism for Index Creation

Defaults to 0. Controls the use of parallel processes when creating indexes on the temporary tables created during the ODS LoadRequired setting of 1 if fails with NULL or ZERO - Possible errors are ORA-12801, ORA-12813 and ORA-00060 (ORA-60)

This can be increased if there are performance problems with the ODS Load and system resources can be allotted.

Enables summarization of supply and demand data following the data collection and plan launch processes. These tables are only for ATP based on Collected Data. Valid values are:Yes: Enable ATP Summary ModeNo: Disable ATP Summary ModeIf this profile =YES and INV:Capable to Promise = ATP/CTP based on Planning Data, then the request Load ATP Summary Tables will run at the end of Data Collections and will error. This can be ignored OR set the profile to No in order to avoid the error

Default - My Company - at Application Level for Advanced Supply Chain Planning

IF NULL. then Data Collections will failMy Company is defaulted during the installation. MSCXUPG.sql is SQL that inserts MSC_COMPANIES.COMPANY_ID = 1, COMPANY_NAME = My Company during installation

MSC:Organization containing generic BOM for forecast explosion

Default = NullPopulate with Organization code of org that will hold the BOM for ATO Models.This is usually the Master Org.

Used by collections to identify and populate the bill of material validation organization.

In distributed installation, this profile.is setup on EBS Source.Then Data Collections will populate this organization_id in MSC_APPS_INSTANCES in column VALIDATION_ORG_ID

This will be used for ASCP planning to explode BOM for forecast explosion and consumption

MSC: Project Task Collection Window Days

Integer - Defaults as NULL (seen as 0 - Zero) - which will collect all records

Use to limit the collection of completed projects and tasksExample - value 100 means we will collect the projects and tasks marked as completed for 100 days after the are completed.Then on day 101, we will no longer collect these completed projects and tasks

Not yet implemented in R12.x - Ref Bug 4895486

There have been performance issues for customers who have very large number of projects and tasks. So we introduced this profile to reduce the amount of data being collected.

MSC_COLLECTION_WINDOW_FOR_PROJ_TASKS

MSC: Purge Stg Tbl CntrlOR in R12.0.6 and 12.1,1 - new nameMSC: Purge Staging and Entity Key Translation Tables

Use YES to Truncate the staging table during data collection process.When Data Collections will retrieve data from a single instance (most common use of this process), set to Yes to improve performance and conserve disk space, or as separate processes for multiple instances.

Setting No will cause Staging tables to be deleted instead of using Truncate command. Since the tables are not truncated, this can increase their size over time and space recovered, which can lead to slower collections performance

A B C D E F G H I

26

27

28

29

30

31

32

x MSC_REFRESH_REGION_SITE

MSC: Refresh Snapshots Pending Timeout x MSC_REF_SNAP_PENDING_TIMEOUT

MSC: Sales Orders Offset Days x x MSC_SO_OFFSET_DAYS

MSC: Source Setup Required x MSC_SOURCE_SETUP

x Integer - Defaults as NULL MSC_START_SOURCING_HISTORY

MSC: Use Shipping/Receiving Calendar x x Yes/No MSC_USE_SHIP_REC_CAL

MSC: Refresh Site to Region Mappings Event

Collection of Sourcing RulesRunning of Refresh Collection Snapshots Request

Performs mapping of Regions to Supplier Sites based on setups in Order Management Regions and Zones form

Collection of Sourcing Rules - When Parameter Sourcing Rules - Yes, then run Region to Site mapping (recommended)

Running of Refresh Collection Snapshots Request - Only run this integration when you launch Running of Refresh Collection Snapshots as a standalone request

This is only for Vendor Site to Region Mapping This is used for Transit Times setup in ASCP with Region and Zones

After initial collection, we collect only changes to current regionsBut if you introduce a new region, then we remap all the vendor sitesThis can be costly if there are many vendor sites

10 is default (minutes)Integer

When Data Collections is launched, then this timeout is checked to make sure that Refresh Collections Snapshots has launched.No changes are recommended unless there is a problem with launching Refresh Snapshots

NULL or integer number - Note:1. Calculated using calendar days2. Must be the same on both Source and Destination

Collecting information on Shipped Sales Order Lines for use in Forecast Consumption during ASCP Planning where a Forecast for the Demand schedule of a plan.

It is designed to be used to collect only Closed Sales Orders where open_flag = No OR order_quantity = shipped_quantity.

Setting of NULL will collect all closed Sales Orders after SYSDATE -99999 (or 10,000 days - NOT recommended)

Before 11.5.10, Collections Rollup #14 Patch 5378494 - this profile will effect Net Change Collections and must be set to a value higher than the oldest Scheduled Ship Date that will ship late or that change will NOT be collected and ATP calculations may show old sales order demand

The smaller this number, the faster Data Collections can complete Sales Order loading.

Number required depends on forecasts consumption Forward Days setting.Example: If Maximum Forward Days setting for any Collected Forecast OR ODP forecast is 30 days, then setting should be at least 30 days

11.5.10 - Y or NR12 Yes / No

This Profile is set automatically by the application when a Collections Patch is applied.When set to Y (Yes), the Setup requests are run during Data Collections - the profile is read by the request Refresh Collection SnapshotsThese requests create all the EBS Source instance database objects that are needed for Collections to complete successfullyReview Note 207644.1 for more information on these Setup requests and the standard Data Collections requests that are submitted when running Data Collections.

Not considered when you run Refresh Collection Snapshots as a standalone request and use Automatic Refresh

MSC: Sourcing History Start Date Offset (in months)

For Collections when running an ASCP Plan, used to calculate planned orders when sourcing rules are Split % for ranks.Defaults as Null. Offsets the starting date of sourcing history calculations and is used in with collections parameters Purge Sourcing History = Yes and Recalculate Sourcing History = Yes. These settings delete, then calculate Sourcing History from the Start date determined by the profile option value (in months).

System performance can be degraded when NULL or a high value and a high volume of source transaction dataDo NOT leave NULLSet 0 if you have no sourcing splits defined in sourcing rulesFor Sourcing rules with splits - We recommend setting of between 3 and 12 depending on your business requirements

Default - NoWhen Yes, then we collect Calendars assigned via Order Management / Shipping / Setup / Calendars / AssignATP/GOP and Planning can use these calendar assignments, See the ASCP and GOP users guide for more information

A B C D E F G H I

33

34

35

36

37

38

MSC:Coll Error Debug Mode x see below Default OFF MSC_COLL_ERR_DEBUG

MSC:Coll Performance Debug Mode x Default OFF MSC_COLL_PERF_DEBUG

MRP: Debug Mode x x Yes / No MRP_DEBUG

GMD: Yield Type x FM_YIELD_TYPE

MRP: Plan Revenue Discount Percent x x Integer 0-100 MRP_BIS_AV_DISCOUNT

MRP: Plan Revenue Price List x Lookup for Price List in Order Management MRP_BIS_PRICE_LIST

MSC: Cost Type x Lookup of cost type in Costing application MSC_COST_TYPE

MSC: Inflate WIP Resource Requirements x x Yes / No MSC_INFLATE_WIP

x NULL = Unspecified Items MSC_NO_ACTIVITY_ITEM_CATEGORY

x NULL = NEW.MISC

x x MSC_PO_DOCK_DATE_CALC_PREF

x

x

x Integer / NULL = 1 MSC_RES_AVAIL_BEFORE_SYSDAT

MSC: Service Planning Enabled x Yes / No MSC_SRP_ENABLED

Leave this as OFF if you have a performance issueUnless instructed by Support or DEV, do not useHighHigh (Verbose)Dev

OffMediumHigh384 - Do Not Use128 - Do Not Use0 - Do Not Use

No is defaultIn 11.5.10, this profile provides more messages in all Collection log filesIn R12 - this is used only for Refersh Snapshots request for more complete messaging.

Do NOT set at site level - only at User LevelFor Collections - will write more info into MSRFWOR Refresh Snapshots log file

Note for ASCP Planning: this profile makes very large log files and could slow down performance.

Lookup for OPM conversion -Typically MASS or similar

Used for OPM - UOM Class for common conversions - from SY_UOMS_TYP

Optional - Average Discount to be applied when calculating Revenue of a plan as part of Plan Performance IndicatorsThis value is a key performance indicator used to calculate performance in a plan for Business Intelligence reports.

Optional - Price List used to calculate revenue of a plan as part of Plan Performance Indicators- from SO_PRICE_LISTSThis value is a key performance indicator used to calculate performance in a plan for Business Intelligence reports.

When profile MSC: Collect Item Costs = Yes, Then use this profile option to specify the cost type that collections should use when collecting the item costs.- from CST_COST_TYPES

Used for ASCP Planning - Determines whether ASCP should inflate the Work in Process resource requirements based on resource efficiency and utilization during collections from Oracle Work in Processsee ASCP Users Guide - Appendix A for more information

MSC: Category for Jobs without an Item Reference

Category for Jobs without an Item Reference to be used for display in ASCP planner workbench

MSC: Category Set for Jobs without an Item Reference

Category Set for Jobs without an Item Reference to be used for display in ASCP planner workbench

MSC_NO_ACTIVITY_ITEM_CATEGORY_SET

MSC: Purchase Order Dock Date Calculation Preference

Promised DateNeed By Date

This profile option specifies the purchase order line date that ATP and ASCP Plan use as the material arrival (dock) date.

MSC: Future Days for Currency Conversion -see bug 7631507 -11.5.10 only

Integer - not using APCC and not collecting currency Conversions, then not used

Used in APCC and for collecting for Curerncy Conversion and display in Advanced Planning Command Center (APCC) - Number of days in the future to be considered for collecting currency conversions

Set this number to be reasonable future days for displaying currency conversion data, A very high number or NULL with long calendar end date like 2020 could cause perforamnce issues

MSC_FUTURE_DAYS_FOR_CURR_CONV

MSC: History Days for Currency Conversion

Integer - not using APCC and not collecting currency Conversions, then not used

Used in APCC and for collecting for Curerncy Conversion and display in Advanced Planning Command Center (APCC) - Number of days in the past to be considered for collecting currency conversions

A high number could cause longer collection times when using Currency Conversions = Yes in most cases 365 days should be sifficient

MSC_HISTORY_DAYS_FOR_CURR_CONV

MSC: Days of Resource Availability before sysdate

Calculate Resource Availability for X days before sysdate

If a high number, then resource availability calculation during ODS Load could take a longer time

If using Service Parts Planning, then set to Yes to collect data for SPP (aka SRP)

A B C D E F G H I

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

BIS: Primary Rate Type x x lookup from GL tables BIS_PRIMARY_RATE_TYPE

Legacy Collection Profiles

MSC: Batch Size for Self Service Loads x Integer - default 1000

x Integer - default 3

MSC: Self Service Loads Delimiter x

MSCUTILS.PLS

MEANING LOOKUP_CODE --Collections profile options

Off 0 G_LVL_FATAL_ERR CONSTANT NUMBER := 1 ;

Medium 14 G_LVL_STATUS CONSTANT NUMBER := 2 ;

On (Minimal) 2 G_LVL_WARNING CONSTANT NUMBER := 4 ;

High 30 G_LVL_DEBUG_1 CONSTANT NUMBER := 8 ;

High (Verbose) 6 G_LVL_DEBUG_2 CONSTANT NUMBER := 16 ;

Dev 94 G_LVL_DEV CONSTANT NUMBER := 64 ;94 - Do Not Use DEV

30 - Do Not Use HIGH G_LVL_PERFDBG_1 CONSTANT NUMBER := 128 ;

6 - Do Not Use LOW G_LVL_PERFDBG_2 CONSTANT NUMBER := 256 ;14 - Do Not Use MEDIUM0 - Do Not Use OFF

--old status values are restored for backward compatibility.

--avoid using these for any new development.

G_D_STATUS CONSTANT NUMBER := 2 ;

G_D_DEBUG_1 CONSTANT NUMBER := 8 ;

G_D_DEBUG_2 CONSTANT NUMBER := 16 ;

G_D_PERFDBG_1 CONSTANT NUMBER := 128 ;

G_D_PERFDBG_2 CONSTANT NUMBER := 256 ;

-- variable for MSC:Coll Err Debug and MSC:Coll Perf Debug profile options

G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug

+ NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile

+ G_LVL_FATAL_ERR ; --Manadtory level

If populated, then can be used for price information of supplies and demands - from GL_DAILY_CONVERSION_TYPES

If running Legacy Collections and have many rows to import, then set this higher

This needs to be set appropriately for the size of your flat file data loads

MSC_SELF_SERVICE_LOADS_BATCH_SIZE

MSC: Number of Workers for Self Service Loads

If running Legacy Collections and have many rows to import, you may set higher in conjunction with Batch Size

MSC_SELF_SERVICE_LOADS_WORKERS_NUM

~ (tilde), (comma)

Tilde is the default setup for the DAT files provided in OATemplate.exeDownload the templates from the Collect Flat File Data - Self Service and click to unzipThen review reame file - OATemplateReadme.html

MSC_SELF_SERVICE_LOADS_DELIMITER

A B C D E F G H I

54

55

56

57

58

59

60616263646566676869707172

73

74

75

76

77

787980

8182838485

86

87

88

89

90

919293

94

95

96

R12.1malheur.be.oracle.com

Parameters Screen Shots 12.1.1 with CU4 Parameters in 12.1.3.2

See column I line 75 for explanation of the parameters passed to Planning Data Pull

Launch of Targeted Collections - only for ForecastsDifference between this and running Complete Refresh for all is that APS Collections Refresh Snapshot Thread launches only for the MRP% snapshots related for forecasts

New In R12 or 12.1.1

Request ID Shortname Program Name Phase Status Support Comment Parameters5846646 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C C 724, 12325846647 FNDRSSTG Planning Data Pull (Request Set Stage) C C 724, 1232, 11466, 5846646, 0

5846648 MSCPDP Planning Data Pull C C

5846649 MSRFWOR Refresh Collection Snapshots C C 1, COLL SNAPSHOTS, 0, 0, 1, P, 1, 2061, TST,

5846650 MSCDROPS Drop Changed Snapshots C C

null5846653 MSCWSMSN Create WSM Snapshots C C null5846654 MSCBOMSN Create BOM Snapshots C C null5846655 MSCINVSN Create INV Snapshots C C null5846656 MSCCSPSN Create CSP Snapshots C C null5846657 MSCMRPSN Create MRP Snapshots C C null5846658 MSCPOXSN Create PO Snapshots C C null5846659 MSCONTSN Create OE Snapshots C C null5846660 MSCWSHSN Create WSH Snapshots C C null5846661 MSCAHLSN Create AHL Snapshots C C null5846662 MSCEAMSN Create EAM Snapshots C C null5846663 MSCWIPSN Create WIP Snapshots C C null5846664 MSCSYNMS Collections Synonyms C C null5846665 MSCVIEWS Collections Views C C null5846666 MSCTRIGS Collections Triggers C C null5846667 MSCTRITM Create Collections Item Snapshot Triggers C C null5846668 MSCTRBOM Create Collections BOM Snapshot Triggers C C null5846669 MSCTRRTG Create Collections Routing Snapshot Triggers C C null5846670 MSCTRWIP Create Collections WIP Snapshot Triggers C C null5846671 MSCTRDEM Create Collections Demand Snapshot Triggers C C null5846672 MSCTRSUP Create Collections Supply Snapshot Triggers C C null5846673 MSCTROTH Create Collections Other Snapshot Triggers C C null5846674 MSCTRRPO Create Collections Repair Order Snapshot Triggers C C null5846675 MSCVWSTP Create Collections Setup Views C C null5846676 MSCVWITM Create Collections Item Views C C null5846677 MSCVWBOM Create Collections BOM Views C C null5846678 MSCVWRTG Create Collections Routing Views C C null5846679 MSCVWWIP Create Collections WIP Views C C null5846680 MSCVWDEM Create Collections Demand Views C C null5846681 MSCVWSUP Create Collections Supply Views C C null5846682 MSCVWOTH Create Collections Other Views C C null5846683 MSCVWRPO Create Collections Repair Order Views C C null

5846685 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DATES_SN, 2, 176574, 0

5846686 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DSGN_SN, 2, 176574, 05846687 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_ITEMS_SN, 2, 176574, 0

5846688 MSCPDPW Planning Data Pull Worker C C


5846690 FNDRSSTG Planning ODS Load (Request Set Stage) C C 724, 1232, 11468, 5846646, 05846691 MSCPDC Planning ODS Load C C 2061, 180, 3, 2, 2, 25846692 MSCPDCW Planning ODS Load Worker C C 5846691, 2061, 8972, 180, 2, 2, 1, 25846693 MSCPDCW Planning ODS Load Worker C C 5846691, 2061, 8972, 180, 2, 2, 1, 25846694 MSCPDCW Planning ODS Load Worker C C 5846691, 2061, 8972, 180, 2, 2, 1, 2

5846695 MSCALTBL Alter Temporary ODS Tables C C MSC_DEMANDS, TST, 15846696 MSCALTBL Alter Temporary ODS Tables C C MSC_SUPPLIES, TST, 15846697 MSCPDCP Planning Data Collection - Purge Staging Tables C C 2061, 1

5846698 MSCXPUBO Collaboration ODS Load C C 2061, 1013615, 2, 2, 2, 2, 2, , , ,

Complete Refresh of Planning Data Collections with Default ParametersRequest ID Shortname Program Name Phase Status Parameters

5846704 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C C 724, 12325846705 FNDRSSTG Planning Data Pull (Request Set Stage) C C 724, 1232, 11466, 5846704, 0


5846707 MSRFWOR Refresh Collection Snapshots C C 1, COLL SNAPSHOTS, 0, 0, 1, C, 1, 2061, TST,

5846708 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, AHL_SCH_MTLS_SN, 2, 176575, 0

5846709 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_RELATIONSHIPS_SN, 2, 176575, 05846710 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RTNS_SN, 2, 176575, 05846711 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, CSP_REPAIR_PO_HEADERS_SN, 2, 176575, 0

5846712 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_SEQS_SN, 2, 176575, 0 Data Pull Parameters and their meaning5846713 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_CHNGS_SN, 2, 176575, 0 If we parse the entry in G69 and match it to the parameters from Data Pull we see the following:5846714 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_INST_CHNGS_SN, 2, 176575, 0 These are the default parameters for Complete Refresh5846715 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_COMPS_SN, 2, 176575, 0 Parameter Value Meaning5846716 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_OPR_RESS_SN, 2, 176575, 0 Instance 2061 Instance_id5846717 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, EAM_WO_RELATIONSHIPS_SN, 2, 176575, 0 Collection Group -999 All Orgs, otherwise Collection Group name will be shown5846718 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DATES_SN, 2, 176575, 0 Number of Workers 2

Setup requests

Starting on line 21 - we see example of Setup Requests Launched Targeted Refresh only for Forecasts to capture setup requests launched when MSC: Source Setup Required = YesAnd this also shows that in R12.x, a targeted refresh now launches Refresh Snapshots only for the required snapshots

Setup Request Log File

Targeted Refresh Starting on line 12 - launched targeted refresh of forecasts to get launch of Setups reqeusts

Complete RefreshStarting on line 69 - Launched Complete Refresh and used the default parameters - See Column H for screen shots of the parameters

Parameters screen shots 12.1.1 CU4Parameters screen shots 12.1.3.2Parameters explained

In a distributed installation where EBS Source and APS destination are on separate instances, these requests will launch on the EBS Source InstanceNote: If EBS Source is 11.5.10, then see that worksheet to see the processes executed on the EBS Source

-999 is for all orgs, otherwise you would see the Org Group name listed

2061, -999, 2, 180, US, 2, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2

Now launches sub requests for performance improvements - APS Collections Refresh Snapshot Thread

The Shortname for these requests are files located at $MSC_TOP/sql that are executed to create/maintain the Data Collection entities - e.g. MSCDROPS.sql

Since this is targeted refresh of only forecasts, we refresh only the snapshots required for this entity, and not all snapshots. This improvement was introduced in R12.0.4

5846648, 2061, 180, US, 3, 1096760, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2

5846648, 2061, 180, US, 3, 1096760, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2

These are also introduced to improve performance

Only Required if using Collaborative Planning - Launches only when you have set profile MSC: Configuration - APS & CP


2061, -999, 2, 180, US, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1, 3, 1, 1, 2, 2, 2, 2, 2, 2, 2

Now launches sub requests for performance improvements - APS Collections Refresh Thread

These are sub requests that are launched for individual snapshots, to help with overall performance of the Refresh Snapshots processing

A B C D E F G H I J K L M N O P Q R

1

23

4

5

6

7

8

9

10

11

12

1314

15

161718

19

20

21

22232425262728293031323334353637383940414243444546474849505152

53

5455

56

57

5859606162

63

6465

66

6768

69

707172

73

74

75

767778

79

80

8182838485

5846719 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DSGN_SN, 2, 176575, 0 Timeout (Minutes) 1805846720 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_ITEMS_SN, 2, 176575, 0 Language US5846721 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_BOMS_SN, 2, 176575, 0 Delete ODS Data 1 1 = Yes, 2= No5846722 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_SCHD_DATES_SN, 2, 176575, 0 Complete, Net Change, Targeted 1 1 = Complete, 2 = Net Change, 3 = Targeted5846723 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_MTRX_TMP_SN, 2, 176575, 0 Analyze Staging Tables 2 All the rest of these are 1 = Yes and 2 = No except as noted5846724 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_OH_QTYS_SN, 2, 176575, 0 Approved Supplier Lists 15846725 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_RESERVATIONS_SN, 2, 176575, 0 ATP Rules 15846726 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SUPPLY_SN, 2, 176575, 0 BOM/Routings/Resources 15846727 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SYS_ITEMS_SN, 2, 176575, 0 BOR/Bill Of Resources 15846728 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_TXN_REQUEST_LINES_SN, 2, 176575, 0 Calendars 15846729 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_DEMAND_SN, 2, 176575, 0 Demand Class 15846730 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_SUPPLY_SN, 2, 176575, 0 End Item Substitutions 15846731 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_INV_COMPS_SN, 2, 176575, 0 Forecasts 15846732 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, OE_ODR_LINES_SN, 2, 176575, 0 Items 15846733 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, PO_ACCEPTANCES_SN, 2, 176575, 0 KPI Targets (BIS) 15846734 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, PO_CHANGE_REQUESTS_SN, 2, 176575, 0 Master Demand Schedule (MDS) 15846735 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, PO_SI_CAPA_SN, 2, 176575, 0 Master Prod. Schdule (MPS) 25846736 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_DSCR_JOBS_SN, 2, 176575, 0 On Hand 15846737 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_FLOW_SCHDS_SN, 2, 176575, 0 Planning Parameters 15846738 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_OPR_RES_INSTS_SN, 2, 176575, 0 Planners 15846739 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_ITEMS_SN, 2, 176575, 0 PO Receipts 25846740 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_SCHDS_SN, 2, 176575, 0 Projects/Tasks 15846741 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WLINES_SN, 2, 176575, 0 Purchasing Reqs (PO) 15846742 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_NETWORKS_SN, 2, 176575, 0 Reservations 1

5846743 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_NETWORKS_SN, 2, 176575, 0 Resource Avail Recalc (NRA) 3

5846744 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_RESS_SN, 2, 176575, 0 Safety Stock 15846745 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_SUB_RESS_SN, 2, 176575, 0 Sales Orders 15846746 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPRS_SN, 2, 176575, 0 Sourcing History 25846747 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WREQ_OPRS_SN, 2, 176575, 0 Sourcing Rules 15846748 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSH_TRIP_SN, 2, 176575, 0 Sub Inventories 15846749 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSH_TRIP_STOP_SN, 2, 176575, 0 Supplier Responses 15846750 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_NWK_SN, 2, 176575, 0 Suppliers/Customers/Orgs 15846751 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_INSTS_SN, 2, 176575, 0 Trading Partners (Suppliers) 25846752 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_SN, 2, 176575, 0 Transportation Details 15846753 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RESS_SN, 2, 176575, 0 Unit Numbers 15846754 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPRS_SN, 2, 176575, 0 Unit of Measures (UOM) 1

5846755 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_REQ_OPRS_SN, 2, 176575, 0 User Company Association 3

5846756 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_CATS_SN, 2, 176575, 0 User Supplies and Demands 1

5846758 MSCPDPW Planning Data Pull Worker C C Work in Process (WIP) 1

5846759 MSCPDPW Planning Data Pull Worker C C Sales Channel 25846761 FNDRSSTG Planning ODS Load (Request Set Stage) C C 724, 1232, 11468, 5846704, 0 Fiscal Calendar 25846762 MSCPDC Planning ODS Load C C 2061, 180, 3, 2, 2, 2 Internal Repair Orders 25846764 MSCITTK Generate Items and Category Sets Keys C C 2061 External Repair Orders 25846765 MSCTPTK Generate Trading Partner Keys C C 2061 Payback Demand/Supply 25846766 MSCPDCW Planning ODS Load Worker C G 5846762, 2061, 8973, 180, 1, 2, 1, 1 Currency Conversion 25846767 MSCPDCW Planning ODS Load Worker C C 5846762, 2061, 8973, 180, 1, 2, 1, 1 Delivery Details 25846768 MSCPDCW Planning ODS Load Worker C G 5846762, 2061, 8973, 180, 1, 2, 1, 15846770 MSCCLMISC APS Collections Miscellaneous Task C C MSC_CL_OTHER_ODS_LOAD, PURGE_STALE_CURRENCY_CONV, 5846771 MSCCLMISC APS Collections Miscellaneous Task C C MSC_PHUB_PKG, REFRESH_MVS, 15846772 MSCCLMISC APS Collections Miscellaneous Task C C MSC_WS_OTM_BPEL, PURGETRANSPORTATIONUPDATES, 5846773 MSCALTBL Alter Temporary ODS Tables C C MSC_SALES_ORDERS, TST, 15846774 MSCALTBL Alter Temporary ODS Tables C C MSC_DEMANDS, TST, 15846775 MSCALTBL Alter Temporary ODS Tables C C MSC_SUPPLIES, TST, 15846777 MSCPDCP Planning Data Collection - Purge Staging Tables C C 2061, 1

5846778 MSCXPUBO Collaboration ODS Load C C 2061, 1013615, 1, 1, 1, 1, 1, 2, 2, 2, 2

Setup Requests - Refresh Collection Snapshots log file example:

+---------------------------------------------------------------------------+Master Scheduling/MRP: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. MSRFWOR module: Refresh Collection Snapshots+---------------------------------------------------------------------------+ Current system time is 12-JUN-2010 00:20:15 +---------------------------------------------------------------------------+ **Starts**12-JUN-2010 00:20:15**Ends**12-JUN-2010 00:27:56+---------------------------------------------------------------------------+Start of log messages from FND_FILE+---------------------------------------------------------------------------+12-JUN 00:20:15 : ref mode - 112-JUN 00:20:15 : snp name - COLL SNAPSHOTS12-JUN 00:20:15 : The degree of parallelism for Refreshing snapshots is set to: 012-JUN 00:20:16 : Request : 5943208 :Checks for Snapshots which have changed and Drops them12-JUN 00:21:16 : select NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N') from dual 12-JUN 00:21:16 : Request : 5943209 :Creates WSM Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943210 :Creates BOM Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943211 :Creates INV Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943212 :Creates CSP Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943213 :Creates MRP Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943214 :Creates PO Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943215 :Creates OE Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943216 :Creates WSH Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943217 :Creates AHL Snapshot Logs and Snapshots12-JUN 00:21:16 : Request : 5943218 :Creates EAM Snapshot Logs and Snapshots12-JUN 00:22:16 : Request : 5943219 :Creates WIP Snapshot Logs and Snapshots12-JUN 00:23:16 : Request : 5943220 :Creates Synonyms used by Collections Process12-JUN 00:24:16 : Request : 5943223 :Creates Views used by Collections Process12-JUN 00:24:16 : Request : 5943224 :Creates Triggers used by Collections Process12-JUN 00:26:16 : Updating Profile Option MSC_SOURCE_SETUP to No 12-JUN 00:26:16 : Region Site Mapping not being called here 12-JUN 00:26:17 : Profile Option MSC_SOURCE_SETUP has been updated No 12-JUN 00:26:17 : The Value No indicates that the Collection Setup Objects have been applied12-JUN 00:26:17 : Source set up completed successfully12-JUN 00:26:17 : Start: split_refresh12-JUN 00:26:17 : ('PO','USUD','ITEM','ISUB','OH','BOM','MRP','FCST','WIP','EAM','ERO','SCAP','SRSP','ONT','WSH' ) 12-JUN 00:26:17 : ('PO','USUD','ITEM','ISUB','OH','BOM','MRP','FCST','WIP','EAM','ERO','SCAP','SRSP','ONT','WSH' ) 12-JUN 00:26:17 : Product short name - MRP12-JUN 00:26:17 : MRP schema - MRP12-JUN 00:26:17 : Evaluating -- MRP_CL_FUNCTION.CHECK_AHL_VER12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: AHL_SCH_MTLS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_ITEM_RELATIONSHIPS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_OPR_RTNS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: CSP_REPAIR_PO_HEADERS_SN

1 = Collect Existing Data2 = Do Not Collect Data3 = Regenerate and Collect Data

1 = No2 = Enable User Company Association3 = Create Users and Enable User Company Association

5846706, 2061, 180, US, 1, 1096761, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 3, 1, 1

5846706, 2061, 180, US, 1, 1096761, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 3, 1, 1


A B C D E F G H I J K L M N O P Q R8687888990919293949596979899100101102103104105106107108109

110

111112113114115116117118119120121

122

123

124

125

126127128129130131132133134135136137138139

140

141142

143

144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200

12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_OPR_SEQS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_RES_CHNGS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_RES_INST_CHNGS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_SUB_COMPS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_SUB_OPR_RESS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: EAM_WO_RELATIONSHIPS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MRP_FORECAST_DATES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MRP_FORECAST_DSGN_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MRP_FORECAST_ITEMS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_BOMS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MRP_SCHD_DATES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_MTRX_TMP_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_OH_QTYS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_RESERVATIONS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_SUPPLY_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_SYS_ITEMS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_TXN_REQUEST_LINES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_U_DEMAND_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_U_SUPPLY_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_INV_COMPS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: OE_ODR_LINES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: PO_ACCEPTANCES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: PO_CHANGE_REQUESTS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: PO_SI_CAPA_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_DSCR_JOBS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_FLOW_SCHDS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_OPR_RES_INSTS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_REPT_ITEMS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_REPT_SCHDS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WLINES_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_OPR_NETWORKS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WOPR_NETWORKS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WOPR_RESS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WOPR_SUB_RESS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WOPRS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WIP_WREQ_OPRS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSH_TRIP_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSH_TRIP_STOP_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Evaluating -- TO_NUMBER(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'))12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSM_LJ_OPR_NWK_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Evaluating -- TO_NUMBER(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'))12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSM_LJ_OPR_RESS_INSTS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Evaluating -- TO_NUMBER(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'))12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSM_LJ_OPR_RESS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: BOM_OPR_RESS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Evaluating -- TO_NUMBER(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'))12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSM_LJ_OPRS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Evaluating -- TO_NUMBER(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'))12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: WSM_LJ_REQ_OPRS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:26:17 : Submitted request 5943242, to refresh snapshot: MTL_ITEM_CATS_SN12-JUN 00:26:17 : ------------------------------------------------12-JUN 00:27:17 : Successfully refreshed all snapshots12-JUN 00:27:17 : Successfully refreshed these Snapshots :12-JUN 00:27:17 : AHL_SCH_MTLS_SN,MTL_ITEM_RELATIONSHIPS_SN,BOM_OPR_RTNS_SN,CSP_REPAIR_PO_HEADERS_SN,BOM_OPR_SEQS_SN,B12-JUN 00:27:17 : OM_RES_CHNGS_SN,BOM_RES_INST_CHNGS_SN,BOM_SUB_COMPS_SN,BOM_SUB_OPR_RESS_SN,EAM_WO_RELATIONSHIPS_SN,M12-JUN 00:27:17 : RP_FORECAST_DATES_SN,MRP_FORECAST_DSGN_SN,MRP_FORECAST_ITEMS_SN,BOM_BOMS_SN,MRP_SCHD_DATES_SN,MTL_MT12-JUN 00:27:17 : RX_TMP_SN,MTL_OH_QTYS_SN,MTL_RESERVATIONS_SN,MTL_SUPPLY_SN,MTL_SYS_ITEMS_SN,MTL_TXN_REQUEST_LINES_SN12-JUN 00:27:17 : ,MTL_U_DEMAND_SN,MTL_U_SUPPLY_SN,BOM_INV_COMPS_SN,OE_ODR_LINES_SN,PO_ACCEPTANCES_SN,PO_CHANGE_REQUES12-JUN 00:27:17 : TS_SN,PO_SI_CAPA_SN,WIP_DSCR_JOBS_SN,WIP_FLOW_SCHDS_SN,WIP_OPR_RES_INSTS_SN,WIP_REPT_ITEMS_SN,WIP_REPT_SCHDS_SN,WIP_WLINES_SN,BOM_OPR_NETWORKS_SN,WIP_WOPR_NETWORKS_SN,WIP_WOPR_RESS_SN,WIP_WOPR_SUB_RESS_SN,WIP_WOPRS_SN,WIP_WREQ_OPRS_SN,WSH_TRIP_SN,WSH_TRIP_STOP_SN,WSM_LJ_OPR_NWK_SN,WSM_LJ_OPR_RESS_INSTS_SN,WSM_LJ_OPR_RESS_SN,BOM_OPR_RESS_SN,WSM_LJ_OPRS_SN,WSM_LJ_REQ_OPRS_SN,MTL_ITEM_CATS_SN12-JUN 00:27:17 : Type of Refresh done: ?????????????????????????????????????????????????12-JUN 00:27:17 : Doing a fast refresh of all snapshots...12-JUN 00:27:17 : lv_snapshot_str: AHL_SCH_MTLS_SN,MTL_ITEM_RELATIONSHIPS_SN,BOM_OPR_RTNS_SN,CSP_REPAIR_PO_HEADERS_SN,BOM_OPR_SEQS_SN,BOM_RES_CHNGS_SN,BOM_RES_INST_CHNGS_SN,BOM_SUB_COMPS_SN,BOM_SUB_OPR_RESS_SN,EAM_WO_RELATIONSHIPS_SN,MRP_FORECAST_DATES_SN,MRP_FORECAST_DSGN_SN,MRP_FORECAST_ITEMS_SN,BOM_BOMS_SN,MRP_SCHD_DATES_SN,MTL_MTRX_TMP_SN,MTL_OH_QTYS_SN,MTL_RESERVATIONS_SN,MTL_SUPPLY_SN,MTL_SYS_ITEMS_SN,MTL_TXN_REQUEST_LINES_SN,MTL_U_DEMAND_SN,MTL_U_SUPPLY_SN,BOM_INV_COMPS_SN,OE_ODR_LINES_SN,PO_ACCEPTANCES_SN,PO_CHANGE_REQUESTS_SN,PO_SI_CAPA_SN,WIP_DSCR_JOBS_SN,WIP_FLOW_SCHDS_SN,WIP_OPR_RES_INSTS_SN,WIP_REPT_ITEMS_SN,WIP_REPT_SCHDS_SN,WIP_WLINES_SN,BOM_OPR_NETWORKS_SN,WIP_WOPR_NETWORKS_SN,WIP_WOPR_RESS_SN,WIP_WOPR_SUB_RESS_SN,WIP_WOPRS_SN,WIP_WREQ_OPRS_SN,WSH_TRIP_SN,WSH_TRIP_STOP_SN,WSM_LJ_OPR_NWK_SN,WSM_LJ_OPR_RESS_INSTS_SN,WSM_LJ_OPR_RESS_SN,BOM_OPR_RESS_SN,WSM_LJ_OPRS_SN,WSM_LJ_REQ_OPRS_SN,MTL_ITEM_CATS_SN


12-JUN 00:27:17 : lv_refresh_param: FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF12-JUN 00:27:17 : lv_DEGREE: 012-JUN 00:27:24 : Doen with refresh.12-JUN 00:27:24 : Populating Flow Demand, Complete Refresh Flow: 112-JUN 00:27:37 : .3 Minutes Elapsed.12-JUN 00:27:37 : Exploding SMC demand, LRN: -112-JUN 00:27:37 : 11510 or greater source12-JUN 00:27:49 : Value of p_lrn is :-112-JUN 00:27:52 : Value of p_lrn is :-112-JUN 00:27:52 : Value of lv_lrn is :17735412-JUN 00:27:52 : Value of lv_lrn is :012-JUN 00:27:53 : Value of p_lrn is :-112-JUN 00:27:53 : Value of lv_lrn is :17741712-JUN 00:27:53 : Value of lv_lrn is :012-JUN 00:27:53 : Job Exists for line id :38841412-JUN 00:27:54 : Inserting row for :38841112-JUN 00:27:54 : Exploding the model of the config12-JUN 00:27:54 : Exploding the model for the config is completed.12-JUN 00:27:54 : Inserting row for :38841212-JUN 00:27:54 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:54 : Inserting row for :38841312-JUN 00:27:54 : Value of p_lrn is :-112-JUN 00:27:54 : Value of lv_lrn is :17741712-JUN 00:27:54 : Value of lv_lrn is :012-JUN 00:27:54 : Value of p_lrn is :-112-JUN 00:27:54 : Value of lv_lrn is :17741712-JUN 00:27:54 : Value of lv_lrn is :012-JUN 00:27:54 : Job Exists for line id :38842212-JUN 00:27:54 : Inserting row for :38841912-JUN 00:27:54 : Exploding the model of the config12-JUN 00:27:54 : Exploding the model for the config is completed.12-JUN 00:27:54 : Inserting row for :38842012-JUN 00:27:54 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:54 : Inserting row for :38842112-JUN 00:27:54 : Value of p_lrn is :-112-JUN 00:27:54 : Value of lv_lrn is :17741712-JUN 00:27:54 : Value of lv_lrn is :012-JUN 00:27:54 : Value of p_lrn is :-112-JUN 00:27:54 : Value of lv_lrn is :17751512-JUN 00:27:54 : Value of lv_lrn is :012-JUN 00:27:55 : Job Exists for line id :38851712-JUN 00:27:55 : Inserting row for :38851412-JUN 00:27:55 : Exploding the model of the config12-JUN 00:27:55 : Exploding the model for the config is completed.12-JUN 00:27:55 : Inserting row for :38851512-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :38851612-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17751512-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17751512-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Job Exists for line id :38852112-JUN 00:27:55 : Inserting row for :38851812-JUN 00:27:55 : Exploding the model of the config12-JUN 00:27:55 : Exploding the model for the config is completed.12-JUN 00:27:55 : Inserting row for :38851912-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :38852012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17751512-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17785512-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : Job Exists for line id :35039212-JUN 00:27:55 : Inserting row for :35037212-JUN 00:27:55 : Exploding the model of the config12-JUN 00:27:55 : Exploding the model for the config is completed.12-JUN 00:27:55 : Inserting row for :35037412-JUN 00:27:55 : Inserting row for :35037512-JUN 00:27:55 : Inserting row for :35037612-JUN 00:27:55 : Inserting row for :35037712-JUN 00:27:55 : Inserting row for :35037812-JUN 00:27:55 : Inserting row for :35037912-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038012-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.componen


t_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038112-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038212-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038312-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038412-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038512-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038612-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038712-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038812-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35038912-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35039012-JUN 00:27:55 : sql statement : select NVL(bic.wip_supply_type, msi.wip_supply_type) from bom_components_b bic, bom_structures_b bbom , mtl_system_items msi where bbom.assembly_item_id = :lv_item_id and bbom.organization_id = :Source_Organization_Id and bbom.alternate_bom_designator IS NULL and bic.bill_sequence_id = bbom.common_bill_sequence_id and bic.component_item_id = :Inventory_Item_Id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbom.organization_id and rownum = 1 12-JUN 00:27:55 : Inserting row for :35039112-JUN 00:27:55 : Value of p_lrn is :-112-JUN 00:27:55 : Value of lv_lrn is :17619612-JUN 00:27:55 : Value of lv_lrn is :012-JUN 00:27:55 : .3 Minutes Elapsed.12-JUN 00:27:56 : Calling Module: 112-JUN 00:27:56 : Map Region Site during collection : 112-JUN 00:27:56 : Collection refresh type: C12-JUN 00:27:56 : The value of lv_sourcing_flag:112-JUN 00:27:56 : before calling MRP_MAP_REG_SITE.MAP_REGION_TO_SITE12-JUN 00:27:56 : Calling function MAP_REGION_TO_SITE with max_lrd:11-JUN-1012-JUN 00:27:56 : Time consumed for calling map_region_to_site:012-JUN 00:27:56 : after calling MRP_MAP_REG_SITE.MAP_REGION_TO_SITE12-JUN 00:27:56 : Refresh Snapshot process completed successfully+---------------------------------------------------------------------------+End of log messages from FND_FILE+---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+Executing request completion options... Output is not being printed because:The print option has been disabled for this report. +------------- 1) PRINT -------------++--------------------------------------+ Finished executing request completion options. +---------------------------------------------------------------------------+Concurrent request completed successfullyCurrent system time is 12-JUN-2010 00:27:56 +---------------------------------------------------------------------------+


Request ID User Program Name Phase Status Parameters6305398 1068 Planning Data Collection (Request Set Planning Data Collection) C C 724, 12326305401 1068 Planning Data Pull (Request Set Stage) C C 724, 1232, 11466, 6305398, 06305402 1068 Planning Data Pull C C 2061, M1, 2, 180, US, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1, 3, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 26305403 1068 Refresh Collection Snapshots C C 1, COLL SNAPSHOTS, 0, 0, 1, C, 1, 2061, TST, 6305405 1068 APS Collections Refresh Snapshot Thread C C 1, AHL_SCH_MTLS_SN, 2, 299384, 06305406 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_RELATIONSHIPS_SN, 2, 299384, 06305407 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RTNS_SN, 2, 299384, 06305408 1068 APS Collections Refresh Snapshot Thread C C 1, CSP_REPAIR_PO_HEADERS_SN, 2, 299384, 06305409 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_SEQS_SN, 2, 299384, 06305410 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_RES_CHNGS_SN, 2, 299384, 06305411 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_RES_INST_CHNGS_SN, 2, 299384, 06305412 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_COMPS_SN, 2, 299384, 06305413 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_OPR_RESS_SN, 2, 299384, 06305414 1068 APS Collections Refresh Snapshot Thread C C 1, EAM_WO_RELATIONSHIPS_SN, 2, 299384, 06305415 1068 APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DATES_SN, 2, 299384, 06305416 1068 APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_DSGN_SN, 2, 299384, 06305417 1068 APS Collections Refresh Snapshot Thread C C 1, MRP_FORECAST_ITEMS_SN, 2, 299384, 06305418 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_BOMS_SN, 2, 299384, 06305419 1068 APS Collections Refresh Snapshot Thread C C 1, MRP_SCHD_DATES_SN, 2, 299384, 06305420 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_DEMAND_SN, 2, 299384, 06305421 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_MTRX_TMP_SN, 2, 299384, 06305422 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_OH_QTYS_SN, 2, 299384, 06305423 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_RESERVATIONS_SN, 2, 299384, 06305424 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_SUPPLY_SN, 2, 299384, 06305425 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_SYS_ITEMS_SN, 2, 299384, 06305426 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_TXN_REQUEST_LINES_SN, 2, 299384, 06305427 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_U_DEMAND_SN, 2, 299384, 06305428 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_U_SUPPLY_SN, 2, 299384, 06305429 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_INV_COMPS_SN, 2, 299384, 06305430 1068 APS Collections Refresh Snapshot Thread C C 1, OE_ODR_LINES_SN, 2, 299384, 06305431 1068 APS Collections Refresh Snapshot Thread C C 1, PO_ACCEPTANCES_SN, 2, 299384, 06305432 1068 APS Collections Refresh Snapshot Thread C C 1, PO_CHANGE_REQUESTS_SN, 2, 299384, 06305433 1068 APS Collections Refresh Snapshot Thread C C 1, PO_SI_CAPA_SN, 2, 299384, 06305434 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_DSCR_JOBS_SN, 2, 299384, 06305435 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_FLOW_SCHDS_SN, 2, 299384, 06305436 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_OPR_RES_INSTS_SN, 2, 299384, 06305437 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_ITEMS_SN, 2, 299384, 06305438 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_SCHDS_SN, 2, 299384, 06305439 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WLINES_SN, 2, 299384, 06305440 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_NETWORKS_SN, 2, 299384, 06305441 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_NETWORKS_SN, 2, 299384, 06305442 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_RESS_SN, 2, 299384, 06305443 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_SUB_RESS_SN, 2, 299384, 06305444 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WOPRS_SN, 2, 299384, 06305445 1068 APS Collections Refresh Snapshot Thread C C 1, WIP_WREQ_OPRS_SN, 2, 299384, 06305446 1068 APS Collections Refresh Snapshot Thread C C 1, WSH_TRIP_SN, 2, 299384, 06305447 1068 APS Collections Refresh Snapshot Thread C C 1, WSH_TRIP_STOP_SN, 2, 299384, 06305448 1068 APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_NWK_SN, 2, 299384, 06305449 1068 APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_INSTS_SN, 2, 299384, 06305450 1068 APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_SN, 2, 299384, 06305451 1068 APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RESS_SN, 2, 299384, 06305452 1068 APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPRS_SN, 2, 299384, 06305453 1068 APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_REQ_OPRS_SN, 2, 299384, 06305454 1068 APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_CATS_SN, 2, 299384, 06305456 1068 Planning Data Pull Worker C C 6305402, 2061, 180, US, 1, 1369058, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 3, 1, 16305457 1068 Planning Data Pull Worker C C 6305402, 2061, 180, US, 1, 1369058, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 3, 1, 16305461 1068 Planning ODS Load (Request Set Stage) C C 724, 1232, 11468, 6305398, 06305462 1068 Planning ODS Load C C 2061, 180, 3, 2, 2, 2, 26305463 1068 Generate Items and Category Sets Keys C C 20616305464 1068 Generate Trading Partner Keys C C 20616305477 1068 Planning ODS Load Worker C C 6305462, 2061, 13288, 180, 1, 2, 1, 16305478 1068 Planning ODS Load Worker C C 6305462, 2061, 13288, 180, 1, 2, 1, 16305479 1068 Planning ODS Load Worker C C 6305462, 2061, 13288, 180, 1, 2, 1, 16305483 1068 APS Collections Miscellaneous Task C C MSC_CL_OTHER_ODS_LOAD, PURGE_STALE_CURRENCY_CONV, 6305484 1068 APS Collections Miscellaneous Task C C MSC_PHUB_PKG, REFRESH_MVS, 16305485 1068 APS Collections Miscellaneous Task C C MSC_WS_OTM_BPEL, PURGETRANSPORTATIONUPDATES, 6305492 1068 Alter Temporary ODS Tables C C MSC_SALES_ORDERS, TST, 16305493 1068 Alter Temporary ODS Tables C C MSC_DEMANDS, TST, 16305494 1068 Alter Temporary ODS Tables C C MSC_SUPPLIES, TST, 16305495 1068 Planning Data Collection - Purge Staging Tables C C 2061, 16305496 1068 Collaboration ODS Load C C 2061, 1068, 1, 1, 1, 1, 1, 2, 2, 2, 2


S T U

1

23

4

5

6

7

8

9

10

11

12

1314

15

161718

19

20

21

22232425262728293031323334353637383940414243444546474849505152

53

5455

56

57

5859606162

63

6465

66

6768

69

707172

73

74

75

767778

79

80

8182838485

12.0.6 with CU7 Collections Patch appliedcopernicus.us.oracle.com

Starting on line 141

See column I line 64 for explanation of the parameters passed to Planning Data Pull

Launch of Targeted Collections - only for Forecasts

New in R12

Difference between this and running Complete Refresh for all is that APS Collections Refresh Snapshot Thread launches only for the MRP% snapshots related for forecastsRequest ID Shortname Program Name Phase Status Support Comment

5029846 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C C5029847 FNDRSSTG Planning Data Pull (Request Set Stage) C C

5029848MSCPDP Planning Data Pull C C

5029851 MSRFWOR Refresh Collection Snapshots C C


5029857 MSCWSMSN Create WSM Snapshots C C5029858 MSCBOMSN Create BOM Snapshots C C5029859 MSCINVSN Create INV Snapshots C C5029860 MSCMRPSN Create MRP Snapshots C C5029861 MSCPOXSN Create PO Snapshots C C5029862 MSCONTSN Create OE Snapshots C C5029863 MSCWSHSN Create WSH Snapshots C C5029864 MSCAHLSN Create AHL Snapshots C C5029865 MSCEAMSN Create EAM Snapshots C C5029868 MSCWIPSN Create WIP Snapshots C C5029871 MSCSYNMS Collections Synonyms C C

Setup requestsStarting on line 20 - we see example of Setup Requests Launched Targeted Refresh only for Forecasts to capture setup requests launched when MSC: Source Setup Required = YesLine 141 shows an Refresh Collection Snapshots log file when setup requests are launched

Setup Request Log FileTargeted Refresh Starting on Line 12 - Launched Targeted Refresh

Complete RefreshStarting on Line 50 - Launched Complete Refresh and used the default parameters - See Column H for screen shots of the parameters

ATP Data Collections Starting on Line 120 - Example of ATP Data Collections Requests with Net Change for both parameters

Parameters screen shots in Column HParameters explained

In a distributed installation where EBS Source and APS destination are on separate instances, these requests will launch on the EBS Source InstanceNote: If EBS Source is 11.5.10, then see that worksheet to see the processes executed on the EBS Source


Now launches sub requests for performance improvements - APS Collections Refresh Snapshot Thread


A B C D E F

1

23

4

5

6

7

8

9

10

11

12

13

14151617

18

19

20

2122232425262728293031

5029874 MSCVIEWS Collections Views C C5029875 MSCTRIGS Collections Triggers C C


5029882 MSRFWOR Refresh Collection Snapshots C C5029883 MSRFWOR Refresh Collection Snapshots C C



5029890 FNDRSSTG Planning ODS Load (Request Set Stage) C C5029891 MSCPDC Planning ODS Load C C5029892 MSCPDCW Planning ODS Load Worker C C5029893 MSCPDCW Planning ODS Load Worker C C5029894 MSCPDCW Planning ODS Load Worker C C5029897 MSCALTBL Alter Temporary ODS Tables C C5029898 MSCALTBL Alter Temporary ODS Tables C C5029901 MSCPDCP Planning Data Collection - Purge Staging Tables C C

5029902

MSCXPUBO Collaboration ODS Load C C

Complete Refresh of Planning Data Collections with Default ParametersRequest ID Shortname Program Name Phase Status

5029968 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C G

5029969 FNDRSSTG Planning Data Pull (Request Set Stage) C C

5029970MSCPDP Planning Data Pull C C



5029975 MSRFWOR Refresh Collection Snapshots C C5029976 MSRFWOR Refresh Collection Snapshots C C5029977 MSRFWOR Refresh Collection Snapshots C C5029978 MSRFWOR Refresh Collection Snapshots C C5029979 MSRFWOR Refresh Collection Snapshots C C5029980 MSRFWOR Refresh Collection Snapshots C C5029981 MSRFWOR Refresh Collection Snapshots C C




Since this is targeted refresh of only forecasts, we refresh only the snapshots required for this entity, and not all snapshots. This improvement was introduced in R12.0.4

Refresh Individual snapshots requests are new in R12


Status G indicates Warning - this is due to ODS Load which finished with Warning


These are sub requests that are launched for individual snapshots, to help with overall performance of the Refresh Snapshots processing

A B C D E F3233

34

35

36

37

38

3940414243444546

47

4849

50

51

52

53

54

55

56

57585960616263

64

65

66

5029985 MSRFWOR Refresh Collection Snapshots C C5029986 MSRFWOR Refresh Collection Snapshots C C5029987 MSRFWOR Refresh Collection Snapshots C C5029988 MSRFWOR Refresh Collection Snapshots C C5029989 MSRFWOR Refresh Collection Snapshots C C5029990 MSRFWOR Refresh Collection Snapshots C C5029991 MSRFWOR Refresh Collection Snapshots C C5029992 MSRFWOR Refresh Collection Snapshots C C5029993 MSRFWOR Refresh Collection Snapshots C C5029994 MSRFWOR Refresh Collection Snapshots C C5029995 MSRFWOR Refresh Collection Snapshots C C5029996 MSRFWOR Refresh Collection Snapshots C C5029997 MSRFWOR Refresh Collection Snapshots C C5029998 MSRFWOR Refresh Collection Snapshots C C5029999 MSRFWOR Refresh Collection Snapshots C C5030000 MSRFWOR Refresh Collection Snapshots C C5030001 MSRFWOR Refresh Collection Snapshots C C5030002 MSRFWOR Refresh Collection Snapshots C C5030003 MSRFWOR Refresh Collection Snapshots C C5030004 MSRFWOR Refresh Collection Snapshots C C5030005 MSRFWOR Refresh Collection Snapshots C C5030006 MSRFWOR Refresh Collection Snapshots C C5030007 MSRFWOR Refresh Collection Snapshots C C5030008 MSRFWOR Refresh Collection Snapshots C C5030009 MSRFWOR Refresh Collection Snapshots C C5030010 MSRFWOR Refresh Collection Snapshots C C5030011 MSRFWOR Refresh Collection Snapshots C C5030012 MSRFWOR Refresh Collection Snapshots C C


5030014 MSRFWOR Refresh Collection Snapshots C C5030015 MSRFWOR Refresh Collection Snapshots C C5030016 MSRFWOR Refresh Collection Snapshots C C5030017 MSRFWOR Refresh Collection Snapshots C C5030018 MSRFWOR Refresh Collection Snapshots C C5030019 MSRFWOR Refresh Collection Snapshots C C5030020 MSRFWOR Refresh Collection Snapshots C C5030021 MSRFWOR Refresh Collection Snapshots C C5030022 MSRFWOR Refresh Collection Snapshots C C5030023 MSRFWOR Refresh Collection Snapshots C C5030024 MSRFWOR Refresh Collection Snapshots C C

5030031MSCPDPW Planning Data Pull Worker C C


5030044 FNDRSSTG Planning ODS Load (Request Set Stage) C G

5030045 MSCPDC Planning ODS Load C G


Investigate the Log file to see cause of the warning status. Warnings can be generated in the main ODS Load or in the ODS Loader Worker

A B C D E F67686970717273747576777879808182838485868788899091929394

95

96979899100101102103104105106

107

108

109

110

5030046 MSCITTK Generate Items and Category Sets Keys C C5030047 MSCTPTK Generate Trading Partner Keys C C5030052 MSCPDCW Planning ODS Load Worker C C

5030053 MSCPDCW Planning ODS Load Worker C G

5030054 MSCPDCW Planning ODS Load Worker C C5030061 MSCALTBL Alter Temporary ODS Tables C C5030062 MSCALTBL Alter Temporary ODS Tables C C5030066 MSCPDCP Planning Data Collection - Purge Staging Tables C C

5030069 MSCXPUBO Collaboration ODS Load C C


Request ID User Program Name Phase Status5150279 FNDRSSUB ATP Data Collection (Report Set) C G5150280 FNDRSSTG Pull Data (Request Set Stage) C C

5150282 MSCATPDP ATP Data Pull C C




5150297 FNDRSSTG Collect Data (Request Set Stage) C G5150298 MSCPDC Planning ODS Load C G5150300 MSCITTK Generate Items and Category Sets Keys C C5150301 MSCTPTK Generate Trading Partner Keys C C5150304 MSCPDCW Planning ODS Load Worker C C5150305 MSCPDCW Planning ODS Load Worker C C5150306 MSCPDCW Planning ODS Load Worker C C5150308 MSCPDCP Planning Data Collection - Purge Staging Tables C C5150309 MSCXPUBO Collaboration ODS Load C C

Setup Requests - Refresh Collection Snapshots log file example:



The parameters here show full set that appears like it would for standard data collections.

The parameters submitted are the same for Both Net Change and Complete RefreshHowever, if running Net Change, then any entity that is a Setup Entity is ignored when set to Yes (1)

This launches single request for snapshots instead of multiple requests seen in Standard Collections starting in R12

A B C D E F111112113

114

115116117118

119

120

121

122123124125

126

127

128

129

130131132133134135136137138139140

141

142

+---------------------------------------------------------------------------+Master Scheduling/MRP: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MSRFWOR module: Refresh Collection Snapshots+---------------------------------------------------------------------------+

Current system time is 06-SEP-2009 08:24:19

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

**Starts**06-SEP-2009 08:24:20**Ends**06-SEP-2009 08:31:41+---------------------------------------------------------------------------+Start of log messages from FND_FILE+---------------------------------------------------------------------------+06-SEP 08:24:20 : ref mode - 106-SEP 08:24:20 : snp name - ALL SNAPSHOTS06-SEP 08:24:20 : Request : 5029854 :Checks for Snapshots which have changed and Drops them06-SEP 08:25:20 : Request : 5029857 :Creates WSM Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029858 :Creates BOM Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029859 :Creates INV Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029860 :Creates MRP Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029861 :Creates PO Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029862 :Creates OE Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029863 :Creates WSH Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029864 :Creates AHL Snapshot Logs and Snapshots06-SEP 08:25:20 : Request : 5029865 :Creates EAM Snapshot Logs and Snapshots06-SEP 08:26:20 : Request : 5029868 :Creates WIP Snapshot Logs and Snapshots06-SEP 08:27:20 : Request : 5029871 :Creates Synonyms used by Collections Process06-SEP 08:28:20 : Request : 5029874 :Creates Views used by Collections Process06-SEP 08:28:20 : Request : 5029875 :Creates Triggers used by Collections Process06-SEP 08:30:20 : Updating Profile Option MSC_SOURCE_SETUP to No 06-SEP 08:30:21 : Profile Option MSC_SOURCE_SETUP has been updated No 06-SEP 08:30:21 : The Value No indicates that the Collection Setup Objects have been applied06-SEP 08:30:21 : Source set up completed successfully06-SEP 08:30:21 : start - snapshot_data_correct06-SEP 08:30:21 : start - snapshot_data_correct06-SEP 08:30:21 : start - snapshot_data_correct06-SEP 08:30:21 : Start: split_refresh06-SEP 08:30:21 : Product short name - MRP06-SEP 08:30:21 : MRP schema - MRP06-SEP 08:30:21 : Snapshot name: MRP_FORECAST_DSGN_SN06-SEP 08:30:21 : Refresh mode: ?06-SEP 08:30:22 : Submitted request 5029881, to refresh snapshot: MRP_FORECAST_DSGN_SN06-SEP 08:30:22 : ------------------------------------------------06-SEP 08:30:22 : Snapshot name: MRP_FORECAST_ITEMS_SN06-SEP 08:30:22 : Refresh mode: ?06-SEP 08:30:22 : Submitted request 5029882, to refresh snapshot: MRP_FORECAST_ITEMS_SN06-SEP 08:30:22 : ------------------------------------------------06-SEP 08:30:22 : Snapshot name: MRP_FORECAST_DATES_SN06-SEP 08:30:22 : Refresh mode: ?06-SEP 08:30:22 : Submitted request 5029883, to refresh snapshot: MRP_FORECAST_DATES_SN06-SEP 08:30:22 : ------------------------------------------------

A B C D E F143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197

06-SEP 08:31:22 : Successfully refreshed all snapshots06-SEP 08:31:22 : Snapshots successfully refreshed in parallel mode06-SEP 08:31:22 : Doing a fast refresh of all snapshots...06-SEP 08:31:40 : Successfully refreshed these Snapshots :06-SEP 08:31:40 : MRP.MRP_FORECAST_DSGN_SN,MRP.MRP_FORECAST_ITEMS_SN,MRP.MRP_FORECAST_DATES_SN

9/6/2010 8:319/6/2010 8:319/6/2010 8:319/6/2010 8:319/6/2010 8:31

06-SEP 08:31:40 : Type of Refresh done: FFF06-SEP 08:31:41 : Calling Module: 106-SEP 08:31:41 : Map Region Site during collection : 106-SEP 08:31:41 : Collection refresh type: P06-SEP 08:31:41 : The value of lv_sourcing_flag:2+---------------------------------------------------------------------------+End of log messages from FND_FILE+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+Executing request completion options...

Output is not being printed because:The print option has been disabled for this report.

+------------- 1) PRINT -------------++--------------------------------------+

Finished executing request completion options.

+---------------------------------------------------------------------------+Concurrent request completed successfullyCurrent system time is 06-SEP-2009 08:31:41

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

A B C D E F198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235

Parameters Screen shots

Difference between this and running Complete Refresh for all is that APS Collections Refresh Snapshot Thread launches only for the MRP% snapshots related for forecastsParameters724, 1232724, 1232, 11466, 5029846, 0

1, ALL SNAPSHOTS, 0, 0, 1, P, 1, 21, TST,

nullnullnullnullnullnullnullnullnullnullnullnull

21, v1, M, D, 2, 180, US, 2, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2

G H I J K L M N

1

23

4

5

6

7

8

9

10

11

12

13

14151617

18

19

20

2122232425262728293031

nullnull

4, MRP_FORECAST_DSGN_SN, 0, 2, 1, C, 3, , ,

4, MRP_FORECAST_ITEMS_SN, 0, 2, 1, C, 3, , , 4, MRP_FORECAST_DATES_SN, 0, 2, 1, C, 3, , ,

724, 1232, 11468, 5029846, 021, 180, 3, 2, 2, 25029891, 21, 8568, 180, 2, 2, 1, 25029891, 21, 8568, 180, 2, 2, 1, 25029891, 21, 8568, 180, 2, 2, 1, 2MSC_DEMANDS, TST, 1MSC_SUPPLIES, TST, 121, 1

21, 1011881, 2, 2, 2, 2, 2, , , ,

Parameters

724, 1232

724, 1232, 11466, 5029968, 0

1, ALL SNAPSHOTS, 0, 0, 1, C, 1, 21, TST,

4, MTL_SUPPLY_SN, 0, 2, 1, C, 3, , ,

4, MTL_U_SUPPLY_SN, 0, 2, 1, C, 3, , , 4, MTL_U_DEMAND_SN, 0, 2, 1, C, 3, , , 4, MTL_SYS_ITEMS_SN, 0, 2, 1, C, 3, , , 4, MTL_OH_QTYS_SN, 0, 2, 1, C, 3, , , 2, MTL_MTRX_TMP_SN, 0, 2, 1, C, 3, , , 4, MTL_DEMAND_SN, 0, 2, 1, C, 3, , , 4, BOM_BOMS_SN, 0, 2, 1, C, 3, , ,

4, BOM_INV_COMPS_SN, 0, 2, 1, C, 3, , , Data Pull Parameters and their meaning4, BOM_SUB_COMPS_SN, 0, 2, 1, C, 3, , , If we parse the entry in G53 and match it to the parameters from Planning Data Pull we see the following:4, BOM_OPR_RTNS_SN, 0, 2, 1, C, 3, , , These are the default parameters for Complete Refresh

5029848, 21, 180, US, 3, 860922, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2

5029848, 21, 180, US, 3, 860922, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2

21, -999, 2, 180, US, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 2, 2, 2

G H I J K L M N3233

34

35

36

37

38

3940414243444546

47

4849

50

51

52

53

54

55

56

57585960616263

64

65

66

4, BOM_OPR_SEQS_SN, 0, 2, 1, C, 3, , , Parameter Value Meaning4, BOM_OPR_RESS_SN, 0, 2, 1, C, 3, , , Instance 21 Instance_id4, BOM_SUB_OPR_RESS_SN, 0, 2, 1, C, 3, , , Collection Group -999 All Orgs, otherwise Collection Group name will be shown4, BOM_RES_CHNGS_SN, 0, 2, 1, C, 3, , , Number of Workers 24, BOM_OPR_NETWORKS_SN, 0, 2, 1, C, 3, , , Timeout (Minutes) 1804, MRP_SCHD_DATES_SN, 0, 2, 1, C, 3, , , Language US4, MRP_FORECAST_DSGN_SN, 0, 2, 1, C, 3, , , Delete ODS Data 1 1 = Yes, 2= No4, MRP_FORECAST_ITEMS_SN, 0, 2, 1, C, 3, , , Complete, Net Change, Targeted 1 1 = Complete, 2 = Net Change, 3 = Targeted4, MRP_FORECAST_DATES_SN, 0, 2, 1, C, 3, , , Analyze Staging Tables 2 All the rest of these are 1 = Yes and 2 = No except as noted4, WIP_DSCR_JOBS_SN, 0, 2, 1, C, 3, , , Approved Supplier Lists 14, WIP_WREQ_OPRS_SN, 0, 2, 1, C, 3, , , ATP Rules 14, WIP_FLOW_SCHDS_SN, 0, 2, 1, C, 3, , , BOM/Routings/Resources 14, WIP_WOPRS_SN, 0, 2, 1, C, 3, , , BOR/Bill Of Resources 14, WIP_WOPR_RESS_SN, 0, 2, 1, C, 3, , , Calendars 14, WIP_REPT_ITEMS_SN, 0, 2, 1, C, 3, , , Demand Class 14, WIP_REPT_SCHDS_SN, 0, 2, 1, C, 3, , , End Item Substitutions 14, WIP_WLINES_SN, 0, 2, 1, C, 3, , , Forecasts 14, WIP_WOPR_SUB_RESS_SN, 0, 2, 1, C, 3, , , Items 14, WSM_LJ_OPR_NWK_SN, 0, 2, 1, C, 3, , , KPI Targets (BIS) 14, WSM_LJ_OPRS_SN, 0, 2, 1, C, 3, , , Master Demand Schedule (MDS) 14, WSM_LJ_REQ_OPRS_SN, 0, 2, 1, C, 3, , , Master Prod. Schdule (MPS) 14, WSM_LJ_OPR_RESS_SN, 0, 2, 1, C, 3, , , On Hand 14, MTL_RESERVATIONS_SN, 0, 2, 1, C, 3, , , Planning Parameters 14, PO_SI_CAPA_SN, 0, 2, 1, C, 3, , , Planners 14, PO_ACCEPTANCES_SN, 0, 2, 1, C, 3, , , PO Receipts 24, PO_CHANGE_REQUESTS_SN, 0, 2, 1, C, 3, , , Projects/Tasks 14, OE_ODR_LINES_SN, 0, 2, 1, C, 3, , , Purchasing Reqs (PO) 14, WSH_TRIP_SN, 0, 2, 1, C, 3, , , Reservations 1

4, WSH_TRIP_STOP_SN, 0, 2, 1, C, 3, , , Resource Avail Recalc (NRA)1

4, AHL_SCH_MTLS_SN, 0, 2, 1, C, 3, , , Safety Stock 14, WIP_OPR_RES_INSTS_SN, 0, 2, 1, C, 3, , , Sales Orders 24, WIP_WOPR_NETWORKS_SN, 0, 2, 1, C, 3, , , Sourcing History 22, BOM_RES_INST_CHNGS_SN, 0, 2, 1, C, 3, , , Sourcing Rules 14, WSM_LJ_OPR_RESS_INSTS_SN, 0, 2, 1, C, 3, , , Sub Inventories 14, EAM_WO_RELATIONSHIPS_SN, 0, 2, 1, C, 3, , , Supplier Responses 14, MTL_TXN_REQUEST_LINES_SN, 0, 2, 1, C, 3, , , Suppliers/Customers/Orgs 14, MTL_ITEM_CATS_SN, 0, 2, 1, C, 3, , , Trading Partners (Suppliers) 24, MTL_ITEM_RELATIONSHIPS_SN, 0, 2, 1, C, 3, , , Transportation Details 14, CSP_REPAIR_PO_HEADERS_SN, 0, 2, 1, C, 3, , , Unit Numbers 14, AHL_SCH_MTLS_SN, 0, 2, 1, C, 3, , , Unit of Measures (UOM) 1

User Company Association 1

User Supplies and Demands 1

724, 1232, 11468, 5029968, 0 Work in Process (WIP) 1

21, 180, 3, 2, 2, 2 Sales Channel 2

1 = Collect Existing Data2 = Do Not Collect Data3 = Regenerate and Collect Data

5029970, 21, 180, US, 1, 860923, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1


5029970, 21, 180, US, 1, 860923, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1

G H I J K L M N67686970717273747576777879808182838485868788899091929394

95

96979899100101102103104105106

107

108

109

110

21 Fiscal Calendar 221 Payback Demand/Supply 2

5030045, 21, 8569, 180, 2, 2, 1, 2

5030045, 21, 8569, 180, 2, 2, 1, 2

5030045, 21, 8569, 180, 2, 2, 1, 2MSC_DEMANDS, TST, 1MSC_SUPPLIES, TST, 121, 1

21, 1011881, 1, 1, 1, 1, 1, 2, 2, 2, 2

Parameters724, 363724, 363, 10055, 5150279, 0

1, ALL SNAPSHOTS, 0, 0, 1, I, 1, 21, TST,

724, 363, 10057, 5150279, 021, 60, 3, 2, 2, 2

2121

5150298, 21, 8807, 60, 2, 2, 2, 25150298, 21, 8807, 60, 2, 2, 2, 25150298, 21, 8807, 60, 2, 2, 2, 221, 121, 1011881, 1, 1, 1, 2, 2, , , ,

21,-999, 2, 30, US, 1, 2, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 1, 1, 1

5150282, 21, 30, US, 2, 874831, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 2

5150282, 21, 30, US, 2, 874831, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 2

G H I J K L M N111112113

114

115116117118

119

120

121

122123124125

126

127

128

129

130131132133134135136137138139140

141

142

11.5.10 with Collections Rollup #30 appliedaps.us.oracle.com

See Column I line 73 for explanation of the parameters passed to Planning Data Pull

Launch of Targeted Collections - only for ForecastsIn 11.5.10, the Refresh Snapshots process is the same when you launch Targeted or Complete Refresh, but overall processing time for rest of the request set is much faster with Targeted.Request ID Shortname Program Name Phase Status Support Comment Parameters

4054668 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C C 724, 12324054669 FNDRSSTG Planning Data Pull (Request Set Stage) C C 724, 1232, 11466, 4054668

4054670 MSCPDPPlanning Data Pull C C

4054671 MSRFWOR Refresh Collection Snapshots C C 1, ALL SNAPSHOTS, 0, 0, 1, P, 1, 21, TST,


null4054673 MSCWSMSN Create WSM Snapshots C C null4054674 MSCBOMSN Create BOM Snapshots C C null4054675 MSCINVSN Create INV Snapshots C C null4054676 MSCMRPSN Create MRP Snapshots C C null4054677 MSCPOXSN Create PO Snapshots C C null4054678 MSCONTSN Create OE Snapshots C C null4054679 MSCWSHSN Create WSH Snapshots C C null4054680 MSCAHLSN Create AHL Snapshots C C null4054681 MSCWIPSN Create WIP Snapshots C C null4054682 MSCSYNMS Collections Synonyms C C null4054683 MSCVIEWS Collections Views C C null4054684 MSCTRIGS Collections Triggers C C null



4054690 FNDRSSTG Planning ODS Load (Request Set Stage) C C 724, 1232, 11468, 40546684054691 MSCPDC Planning ODS Load C C 21, 180, 3, 2, 2, 24054692 MSCPDCW Planning ODS Load Worker C C 4054691, 21, 6728, 180, 2, 2, 1, 24054693 MSCPDCW Planning ODS Load Worker C C 4054691, 21, 6728, 180, 2, 2, 1, 24054694 MSCPDCW Planning ODS Load Worker C C 4054691, 21, 6728, 180, 2, 2, 1, 24054695 MSCPDCP Planning Data Collection - Purge Staging Tables C C 21, 1

4054696 MSCXPUBO Collaboration ODS Load C C 21, 1007959, 2, 2, 2, 2, 2, , , ,

Setup requestsStarting on Line 18 - Launched Targeted Refresh of Forecasts to capture the Setup Requests launched when MSC: Source Setup Required = Y (or Yes in R12.x)

Setup Request Log File

Targeted Refresh Starting on line 11 - launched targeted refresh of forecasts to get launch of Setups reqeusts

Complete RefreshStarting on Line 41 - Launched Complete Refresh and used the default parameters - See Column H for screen shots of the parameters

Parameters screen shots in Column HParameters explained

In a distributed installation where EBS Source and APS destination are on separate instances, these requests will launch on the EBS Source Instance


21,-999, 2, 180, US, 2, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2


4054670, 21, 180, US, 3, 861013, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2

4054670, 21, 180, US, 3, 861013, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2


A B C D E F G H

1

23

4

5

6

7

8

9

10

11

12131415

16

17

18

192021222324252627282930

31

32

333435363738

39

Complete Refresh of Planning Data Collections with Default ParametersRequest ID Shortname Program Name Phase Status Parameters

4054717 MSCPDX Planning Data Collection (Request Set Planning Data Collection) C G 724, 1232

4054718 FNDRSSTG Planning Data Pull (Request Set Stage) C C 724, 1232, 11466, 4054717


4054720 MSRFWOR Refresh Collection Snapshots C C 1, ALL SNAPSHOTS, 0, 0, 1, C, 1, 21, TST,



4054728 FNDRSSTG Planning ODS Load (Request Set Stage) C G 724, 1232, 11468, 4054717

4054729 MSCPDC Planning ODS Load C G 21, 180, 3, 1, 2, 2

4054732 MSCPDCW Planning ODS Load Worker C C 4054729, 21, 6729, 180, 1, 2, 1, 24054733 MSCPDCW Planning ODS Load Worker C C 4054729, 21, 6729, 180, 1, 2, 1, 24054734 MSCPDCW Planning ODS Load Worker C C 4054729, 21, 6729, 180, 1, 2, 1, 24054740 MSCPDCP Planning Data Collection - Purge Staging Tables C C 21, 1

4054741

MSCXPUBO Collaboration ODS Load C C 21, 1007959, 1, 1, 1, 1, 1, 2, 2, 2, 2

Setup Requests - Refresh Collection Snapshots log file example:+---------------------------------------------------------------------------+Master Scheduling/MRP: Version : 11.5.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. MSRFWOR module: Refresh Collection Snapshots+---------------------------------------------------------------------------+ Current system time is 25-JUN-2010 06:21:33 +---------------------------------------------------------------------------+ **Starts**25-JUN-2010 06:21:34

**Ends**25-JUN-2010 06:31:40

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

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+The degree of parallelism for Refreshing snapshots is set to: 0

Request : 4759440 :Checks for Snapshots which have changed and Drops them

Request : 4759441 :Creates WSM Snapshot Logs and Snapshots

Request : 4759442 :Creates BOM Snapshot Logs and Snapshots

Request : 4759443 :Creates INV Snapshot Logs and Snapshots


21, -999, 2, 180, US, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2

4054719, 21, 180, US, 1, 861014, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1

4054719, 21, 180, US, 1, 861014, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1




A B C D E F G H40

41

42

43

44

45

46

47

48

49

50

51525354

55

565758

59

60616263646566676869707172

73

74

75

767778

79

80

81

Request : 4759444 :Creates MRP Snapshot Logs and Snapshots

Request : 4759445 :Creates PO Snapshot Logs and Snapshots

Request : 4759446 :Creates OE Snapshot Logs and Snapshots

Request : 4759447 :Creates WSH Snapshot Logs and Snapshots

Request : 4759448 :Creates AHL Snapshot Logs and Snapshots

Request : 4759452 :Creates WIP Snapshot Logs and Snapshots

Request : 4759454 :Creates Synonyms used by Collections Process

Request : 4759456 :Creates Views used by Collections Process

Request : 4759457 :Creates Triggers used by Collections Process

Updating Profile Option MSC_SOURCE_SETUP to No

Profile Option MSC_SOURCE_SETUP has been updated No

The Value No indicates that the Collection Setup Objects have been applied

Master Table = MTL_SUPPLY

Master Table = MTL_USER_SUPPLY

Master Table = MTL_USER_DEMAND

Master Table = MTL_SYSTEM_ITEMS_B

Master Table = MTL_ONHAND_QUANTITIES_DETAIL

Master Table = MTL_MATERIAL_TRANSACTIONS_TEMP

Master Table = MTL_DEMAND

Master Table = BOM_STRUCTURES_B

Master Table = BOM_COMPONENTS_B

Master Table = BOM_SUBSTITUTE_COMPONENTS

Master Table = BOM_OPERATIONAL_ROUTINGS

Master Table = BOM_OPERATION_SEQUENCES

Master Table = BOM_OPERATION_RESOURCES

Master Table = BOM_SUB_OPERATION_RESOURCES

Master Table = BOM_RESOURCE_CHANGES

Master Table = BOM_OPERATION_NETWORKS

Master Table = MRP_SCHEDULE_DATES

Master Table = MRP_FORECAST_DESIGNATORS

Master Table = MRP_FORECAST_ITEMS

Master Table = MRP_FORECAST_DATES

Master Table = WIP_DISCRETE_JOBS

Master Table = WIP_REQUIREMENT_OPERATIONS

Master Table = WIP_FLOW_SCHEDULES

Master Table = WIP_OPERATIONS

Master Table = WIP_OPERATION_RESOURCES

Master Table = WIP_REPETITIVE_ITEMS

Master Table = WIP_REPETITIVE_SCHEDULES

Master Table = WIP_LINES

Master Table = WIP_SUB_OPERATION_RESOURCESMaster Table = WSM_COPY_OP_NETWORKSMaster Table = WSM_COPY_OPERATIONSMaster Table = WSM_COPY_REQUIREMENT_OPSMaster Table = WSM_COPY_OP_RESOURCESMaster Table = MTL_RESERVATIONSMaster Table = PO_SUPPLIER_ITEM_CAPACITYMaster Table = PO_ACCEPTANCESMaster Table = PO_CHANGE_REQUESTSMaster Table = OE_ORDER_LINES_ALLMaster Table = WSH_TRIPS

A B C D E F G H82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122123124125126127128129130131132

Master Table = WSH_TRIP_STOPSMaster Table = MTL_TXN_REQUEST_LINESMaster Table = WIP_OP_RESOURCE_INSTANCESMaster Table = BOM_RES_INSTANCE_CHANGESMaster Table = WSM_COPY_OP_RESOURCE_INSTANCESMaster Table = MTL_ITEM_CATEGORIESMaster Table = AHL_SCHEDULE_MATERIALSSuccessfully refreshed these Snapshots :MTL_SUPPLY_SN,MTL_U_SUPPLY_SN,MTL_U_DEMAND_SN,MTL_SYS_ITEMS_SN,MTL_OH_QTYS_SN,MTL_MTRX_TMP_SN,MTL_DEMAND_SN,BOM_BOMS_SN,BOM_INV_COMPS_SN,BOM_SUB_COMPS_SN,BOM_OPR_RTNS_SN,BOM_OPR_SEQS_SN,BOM_OPR_RESS_SN,BOM_SUB_OPR_RESS_SN,BOM_RES_CHNGS_SN,BOM_OPR_NETWORKS_SN,MRP_SCHD_DATES_SN,MRP_FORECAST_DSGN_SN,MRP_FORECAST_ITEMS_SN,MRP_FORECAST_DATES_SN,WIP_DSCR_JOBS_SN,WIP_WREQ_OPRS_SN,WIP_FLOW_SCHDS_SN,WIP_WOPRS_SN,WIP_WOPR_RESS_SN,WIP_REPT_ITEMS_SN,WIP_REPT_SCHDS_SN,WIP_WLINES_SN,WIP_WOPR_SUB_RESS_SN,WSM_LJ_OPR_NWK_SN,WSM_LJ_OPRS_SN,WSM_LJ_REQ_OPRS_SN,WSM_LJ_OPR_RESS_SN,MTL_RESERVATIONS_SN,PO_SI_CAPA_SN,PO_ACCEPTANCES_SN,PO_CHANGE_REQUESTS_SN,OE_ODR_LINES_SN,WSH_TRIP_SN,WSH_TRIP_STOP_SN,MTL_TXN_REQUEST_LINES_SN,WIP_OPR_RES_INSTS_SN,BOM_RES_INST_CHNGS_SN,WSM_LJ_OPR_RESS_INSTS_SN,MTL_ITEM_CATS_SN,AHL_SCH_MTLS_SNType of Refresh done: ????CC?????C???????????????C??????????CC??????Populating Flow Demand, Complete Refresh Flow: 1.6 Minutes Elapsed.Exploding SMC demand, LRN: 3270011510 sourceValue of p_lrn is :32700.1 Minutes Elapsed.Calling Module: 1Map Region Site during collection : 1Collection refresh type: CThe value of lv_sourcing_flag:1before calling MRP_MAP_REG_SITE.MAP_REGION_TO_SITECalling function MAP_REGION_TO_SITE with max_lrd:30-APR-10Time consumed for calling map_region_to_site:.1after calling MRP_MAP_REG_SITE.MAP_REGION_TO_SITE+---------------------------------------------------------------------------+End of log messages from FND_FILE+---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+Executing request completion options... Output is not being printed because:The print option has been disabled for this report. +------------- 1) PRINT -------------++--------------------------------------+ Finished executing request completion options. +---------------------------------------------------------------------------+Concurrent request completed successfullyCurrent system time is 25-JUN-2010 06:31:43 +---------------------------------------------------------------------------+

A B C D E F G H133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192

Parameters Screen Shots

I J K L M

1

23

4

5

6

7

8

9

10

11

12131415

16

17

18

192021222324252627282930

31

32

333435363738

39

Data Pull Parameters and their meaningIf we parse the entry in G53 and match it to the parameters from Planning Data Pull we see the following:These are the default parameters for Complete RefreshParameter Value Meaning

Instance 21 Instance_id

Collection Group -999 All Orgs, otherwise Collection Group name will be shown

Number of Workers 2

Timeout (Minutes) 180

I J K L M40

41

42

43

44

45

46

47

48

49

50

51525354

55

565758

59

60616263646566676869707172

73

74

75

767778

79

80

81

Language US

Delete ODS Data 1 1 = Yes, 2= No

Complete, Net Change, Targeted 1 1 = Complete, 2 = Net Change, 3 = Targeted

Analyze Staging Tables 2 All the rest of these are 1 = Yes and 2 = No except as noted

Approved Supplier Lists 1

ATP Rules 1

BOM/Routings/Resources 1

BOR/Bill Of Resources 1

Calendars 1

Demand Class 1

End Item Substitutions 1

Forecasts 1

Items 1

KPI Targets (BIS) 1

Master Demand Schedule (MDS) 1

Master Prod. Schdule (MPS) 1

On Hand 1

Planning Parameters 1

Planners 1

Projects/Tasks 1

Purchasing Reqs (PO) 1

Reservations 1

Resource Avail Recalc (NRA) 1

Safety Stock 1

Sales Orders 2

Sourcing History 2

Sourcing Rules 1

Sub Inventories 1

Supplier Responses 1

Suppliers/Customers/Orgs 1

Trading Partners (Suppliers) 2

Transportation Details 1

Unit Numbers 1

Unit of Measures (UOM) 1

User Company Association 1

User Supplies and Demands 1

Work in Process (WIP) 1

Sales Channel 2

Fiscal Calendar 2

Payback Demand/Supply 2

Currency Conversion 2


I J K L M82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122123124125126127128129130131132


We have hidden and defaulted most all parameters in ATP Data Collections -- this means that the flag to Yes/No have been set automatically for the parameters you see in ASCP Data Collections

Using 12.1.1 paraemters shown below for ASCP Data Collections we are showing here what is preset for each parameter

In 12.0 and 11.5.10 we only Launch a single Refresh request for all snapshotsIn 12.1.1 we see child requests for refreshing single snapshots as part of our performance improvements for collections

Table starting In H59 - we show how the parameters are parsed and sent to data collections code to collect the data. Note that any value set to Yes, which cannot be collected in Net Change is simply ignored.AND you can use Parameters shown in that table - Column K to run Standard Collections to mimic ATP Data Collections

Net Change CollectionsRequest ID Shortname Program Name Phase Status Parameters

5850655 FNDRSSUB ATP Data Collection (Report Set) C E 724, 3635850657 FNDRSSTG Pull Data (Request Set Stage) C C 724, 363, 10055, 5850655, 05850658 MSCATPDP ATP Data Pull C C 2061, -999, 2, 30, US, 1, 2, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 1, 1, 15850659 MSRFWOR Refresh Collection Snapshots C C 1, COLL SNAPSHOTS, 0, 0, 1, I, 1, 2061, TST, 5850660 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, AHL_SCH_MTLS_SN, 2, 176605, 05850661 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_BOMS_SN, 2, 176605, 05850662 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_INV_COMPS_SN, 2, 176605, 05850663 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_NETWORKS_SN, 2, 176605, 05850664 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RESS_SN, 2, 176605, 05850665 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RTNS_SN, 2, 176605, 05850666 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_SEQS_SN, 2, 176605, 05850667 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_CHNGS_SN, 2, 176605, 05850668 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_INST_CHNGS_SN, 2, 176605, 05850669 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_COMPS_SN, 2, 176605, 05850670 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_OPR_RESS_SN, 2, 176605, 05850671 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, CSP_REPAIR_PO_HEADERS_SN, 2, 176605, 05850672 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, EAM_WO_RELATIONSHIPS_SN, 2, 176605, 05850673 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_SCHD_DATES_SN, 2, 176605, 05850674 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_CATS_SN, 2, 176605, 05850675 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_RELATIONSHIPS_SN, 2, 176605, 05850676 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_MTRX_TMP_SN, 2, 176605, 05850677 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_OH_QTYS_SN, 2, 176605, 05850678 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_RESERVATIONS_SN, 2, 176605, 05850679 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SUPPLY_SN, 2, 176605, 05850680 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SYS_ITEMS_SN, 2, 176605, 05850681 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_TXN_REQUEST_LINES_SN, 2, 176605, 05850682 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_DEMAND_SN, 2, 176605, 05850683 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_SUPPLY_SN, 2, 176605, 05850684 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, OE_ODR_LINES_SN, 2, 176605, 05850685 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_DSCR_JOBS_SN, 2, 176605, 05850686 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_FLOW_SCHDS_SN, 2, 176605, 05850687 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_OPR_RES_INSTS_SN, 2, 176605, 05850688 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_ITEMS_SN, 2, 176605, 05850689 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_SCHDS_SN, 2, 176605, 05850690 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WLINES_SN, 2, 176605, 05850691 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPRS_SN, 2, 176605, 05850692 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_NETWORKS_SN, 2, 176605, 0

A B C D E F

1

2

3

4

5

6

7

8

9

10

11

12

131415161718192021222324252627282930313233343536373839404142434445464748495051525354

5850693 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_RESS_SN, 2, 176605, 05850694 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_SUB_RESS_SN, 2, 176605, 05850695 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WREQ_OPRS_SN, 2, 176605, 05850696 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPRS_SN, 2, 176605, 0

5850697 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_NWK_SN, 2, 176605, 0

5850698 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_INSTS_SN, 2, 176605, 0

5850699 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_SN, 2, 176605, 0

5850700 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_REQ_OPRS_SN, 2, 176605, 0

5850701 MSCPDPW Planning Data Pull Worker C C 5850658, 2061, 30, US, 2, 1101904, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 25850702 MSCPDPW Planning Data Pull Worker C C 5850658, 2061, 30, US, 2, 1101904, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 2

5850703 FNDRSSTG Collect Data (Request Set Stage) C E 724, 363, 10057, 5850655, 05850704 MSCPDC Planning ODS Load C E 2061, 60, 3, 2, 2, 25850705 MSCITTK Generate Items and Category Sets Keys C C 20615850706 MSCTPTK Generate Trading Partner Keys C C 2061

5850707 MSCPDCW Planning ODS Load Worker C E 5850704, 2061, 8996, 60, 2, 2, 2, 25850708 MSCPDCW Planning ODS Load Worker C E 5850704, 2061, 8996, 60, 2, 2, 2, 25850709 MSCPDCW Planning ODS Load Worker C E 5850704, 2061, 8996, 60, 2, 2, 2, 25850710 MSCXPUBO Collaboration ODS Load C C 2061, 1013615, 1, 1, 2, 2, 2, , , ,

Complete CollectionsRequest ID Shortname Program Name Phase Status Parameters

5850718 FNDRSSUB ATP Data Collection (Report Set) C C 724, 3635850719 FNDRSSTG Pull Data (Request Set Stage) C C 724, 363, 10055, 5850718, 05850720 MSCATPDP ATP Data Pull C C 2061, -999, 2, 30, US, 1, 1, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 2, 1, 1, 2, 2, 1, 1, 1, 15850721 MSRFWOR Refresh Collection Snapshots C C 1, COLL SNAPSHOTS, 0, 0, 1, C, 1, 2061, TST, 5850722 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_BOMS_SN, 2, 176606, 05850723 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_INV_COMPS_SN, 2, 176606, 05850724 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_NETWORKS_SN, 2, 176606, 05850725 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RESS_SN, 2, 176606, 05850726 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_RTNS_SN, 2, 176606, 05850727 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_OPR_SEQS_SN, 2, 176606, 05850728 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_CHNGS_SN, 2, 176606, 05850729 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_RES_INST_CHNGS_SN, 2, 176606, 05850730 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_COMPS_SN, 2, 176606, 05850731 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, BOM_SUB_OPR_RESS_SN, 2, 176606, 05850732 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, CSP_REPAIR_PO_HEADERS_SN, 2, 176606, 05850733 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, EAM_WO_RELATIONSHIPS_SN, 2, 176606, 05850734 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MRP_SCHD_DATES_SN, 2, 176606, 0

5850735 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_CATS_SN, 2, 176606, 05850736 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_ITEM_RELATIONSHIPS_SN, 2, 176606, 05850737 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_MTRX_TMP_SN, 2, 176606, 05850738 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_OH_QTYS_SN, 2, 176606, 05850739 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SUPPLY_SN, 2, 176606, 05850740 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_SYS_ITEMS_SN, 2, 176606, 05850741 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_TXN_REQUEST_LINES_SN, 2, 176606, 05850742 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_DEMAND_SN, 2, 176606, 05850743 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, MTL_U_SUPPLY_SN, 2, 176606, 05850744 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_DSCR_JOBS_SN, 2, 176606, 05850745 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_FLOW_SCHDS_SN, 2, 176606, 05850746 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_OPR_RES_INSTS_SN, 2, 176606, 05850747 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_ITEMS_SN, 2, 176606, 0

A B C D E F55565758

59

60

61

62

63

64

65

666768

69

7071727374757677787980818283848586878889909192

93

949596979899

100101102103104105

5850748 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_REPT_SCHDS_SN, 2, 176606, 0

5850749 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WLINES_SN, 2, 176606, 05850750 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPRS_SN, 2, 176606, 05850751 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_NETWORKS_SN, 2, 176606, 05850752 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_RESS_SN, 2, 176606, 05850753 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WOPR_SUB_RESS_SN, 2, 176606, 05850754 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WIP_WREQ_OPRS_SN, 2, 176606, 05850755 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPRS_SN, 2, 176606, 05850756 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_NWK_SN, 2, 176606, 05850757 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_INSTS_SN, 2, 176606, 05850758 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_OPR_RESS_SN, 2, 176606, 05850759 MSCCLRFS APS Collections Refresh Snapshot Thread C C 1, WSM_LJ_REQ_OPRS_SN, 2, 176606, 05850761 MSCPDPW Planning Data Pull Worker C C 5850720, 2061, 30, US, 1, 1101905, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 25850762 MSCPDPW Planning Data Pull Worker C C 5850720, 2061, 30, US, 1, 1101905, 2, 1, 1, 2, 1, 1, 2, 2, 1, 2, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 1, 1, 1, 2, 1, 1, 1, 2, 1, 2, 25850763 FNDRSSTG Collect Data (Request Set Stage) C C 724, 363, 10057, 5850718, 05850764 MSCPDC Planning ODS Load C C 2061, 60, 3, 2, 2, 25850766 MSCITTK Generate Items and Category Sets Keys C C 20615850767 MSCTPTK Generate Trading Partner Keys C C 20615850769 MSCPDCW Planning ODS Load Worker C C 5850764, 2061, 8997, 60, 2, 2, 1, 25850770 MSCPDCW Planning ODS Load Worker C C 5850764, 2061, 8997, 60, 2, 2, 1, 25850771 MSCPDCW Planning ODS Load Worker C G 5850764, 2061, 8997, 60, 2, 2, 1, 25850772 MSCCLMISC APS Collections Miscellaneous Task C C MSC_CL_OTHER_ODS_LOAD, PURGE_STALE_CURRENCY_CONV, 5850773 MSCCLMISC APS Collections Miscellaneous Task C C MSC_PHUB_PKG, REFRESH_MVS, 15850774 MSCCLMISC APS Collections Miscellaneous Task C C MSC_WS_OTM_BPEL, PURGETRANSPORTATIONUPDATES, 5850775 MSCALTBL Alter Temporary ODS Tables C C MSC_DEMANDS, TST, 15850776 MSCALTBL Alter Temporary ODS Tables C C MSC_SUPPLIES, TST, 15850777 MSCPDCP Planning Data Collection - Purge Staging Tab C C 2061, 15850778 MSCXPUBO Collaboration ODS Load C C 2061, 1013615, 1, 1, 1, 1, 1, 2, 2, 2, 2

A B C D E F

106

107108109110111112113114115116117118119120121122123124125126127128129130131132133

Table starting In H59 - we show how the parameters are parsed and sent to data collections code to collect the data. Note that any value set to Yes, which cannot be collected in Net Change is simply ignored.

G H I J K

1

2

3

4

5

6

7

8

9

10

11

12

131415161718192021222324252627282930313233343536373839404142434445464748495051525354

ATP Data Pull Parameters and their meaningIf we parse the entry in F16 and match it to the parameters from ATP Data Pull we see the following:These are how we default the parameters for ATP Data Collections using the preset parametersIf you run Net Change and have any parameter set to Yes that we cannot collect in Net Change Mode, it is simply ignored.

Parameter Value Meaning

Instance 2061 Instance_id Instance code will default

Collection Group -999 Use All OrgsNumber of Workers 2 2-4 workersTimeout (Minutes) 30 default is 180, this is fineLanguage US per your setups

Purge Previous Collected Data 1 1 = Yes, 2= NoComplete/Net Change Collection 2 1 = Complete, 2 = Net Change Choose Complete, Targeted or Net ChangeAnalyze Staging Tables 2 All the rest of these are 1 = Yes and 2 = No NoApproved Supplier Capacities 2 NoATP Rules 1 YesBOM/Routings/Resources 1 NoBOR/Bill Of Resources 2 YesCalendars 1 YesDemand Class 1 NoEnd Item Substitutions 2 NoForecasts 2 YesItems 1 YesKPI Targets (BIS) 2 NoMaster Demand Schedule (MDS) 2 NoMaster Prod. Schedule (MPS) 1 YesOn Hand 1 YesPlanning Parameters 2 NoPlanners 2 NoPO Receipts 2 NoProjects/Tasks 2 NoPurchase Requisitions (PO) 1 YesReservations 2 NoResource Avail Recalc (NRA) 2 NoSafety Stock 2 No

Sales Orders 2

Sourcing History 2 NoSourcing Rules 1 YesSub Inventories 1 YesSupplier Responses 2 NoTrading Partners (Customers) 1 YesTrading Partners (Suppliers) 1 YesTransportation Details 2 NoUnit Numbers 2 NoUnits of Measure (UOM) 1 YesUser Company Association 1 NoUser Supplies and Demands 1 YesWork In Process (WIP) 1 Yes

Parameters to Use if running Standard Collections to mimic ATP Data Collections

All Orgs, otherwise Collection Group name will be shown

Yes for Complete RefreshNo to use Net change or Targeted Refresh

Sales order will always be collected in Net Change mode unless specifically set to yes.

No for Complete will collect sales order in Net Change ModeWill default to Yes in Net change mode (cannot change)

G H I J K55565758

59

60

61

62

63

64

65

666768

69

7071727374757677787980818283848586878889909192

93

949596979899

100101102103104105

Set NO for any parameter not listedFor ODS Load, paramerters setInastance Code will defaultset 3 -4 workersTime out default of 60 is fineSet NO for all other parameters in ODS Load

G H I J K

106

107108109110111112113114115116117118119120121122123124125126127128129130131132133

Entity MappingThis table maps the tables, snapshots and views used to move the data from Source to DestinationNotations in the table:View names in italicsPartitioned tables are underlinedSuperscript suffix # indicates 12.0.x changeSuperscript suffix $ indicates 12.1 change

Entity Data Pull Parameter

ASL

ATP Rules ATP Rules

Items Items

End Item Substitutions End Item Substitutions

Reservations Reservations

Demand Classes Demand Classes

Bom

Approved Supplier Lists (Supplier Capacities)

Bill of Materials/Routing/ Resources

Bom

Resource

Routings




Routings

BOR Bills of Resource

Calendars Calendars

Fiscal Calender Fiscal Calender

Forecasts Forecasts

MPS Master Production Schedules


KPI Targets

MDS MDS

On Hand On Hand

Planning Parameters Planning ParametersPlanners Planners

PO Receipts PO Receipts

Projects Tasks Projects Tasks

Sales Channel Sales Channel

Resource Avalability Resource Avalability

Purchase Orders/ Purchase Requisitions

Key Performance Indicator Targets



Safety Stocks Safety Stocks

Sales Orders Sales Orders

Sourcing History Sourcing History

Sub inventories Sub inventories

Supplier Response Supplier Response

Sourcing Rules Sourcing Rules


Suppliers Suppliers/Customers/Orgs

Customers Suppliers/Customers/Orgs

Orgs Suppliers/Customers/Orgs

Carriers Suppliers/Customers/Orgs

Transportation Details Transportation Details

WIP Work in Process

WIP Work in Process

User Supplies and Demands User Supplies and Demands

WIP - OSFM - Shop Floor Management Work in Process

WIP - OSFM - Shop Floor Management Work in Process

Transportation Details Transportation Details

Unit Numbers Unit Numbers

UOM Units of Measure

User Company Associations User Company Associations

User Supplies and Demands User Supplies and Demands

Internal Repair Orders

External Repair Orders

Payback Demand/Supply Payback Demand/Supply

Currency Conversion

Framework n/a

Legacy collection key generator n/a

Internal Repair Orders $

External Repair Orders $

Currency Conversion $

This table maps the tables, snapshots and views used to move the data from Source to Destination

Source side (ERP) tables

PO_APPROVED_SUPPLIER_LIST

YPO_ASL_ATTRIBUTESPO_SUPPLIER_ITEM_CAPACITYpo_approved_supplier_lis_val_vMTL_ATP_RULES N

MTL_SYSTEM_ITEMS,

Y

MTL_ITEM_CATEGORIESMTL_CATEGORYMTL_CATEGORY_SETMTL_CATEGORY_SET_VALID_CATS

MTL_RELATED_ITEMS

MTL_ABC_CLASSESMTL_ABC_CLASS_ASSIGNMENTS

MTL_ABC_ASSIGNMENT_GROUPSCST_ITEM_COSTSMTL_RELATED_ITEMS

MTL_RELATED_ITEMS_PLN_INFO

MTL_RELATED_ITEMS_CUST_REF

MTL_RESERVATIONS

Y

N

Y

BOM_SETUP_TRANSITIONSBOM_STANDARD_OPERATIONS

Collected in Net Change

Y$

MTL_ITEM_RELATIONSHIPS_SN $

FND_COMMON_LOOKUPS (lookuptype= DEMAND_CLASS)BOM_STRUCTURES_B; BOM_COMPONENTS_B; BOM_COMPONENT_OPERATIONS

BOM_INVENTORY_COMPONENTS (view)

BOM_SETUP_TYPESY

BOM_DEPARTMENT_RESOURCESBOM_STD_OP_RESOURCES

BOM_RESOURCES

Y

BOM_DEPARTMENTSCRP_SIMULATION_SETSWSM_COPY_OP_RESOURCESBOM_RESOURCE_SETUPSBOM_RESOURCE_EQUIPMENTS

BOM_OPERATIONAL_ROUTINGS

Y

BOM_OPERATION_SEQUENCESBOM_OPERATION_RESOURCESBOM_SUB_OPERATION_RESOURCESBOM_OPERATION_NETWORKSBOM_RES_INSTANCE_CHANGES

Y

CRP_BILLS_OF_RESOURCESY

CRP_RESOURCE_HOURSBOM_CALENDARS

Y

BOM_CALENDAR_DATES

BOM_CALENDAR_SHIFTSBOM_CALENDAR_EXCEPTIONSBOM_PERIOD_START_DATESBOM_CAL_YEAR_START_DATESBOM_CAL_WEEK_START_DATESBOM_WORK_DAY_PATTERNSBOM_RESOURCE_SHIFTSBOM_RESOURCE_CHANGESBOM_RES_INSTANCE_CHANGESBOM_SHIFT_DATESBOM_SHIFT_TIMESBOM_SHIFT_EXCEPTIONSWSH_CALENDAR_ASSIGNMENTSWSH_CARRIER_SERVICESPO_ASL_ATTRIBUTESMTL_PARAMETERSGL_PERIODS N

MRP_SCHEDULE_DATES

YMRP_FORECAST_DESIGNATORSMRP_FORECAST_DATESMRP_FORECAST_ITEMSPJM_PROJECT_PARAMETERS

MRP_SCHEDULE_DATES

Y

GL_PERIODS

NBIS_INDICATORS_VLBIS_TARGET_LEVELS_VLBIS_TARGET_VALUES_VBIS_BUSINESS_PLANS_VL

MRP_SCHEDULE_DATES

YMRP_FORECAST_DESIGNATORSMRP_FORECAST_DATESOE_ORDER_LINES_ALLMTL_ONHAND_QUANTITIES_DETAIL

Y

MTL_ONHAND_QUANTITIES (view)MTL_ITEM_LOCATIONS

MTL_LOT_NUMBERSMTL_SERIAL_NUMBERMRP_PARAMETERS N

MTL_PLANNERS N

RCV_SHIPMENT_LINES N

PA_PROJECTS_ALLN

PA_TASKS

N (lookuptype= SALES_CHANNEL)

Y

MTL_SUPPLY

Y

PO_HEADERS_ALLPO_LINES_ALLPO_LINE_LOCATIONS_ALLPO_DISTRIBUTIONS_ALLPO_RELEASES_ALL

RCV_SHIPMENT_HEADERSRCV_SHIPMENT_LINES

FND_COMMON_LOOKUPS (SO_LOOKUPS)

RCV_TRANSACTIONSY

PO_REQUISITION_HEADERS_ALLPO_REQUISITION_LINES_ALLPO_REQ_DISTRIBUTIONS_ALL

WSH_DELIVERY_DETAILSWSH_DELIVERY_LEGSWSH_TRIPS, WSH_TRIP_STOPSMTL_SAFETY_STOCKS Y

Y

AHL_SCHEDULE_MATERIALSMTL_DEMANDSMTL_RESERVATIONS

MTL_MATERIAL_TRANSACTIONSNRCV_SHIPMENT_LINES

RCV_TRANSACTIONSMTL_SECONDARY_INVENTORIES

N

PO_CHANGE_REQUESTSy

PO_ACCEPTANCESMRP_ASSIGNMENT_SETS

N

MRP_SR_ASSIGNMENTSMRP_SOURCING_RULESMRP_SR_RECEIPT_ORGMRP_SR_SOURCE_ORGMTL_INTERORG_SHIP_METHODSWSH_REGIONSWSH_ZONE_REGIONSMRP_REGION_SITESWSH_REGION_LOCATIONSWSH_CARRIERSWSH_CARRIER_SERVICES

OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL

PO_VENDORS

N

PO_VENDORS_VIEWPO_VENDOR_SITES_ALLPO_VENDOR_CONTACTSHR_ALL_ORGANIZATION_UNITS_TLAP_SUPPLIERSAP_SUPPLIER_CONTACTSAP_SUPPLIER_SITES_ALLHZ_PARTY_SITES

N

HZ_PARTIES (R12)HZ_CUST_ACCT_SITES_ALLHZ_CUST_SITE_USES_ALLHZ_CUST_ACCOUNTSHZ_LOCATIONSHZ_PARTY_SITESHZ_CUST_ACCOUNT_ROLESHZ_RELATIONSHIPSHR_ALL_ORGANIZATION_UNITS

N

HR_LOCATIONSHR_ALL_ORGANIZATION_UNITSMTL_PARAMETERSBOM_PARAMETERSMRP_ORG_DEFINITIONS_V…..

.

WSH_TRIPS

YWSH_TRIP_STOPS

Y

RA_CUSTOMERS view (11i)

Y

WIP_ENTITIES,WIP_DISCRETE_JOBS,WIP_REPETITIVE_SCHEDULESWIP_FLOW_SCHEDULES

WIP_OPERATIONS

WIP_OPERATION_RESOURCES

WIP_SUB_OPERATION_RESOURCESWIP_REQUIREMENT_OPERATIONS

MTL_USER_DEMAND

YMTL_USER_SUPPLY

WIP_ENTITIES,WIP_DISCRETE_JOBS,WIP_REPETITIVE_SCHEDULESWIP_FLOW_SCHEDULESWIP_OPERATIONSWIP_OPERATION_RESOURCESWIP_SUB_OPERATION_RESOURCESWIP_REQUIREMENT_OPERATIONSWIP_SCHEDULE_GROUPS

WIP_SCHEDULE_GROUPS

WSM_COPY_OP_NETWORKS WSM_COPY_OPERATIONS

WSM_COPY_REQUIREMENT_OPS

WSH_TRIPS

YWSH_TRIP_STOPS

PJM_UNIT_NUMBERS Y

MTL_UNITS_OF_MEASURE

YMTL_UOM_CLASS_CONVERSIONSMTL_UOM_CONVERSIONS

N

Y

FND_USERHZ_PARTIESPO_VENDOR_CONTACTSPO_VENDOR_SITES_ALL

MTL_USER_DEMANDMTL_USER_SUPPLY

Y

Y

N

GL_DAILY_RATES N

n/a

n/a

CSD_REPAIRS $

CSD_REPAIR_JOB_XREF $

CSP_ REPAIR_ PO_HEADERS $

MTL_PARAMETERS ,PJM_PROJECT_PARAMETERS ,MRP_AP_UNIT_PAYBACK_QTY_VMTL_SYSTEM_ITEMS_BPJM_BORROW_TRANSACTIONSPJM_BORROW_PAYBACKSMTL_UNIT_TRANSACTIONSMTL_SERIAL_NUMBERS

MRP_AP_APPS_INSTANCES_ALL mrp_ap_apps_instances

Snapshots & AD_ Tables

po_si_capa_sn

mrp_ad_si_capa

NA

mtl_sys_items_snmrp_ad_item_categories

mtl_reservations_sn

mrp_ad_demand

mrp_ad_reservationsna

bom_boms_sn

bom_cto_order_dmd_sn

bom_inv_comps_snbom_sub_comps_sn

MRP_AD_ITEM_RELATIONSHIPS $

MRP_SN_ ITEM_RELATIONSHIPS$

mrp_ad_bomsmrp_ad_inv_compsmrp_ad_operation_componentsmrp_ad_process_effectivitymrp_ad_sub_comps

wip_wlines_sn

mrp_ad_resource_requirementsmrp_ad_res_instance_reqsmrp_ad_lj_opr_ressmrp_ad_wopr_sub_ressmrp_ad_lj_opr_res_instsmrp_sn_lj_opr_ressmrp_sn_wopr_sub_ressMRP_SN_RES_INST_CHNGS

bom_opr_networks_snbom_opr_ress_snbom_opr_rtns_snbom_opr_seqs_snbom_res_chngs_snbom_res_inst_chngs_snbom_sub_opr_ress_sn

mrp_ad_lj_opr_res_instsmrp_ad_opr_seqsmrp_ad_opr_ressmrp_ad_process_effectivity

NA

bom_res_chngs_sn

namrp_schd_dates_sn

mrp_forecast_dates_snmrp_forecast_dsgn_snmrp_forecast_items_sn

mrp_ad_forecast_dsgnmrp_ad_forecast_datesmrp_ad_rept_item_demandsmrp_schd_dates_sn

mrp_ad_rept_item_suppliesmrp_ad_schd_dates mrp_ad_oh_qtysmrp_ad_mtrx_tmpmrp_ad_txn_request_lines

NA

mrp_schd_dates_sn

mrp_ad_schd_dates

mtl_oh_qtys_snmtl_txn_request_lines_snmtl_mtrx_tmp_sn

nananana

na

mtl_supply_sn

mrp_ad_supply

mrp_items_snoe_odr_lines_sn

ahl_sch_mtls_snmtl_demands_sn

mrp_derived_so_demands

mrp_ad_cto_order_demandmrp_ad_order_lines_all

na

na

po_change_requests_snpo_acceptances_snna

na

na

na

wsh_trip_snwsh_trip_stop_sn

mrp_ad_tripsmrp_ad_trip_stopswip_dscr_jobs_snwip_flow_schds_snwip_opr_res_insts_snwip_rept_items_snwip_rept_schds_snwip_wlines_snwip_woprs_snwip_wopr_networks_snwip_wopr_ress_sn

wip_wopr_sub_ress_snwip_wreq_oprs_snwsm_lj_oprs_snwsm_lj_opr_nwk_snwsm_lj_opr_ress_insts_sn

wsm_lj_opr_ress_sn

wsm_lj_req_oprs_sn

eam_wo_relationships_snmrp_flow_demands

mrp_ad_flow_schdsmrp_ad_dscr_jobsmrp_ad_wip_comp_suppliesmrp_ad_resource_requirementsmrp_ad_lj_req_oprs

mrp_sn_lj_oprs mrp_sn_lj_req_oprsmtl_u_demand_snmtl_u_supply_sn

mrp_ad_u_demandmrp_ad_u_supplywip_dscr_jobs_snwip_flow_schds_snwip_opr_res_insts_snwip_rept_items_snwip_rept_schds_snwip_wlines_snwip_woprs_snwip_wopr_networks_snwip_wopr_ress_sn

wip_wopr_sub_ress_sn

mrp_ad_wip_comp_demands mrp_ad_lj_opr_nwk mrp_ad_wopr_networks mrp_ad_eam_wo_relationships

mrp_sn_lj_opr_nwk mrp_sn_dscr_jobs mrp_sn_sys_items mrp_ad_lj_oprs

wip_wreq_oprs_snwsm_lj_oprs_snwsm_lj_opr_nwk_snwsm_lj_opr_ress_insts_sn

wsm_lj_opr_ress_sn

wsm_lj_req_oprs_sn

eam_wo_relationships_sn

mrp_ad_flow_schds

mrp_ad_dscr_jobsmrp_ad_wip_comp_suppliesmrp_ad_resource_requirementsmrp_ad_lj_req_oprs

mrp_sn_lj_oprs mrp_sn_lj_req_oprswsh_trip_snwsh_trip_stop_sn

mrp_ad_tripsmrp_ad_trip_stopsna

mtl_sys_items_sn

mrp_ad_wip_comp_demands mrp_ad_lj_opr_nwk

mrp_ad_wopr_networks mrp_ad_eam_wo_relationships

mrp_sn_lj_opr_nwk mrp_sn_dscr_jobs mrp_sn_sys_items mrp_ad_lj_oprs

MTL_U_DEMAND_SNMTL_U_SUPPLY_SNMRP_AD_U_DEMANDMRP_AD_U_SUPPLY

MRP_AD_ERO

Views

mrp_ap_po_suppliers_vmrp_ap_supplier_capacities_vmrp_ad_supplier_capacities_vmrp_ap_supplier_flex_fences_vmrp_ap_atp_rules_v

mrp_ap_nocost_system_items_vmrp_ap_system_items_v mrp_ap_category_sets_vmrp_ap_item_categories_vmrp_ap_sys_items_vmrp_ap_item_substitutes_v

gmp_aps_output_pkg.retrieve_item_cost

mrp_ap_item_substitutes_v

mrp_ad_hard_reservations_vmrp_ap_hard_reservations_v

mrp_ap_demand_classes_v

mrp_ap_boms_v

mrp_ad_boms_v

mrp_ap_bom_components_v mrp_ad_bom_components_v

mrp_ap_abc_classes_v #

MRP_AP_ITEM_SUBSTITUTES_V$

MRP_AP_ITEM_SUPERSESSION_REL_V$

MRP_AD_ITEM_RELATIONSHIPS_V$

mrp_ap_ext_repair _reservations_v $

mrp_ap_process_effectivity_vmrp_ad_process_effectivity_vmrp_ap_component_substitutes_vmrp_ad_sub_comps_vmrp_ap_setup_transitions_vmrp_ap_std_op_resources_vgmp_bom_routing_pkg.extract_effectivitiesmrp_ap_department_resources_vmrp_ap_dept_res_instances_vmrp_ap_simulation_sets_vmrp_ap_resource_requirements_vmrp_ad_resource_requirements_vmrp_ap_res_instance_reqs_vmrp_ad_res_instance_reqs_vmrp_ap_job_op_resources_vmrp_ad_job_op_resources_vmrp_ap_lj_sub_op_resources_vmrp_ad_lj_sub_op_resources_vmrp_ap_djob_sub_op_resources_vmrp_ad_djob_sub_op_resources_vmrp_ap_job_res_instances_vmrp_ad_lj_opr_res_insts_vmrp_ap_resource_setups_vMRP_AD_RES_INST_CHANGES_VMRP_AP_RES_INST_CHANGES_Vgmp_calendar_pkg.rsrc_extractmrp_ap_routings_v mrp_ad_routings_vmrp_ap_routing_operations_vmrp_ad_routing_operations_vmrp_ad_op_resource_seqs_vmrp_ap_op_resource_seqs_vmrp_ap_operation_resources_v

mrp_ad_operation_resources_vmrp_ad_sub_oper_ress_vmrp_ap_operation_resources_vmrp_ad_operation_resources_vmrp_ad_operation_components_vmrp_ap_operation_components_vmrp_ad_process_effectivity_v

mrp_ap_operation_components_v mrp_ad_operation_components_v

mrp_ap_process_effectivity_vmrp_ap_bill_of_resources_vmrp_ap_crp_resource_hours_v

mrp_ap_cal_week_start_dates_v

mrp_ap_cal_year_start_dates_vmrp_ad_res_inst_changes_v

mrp_ap_fiscal_time_v

gmp_aps_ds_pull.sales_forecast

mrp_ad_rept_item_supplies_vmrp_ap_rept_item_supplies_vmrp_ad_mps_supplies_vmrp_ap_mps_supplies_v

mrp_ap_cal_assignments_v mrp_ap_calendar_dates_v mrp_ap_calendar_shifts_v

mrp_ap_forecast_dsgn_v mrp_ad_forecast_demand_v mrp_ap_forecast_demand_v mrp_ad_rept_item_demands_v mrp_ap_rept_item_demands_v

bisbv_targetsbisbv_business_plans

mrp_ad_mds_demands_v mrp_ap_mds_demands_v

mrp_ad_onhand_supplies_vmrp_ap_onhand_supplies_v

gmp_aps_ds_pull.onhand_inventory

mrp_ap_parameters_vmrp_ap_planners_vmrp_ap_po_suppliers_vmrp_ap_projects_vmrp_ap_project_tasks_vmrp_ap_sales_channel_v

gmp_calendar_pkg.populate_rsrc_cal

mrp_ad_po_supplies_vmrp_ap_po_ship_supply_vmrp_ap_po_ship_rcv_supply_vmrp_ap_po_po_supply_vmrp_ap_po_req_supply_vmrp_ap_po_rcv_supply_vmrp_ap_intransit_supplies_v

mrp_ap_bis_periods_v bis_indicators_vl bis_target_levels_vl bis_target_values_v bis_business_plans_vl mrp_ap_bis_periods_v bisbv_performance_measures bisbv_target_levels

mrp_ap1_onhand_supplies _v$

mrp_ap_safety_stocks_vmrp_ad_sales_orders_v

mrp_ad_hard_reservations_vmrp_ap_hard_reservations_vmrp_ap1_sales_orders_v (resv)mrp_ap2_sales_orders_v (SOline)mrp_ap3_sales_orders_vmrp_ap4_sales_orders_vmrp_an1_sales_orders_v (resv)mrp_an2_sales_orders_v(SOline)mrp_an3_sales_orders_vmrp_an4_sales_orders_vmrp_ap_ahl_mtl_reqs_vmrp_an_ahl_mtl_reqs_v

mrp_ap_sub_inventories_vgmp_bom_routing_pkg.extract_sub_inventory

mrp_ap_assignment_sets_vmrp_ap_sr_assignments_vmrp_ap_sourcing_rules_vmrp_ap_sr_receipt_org_vmrp_ap_sr_source_org_vmrp_ap_interorg_ship_methods_vmrp_ap_wsh_regions_vmrp_ap_zone_regions_vmrp_ap_region_sites_vmrp_ap_wsh_region_locations_vmrp_ap_carriers_vmrp_ap_carrier_services_v

mrp_ap_vendors_v

mrp_ap_vendor_sites_vmrp_ap_location_associations_v mrp_ap_vendor_contacts_v

mrp_ap_customers_vmrp_ap_customer_sites_vmrp_ap_location_associations_vmrp_ap_customer_contacts_vmrp_ap_buyer_contacts_v

mrp_ap_organizations_vmrp_ap_organization_sites_vmrp_ap_location_associations_v

mrp_ap_carriers_v

mrp_ad_trips_vmrp_ad_trip_stops_vmrp_ap_trips_vmrp_ap_trip_stops_v

mrp_ad_wip_job_supplies_vmrp_ad_wip_comp_supplies_vmrp_ap_wip_job_supplies_vmrp_ap_wip_comp_supplies_vmrp_ap_resource_requirements_vmrp_ad_resource_requirements_vmrp_ad_requirement_ops_vmrp_ap_job_requirement_ops_vmrp_ad_wip_comp_demands_v mrp_ad_wip_flow_demands_v

mrp_ap_wip_jobs_vmrp_ap_wip_comp_demands_vmrp_ap_job_op_networks_vmrp_ap_job_operations_v

mrp_ap_non_ero_wip_demand_v mrp_ad_job_op_networks_v

gmp_aps_ds_pull.production_orders

mrp_ad_user_demands_vmrp_ap_user_demands_vmrp_ad_user_supplies_vmrp_ap_user_supplies_v

mrp_ad_wip_job_supplies_vmrp_ad_wip_comp_supplies_vmrp_ap_wip_job_supplies_vmrp_ap_wip_comp_supplies_vmrp_ap_resource_requirements_vmrp_ad_resource_requirements_vmrp_ad_requirement_ops_vmrp_ap_job_requirement_ops_v

mrp_ap_wip_jobs_v

mrp_ap_non_ro_wip_demand_v$

mrp_ap_non_ero_wip_job_supp_v$

mrp_ap_non_ro_wip_job_supply_v$

mrp_ad_wopr_networks_v mrp_ad_eam_wo_relships_v mrp_ad_job_operations_v

mrp_ad_wip_comp_demands_v mrp_ad_wip_flow_demands_v

mrp_ap_wip_comp_demands_vmrp_ap_job_op_networks_vmrp_ap_job_operations_v

mrp_ap_non_ero_wip_demand_v mrp_ad_job_op_networks_v

gmp_aps_ds_pull.production_orders

mrp_ad_trips_vmrp_ad_trip_stops_vmrp_ap_trips_vmrp_ap_trip_stops_v

mrp_ap_unit_numbers_v

mrp_ap_units_of_measure_vmrp_ap_uom_class_conversions_vmrp_ap_uom_conversions_v


mrp_ap_non_ero_wip_job_supp_v$


mrp_ad_wopr_networks_v mrp_ad_eam_wo_relships_v mrp_ad_job_operations_v


mrp_ad_non_ro_wip_comp_dem_v $

mrp_ap_repair_demand_v $

mrp_ap_non_ro_wip_demand_v $

mrp_ad_non_ro_wip_job_supp_v $

mrp_ap_non_ro_wip_job_supply_v $

mrp_ap_non_ro_wip_job_v $

mrp_ap_repair_orders_v $

mrp_ap_ero_wip_job_supply_v $

mrp_ap_ero_wip_demand_v $

mrp_ap_non_ero_wip_job_supply_v $

mrp_ap_non_ero_wip_demand_v $

mrp_ad_non_ero_wip_job_supplies_v $

mrp_ad_non_ ero_ wip_comp_demands_v $

mrp_ap_ero_wip_job_supply_v $

mrp_ad_ero_wip_job_supplies_v $

mrp_ad_ ero_ wip_comp_demands_v $

mrp_ap_open_payback_qty_vmrp_ap_item_open_payback_qty_vmrp_ap_unit_payback_qty_v

mrp_ap_cuurency_conv_v $

Staging Tables

MSC_ST_ITEM_SUPPLIERSMSC_ST_SUPPLIER_CAPACITIESMSC_ST_SUPPLIER_FLEX_FENCES

MSC_ST_ATP_RULES

MSC_ST_SYSTEM_ITEMSMSC_ST_CATEGORY_SETSMSC_ST_ITEM_CATEGORIESMSC_ST_ITEM_SUBSTITUTES

MSC_ST_ITEM_SUBSTITUTES

MSC_ST_RESERVATIONS

MSC_ST_DEMAND_CLASSES

MSC_ST_BOMS

MSC_ST_BOM_COMPONENTSMSC_ST_OPERATION_COMPONENTS

MSC_ST_ABC_CLASSES #

MSC_ST_PROCESS_EFFECTIVITY

MSC_ST_COMPONENT_SUBSTITUTESMSC_ST_PROCESS_EFFECTIVITYMSC_ST_SETUP_TRANSITIONSMSC_ST_STD_OP_RESOURCES

MSC_ST_DEPARTMENT_RESOURCESMSC_ST_DEPT_RES_INSTANCESMSC_ST_SIMULATION_SETSMSC_ST_RESOURCE_REQUIREMENTSMSC_ST_RESOURCE_INSTANCE_REQSMSC_ST_JOB_OP_RESOURCESMSC_ST_JOB_OP_RESOURCESMSC_ST_JOB_OP_RES_INSTANCESMSC_ST_RESOURCE_SETUPSMSC_ST_RES_INSTANCE_CHANGES

MSC_ST_ROUTINGSMSC_ST_OPER_NETWORKSMSC_ST_OPERATION_NETWORKSMSC_ST_ROUTING_OPERATIONSMSC_ST_OPERATION_RESOURCE_SEQSMSC_ST_OPERATION_RESOURCESMSC_ST_OPERATION_COMPONENTS MSC_ST_PROCESS_EFFECTIVITY

MSC_ST_BILL_OF_RESOURCESMSC_ST_BOR_REQUIREMENTSMSC_ST_CALENDAR_ASSIGNMENTS

MSC_ST_CALENDAR_DATES

MSC_ST_CALENDAR_SHIFTSMSC_ST_CAL_WEEK_START_DATESMSC_ST_CAL_YEAR_START_DATESMSC_ST_RES_INST_CHANGES

MSC_ST_CALENDAR_MONTHSMSC_ST_DESIGNATORS

MSC_ST_DEMANDS

MSC_ST_SUPPLIES

MSC_ST_BIS_PERIODS

MSC_ST_BIS_PFMC_MEASURESMSC_ST_BIS_TARGET_LEVELSMSC_ST_BIS_TARGETSMSC_ST_BIS_BUSINESS_PLANS

MSC_ST_DEMANDSMSC_ST_DESIGNATORS

MSC_ST_SUPPLIES

MSC_ST_PARAMETERSMSC_ST_PLANNERS

MSC_ST_PROJECTSMSC_ST_PROJECT_TASKSMSC_ST_SR_LOOKUPS

msc_st_sales_channelsMSC_ST_NET_RESOURCE_AVAIL

MSC_ST_SUPPLIES

MSC_ST_SUPPLIES

MSC_ST_SAFETY_STOCKSMSC_ST_SALES_ORDERS

MSC_ST_SUB_INVENTORIES

MSC_ST_ASSIGNMENT_SETSMSC_ST_SR_ASSIGNMENTSMSC_ST_SOURCING_RULESMSC_ST_SR_RECEIPT_ORGMSC_ST_SR_SOURCE_ORGMSC_ST_INTERORG_SHIP_METHODSMSC_ST_REGIONSMSC_ST_ZONE_REGIONSMSC_ST_REGION_SITESMSC_ST_REGION_LOCATIONSMSC_ST_TRADING_PARTNERSMSC_ST_CARRIER_SERVICES

MSC_ST_TRADING_PARTNERS

MSC_ST_TRADING_PARTNER_SITESMSC_ST_LOCATION_ASSOCIATIONSMSC_ST_PARTNER_CONTACTS

MSC_ST_TRADING_PARTNERSMSC_ST_TRADING_PARTNER_SITESMSC_ST_LOCATION_ASSOCIATIONSMSC_ST_PARTNER_CONTACTSMSC_ST_PARTNER_CONTACTS

MSC_ST_TRADING_PARTNERSMSC_ST_TRADING_PARTNER_SITESMSC_ST_LOCATION_ASSOCIATIONS

MSC_ST_TRADING_PARTNERS

MSC_ST_TRIPSMSC_ST_TRIP_STOPS

MSC_ST_SUPPLIESMSC_ST_RESOURCE_REQUIREMENTS

MSC_ST_DEMANDS

MSC_ST_DEMANDSMSC_ST_SUPPLIES

MSC_ST_SUPPLIESMSC_ST_JOB_OPERATION_NETWORKSMSC_ST_JOB_OPERATIONSMSC_ST_JOB_REQUIREMENT_OPS

MSC_ST_TRIPSMSC_ST_TRIP_STOPS

MSC_ST_UNIT_NUMBERS

MSC_ST_UNITS_OF_MEASUREMSC_ST_UOM_CLASS_CONVERSIONSMSC_ST_UOM_CONVERSIONS

MSC_ST_OPEN_PAYBACKS



MSC_ST_CURRENCY_CONVERSIONS $

Destination side(APS) Tables

MSC_ITEM_SUPPLIERSMSC_SUPPLIER_CAPACITIESMSC_SUPPLIER_FLEX_FENCESMSC_ASL_AUTH_DETAILSMSC_ATP_RULES

MSC_ITEMS,

MSC_CATEGORY_SETS

MSC_CATEGORY_SET_ID_LID

MSC_ABC_CLASSES

MSC_ITEM_SUBSTITUTES

MSC_RESERVATIONS

MSC_DEMAND_CLASSES

MSC_PROCESS_EFFECTIVITY

MSC_COMPONENT_SUBSTITUTESMSC_SETUP_TRANSITIONS

MSC_SYSTEM_ITEMS, MSC_ITEM_ID_LID,

MSC_ITEM_CATEGORIES,

MSC_ITEM_SUBSTITUTES,

MSC_ITEM_TYPE_DEFINITIONS$

MSC_BOMS; MSC_BOM_COMPONENTS MSC_OPERATION_COMPONENTS

MSC_STD_OP_RESOURCES

MSC_DEPARTMENT_RESOURCESMSC_DEPT_RES_INSTANCESMSC_SIMULATION_SETSMSC_RESOURCE_SETUPSMSC_RES_INSTANCE_CHANGES

MSC_OPERATION_RESOURCE_SEQMSC_OPERATION_RESOURCESMSC_OPERATION_COMPONENTSMSC_PROCESS_EFFECTIVITYMSC_OPERATION_NETWORKS

MSC_ROUTINGS, MSC_ROUTING_OPERATIONS,

MSC_BILL_OF_RESOURCESMSC_BOR_REQUIREMENTSMSC_CALENDARS,

MSC_CALENDAR_SHIFTS MSC_CALENDAR_ASSIGNMENTS

MSC_CALENDAR_DATESMSC_CALENDAR_EXCEPTIONSMSC_RESOURCE_CHANGES

MSC_CALENDAR_MONTHSMSC_DESIGNATORS

MSC_DEMANDS

MSC_SUPPLIES

MSC_BIS_PERIODS

MSC_BIS_PERFORMANCE_MEASURESMSC_BIS_TARGET_LEVELSMSC_BIS_TARGETSMSC_BIS_BUSINESS_PLANS

MSC_DESIGNATORSMSC_DEMANDS

MSC_SUPPLIES

MSC_PARAMETERSMSC_PLANNERSMSC_PO_RECEIPTSMSC_PROJECTSMSC_PROJECT_TASKSmsc_sales_channels

MSC_SR_LOOKUPSMSC_NET_RESOURCE_AVAIL

MSC_DEPARTMENT_RESOURCESMSC_RESOURCE_CHANGESMSC_SHIFT_DATESMSC_SIMULATION_SETSMSC_SUPPLIES

(msc_net_resource_avail is populated from the following msc tables for discrete orgs)

MSC_SUPPLIES

MSC_SAFETY_STOCKSMSC_SALES_ORDERS

MSC_SOURCING_TRANSACTIONS

MSC_SUB_INVENTORIES

MSC_ASSIGNMENT_SETSMSC_SR_ASSIGNMENTSMSC_SOURCING_RULESMSC_SR_RECEIPT_ORGMSC_SR_SOURCE_ORGMSC_INTERORG_SHIP_METHODSMSC_REGIONSMSC_ZONE_REGIONSMSC_REGION_SITESMSC_REGION_LOCATIONSMSC_TRADING_PARTNERS (carriers)MSC_CARRIER_SERVICES

MSC_LOCATION_ASSOCIATIONSMSC_PARTNER_CONTACTSMSC_TP_ID_LIDMSC_TP_SITE_ID_LID

MSC_TRADING_PARTNERSMSC_TRADING_PARTNER_SITESMSC_LOCATION_ASSOCIATIONSMSC_PARTNER_CONTACTSMSC_TP_ID_LIDMSC_TP_SITE_ID_LID

MSC_TRADING_PARTNERSMSC_TRADING_PARTNER_SITESMSC_LOCATION_ASSOCIATIONSMSC_INSTANCE_ORGS(enabled orgs)

MSC_TRADING_PARTNERSMSC_TP_ID_LIDMSC_TP_SITE_ID_LIDMSC_TRIPSMSC_TRIP_STOPS

MSC_SUPPLIESMSC_RESOURCE_REQUIREMENTSMSC_RESOURCE_INSTANCE_REQSMSC_DEMANDS

MSC_TRADING_PARTNERS, MSC_TRADING_PARTNER_SITES

MSC_DEMANDSMSC_SUPPLIES

MSC_SUPPLIESMSC_JOB_OPERATIONSMSC_JOB_OPERATION_NETWORKSMSC_JOB_OP_RESOURCESMSC_JOB_REQUIREMENT_OPS

MSC_TRIPSMSC_TRIP_STOPS

MSC_UNIT_NUMBERS

MSC_UNITS_OF_MEASUREMSC_UOM_CLASS_CONVERSIONSMSC_UOM_CONVERSIONS

MSC_COMPANY_USERS





MSC_CURRENCY_CONVERSIONS $

MSC_APPS_INSTANCESMSC_INSTANCE_ORGSMSC_COLl_PARAMETERSMSC_PLANSMSC_INST_PARTITIONSMSC_PLAN_PARTITIONSMSD_AUDIT_SQL_STATEMENTS

MSC_LOCAL_ID_ITEMMSC_LOCAL_ID_SETUPMSC_LOCAL_ID_MISC

Snapshots and Snapshot Logs (MLOG$) for Data Collections for All Releases - 11.5.9 to 12.1.1Snapshots are used for all entities that can be collected in Net Change Mode of Data CollectionsSnapshots that have Multiple Tables / MLOG$ are Complex Snapshots that reference muiltple tables in the Snapshot query.Snapshots and MLOG's are created on the EBS Source in a distributed installation.

SQL to view the snapshot query

NOT USED by APS applicattionObsolete - not usedMSC_ATP_PLAN_SN is only for ASCP Planning for ATP Plans, not for data collections

12.1 SnapshotsTABLE_NAME SNAPSHOT MLOG$ OWNERAHL_SCHEDULE_MATERIALS AHL_SCH_MTLS_SN MLOG$_AHL_SCHEDULE_MATERIA APPSBOM_STRUCTURES_B BOM_BOMS_SN MLOG$_BOM_STRUCTURES_B APPSBOM_CTO_ORDER_DEMAND BOM_CTO_ORDER_DMD_SN MLOG$_BOM_CTO_ORDER_DEMAND BOM

BOM_INV_COMPS_SN APPS

BOM_OPR_NETWORKS_SN APPS

Key Note for Managing MLOGs - Note 1063953.1

Used SQL in column B to isolate the Data Collections snapshotsThen SQL in column C to find all base tables that are referenced in the snapshot query

SELECT distinct c.table_name, b.name Snapshot, a.log_table "MLOG$", b.ownerFROM all_SNAPSHOT_LOGS A,all_SNAPSHOTS B,all_Tables cWHERE a.master=b.master and b.name like '%SN' andb.master=c.table_name and a.master=c.table_nameorder by table_name;

select OWNER "Snapshot Owner", MVIEW_NAME "Snapshot", DETAILOBJ_OWNER "Base Table Owner", DETAILOBJ_NAME "Base Table Name", 'MLOG$_'||SUBSTR(DETAILOBJ_NAME,1,20) mlog$_name FROM ALL_MVIEW_DETAIL_RELATIONS where DETAILOBJ_NAME like '&base_schema%' -- like BOM% and DETAILOBJ_TYPE = 'TABLE' order by mview_name;

SELECT name, query FROM all_snapshots WHERE name LIKE '%SN' ORDER BY name;

Note: for SQL*Plus first use set long 3000

Snapshot creation files - See files in $MSC_TOP/sql/*SN.sql

In R12.x - List of Snapshots available for Refresh Collection Snapshots is shown in Advanced Planning Administrator / Admin / Lookups - query on MSC_COLL_SNAPSHOTS

BOM_COMPONENTS_BBOM_STRUCTURES_B

MLOG$_BOM_COMPONENTS_BMLOG$_BOM_STRUCTURES_B

BOM_OPERATION_SEQUENCESBOM_OPERATIONAL_ROUTINGSBOM_OPERATION_NETWORKS

MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_OPERATION_NETWOR

A B C D E

1

2

3

4

5

6

7

8

9

10

111213

14

15161718

19

20


BOM_OPR_RESS_SN APPS

BOM_OPERATIONAL_ROUTINGS BOM_OPR_RTNS_SN MLOG$_BOM_OPERATIONAL_ROUT APPS

BOM_OPR_SEQS_SN APPS

BOM_RES_CHNGS_SN APPS

BOM_RES_INST_CHNGS_SN APPS

BOM_SUB_COMPS_SN APPS

BOM_SUB_OPR_RESS_SN APPS

CSP_REPAIR_PO_HEADERS CSP_REPAIR_PO_HEADERS_SN MLOG$_CSP_REPAIR_PO_HEADER APPSEAM_WO_RELATIONSHIPS EAM_WO_RELATIONSHIPS_SN MLOG$_EAM_WO_RELATIONSHIPS APPSMRP_FORECAST_DATES MRP_FORECAST_DATES_SN MLOG$_MRP_FORECAST_DATES APPSMRP_FORECAST_DESIGNATORS MRP_FORECAST_DSGN_SN MLOG$_MRP_FORECAST_DESIGNA APPSMRP_FORECAST_ITEMS MRP_FORECAST_ITEMS_SN MLOG$_MRP_FORECAST_ITEMS APPSMRP_SCHEDULE_DATES MRP_SCHD_DATES_SN MLOG$_MRP_SCHEDULE_DATES APPSMTL_DEMAND MTL_DEMAND_SN MLOG$_MTL_DEMAND APPSMTL_ITEM_CATEGORIES MTL_ITEM_CATS_SN MLOG$_MTL_ITEM_CATEGORIES APPSMTL_RELATED_ITEMS MTL_ITEM_RELATIONSHIPS_SN MLOG$_MTL_RELATED_ITEMS APPSMTL_MATERIAL_TRANSACTIONS_TEMP MTL_MTRX_TMP_SN MLOG$_MTL_MATERIAL_TRANSAC APPSMTL_ONHAND_QUANTITIES_DETAIL MTL_OH_QTYS_SN MLOG$_MTL_ONHAND_QUANTITIE APPSMTL_RESERVATIONS MTL_RESERVATIONS_SN MLOG$_MTL_RESERVATIONS APPSMTL_SUPPLY MTL_SUPPLY_SN MLOG$_MTL_SUPPLY APPSMTL_SYSTEM_ITEMS_B MTL_SYS_ITEMS_SN MLOG$_MTL_SYSTEM_ITEMS_B APPSMTL_TXN_REQUEST_LINES MTL_TXN_REQUEST_LINES_SN MLOG$_MTL_TXN_REQUEST_LINE APPSMTL_USER_DEMAND MTL_U_DEMAND_SN MLOG$_MTL_USER_DEMAND APPSMTL_USER_SUPPLY MTL_U_SUPPLY_SN MLOG$_MTL_USER_SUPPLY APPSOE_ORDER_LINES_ALL OE_ODR_LINES_SN MLOG$_OE_ORDER_LINES_ALL APPSPO_ACCEPTANCES PO_ACCEPTANCES_SN MLOG$_PO_ACCEPTANCES APPSPO_CHANGE_REQUESTS PO_CHANGE_REQUESTS_SN MLOG$_PO_CHANGE_REQUESTS APPSPO_SUPPLIER_ITEM_CAPACITY PO_SI_CAPA_SN MLOG$_PO_SUPPLIER_ITEM_CAP APPSWIP_DISCRETE_JOBS WIP_DSCR_JOBS_SN MLOG$_WIP_DISCRETE_JOBS APPSWIP_FLOW_SCHEDULES WIP_FLOW_SCHDS_SN MLOG$_WIP_FLOW_SCHEDULES APPSWIP_OP_RESOURCE_INSTANCES WIP_OPR_RES_INSTS_SN MLOG$_WIP_OP_RESOURCE_INST APPS

WIP_REPETITIVE_ITEMS WIP_REPT_ITEMS_SN MLOG$_WIP_REPETITIVE_ITEMS APPS

WIP_REPETITIVE_SCHEDULES WIP_REPT_SCHDS_SN MLOG$_WIP_REPETITIVE_SCHED APPS

WIP_LINES WIP_WLINES_SN MLOG$_WIP_LINES APPS

WIP_WOPRS_SN APPS

WIP_OPERATION_NETWORKS WIP_WOPR_NETWORKS_SN MLOG$_WIP_OPERATION_NETWOR APPS

BOM_OPERATION_SEQUENCESBOM_OPERATION_RESOURCESBOM_OPERATIONAL_ROUTINGS

MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_OPERATION_RESOURMLOG$_BOM_OPERATIONAL_ROUT

BOM_OPERATION_SEQUENCESBOM_OPERATIONAL_ROUTINGS

MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_OPERATIONAL_ROUT

BOM_RESOURCE_CHANGESBOM_DEPARTMENTS

MLOG$_BOM_RESOURCE_CHANGESMLOG$_BOM_DEPARTMENTS

BOM_DEPARTMENTSBOM_RES_INSTANCE_CHANGES

MLOG$_BOM_DEPARTMENTSMLOG$_BOM_RES_INSTANCE_CHA

BOM_STRUCTURES_BBOM_COMPONENTS_BBOM_SUBSTITUTE_COMPONENTS

MLOG$_BOM_STRUCTURES_BMLOG$_BOM_COMPONENTS_BMLOG$_BOM_SUBSTITUTE_COMPO

BOM_OPERATION_SEQUENCESBOM_SUB_OPERATION_RESOURCESBOM_OPERATIONAL_ROUTINGS

MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_SUB_OPERATION_REMLOG$_BOM_OPERATIONAL_ROUT

WIP_MSC_OPEN_JOB_STATUSESWIP_DISCRETE_JOBSWIP_OPERATIONS

MLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_OPERATIONS

A B C D E

21

22

23

24

25

26

27

282930313233343536373839404142434445464748495051

52

53

54

55

56

WIP_WOPR_RESS_SN APPS

WIP_SUB_OPERATION_RESOURCES WIP_WOPR_SUB_RESS_SN MLOG$_WIP_SUB_OPERATION_RE APPS

WIP_WREQ_OPRS_SN APPS

WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_SN MLOG$_WSH_DELIVERY_DETAILS WSHWSH_TRIPS WSH_TRIP_SN MLOG$_WSH_TRIPS APPSWSH_TRIP_STOPS WSH_TRIP_STOP_SN MLOG$_WSH_TRIP_STOPS APPSWSM_COPY_OPERATIONS WSM_LJ_OPRS_SN MLOG$_WSM_COPY_OPERATIONS APPSWSM_COPY_OP_NETWORKS WSM_LJ_OPR_NWK_SN MLOG$_WSM_COPY_OP_NETWORKS APPSWSM_COPY_OP_RESOURCE_INSTANCES WSM_LJ_OPR_RESS_INSTS_SN MLOG$_WSM_COPY_OP_RESOURCE1 APPSWSM_COPY_OP_RESOURCES WSM_LJ_OPR_RESS_SN MLOG$_WSM_COPY_OP_RESOURCE APPSWSM_COPY_REQUIREMENT_OPS WSM_LJ_REQ_OPRS_SN MLOG$_WSM_COPY_REQUIREMENT APPSMSC_DESIGNATORS MSC_ATP_PLAN_SN N/A MSC

Ran the following to determine usage of WSH_DELIVERY_DETAILS_SNselect * from all_source where name like'%'and text like '%WSH_DELIVERY_DETAILS_SN%'order by name, line;This finds reference to the triggers -SO then ran

then find the following in the trigger query which points to MST - which is Transportation Management applicationWSH_DELIVERY_DETAILS_SN_T1 BEGIN select MST_SNP_REFRESH_S.CURRVAL into :new.REFRESH_NUMBER from dual; WSH_DELIVERY_DETAILS_SN_T2 BEGIN INSERT INTO MST_AD_DELIVERY_DETAILS

( DELIVERY_DETAIL_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REFRESH_NUMBER) VALUES ( :old.DELIVERY_DETAIL_ID, SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, mst_snp_refresh_s.currval);END;

WIP_DISCRETE_JOBSWIP_MSC_OPEN_JOB_STATUSESWIP_OPERATION_RESOURCES

MLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_OPERATION_RESOUR

WIP_MSC_OPEN_JOB_STATUSESWIP_DISCRETE_JOBSWIP_REQUIREMENT_OPERATIONS

MLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_REQUIREMENT_OPER

select * from all_triggers where TRIGGER_NAME in ('WSH_DELIVERY_DETAILS_SN_T1','WSH_DELIVERY_DETAILS_SN_T2');

A B C D E

57

58

59

60616263646566676869707172737475767778

79

808182838485868788899091929394959697

12.0.6 Snapshots 11.5.10 snapshotsTABLE_NAME SNAPSHOT MLOG$ OWNER TABLE_NAMEAHL_SCHEDULE_MATERIALS AHL_SCH_MTLS_SN MLOG$_AHL_SCHEDULE_MATERIA AHL AHL_SCHEDULE_MATERIALSBOM_STRUCTURES_B BOM_BOMS_SN MLOG$_BOM_STRUCTURES_B BOM BOM_STRUCTURES_BBOM_CTO_ORDER_DEMAND BOM_CTO_ORDER_DMD_SN MLOG$_BOM_CTO_ORDER_DEMAND BOM BOM_CTO_ORDER_DEMAND

BOM_INV_COMPS_SN BOM

BOM_OPR_NETWORKS_SN BOM

For Refresh Collection Snapshots launched as a standalone requestSome snapshots may be missing from the list of values in the request parametersSee Note 1086104.1 to add snapshots to the list of values.







F G H I J K

1

2

3

4

5

6

7

8

9

10

111213

14

15161718

19

20

BOM_OPR_RESS_SN BOM

BOM_OPERATIONAL_ROUTINGS BOM_OPR_RTNS_SN MLOG$_BOM_OPERATIONAL_ROUT BOM BOM_OPERATIONAL_ROUTINGS

BOM_OPR_SEQS_SN BOM

BOM_RES_CHNGS_SN BOM

BOM_RES_INST_CHNGS_SN BOM

BOM_SUB_COMPS_SN BOM

BOM_SUB_OPR_RESS_SN BOM

CSP_REPAIR_PO_HEADERS CSP_REPAIR_PO_HEADERS_SN MLOG$_CSP_REPAIR_PO_HEADER CSP MRP_FORECAST_DATESEAM_WO_RELATIONSHIPS EAM_WO_RELATIONSHIPS_SN MLOG$_EAM_WO_RELATIONSHIPS EAM MRP_FORECAST_DESIGNATORSMRP_FORECAST_DATES MRP_FORECAST_DATES_SN MLOG$_MRP_FORECAST_DATES MRP MRP_FORECAST_ITEMSMRP_FORECAST_DESIGNATORS MRP_FORECAST_DSGN_SN MLOG$_MRP_FORECAST_DESIGNA MRP MRP_SCHEDULE_DATESMRP_FORECAST_ITEMS MRP_FORECAST_ITEMS_SN MLOG$_MRP_FORECAST_ITEMS MRP MTL_DEMANDMRP_SCHEDULE_DATES MRP_SCHD_DATES_SN MLOG$_MRP_SCHEDULE_DATES MRP MTL_ITEM_CATEGORIESMTL_DEMAND MTL_DEMAND_SN MLOG$_MTL_DEMAND INV MTL_MATERIAL_TRANSACTIONS_TEMPMTL_ITEM_CATEGORIES MTL_ITEM_CATS_SN MLOG$_MTL_ITEM_CATEGORIES INV MTL_ONHAND_QUANTITIES_DETAILMTL_RELATED_ITEMS MTL_ITEM_RELATIONSHIPS_SN MLOG$_MTL_RELATED_ITEMS INV MTL_RESERVATIONSMTL_MATERIAL_TRANSACTIONS_TEMP MTL_MTRX_TMP_SN MLOG$_MTL_MATERIAL_TRANSAC INV MTL_SUPPLYMTL_ONHAND_QUANTITIES_DETAIL MTL_OH_QTYS_SN MLOG$_MTL_ONHAND_QUANTITIE INV MTL_SYSTEM_ITEMS_BMTL_RESERVATIONS MTL_RESERVATIONS_SN MLOG$_MTL_RESERVATIONS INV MTL_TXN_REQUEST_LINESMTL_SUPPLY MTL_SUPPLY_SN MLOG$_MTL_SUPPLY INV MTL_USER_DEMANDMTL_SYSTEM_ITEMS_B MTL_SYS_ITEMS_SN MLOG$_MTL_SYSTEM_ITEMS_B INV MTL_USER_SUPPLYMTL_TXN_REQUEST_LINES MTL_TXN_REQUEST_LINES_SN MLOG$_MTL_TXN_REQUEST_LINE INV OE_ORDER_LINES_ALLMTL_USER_DEMAND MTL_U_DEMAND_SN MLOG$_MTL_USER_DEMAND INV PO_ACCEPTANCESMTL_USER_SUPPLY MTL_U_SUPPLY_SN MLOG$_MTL_USER_SUPPLY INV PO_CHANGE_REQUESTSOE_ORDER_LINES_ALL OE_ODR_LINES_SN MLOG$_OE_ORDER_LINES_ALL ONT PO_SUPPLIER_ITEM_CAPACITYPO_ACCEPTANCES PO_ACCEPTANCES_SN MLOG$_PO_ACCEPTANCES PO WIP_DISCRETE_JOBSPO_CHANGE_REQUESTS PO_CHANGE_REQUESTS_SN MLOG$_PO_CHANGE_REQUESTS PO WIP_FLOW_SCHEDULESPO_SUPPLIER_ITEM_CAPACITY PO_SI_CAPA_SN MLOG$_PO_SUPPLIER_ITEM_CAP PO WIP_OP_RESOURCE_INSTANCESWIP_DISCRETE_JOBS WIP_DSCR_JOBS_SN MLOG$_WIP_DISCRETE_JOBS WIP WIP_REPETITIVE_ITEMSWIP_FLOW_SCHEDULES WIP_FLOW_SCHDS_SN MLOG$_WIP_FLOW_SCHEDULES WIP WIP_REPETITIVE_SCHEDULESWIP_OP_RESOURCE_INSTANCES WIP_OPR_RES_INSTS_SN MLOG$_WIP_OP_RESOURCE_INST WIP WIP_LINES

WIP_REPETITIVE_ITEMS WIP_REPT_ITEMS_SN MLOG$_WIP_REPETITIVE_ITEMS WIP

WIP_REPETITIVE_SCHEDULES WIP_REPT_SCHDS_SN MLOG$_WIP_REPETITIVE_SCHED WIP

WIP_LINES WIP_WLINES_SN MLOG$_WIP_LINES WIP WIP_SUB_OPERATION_RESOURCES

WIP_WOPRS_SN WIP

WIP_OPERATION_NETWORKS WIP_WOPR_NETWORKS_SN MLOG$_WIP_OPERATION_NETWOR WIP WSH_TRIPS

















MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_SUB_OPERATION_REMLOG$_BOM_OPERATIONAL_ROUT\







F G H I J K

21

22

23

24

25

26

27

282930313233343536373839404142434445464748495051

52

53

54

55

56

WIP_WOPR_RESS_SN WIP WSH_TRIP_STOPS

WIP_SUB_OPERATION_RESOURCES WIP_WOPR_SUB_RESS_SN MLOG$_WIP_SUB_OPERATION_RE WIP WSM_COPY_OPERATIONS

WIP_WREQ_OPRS_SN WIP WSM_COPY_OP_NETWORKS

WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_SN MLOG$_WSH_DELIVERY_DETAILS WSH WSM_COPY_OP_RESOURCE_INSTANCESWSH_TRIPS WSH_TRIP_SN MLOG$_WSH_TRIPS WSH WSM_COPY_OP_RESOURCESWSH_TRIP_STOPS WSH_TRIP_STOP_SN MLOG$_WSH_TRIP_STOPS WSH WSM_COPY_REQUIREMENT_OPSWSM_COPY_OPERATIONS WSM_LJ_OPRS_SN MLOG$_WSM_COPY_OPERATIONS WSM MSC_DESIGNATORSWSM_COPY_OP_NETWORKS WSM_LJ_OPR_NWK_SN MLOG$_WSM_COPY_OP_NETWORKS WSMWSM_COPY_OP_RESOURCE_INSTANCES WSM_LJ_OPR_RESS_INSTS_SN MLOG$_WSM_COPY_OP_RESOURCE1 WSMWSM_COPY_OP_RESOURCES WSM_LJ_OPR_RESS_SN MLOG$_WSM_COPY_OP_RESOURCE WSMWSM_COPY_REQUIREMENT_OPS WSM_LJ_REQ_OPRS_SN MLOG$_WSM_COPY_REQUIREMENT WSMMSC_DESIGNATORS MSC_ATP_PLAN_SN N/A MSC





F G H I J K

57

58

59

60616263646566676869707172737475767778

79

808182838485868788899091929394959697

11.5.9 SnapshotsSNAPSHOT MLOG$ OWNER OWNER NAME MASTERAHL_SCH_MTLS_SN MLOG$_AHL_SCHEDULE_MATERIA AHL BOM BOM_BOMS_SN BOM_BILL_OF_MATERIALSBOM_BOMS_SN MLOG$_BOM_STRUCTURES_B BOM BOM BOM_CTO_ORDER_DMD_SN BOM_CTO_ORDER_DEMANDBOM_CTO_ORDER_DMD_SN MLOG$_BOM_CTO_ORDER_DEMAND BOM BOM BOM_INV_COMPS_SN BOM_INVENTORY_COMPONENTS

BOM_INV_COMPS_SN BOM BOM BOM_OPR_NETWORKS_SN BOM_OPERATION_NETWORKS

BOM_OPR_NETWORKS_SN BOM BOM BOM_OPR_RESS_SN BOM_OPERATION_RESOURCES

SQL used - select owner, name, master from all_snapshots where name like '%SN' order by name, owner



L M N O P Q R

1

2

3

4

5

6

7

8

9

10

111213

14

15161718

19

20

BOM_OPR_RESS_SN BOM BOM BOM_OPR_RTNS_SN BOM_OPERATIONAL_ROUTINGS

BOM_OPR_RTNS_SN MLOG$_BOM_OPERATIONAL_ROUT BOM BOM BOM_OPR_SEQS_SN BOM_OPERATION_SEQUENCES

BOM_OPR_SEQS_SN BOM BOM BOM_RES_CHNGS_SN BOM_RESOURCE_CHANGES

BOM_RES_CHNGS_SN BOM BOM BOM_SUB_OPR_RESS_SN BOM_SUB_OPERATION_RESOURCES

BOM_RES_INST_CHNGS_SN BOM MRP MRP_FORECAST_DATES_SN MRP_FORECAST_DATES

BOM_SUB_COMPS_SN BOM MRP MRP_FORECAST_DSGN_SN MRP_FORECAST_DESIGNATORS

BOM_SUB_OPR_RESS_SN BOM MRP MRP_FORECAST_ITEMS_SN MRP_FORECAST_ITEMS

MRP_FORECAST_DATES_SN MLOG$_MRP_FORECAST_DATES MRP MRP MRP_SCHD_DATES_SN MRP_SCHEDULE_DATESMRP_FORECAST_DSGN_SN MLOG$_MRP_FORECAST_DESIGNA MRP MSC MSC_ATP_PLAN_SN MSC_DESIGNATORSMRP_FORECAST_ITEMS_SN MLOG$_MRP_FORECAST_ITEMS MRP INV MTL_DEMAND_SN MTL_DEMANDMRP_SCHD_DATES_SN MLOG$_MRP_SCHEDULE_DATES MRP INV MTL_MTRX_TMP_SN MTL_MATERIAL_TRANSACTIONS_TEMPMTL_DEMAND_SN MLOG$_MTL_DEMAND INV INV MTL_OH_QTYS_SN MTL_ONHAND_QUANTITIES_DETAILMTL_ITEM_CATS_SN MLOG$_MTL_ITEM_CATEGORIES INV INV MTL_RESERVATIONS_SN MTL_RESERVATIONSMTL_MTRX_TMP_SN MLOG$_MTL_MATERIAL_TRANSAC INV INV MTL_SUPPLY_SN MTL_SUPPLYMTL_OH_QTYS_SN MLOG$_MTL_ONHAND_QUANTITIE INV INV MTL_SYS_ITEMS_SN MTL_SYSTEM_ITEMS_BMTL_RESERVATIONS_SN MLOG$_MTL_RESERVATIONS INV INV MTL_U_DEMAND_SN MTL_USER_DEMANDMTL_SUPPLY_SN MLOG$_MTL_SUPPLY INV INV MTL_U_SUPPLY_SN MTL_USER_SUPPLYMTL_SYS_ITEMS_SN MLOG$_MTL_SYSTEM_ITEMS_B INV ONT OE_ODR_LINES_SN OE_ORDER_LINES_ALLMTL_TXN_REQUEST_LINES_SN MLOG$_MTL_TXN_REQUEST_LINE INV PO PO_ACCEPTANCES_SN PO_ACCEPTANCESMTL_U_DEMAND_SN MLOG$_MTL_USER_DEMAND INV PO PO_CHANGE_REQUESTS_SN PO_CHANGE_REQUESTSMTL_U_SUPPLY_SN MLOG$_MTL_USER_SUPPLY INV PO PO_SI_CAPA_SN PO_SUPPLIER_ITEM_CAPACITYOE_ODR_LINES_SN MLOG$_OE_ORDER_LINES_ALL ONT WIP WIP_DSCR_JOBS_SN WIP_DISCRETE_JOBSPO_ACCEPTANCES_SN MLOG$_PO_ACCEPTANCES PO WIP WIP_FLOW_SCHDS_SN WIP_FLOW_SCHEDULESPO_CHANGE_REQUESTS_SN MLOG$_PO_CHANGE_REQUESTS PO WIP WIP_REPT_ITEMS_SN WIP_REPETITIVE_ITEMSPO_SI_CAPA_SN MLOG$_PO_SUPPLIER_ITEM_CAP PO WIP WIP_REPT_SCHDS_SN WIP_REPETITIVE_SCHEDULESWIP_DSCR_JOBS_SN MLOG$_WIP_DISCRETE_JOBS WIP WIP WIP_WLINES_SN WIP_LINESWIP_FLOW_SCHDS_SN MLOG$_WIP_FLOW_SCHEDULES WIP WIP WIP_WOPR_RESS_SN WIP_MSC_OPEN_JOB_STATUSESWIP_OPR_RES_INSTS_SN MLOG$_WIP_OP_RESOURCE_INST WIP WIP WIP_WOPRS_SN WIP_MSC_OPEN_JOB_STATUSESWIP_REPT_ITEMS_SN MLOG$_WIP_REPETITIVE_ITEMS WIP WIP WIP_WREQ_OPRS_SN WIP_MSC_OPEN_JOB_STATUSESWIP_REPT_SCHDS_SN MLOG$_WIP_REPETITIVE_SCHED WIPWIP_WLINES_SN MLOG$_WIP_LINES WIP

WIP_WOPRS_SN WIP

WIP_WOPR_RESS_SN WIP

WIP_WOPR_SUB_RESS_SN MLOG$_WIP_SUB_OPERATION_RE WIP

WIP_WREQ_OPRS_SN WIP

WSH_TRIP_SN MLOG$_WSH_TRIPS WSH






MLOG$_BOM_OPERATION_SEQUENMLOG$_BOM_SUB_OPERATION_REMLOG$_BOM_OPERATIONAL_ROUT\




L M N O P Q R

21

22

23

24

25

26

27

282930313233343536373839404142434445464748495051

52

53

54

55

56

WSH_TRIP_STOP_SN MLOG$_WSH_TRIP_STOPS WSH

WSM_LJ_OPRS_SN MLOG$_WSM_COPY_OPERATIONS WSM

WSM_LJ_OPR_NWK_SN MLOG$_WSM_COPY_OP_NETWORKS WSM

WSM_LJ_OPR_RESS_INSTS_SN MLOG$_WSM_COPY_OP_RESOURCE1 WSMWSM_LJ_OPR_RESS_SN MLOG$_WSM_COPY_OP_RESOURCE WSMWSM_LJ_REQ_OPRS_SN MLOG$_WSM_COPY_REQUIREMENT WSMMSC_ATP_PLAN_SN N/A MSC

L M N O P Q R

57

58

59

60616263646566676869707172737475767778

79

808182838485868788899091929394959697

Views for EBS Source used in Collections

MRP_AP% views are used for Complete Refresh of Data CollectionsMRP_AN% views are used for Net Change Collections MRP_AD% views are used to delete data no longer needed.

SQL used to check these viewsselect view_name from all_views where view_name like 'MRP_AP%'

select view_name from all_views where view_name like 'MRP_AN%'

select view_name from all_views where view_name like 'MRP_AD%'

SQL you can use to check the view text and see what is queried in the views.select text from all_views where view_name like '&view_name';

In 11.5.10 and R12.0, the view are contained in $MSC_TOP/sql/MSCVIEWS.sqlIn R12.1.1, they are split into different view file names[oracle@tebow sql]$ ls *VW*MSCVWBOM.sql MSCVWITM.sql MSCVWRPO.sql MSCVWSTP.sql MSCVWWIP.sqlMSCVWDEM.sql MSCVWOTH.sql MSCVWRTG.sql MSCVWSUP.sql

12.1.3.3 views 12.1.1 ViewsMRP_AP1_ONHAND_SUPPLIES_V MRP_AP1_ONHAND_SUPPLIES_VMRP_AP1_SALES_ORDERS_V MRP_AP1_SALES_ORDERS_VMRP_AP2_SALES_ORDERS_V MRP_AP2_SALES_ORDERS_VMRP_AP3_SALES_ORDERS_V MRP_AP3_SALES_ORDERS_VMRP_AP_ABC_CLASSES_V MRP_AP_ABC_CLASSES_VMRP_AP_AHL_MTL_REQS_V MRP_AP_AHL_MTL_REQS_VMRP_AP_APPS_INSTANCES MRP_AP_APPS_INSTANCESMRP_AP_ASSIGNMENT_SETS_V MRP_AP_ASSIGNMENT_SETS_VMRP_AP_ATP_RULES_V MRP_AP_ATP_RULES_VMRP_AP_BILL_OF_RESOURCES_V MRP_AP_BILL_OF_RESOURCES_VMRP_AP_BIS_PERIODS_V MRP_AP_BIS_PERIODS_VMRP_AP_BOM_COMPONENTS_V MRP_AP_BOM_COMPONENTS_VMRP_AP_BOMS_V MRP_AP_BOMS_VMRP_AP_BUYER_CONTACTS_V MRP_AP_BUYER_CONTACTS_VMRP_AP_CAL_ASSIGNMENTS_V MRP_AP_CAL_ASSIGNMENTS_VMRP_AP_CAL_WEEK_START_DATES_V MRP_AP_CAL_WEEK_START_DATES_VMRP_AP_CAL_YEAR_START_DATES_V MRP_AP_CAL_YEAR_START_DATES_VMRP_AP_CALENDAR_DATES_V MRP_AP_CALENDAR_DATES_VMRP_AP_CALENDAR_SHIFTS_V MRP_AP_CALENDAR_SHIFTS_VMRP_AP_CARRIER_SERVICES_V MRP_AP_CARRIER_SERVICES_VMRP_AP_CARRIERS_V MRP_AP_CARRIERS_VMRP_AP_CATEGORY_SETS_V MRP_AP_CATEGORY_SETS_VMRP_AP_CMRO_WIP_COMP_DMD_V MRP_AP_COMPANY_USERS_VMRP_AP_COMPANY_USERS_V MRP_AP_COMPONENT_SUBSTITUTES_VMRP_AP_COMPONENT_SUBSTITUTES_V MRP_AP_CRP_RESOURCE_HOURS_VMRP_AP_CRP_RESOURCE_HOURS_V MRP_AP_CURRENCY_CONV_VMRP_AP_CURRENCY_CONV_V MRP_AP_CUSTOMER_CONTACTS_VMRP_AP_CUSTOMER_CONTACTS_V MRP_AP_CUSTOMER_SITES_VMRP_AP_CUSTOMER_SITES_V MRP_AP_CUSTOMERS_VMRP_AP_CUSTOMERS_V MRP_AP_DEFAULT_ITEM_CATEGORY_VMRP_AP_DEFAULT_ITEM_CATEGORY_V MRP_AP_DELIVERY_DETAILS_VMRP_AP_DELIVERY_DETAILS_V MRP_AP_DEMAND_CLASSES_VMRP_AP_DEMAND_CLASSES_V MRP_AP_DEPARTMENT_RESOURCES_VMRP_AP_DEPARTMENT_RESOURCES_V MRP_AP_DEPT_RES_INSTANCES_VMRP_AP_DEPT_RES_INSTANCES_V MRP_AP_DESIGNATORS_VMRP_AP_DESIGNATORS_V MRP_AP_DISC_JOB_COMP_DEMANDS_V

A B

1

23

4

56

7

8910111213

14

1516

17

18

19202122

23

242526272829303132333435363738394041424344454647484950515253545556575859

MRP_AP_DISC_JOB_COMP_DEMANDS_V MRP_AP_DJOB_SUB_OP_RESOURCES_VMRP_AP_DJOB_SUB_OP_RESOURCES_V MRP_AP_EAM_WO_RELATIONS_VMRP_AP_EAM_WO_RELATIONS_V MRP_AP_ERO_WIP_DEMAND_VMRP_AP_ERO_WIP_DEMAND_V MRP_AP_ERO_WIP_JOB_SUPPLY_VMRP_AP_ERO_WIP_JOB_SUPPLY_V MRP_AP_EXT_REP_RESERVATIONS_VMRP_AP_EXT_REP_RESERVATIONS_V MRP_AP_FISCAL_TIME_VMRP_AP_FISCAL_TIME_V MRP_AP_FORECAST_DEMAND_VMRP_AP_FORECAST_DEMAND_V MRP_AP_FORECAST_DSGN_VMRP_AP_FORECAST_DSGN_V MRP_AP_HARD_RESERVATIONS_VMRP_AP_HARD_RESERVATIONS_V MRP_AP_INNER_ORG_TRXS_VMRP_AP_INNER_ORG_TRXS_V MRP_AP_INTER_ORG_TRXS_VMRP_AP_INTER_ORG_TRXS_V MRP_AP_INTERORG_SHIP_METHODS_VMRP_AP_INTERORG_SHIP_METHODS_V MRP_AP_INTRANSIT_SUPPLIES_VMRP_AP_INTRANSIT_SUPPLIES_V MRP_AP_ITEM_CATEGORIES_VMRP_AP_ITEM_CATEGORIES_V MRP_AP_ITEM_OPEN_PAYBACK_QTY_VMRP_AP_ITEM_OPEN_PAYBACK_QTY_V MRP_AP_ITEM_SUBSTITUTES_VMRP_AP_ITEM_SUBSTITUTES_V MRP_AP_ITEM_SUPERSESSION_REL_VMRP_AP_ITEM_SUPERSESSION_REL_V MRP_AP_JOB_OP_NETWORKS_VMRP_AP_JOB_OP_NETWORKS_V MRP_AP_JOB_OP_RESOURCES_VMRP_AP_JOB_OP_RESOURCES_V MRP_AP_JOB_OPERATIONS_VMRP_AP_JOB_OPERATIONS_V MRP_AP_JOB_REQUIREMENT_OPS_VMRP_AP_JOB_REQUIREMENT_OPS_V MRP_AP_JOB_RES_INSTANCES_VMRP_AP_JOB_RES_INSTANCES_V MRP_AP_LINE_RESOURCES_VMRP_AP_LINE_RESOURCES_V MRP_AP_LJ_SUB_OP_RESOURCES_VMRP_AP_LJ_SUB_OP_RESOURCES_V MRP_AP_LOCATION_ASSOCIATIONS_VMRP_AP_LOCATION_ASSOCIATIONS_V MRP_AP_MDS_DEMANDS_VMRP_AP_MDS_DEMANDS_V MRP_AP_MPS_SUPPLIES_VMRP_AP_MPS_SUPPLIES_V MRP_AP_NOCOST_SYSTEM_ITEMS_VMRP_AP_NOCOST_SYSTEM_ITEMS_V MRP_AP_NON_ERO_WIP_DEMAND_VMRP_AP_NON_ERO_WIP_DEMAND_V MRP_AP_NON_ERO_WIP_JOB_SUPP_VMRP_AP_NON_ERO_WIP_JOB_SUPP_V MRP_AP_NON_IRO_ERO_RES_REQ_VMRP_AP_NON_IRO_ERO_RES_REQ_V MRP_AP_NON_RO_WIP_DEMAND_VMRP_AP_NON_RO_WIP_DEMAND_V MRP_AP_NON_RO_WIP_JOB_SUPPLY_VMRP_AP_NON_RO_WIP_JOB_SUPPLY_V MRP_AP_NON_RO_WIP_JOB_VMRP_AP_NON_RO_WIP_JOB_V MRP_AP_ONHAND_SUPPLIES_VMRP_AP_OH_PO_RCV_SUPPLY_V MRP_AP_OP_RESOURCE_SEQS_VMRP_AP_ONHAND_SUPPLIES_V MRP_AP_OPEN_PAYBACK_QTY_VMRP_AP_OP_RESOURCE_SEQS_V MRP_AP_OPER_NETWORKS_VMRP_AP_OPEN_PAYBACK_QTY_V MRP_AP_OPERATION_COMPONENTS_VMRP_AP_OPER_NETWORKS_V MRP_AP_OPERATION_RESOURCES_VMRP_AP_OPERATION_COMPONENTS_V MRP_AP_ORGANIZATION_SITES_VMRP_AP_OPERATION_RESOURCES_V MRP_AP_ORGANIZATIONS_VMRP_AP_ORGANIZATION_SITES_V MRP_AP_PARAMETERS_VMRP_AP_ORGANIZATIONS_V MRP_AP_PERIOD_START_DATES_VMRP_AP_PARAMETERS_V MRP_AP_PLANNERS_VMRP_AP_PERIOD_START_DATES_V MRP_AP_PO_CSP_SUPPLY_VMRP_AP_PLANNERS_V MRP_AP_PO_LOCAL_ASL_VMRP_AP_PO_CSP_SUPPLY_V MRP_AP_PO_PO_SUPPLY_VMRP_AP_PO_LOCAL_ASL_V MRP_AP_PO_RCV_SUPPLY_VMRP_AP_PO_PO_SUPPLY_V MRP_AP_PO_REQ_SUPPLY_VMRP_AP_PO_RCV_SUPPLY_V MRP_AP_PO_SHIP_RCV_SUPPLY_VMRP_AP_PO_REQ_SUPPLY_V MRP_AP_PO_SHIP_SUPPLY_VMRP_AP_PO_SHIP_RCV_SUPPLY_V MRP_AP_PO_SUPPLIER_TRXS_VMRP_AP_PO_SHIP_SUPPLY_V MRP_AP_PO_SUPPLIERS_VMRP_AP_PO_SUPPLIER_TRXS_V MRP_AP_PROCESS_EFFECTIVITY_VMRP_AP_PO_SUPPLIERS_V MRP_AP_PROJECT_TASKS_VMRP_AP_PROCESS_EFFECTIVITY_V MRP_AP_PROJECTS_VMRP_AP_PROJECT_TASKS_V MRP_AP_REGION_SITES_VMRP_AP_PROJECTS_V MRP_AP_REPAIR_DEMAND_VMRP_AP_REGION_SITES_V MRP_AP_REPAIR_ORDERS_VMRP_AP_REPAIR_DEMAND_V MRP_AP_REPAIR_TRANSFERS_RESV_VMRP_AP_REPAIR_ORDERS_V MRP_AP_REPT_ITEM_DEMANDS_V

A B60616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121

MRP_AP_REPAIR_TRANSFERS_RESV_V MRP_AP_REPT_ITEM_SUPPLIES_VMRP_AP_REPT_ITEM_DEMANDS_V MRP_AP_RES_INST_CHANGES_VMRP_AP_REPT_ITEM_SUPPLIES_V MRP_AP_RES_INSTANCE_REQS_VMRP_AP_RES_INST_CHANGES_V MRP_AP_RESOURCE_CHANGES_VMRP_AP_RES_INSTANCE_REQS_V MRP_AP_RESOURCE_GROUPS_VMRP_AP_RESOURCE_CHANGES_V MRP_AP_RESOURCE_REQUIREMENTS_VMRP_AP_RESOURCE_GROUPS_V MRP_AP_RESOURCE_SETUPS_VMRP_AP_RESOURCE_REQUIREMENTS_V MRP_AP_RESOURCE_SHIFTS_VMRP_AP_RESOURCE_SETUPS_V MRP_AP_ROUTING_OPERATIONS_VMRP_AP_RESOURCE_SHIFTS_V MRP_AP_ROUTINGS_VMRP_AP_ROUTING_OPERATIONS_V MRP_AP_SAFETY_STOCKS_VMRP_AP_ROUTINGS_V MRP_AP_SALES_CHANNEL_VMRP_AP_SAFETY_STOCKS_V MRP_AP_SETUP_TRANSITIONS_VMRP_AP_SALES_CHANNEL_V MRP_AP_SHIFT_DATES_VMRP_AP_SETUP_TRANSITIONS_V MRP_AP_SHIFT_EXCEPTIONS_VMRP_AP_SHIFT_DATES_V MRP_AP_SHIFT_TIMES_VMRP_AP_SHIFT_EXCEPTIONS_V MRP_AP_SIMULATION_SETS_VMRP_AP_SHIFT_TIMES_V MRP_AP_SOURCING_RULES_VMRP_AP_SIMULATION_SETS_V MRP_AP_SR_ASSIGNMENTS_VMRP_AP_SOURCING_RULES_V MRP_AP_SR_RECEIPT_ORG_VMRP_AP_SR_ASSIGNMENTS_V MRP_AP_SR_SOURCE_ORG_VMRP_AP_SR_RECEIPT_ORG_V MRP_AP_STD_OP_RESOURCES_VMRP_AP_SR_SOURCE_ORG_V MRP_AP_SUB_INVENTORIES_NEW_VMRP_AP_STD_OP_RESOURCES_V MRP_AP_SUB_INVENTORIES_VMRP_AP_SUB_INVENTORIES_NEW_V MRP_AP_SUPPLIER_CAPACITIES_VMRP_AP_SUB_INVENTORIES_V MRP_AP_SUPPLIER_FLEX_FENCES_VMRP_AP_SUPPLIER_CAPACITIES_V MRP_AP_SUPPLIER_RESPONSE_VMRP_AP_SUPPLIER_FLEX_FENCES_V MRP_AP_SYS_ITEMS_VMRP_AP_SUPPLIER_RESPONSE_V MRP_AP_SYSTEM_ITEMS_VMRP_AP_SYS_ITEMS_V MRP_AP_TRIP_STOPS_VMRP_AP_SYSTEM_ITEMS_V MRP_AP_TRIPS_VMRP_AP_TRIP_STOPS_V MRP_AP_UNIT_BORROW_QTY_VMRP_AP_TRIPS_V MRP_AP_UNIT_NUMBERS_VMRP_AP_UNIT_BORROW_QTY_V MRP_AP_UNIT_PAYBACK_QTY_VMRP_AP_UNIT_NUMBERS_V MRP_AP_UNITS_OF_MEASURE_VMRP_AP_UNIT_PAYBACK_QTY_V MRP_AP_UOM_CLASS_CONVERSIONS_VMRP_AP_UNITS_OF_MEASURE_V MRP_AP_UOM_CONVERSIONS_VMRP_AP_UOM_CLASS_CONVERSIONS_V MRP_AP_USER_DEMANDS_VMRP_AP_UOM_CONVERSIONS_V MRP_AP_USER_SUPPLIES_VMRP_AP_USER_DEMANDS_V MRP_AP_VENDOR_CONTACTS_VMRP_AP_USER_SUPPLIES_V MRP_AP_VENDOR_SITES_VMRP_AP_VENDOR_CONTACTS_V MRP_AP_VENDORS_VMRP_AP_VENDOR_SITES_V MRP_AP_VMI_INTRANSITS_VMRP_AP_VENDORS_V MRP_AP_WIP_COMP_DEMANDS_VMRP_AP_VMI_INTRANSITS_V MRP_AP_WIP_COMP_SUPPLIES_VMRP_AP_WIP_COMP_DEMANDS_V MRP_AP_WIP_DISCRETE_JOBS_VMRP_AP_WIP_COMP_SUPPLIES_V MRP_AP_WIP_JOB_SUPPLIES_VMRP_AP_WIP_DISCRETE_JOBS_V MRP_AP_WIP_JOBS_VMRP_AP_WIP_JOB_SUPPLIES_V MRP_AP_WIP_OPR_NETWORKS_VMRP_AP_WIP_JOBS_V MRP_AP_WSH_REGION_LOCATIONS_VMRP_AP_WIP_OPR_NETWORKS_V MRP_AP_WSH_REGIONS_VMRP_AP_WSH_REGION_LOCATIONS_V MRP_AP_WSH_ZONE_REGIONS_VMRP_AP_WSH_REGIONS_VMRP_AP_WSH_ZONE_REGIONS_V MRP_AN_AHL_MTL_REQS_V

MRP_AN_BOM_COMPONENTS_VMRP_AN1_SALES_ORDERS_V MRP_AN_ONHAND_SUPPLIES_VMRP_AN2_SALES_ORDERS_V MRP_AN_PO_GLOBAL_ASL_VMRP_AN3_SALES_ORDERS_V MRP_AN_PO_LOCAL_ASL_VMRP_AN_AHL_MTL_REQS_V MRP_AN1_SALES_ORDERS_VMRP_AN_BOM_COMPONENTS_V MRP_AN2_SALES_ORDERS_VMRP_AN_ONHAND_SUPPLIES_V MRP_AN3_SALES_ORDERS_VMRP_AN_PO_GLOBAL_ASL_V

A B122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183

MRP_AN_PO_LOCAL_ASL_V MRP_AD_BOM_COMPONENTS_VMRP_AD_BOMS_V

MRP_AD_BOMS_V MRP_AD_DJOB_SUB_OP_RESOURCES_VMRP_AD_BOM_COMPONENTS_V MRP_AD_EAM_WO_RELSHIPS_VMRP_AD_DJOB_SUB_OP_RESOURCES_V MRP_AD_ERO_WIP_COMP_DEM_VMRP_AD_EAM_WO_RELSHIPS_V MRP_AD_ERO_WIP_JOB_SUPP_VMRP_AD_ERO_WIP_COMP_DEM_V MRP_AD_FORECAST_DEMAND_VMRP_AD_ERO_WIP_JOB_SUPP_V MRP_AD_FORECAST_DSGN_VMRP_AD_FORECAST_DEMAND_V MRP_AD_HARD_RESERVATIONS_VMRP_AD_FORECAST_DSGN_V MRP_AD_ITEM_CATEGORIES_VMRP_AD_HARD_RESERVATIONS_V MRP_AD_ITEM_RELATIONSHIPS_VMRP_AD_ITEM_CATEGORIES_V MRP_AD_JOB_OP_NETWORKS_VMRP_AD_ITEM_RELATIONSHIPS_V MRP_AD_JOB_OP_RESOURCES_VMRP_AD_JOB_OPERATIONS_V MRP_AD_JOB_OPERATIONS_VMRP_AD_JOB_OP_NETWORKS_V MRP_AD_LJ_OPR_RES_INSTS_VMRP_AD_JOB_OP_RESOURCES_V MRP_AD_LJ_SUB_OP_RESOURCES_VMRP_AD_LJ_OPR_RES_INSTS_V MRP_AD_MDS_DEMANDS_VMRP_AD_LJ_SUB_OP_RESOURCES_V MRP_AD_MPS_SUPPLIES_VMRP_AD_MDS_DEMANDS_V MRP_AD_NON_ERO_WIP_COMP_DEM_VMRP_AD_MPS_SUPPLIES_V MRP_AD_NON_ERO_WIP_JOB_SUP_VMRP_AD_NON_ERO_WIP_COMP_DEM_V MRP_AD_NON_IRO_ERO_RES_REQ_VMRP_AD_NON_ERO_WIP_JOB_SUP_V MRP_AD_NON_RO_WIP_COMP_DEM_VMRP_AD_NON_IRO_ERO_RES_REQ_V MRP_AD_NON_RO_WIP_JOB_SUPP_VMRP_AD_NON_RO_WIP_COMP_DEM_V MRP_AD_ONHAND_SUPPLIES_VMRP_AD_NON_RO_WIP_JOB_SUPP_V MRP_AD_OP_RESOURCE_SEQS_VMRP_AD_ONHAND_SUPPLIES_V MRP_AD_OPER_NETWORKS_VMRP_AD_OPERATION_COMPONENTS_V MRP_AD_OPERATION_COMPONENTS_VMRP_AD_OPERATION_RESOURCES_V MRP_AD_OPERATION_RESOURCES_VMRP_AD_OPER_NETWORKS_V MRP_AD_PO_SUPPLIES_VMRP_AD_OP_RESOURCE_SEQS_V MRP_AD_PROCESS_EFFECTIVITY_VMRP_AD_PO_SUPPLIES_V MRP_AD_REPAIR_RESERVATIONS_VMRP_AD_PROCESS_EFFECTIVITY_V MRP_AD_REPT_ITEM_DEMANDS_VMRP_AD_REPAIR_RESERVATIONS_V MRP_AD_REPT_ITEM_SUPPLIES_VMRP_AD_REPT_ITEM_DEMANDS_V MRP_AD_REQUIREMENT_OPS_VMRP_AD_REPT_ITEM_SUPPLIES_V MRP_AD_RES_INST_CHANGES_VMRP_AD_REQUIREMENT_OPS_V MRP_AD_RES_INSTANCE_REQS_VMRP_AD_RESOURCE_CHANGES_V MRP_AD_RESOURCE_CHANGES_VMRP_AD_RESOURCE_REQUIREMENTS_V MRP_AD_RESOURCE_REQUIREMENTS_VMRP_AD_RES_INSTANCE_REQS_V MRP_AD_RO_WIP_COMP_DEMANDS_VMRP_AD_RES_INST_CHANGES_V MRP_AD_ROUTING_OPERATIONS_VMRP_AD_ROUTINGS_V MRP_AD_ROUTINGS_VMRP_AD_ROUTING_OPERATIONS_V MRP_AD_SALES_ORDERS_VMRP_AD_RO_WIP_COMP_DEMANDS_V MRP_AD_SUB_COMPS_VMRP_AD_SALES_ORDERS_V MRP_AD_SUB_OPER_RESS_VMRP_AD_SUB_COMPS_V MRP_AD_SUPPLIER_CAPACITIES_VMRP_AD_SUB_OPER_RESS_V MRP_AD_TRIP_STOPS_VMRP_AD_SUPPLIER_CAPACITIES_V MRP_AD_TRIPS_VMRP_AD_TRIPS_V MRP_AD_USER_DEMANDS_VMRP_AD_TRIP_STOPS_V MRP_AD_USER_SUPPLIES_VMRP_AD_USER_DEMANDS_V MRP_AD_WIP_COMP_DEMANDS_VMRP_AD_USER_SUPPLIES_V MRP_AD_WIP_COMP_SUPPLIES_VMRP_AD_WIP_COMP_DEMANDS_V MRP_AD_WIP_FLOW_DEMANDS_VMRP_AD_WIP_COMP_SUPPLIES_V MRP_AD_WIP_JOB_SUPPLIES_VMRP_AD_WIP_FLOW_DEMANDS_V MRP_AD_WOPR_NETWORKS_VMRP_AD_WIP_JOB_SUPPLIES_VMRP_AD_WOPR_NETWORKS_V

A B184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242

12.0.6 Views 11.5.10 ViewsMRP_AP1_ONHAND_SUPPLIES_V MRP_AP_AHL_MTL_REQS_VMRP_AP1_SALES_ORDERS_V MRP_AP_APPS_INSTANCESMRP_AP2_SALES_ORDERS_V MRP_AP_ASSIGNMENT_SETS_VMRP_AP3_SALES_ORDERS_V MRP_AP_ATP_RULES_VMRP_AP4_SALES_ORDERS_V MRP_AP_BILL_OF_RESOURCES_VMRP_AP_ABC_CLASSES_V MRP_AP_BIS_PERIODS_VMRP_AP_AHL_MTL_REQS_V MRP_AP_BOM_COMPONENTS_VMRP_AP_APPS_INSTANCES MRP_AP_BOMS_VMRP_AP_ASSIGNMENT_SETS_V MRP_AP_BUYER_CONTACTS_VMRP_AP_ATP_RULES_V MRP_AP_CAL_ASSIGNMENTS_VMRP_AP_BILL_OF_RESOURCES_V MRP_AP_CAL_WEEK_START_DATES_VMRP_AP_BIS_PERIODS_V MRP_AP_CAL_YEAR_START_DATES_VMRP_AP_BOMS_V MRP_AP_CALENDAR_DATES_VMRP_AP_BOM_COMPONENTS_V MRP_AP_CALENDAR_SHIFTS_VMRP_AP_BUYER_CONTACTS_V MRP_AP_CARRIER_SERVICES_VMRP_AP_CALENDAR_DATES_V MRP_AP_CARRIERS_VMRP_AP_CALENDAR_SHIFTS_V MRP_AP_CATEGORY_SETS_VMRP_AP_CAL_ASSIGNMENTS_V MRP_AP_COMPANY_USERS_VMRP_AP_CAL_WEEK_START_DATES_V MRP_AP_COMPONENT_SUBSTITUTES_VMRP_AP_CAL_YEAR_START_DATES_V MRP_AP_CRP_RESOURCE_HOURS_VMRP_AP_CARRIERS_V MRP_AP_CURRENCY_CONV_VMRP_AP_CARRIER_SERVICES_V MRP_AP_CUSTOMER_CONTACTS_VMRP_AP_CATEGORY_SETS_V MRP_AP_CUSTOMER_SITES_VMRP_AP_COMPANY_USERS_V MRP_AP_CUSTOMERS_VMRP_AP_COMPONENT_SUBSTITUTES_V MRP_AP_DEFAULT_ITEM_CATEGORY_VMRP_AP_CRP_RESOURCE_HOURS_V MRP_AP_DEMAND_CLASSES_VMRP_AP_CURRENCY_CONV_V MRP_AP_DEPARTMENT_RESOURCES_VMRP_AP_CUSTOMERS_V MRP_AP_DEPT_RES_INSTANCES_VMRP_AP_CUSTOMER_CONTACTS_V MRP_AP_DESIGNATORS_VMRP_AP_CUSTOMER_SITES_V MRP_AP_DJOB_SUB_OP_RESOURCES_VMRP_AP_DEFAULT_ITEM_CATEGORY_V MRP_AP_FISCAL_TIME_VMRP_AP_DELIVERY_DETAILS_V MRP_AP_FORECAST_DEMAND_VMRP_AP_DEMAND_CLASSES_V MRP_AP_FORECAST_DSGN_VMRP_AP_DEPARTMENT_RESOURCES_V MRP_AP_HARD_RESERVATIONS_VMRP_AP_DEPT_RES_INSTANCES_V MRP_AP_INNER_ORG_TRXS_VMRP_AP_DESIGNATORS_V MRP_AP_INTER_ORG_TRXS_V

C D

1

23

4

56

7

8910111213

14

1516

17

18

19202122

23

242526272829303132333435363738394041424344454647484950515253545556575859

MRP_AP_DISC_JOB_COMP_DEMANDS_V MRP_AP_INTERORG_SHIP_METHODS_VMRP_AP_DJOB_SUB_OP_RESOURCES_V MRP_AP_INTRANSIT_SUPPLIES_VMRP_AP_EAM_WO_RELATIONS_V MRP_AP_ITEM_CATEGORIES_VMRP_AP_ERO_WIP_DEMAND_V MRP_AP_ITEM_OPEN_PAYBACK_QTY_VMRP_AP_ERO_WIP_JOB_SUPPLY_V MRP_AP_ITEM_SUBSTITUTES_VMRP_AP_EXT_REP_RESERVATIONS_V MRP_AP_ITEM_SUPERSESSION_REL_VMRP_AP_FISCAL_TIME_V MRP_AP_JOB_OP_NETWORKS_VMRP_AP_FORECAST_DEMAND_V MRP_AP_JOB_OP_RESOURCES_VMRP_AP_FORECAST_DSGN_V MRP_AP_JOB_OPERATIONS_VMRP_AP_HARD_RESERVATIONS_V MRP_AP_JOB_REQUIREMENT_OPS_VMRP_AP_INNER_ORG_TRXS_V MRP_AP_JOB_RES_INSTANCES_VMRP_AP_INTERORG_SHIP_METHODS_V MRP_AP_LINE_RESOURCES_VMRP_AP_INTER_ORG_TRXS_V MRP_AP_LJ_SUB_OP_RESOURCES_VMRP_AP_INTRANSIT_SUPPLIES_V MRP_AP_LOCATION_ASSOCIATIONS_VMRP_AP_ITEM_CATEGORIES_V MRP_AP_MDS_DEMANDS_VMRP_AP_ITEM_OPEN_PAYBACK_QTY_V MRP_AP_MPS_SUPPLIES_VMRP_AP_ITEM_SUBSTITUTES_V MRP_AP_NOCOST_SYSTEM_ITEMS_VMRP_AP_ITEM_SUPERSESSION_REL_V MRP_AP_ONHAND_SUPPLIES_VMRP_AP_JOB_OPERATIONS_V MRP_AP_OP_RESOURCE_SEQS_VMRP_AP_JOB_OP_NETWORKS_V MRP_AP_OPEN_PAYBACK_QTY_VMRP_AP_JOB_OP_RESOURCES_V MRP_AP_OPER_NETWORKS_VMRP_AP_JOB_REQUIREMENT_OPS_V MRP_AP_OPERATION_COMPONENTS_VMRP_AP_JOB_RES_INSTANCES_V MRP_AP_OPERATION_RESOURCES_VMRP_AP_LINE_RESOURCES_V MRP_AP_ORGANIZATION_SITES_VMRP_AP_LJ_SUB_OP_RESOURCES_V MRP_AP_ORGANIZATIONS_VMRP_AP_LOCATION_ASSOCIATIONS_V MRP_AP_PARAMETERS_VMRP_AP_MDS_DEMANDS_V MRP_AP_PERIOD_START_DATES_VMRP_AP_MPS_SUPPLIES_V MRP_AP_PLANNERS_VMRP_AP_NOCOST_SYSTEM_ITEMS_V MRP_AP_PO_LOCAL_ASL_VMRP_AP_NON_ERO_WIP_DEMAND_V MRP_AP_PO_PO_SUPPLY_VMRP_AP_NON_ERO_WIP_JOB_SUPP_V MRP_AP_PO_RCV_SUPPLY_VMRP_AP_NON_IRO_ERO_RES_REQ_V MRP_AP_PO_REQ_SUPPLY_VMRP_AP_NON_RO_WIP_DEMAND_V MRP_AP_PO_SHIP_RCV_SUPPLY_VMRP_AP_NON_RO_WIP_JOB_SUPPLY_V MRP_AP_PO_SHIP_SUPPLY_VMRP_AP_NON_RO_WIP_JOB_V MRP_AP_PO_SUPPLIER_TRXS_VMRP_AP_OH_PO_RCV_SUPPLY_V MRP_AP_PO_SUPPLIERS_VMRP_AP_ONHAND_SUPPLIES_V MRP_AP_PROCESS_EFFECTIVITY_VMRP_AP_OPEN_PAYBACK_QTY_V MRP_AP_PROJECT_TASKS_VMRP_AP_OPERATION_COMPONENTS_V MRP_AP_PROJECTS_VMRP_AP_OPERATION_RESOURCES_V MRP_AP_REGION_SITES_VMRP_AP_OPER_NETWORKS_V MRP_AP_REPT_ITEM_DEMANDS_VMRP_AP_OP_RESOURCE_SEQS_V MRP_AP_REPT_ITEM_SUPPLIES_VMRP_AP_ORGANIZATIONS_V MRP_AP_RES_INST_CHANGES_VMRP_AP_ORGANIZATION_SITES_V MRP_AP_RES_INSTANCE_REQS_VMRP_AP_PARAMETERS_V MRP_AP_RESOURCE_CHANGES_VMRP_AP_PERIOD_START_DATES_V MRP_AP_RESOURCE_GROUPS_VMRP_AP_PLANNERS_V MRP_AP_RESOURCE_REQUIREMENTS_VMRP_AP_PO_CSP_SUPPLY_V MRP_AP_RESOURCE_SETUPS_VMRP_AP_PO_LOCAL_ASL_V MRP_AP_RESOURCE_SHIFTS_VMRP_AP_PO_PO_SUPPLY_V MRP_AP_ROUTING_OPERATIONS_VMRP_AP_PO_RCV_SUPPLY_V MRP_AP_ROUTINGS_VMRP_AP_PO_REQ_SUPPLY_V MRP_AP_SAFETY_STOCKS_VMRP_AP_PO_SHIP_RCV_SUPPLY_V MRP_AP_SALES_CHANNEL_VMRP_AP_PO_SHIP_SUPPLY_V MRP_AP_SALES_ORDERS_VMRP_AP_PO_SUPPLIERS_V MRP_AP_SETUP_TRANSITIONS_VMRP_AP_PO_SUPPLIER_TRXS_V MRP_AP_SHIFT_DATES_VMRP_AP_PROCESS_EFFECTIVITY_V MRP_AP_SHIFT_EXCEPTIONS_VMRP_AP_PROJECTS_V MRP_AP_SHIFT_TIMES_VMRP_AP_PROJECT_TASKS_V MRP_AP_SIMULATION_SETS_VMRP_AP_REGION_SITES_V MRP_AP_SOURCING_RULES_VMRP_AP_REPAIR_DEMAND_V MRP_AP_SR_ASSIGNMENTS_VMRP_AP_REPAIR_ORDERS_V MRP_AP_SR_RECEIPT_ORG_V

C D60616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121

MRP_AP_REPAIR_TRANSFERS_RESV_V MRP_AP_SR_SOURCE_ORG_VMRP_AP_REPT_ITEM_DEMANDS_V MRP_AP_STD_OP_RESOURCES_VMRP_AP_REPT_ITEM_SUPPLIES_V MRP_AP_SUB_INVENTORIES_NEW_VMRP_AP_RESOURCE_CHANGES_V MRP_AP_SUB_INVENTORIES_VMRP_AP_RESOURCE_GROUPS_V MRP_AP_SUPPLIER_CAPACITIES_VMRP_AP_RESOURCE_REQUIREMENTS_V MRP_AP_SUPPLIER_FLEX_FENCES_VMRP_AP_RESOURCE_SETUPS_V MRP_AP_SUPPLIER_RESPONSE_VMRP_AP_RESOURCE_SHIFTS_V MRP_AP_SYS_ITEMS_VMRP_AP_RES_INSTANCE_REQS_V MRP_AP_SYSTEM_ITEMS_VMRP_AP_RES_INST_CHANGES_V MRP_AP_TRIP_STOPS_VMRP_AP_ROUTINGS_V MRP_AP_TRIPS_VMRP_AP_ROUTING_OPERATIONS_V MRP_AP_UNIT_BORROW_QTY_VMRP_AP_SAFETY_STOCKS_V MRP_AP_UNIT_NUMBERS_VMRP_AP_SALES_CHANNEL_V MRP_AP_UNIT_PAYBACK_QTY_VMRP_AP_SALES_ORDERS_V MRP_AP_UNITS_OF_MEASURE_VMRP_AP_SETUP_TRANSITIONS_V MRP_AP_UOM_CLASS_CONVERSIONS_VMRP_AP_SHIFT_DATES_V MRP_AP_UOM_CONVERSIONS_VMRP_AP_SHIFT_EXCEPTIONS_V MRP_AP_USER_DEMANDS_VMRP_AP_SHIFT_TIMES_V MRP_AP_USER_SUPPLIES_VMRP_AP_SIMULATION_SETS_V MRP_AP_VENDOR_CONTACTS_VMRP_AP_SOURCING_RULES_V MRP_AP_VENDOR_SITES_VMRP_AP_SR_ASSIGNMENTS_V MRP_AP_VENDORS_VMRP_AP_SR_RECEIPT_ORG_V MRP_AP_VMI_INTRANSITS_VMRP_AP_SR_SOURCE_ORG_V MRP_AP_WIP_COMP_DEMANDS_VMRP_AP_STD_OP_RESOURCES_V MRP_AP_WIP_COMP_SUPPLIES_VMRP_AP_SUB_INVENTORIES_NEW_V MRP_AP_WIP_DISCRETE_JOBS_VMRP_AP_SUB_INVENTORIES_V MRP_AP_WIP_JOB_SUPPLIES_VMRP_AP_SUPPLIER_CAPACITIES_V MRP_AP_WIP_JOBS_VMRP_AP_SUPPLIER_FLEX_FENCES_V MRP_AP_WSH_REGION_LOCATIONS_VMRP_AP_SUPPLIER_RESPONSE_V MRP_AP_WSH_REGIONS_VMRP_AP_SYSTEM_ITEMS_V MRP_AP_WSH_ZONE_REGIONS_VMRP_AP_SYS_ITEMS_V MRP_AP1_ONHAND_SUPPLIES_VMRP_AP_TRIPS_V MRP_AP1_SALES_ORDERS_VMRP_AP_TRIP_STOPS_V MRP_AP2_SALES_ORDERS_VMRP_AP_UNITS_OF_MEASURE_V MRP_AP3_SALES_ORDERS_VMRP_AP_UNIT_BORROW_QTY_V MRP_AP4_SALES_ORDERS_VMRP_AP_UNIT_NUMBERS_VMRP_AP_UNIT_PAYBACK_QTY_VMRP_AP_UOM_CLASS_CONVERSIONS_V MRP_AN_AHL_MTL_REQS_VMRP_AP_UOM_CONVERSIONS_V MRP_AN_BOM_COMPONENTS_VMRP_AP_USER_DEMANDS_V MRP_AN_ONHAND_SUPPLIES_VMRP_AP_USER_SUPPLIES_V MRP_AN_PO_GLOBAL_ASL_VMRP_AP_VENDORS_V MRP_AN_PO_LOCAL_ASL_VMRP_AP_VENDOR_CONTACTS_V MRP_AN_SALES_ORDERS_VMRP_AP_VENDOR_SITES_V MRP_AN1_SALES_ORDERS_VMRP_AP_VMI_INTRANSITS_V MRP_AN2_SALES_ORDERS_VMRP_AP_WIP_COMP_DEMANDS_V MRP_AN3_SALES_ORDERS_VMRP_AP_WIP_COMP_SUPPLIES_V MRP_AN4_SALES_ORDERS_VMRP_AP_WIP_DISCRETE_JOBS_VMRP_AP_WIP_JOBS_VMRP_AP_WIP_JOB_SUPPLIES_V MRP_AD_BOM_COMPONENTS_VMRP_AP_WIP_OPR_NETWORKS_V MRP_AD_BOMS_VMRP_AP_WSH_REGIONS_V MRP_AD_DJOB_SUB_OP_RESOURCES_VMRP_AP_WSH_REGION_LOCATIONS_V MRP_AD_FORECAST_DEMAND_VMRP_AP_WSH_ZONE_REGIONS_V MRP_AD_FORECAST_DSGN_V

MRP_AD_HARD_RESERVATIONS_VMRP_AN_AHL_MTL_REQS_V MRP_AD_ITEM_CATEGORIES_VMRP_AN_BOM_COMPONENTS_V MRP_AD_JOB_OP_NETWORKS_VMRP_AN_ONHAND_SUPPLIES_V MRP_AD_JOB_OP_RESOURCES_VMRP_AN_PO_GLOBAL_ASL_V MRP_AD_JOB_OPERATIONS_VMRP_AN_PO_LOCAL_ASL_V MRP_AD_LJ_OPR_RES_INSTS_VMRP_AN_SALES_ORDERS_V MRP_AD_LJ_SUB_OP_RESOURCES_V

C D122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183

MRP_AN1_SALES_ORDERS_V MRP_AD_MDS_DEMANDS_VMRP_AN2_SALES_ORDERS_V MRP_AD_MPS_SUPPLIES_VMRP_AN3_SALES_ORDERS_V MRP_AD_ONHAND_SUPPLIES_VMRP_AN4_SALES_ORDERS_V MRP_AD_OP_RESOURCE_SEQS_V

MRP_AD_OPER_NETWORKS_VMRP_AD_BOM_COMPONENTS_V MRP_AD_OPERATION_COMPONENTS_VMRP_AD_BOMS_V MRP_AD_OPERATION_RESOURCES_VMRP_AD_DJOB_SUB_OP_RESOURCES_V MRP_AD_PO_SUPPLIES_VMRP_AD_EAM_WO_RELSHIPS_V MRP_AD_PROCESS_EFFECTIVITY_VMRP_AD_ERO_WIP_COMP_DEM_V MRP_AD_REPT_ITEM_DEMANDS_VMRP_AD_ERO_WIP_JOB_SUPP_V MRP_AD_REPT_ITEM_SUPPLIES_VMRP_AD_FORECAST_DEMAND_V MRP_AD_REQUIREMENT_OPS_VMRP_AD_FORECAST_DSGN_V MRP_AD_RES_INST_CHANGES_VMRP_AD_HARD_RESERVATIONS_V MRP_AD_RES_INSTANCE_REQS_VMRP_AD_ITEM_CATEGORIES_V MRP_AD_RESOURCE_CHANGES_VMRP_AD_ITEM_RELATIONSHIPS_V MRP_AD_RESOURCE_REQUIREMENTS_VMRP_AD_JOB_OP_NETWORKS_V MRP_AD_ROUTING_OPERATIONS_VMRP_AD_JOB_OP_RESOURCES_V MRP_AD_ROUTINGS_VMRP_AD_JOB_OPERATIONS_V MRP_AD_SALES_ORDERS_VMRP_AD_LJ_OPR_RES_INSTS_V MRP_AD_SUB_COMPS_VMRP_AD_LJ_SUB_OP_RESOURCES_V MRP_AD_SUB_OPER_RESS_VMRP_AD_MDS_DEMANDS_V MRP_AD_SUPPLIER_CAPACITIES_VMRP_AD_MPS_SUPPLIES_V MRP_AD_TRIP_STOPS_VMRP_AD_NON_ERO_WIP_COMP_DEM_V MRP_AD_TRIPS_VMRP_AD_NON_ERO_WIP_JOB_SUP_V MRP_AD_USER_DEMANDS_VMRP_AD_NON_IRO_ERO_RES_REQ_V MRP_AD_USER_SUPPLIES_VMRP_AD_NON_RO_WIP_COMP_DEM_V MRP_AD_WIP_COMP_DEMANDS_VMRP_AD_NON_RO_WIP_JOB_SUPP_V MRP_AD_WIP_COMP_SUPPLIES_VMRP_AD_ONHAND_SUPPLIES_V MRP_AD_WIP_FLOW_DEMANDS_VMRP_AD_OP_RESOURCE_SEQS_V MRP_AD_WIP_JOB_SUPPLIES_VMRP_AD_OPER_NETWORKS_VMRP_AD_OPERATION_COMPONENTS_VMRP_AD_OPERATION_RESOURCES_VMRP_AD_PO_SUPPLIES_VMRP_AD_PROCESS_EFFECTIVITY_VMRP_AD_REPAIR_RESERVATIONS_VMRP_AD_REPT_ITEM_DEMANDS_VMRP_AD_REPT_ITEM_SUPPLIES_VMRP_AD_REQUIREMENT_OPS_VMRP_AD_RES_INST_CHANGES_VMRP_AD_RES_INSTANCE_REQS_VMRP_AD_RESOURCE_CHANGES_VMRP_AD_RESOURCE_REQUIREMENTS_VMRP_AD_RO_WIP_COMP_DEMANDS_VMRP_AD_ROUTING_OPERATIONS_VMRP_AD_ROUTINGS_VMRP_AD_SALES_ORDERS_VMRP_AD_SUB_COMPS_VMRP_AD_SUB_OPER_RESS_VMRP_AD_SUPPLIER_CAPACITIES_VMRP_AD_TRIP_STOPS_VMRP_AD_TRIPS_VMRP_AD_USER_DEMANDS_VMRP_AD_USER_SUPPLIES_VMRP_AD_WIP_COMP_DEMANDS_VMRP_AD_WIP_COMP_SUPPLIES_VMRP_AD_WIP_FLOW_DEMANDS_VMRP_AD_WIP_JOB_SUPPLIES_VMRP_AD_WOPR_NETWORKS_V

C D184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242

MLOG information

MLOGs are tables created for a Snapshot and are used to record changes on a base tableExamples:

Managing MLOG Size is a key component to the performance of Refresh Collection snapshotsKEY POINTS

Key Note for Managing MLOGs - Note 1063953.1

Simple - In table all_snapshots - MTL_ITEM_CATS_SN is based on MASTER - MTL_ITEM_CATEGORIES and uses MLOG$_MTL_ITEM_CATEGORIES to check what changes have occurred on the base table.

Complex - In table all_snapshots - BOM_RES_CHNGS_SN shows MASTER as - BOM_DEPARTMENTS - BUT uses two tables BOM_DEPARTMENTS and BOM_RESOURCE_CHANGES - This snapshot will show 2 rows in the output below.

1. The RDBMS will automatically delete rows from the MLOG when ALL snapshots that reference the MLOG are refreshed. 2. With the increasing complexity of the applications and introduction of DBI and customer requirements, we can see multiple snapshots that will reference the same MLOG 3. IF All the snapshots that reference an MLOG are not refreshed, then the MLOG will continue to grow and become very large and hurt performance of Refresh Snapshots process. 4. In table ALL_SNAPSHOTS, to find all the MLOGs, check the QUERY for the snapshot to get all the base tables involved, since column MASTER will show only one table. 5. Not every release will show the same shared MLOGs, so the output of the query below can be different based on your release

6. The key point with shared MLOGs is that the all snapshots must be refreshed before the MLOG can be deleted, so the DBA may have to manually refresh snapshots not used by data collections to manage the MLOGs if those applications are not being used or used very often.

A B

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16171819


SQL to show all snapshots and MLOGs used for Data Collections and reveal the Shared MLOGs

SELECT DISTINCTamdr.MVIEW_NAME "Snapshot",amdr.OWNER "Snapshot Owner",amdr.DETAILOBJ_NAME "Base Table Name",amdr.DETAILOBJ_OWNER "Base Table Owner",log_table mlog$_nameFROM ALL_MVIEW_DETAIL_RELATIONS amdr,dba_snapshot_logs dsl where DETAILOBJ_TYPE = 'TABLE' and (detailobj_owner, detaiLobj_name) not in (('MSC', 'MSC_COLLECTED_ORGS'))AND amdr.DETAILOBJ_NAME = dsl.MASTERand DETAILOBJ_NAME in('AHL_SCHEDULE_MATERIALS','BOM_COMPONENTS_B','BOM_CTO_ORDER_DEMAND','BOM_DEPARTMENTS','BOM_OPERATIONAL_ROUTINGS','BOM_OPERATION_NETWORKS','BOM_OPERATION_RESOURCES','BOM_RESOURCE_CHANGES','BOM_RES_INSTANCE_CHANGES','BOM_STRUCTURES_B','BOM_SUBSTITUTE_COMPONENTS','BOM_SUB_OPERATION_RESOURCES','CSP_REPAIR_PO_HEADERS','EAM_WO_RELATIONSHIPS','MRP_FORECAST_DATES','MRP_FORECAST_DESIGNATORS','MRP_FORECAST_ITEMS','MRP_SCHEDULE_DATES','MTL_DEMAND','MTL_ITEM_CATEGORIES','MTL_MATERIAL_TRANSACTIONS_TEMP','MTL_ONHAND_QUANTITIES_DETAIL',

A B

20

2122232425262728293031323334353637383940414243444546474849505152535455

'MTL_RELATED_ITEMS','MTL_RESERVATIONS','MTL_SUPPLY','MTL_SYSTEM_ITEMS_B','MTL_TXN_REQUEST_LINES','MTL_USER_DEMAND','MTL_USER_SUPPLY','OE_ORDER_LINES_ALL','PO_ACCEPTANCES','PO_CHANGE_REQUESTS','PO_SUPPLIER_ITEM_CAPACITY','WIP_DISCRETE_JOBS','WIP_FLOW_SCHEDULES','WIP_LINES','WIP_MSC_OPEN_JOB_STATUSES','WIP_OPERATIONS','WIP_OPERATION_NETWORKS','WIP_OPERATION_RESOURCES','WIP_OP_RESOURCE_INSTANCES','WIP_REPETITIVE_ITEMS','WIP_REPETITIVE_SCHEDULES','WIP_REQUIREMENT_OPERATIONS','WIP_SUB_OPERATION_RESOURCES','WSH_DELIVERY_DETAILS','WSH_TRIPS','WSH_TRIP_STOPS','WSM_COPY_OPERATIONS','WSM_COPY_OP_NETWORKS','WSM_COPY_OP_RESOURCES','WSM_COPY_OP_RESOURCE_INSTANCES','WSM_COPY_REQUIREMENT_OPS')order by MVIEW_NAME, DETAILOBJ_NAME;

A B565758596061626364656667686970717273747576777879808182838485868788899091

Snapshot from other products that share MLOG tables with Data Collections Snapshots Depending on your release, you may see different shared MLOGs ENI - Product IntelligenceOZF - Trade Management

C D E F

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16171819

Snapshot Base Table Name AHL_SCH_MTLS_SN APPS AHL_SCHEDULE_MATERIALS AHL BOM_BOMS_SN APPS BOM_STRUCTURES_B BOMBOM_CTO_ORDER_DMD_SN BOM BOM_CTO_ORDER_DEMAND BOMBOM_INV_COMPS_SN APPS BOM_COMPONENTS_B BOMBOM_INV_COMPS_SN APPS BOM_STRUCTURES_B BOMBOM_OPR_NETWORKS_SN APPS BOM_OPERATIONAL_ROUTINGS BOMBOM_OPR_NETWORKS_SN APPS BOM_OPERATION_NETWORKS BOMBOM_OPR_RESS_SN APPS BOM_OPERATIONAL_ROUTINGS BOMBOM_OPR_RESS_SN APPS BOM_OPERATION_RESOURCES BOMBOM_OPR_RTNS_SN APPS BOM_OPERATIONAL_ROUTINGS BOMBOM_OPR_SEQS_SN APPS BOM_OPERATIONAL_ROUTINGS BOMBOM_RES_CHNGS_SN APPS BOM_DEPARTMENTS BOMBOM_RES_CHNGS_SN APPS BOM_RESOURCE_CHANGES BOMBOM_RES_INST_CHNGS_SN APPS BOM_DEPARTMENTS BOMBOM_RES_INST_CHNGS_SN APPS BOM_RES_INSTANCE_CHANGES BOMBOM_SUB_COMPS_SN APPS BOM_COMPONENTS_B BOMBOM_SUB_COMPS_SN APPS BOM_STRUCTURES_B BOMBOM_SUB_COMPS_SN APPS BOM_SUBSTITUTE_COMPONENTS BOMBOM_SUB_OPR_RESS_SN APPS BOM_OPERATIONAL_ROUTINGS BOMBOM_SUB_OPR_RESS_SN APPS BOM_SUB_OPERATION_RESOURCES BOMCSP_REPAIR_PO_HEADERS_SN APPS CSP_REPAIR_PO_HEADERS CSPEAM_WO_RELATIONSHIPS_SN APPS EAM_WO_RELATIONSHIPS EAMENI_DBI_BOM_COMPONENTS_MV1 APPS BOM_COMPONENTS_B BOMENI_DBI_BOM_COMPONENTS_MV2 APPS BOM_COMPONENTS_B BOMENI_DBI_MFG_STEPS_JOIN_MV APPS BOM_OPERATIONAL_ROUTINGS BOMENI_RES_1_MV APPS BOM_DEPARTMENTS BOMMRP_FORECAST_DATES_SN APPS MRP_FORECAST_DATES MRPMRP_FORECAST_DSGN_SN APPS MRP_FORECAST_DESIGNATORS MRPMRP_FORECAST_ITEMS_SN APPS MRP_FORECAST_ITEMS MRPMRP_SCHD_DATES_SN APPS MRP_SCHEDULE_DATES MRPMTL_DEMAND_SN APPS MTL_DEMAND INVMTL_ITEM_CATS_SN APPS MTL_ITEM_CATEGORIES INVMTL_ITEM_RELATIONSHIPS_SN APPS MTL_RELATED_ITEMS INVMTL_MTRX_TMP_SN APPS MTL_MATERIAL_TRANSACTIONS_TEMP INVMTL_OH_QTYS_SN APPS MTL_ONHAND_QUANTITIES_DETAIL INV

Snapshot Owner

Base Table Owner

C D E F

20

2122232425262728293031323334353637383940414243444546474849505152535455

MTL_RESERVATIONS_SN APPS MTL_RESERVATIONS INVMTL_SUPPLY_SN APPS MTL_SUPPLY INVMTL_SYS_ITEMS_SN APPS MTL_SYSTEM_ITEMS_B INVMTL_TXN_REQUEST_LINES_SN APPS MTL_TXN_REQUEST_LINES INVMTL_U_DEMAND_SN APPS MTL_USER_DEMAND INVMTL_U_SUPPLY_SN APPS MTL_USER_SUPPLY INVOE_ODR_LINES_SN APPS OE_ORDER_LINES_ALL ONTOZF_EARNING_SUMMARY_MV APPS MTL_ITEM_CATEGORIES INVPO_ACCEPTANCES_SN APPS PO_ACCEPTANCES POPO_CHANGE_REQUESTS_SN APPS PO_CHANGE_REQUESTS POPO_SI_CAPA_SN APPS PO_SUPPLIER_ITEM_CAPACITY POWIP_DSCR_JOBS_SN APPS WIP_DISCRETE_JOBS WIPWIP_FLOW_SCHDS_SN APPS WIP_FLOW_SCHEDULES WIPWIP_OPR_RES_INSTS_SN APPS WIP_OP_RESOURCE_INSTANCES WIPWIP_REPT_ITEMS_SN APPS WIP_REPETITIVE_ITEMS WIPWIP_REPT_SCHDS_SN APPS WIP_REPETITIVE_SCHEDULES WIPWIP_WLINES_SN APPS WIP_LINES WIPWIP_WOPRS_SN APPS WIP_DISCRETE_JOBS WIPWIP_WOPRS_SN APPS WIP_MSC_OPEN_JOB_STATUSES WIPWIP_WOPRS_SN APPS WIP_OPERATIONS WIPWIP_WOPR_NETWORKS_SN APPS WIP_OPERATION_NETWORKS WIPWIP_WOPR_RESS_SN APPS WIP_DISCRETE_JOBS WIPWIP_WOPR_RESS_SN APPS WIP_MSC_OPEN_JOB_STATUSES WIPWIP_WOPR_RESS_SN APPS WIP_OPERATION_RESOURCES WIPWIP_WOPR_SUB_RESS_SN APPS WIP_SUB_OPERATION_RESOURCES WIPWIP_WREQ_OPRS_SN APPS WIP_DISCRETE_JOBS WIPWIP_WREQ_OPRS_SN APPS WIP_MSC_OPEN_JOB_STATUSES WIPWIP_WREQ_OPRS_SN APPS WIP_REQUIREMENT_OPERATIONS WIPWSH_DELIVERY_DETAILS_SN WSH WSH_DELIVERY_DETAILS WSHWSH_TRIP_SN APPS WSH_TRIPS WSHWSH_TRIP_STOP_SN APPS WSH_TRIP_STOPS WSHWSM_LJ_OPRS_SN APPS WSM_COPY_OPERATIONS WSMWSM_LJ_OPR_NWK_SN APPS WSM_COPY_OP_NETWORKS WSMWSM_LJ_OPR_RESS_INSTS_SN APPS WSM_COPY_OP_RESOURCE_INSTANCES WSMWSM_LJ_OPR_RESS_SN APPS WSM_COPY_OP_RESOURCES WSMWSM_LJ_REQ_OPRS_SN APPS WSM_COPY_REQUIREMENT_OPS WSM

C D E F565758596061626364656667686970717273747576777879808182838485868788899091

MLOG$_NAMEMLOG$_AHL_SCHEDULE_MATERIAMLOG$_BOM_STRUCTURES_BMLOG$_BOM_CTO_ORDER_DEMANDMLOG$_BOM_COMPONENTS_BMLOG$_BOM_STRUCTURES_BMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_OPERATION_NETWORMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_OPERATION_RESOURMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_DEPARTMENTSMLOG$_BOM_RESOURCE_CHANGESMLOG$_BOM_DEPARTMENTSMLOG$_BOM_RES_INSTANCE_CHAMLOG$_BOM_COMPONENTS_BMLOG$_BOM_STRUCTURES_BMLOG$_BOM_SUBSTITUTE_COMPOMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_SUB_OPERATION_REMLOG$_CSP_REPAIR_PO_HEADERMLOG$_EAM_WO_RELATIONSHIPSMLOG$_BOM_COMPONENTS_BMLOG$_BOM_COMPONENTS_BMLOG$_BOM_OPERATIONAL_ROUTMLOG$_BOM_DEPARTMENTSMLOG$_MRP_FORECAST_DATESMLOG$_MRP_FORECAST_DESIGNAMLOG$_MRP_FORECAST_ITEMSMLOG$_MRP_SCHEDULE_DATESMLOG$_MTL_DEMANDMLOG$_MTL_ITEM_CATEGORIESMLOG$_MTL_RELATED_ITEMSMLOG$_MTL_MATERIAL_TRANSACMLOG$_MTL_ONHAND_QUANTITIE

G

20

2122232425262728293031323334353637383940414243444546474849505152535455

MLOG$_MTL_RESERVATIONSMLOG$_MTL_SUPPLYMLOG$_MTL_SYSTEM_ITEMS_BMLOG$_MTL_TXN_REQUEST_LINEMLOG$_MTL_USER_DEMANDMLOG$_MTL_USER_SUPPLYMLOG$_OE_ORDER_LINES_ALLMLOG$_MTL_ITEM_CATEGORIESMLOG$_PO_ACCEPTANCESMLOG$_PO_CHANGE_REQUESTSMLOG$_PO_SUPPLIER_ITEM_CAPMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_FLOW_SCHEDULESMLOG$_WIP_OP_RESOURCE_INSTMLOG$_WIP_REPETITIVE_ITEMSMLOG$_WIP_REPETITIVE_SCHEDMLOG$_WIP_LINESMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_OPERATIONSMLOG$_WIP_OPERATION_NETWORMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_OPERATION_RESOURMLOG$_WIP_SUB_OPERATION_REMLOG$_WIP_DISCRETE_JOBSMLOG$_WIP_MSC_OPEN_JOB_STAMLOG$_WIP_REQUIREMENT_OPERMLOG$_WSH_DELIVERY_DETAILSMLOG$_WSH_TRIPSMLOG$_WSH_TRIP_STOPSMLOG$_WSM_COPY_OPERATIONSMLOG$_WSM_COPY_OP_NETWORKSMLOG$_WSM_COPY_OP_RESOURCE1MLOG$_WSM_COPY_OP_RESOURCEMLOG$_WSM_COPY_REQUIREMENT

G565758596061626364656667686970717273747576777879808182838485868788899091

MRP_AD Tables used to record deletes so data collections can remove rows as required

MRP_AD tables are used on the EBS Source instance a distributed installation.

Performance note:

TRIGGER_NAME TABLE_NAME AD tables inserted List of AD Tables

MRP_SN_BOMS_T2 BOM_BOMS_SN MRP_AD_BOMS

MRP_SN_CTO_ORDER_DMD_T2 BOM_CTO_ORDER_DMD_SN MRP_AD_CTO_ORDER_DEMAND MRP_AD_CTO_ORDER_DEMANDMRP_SN_DEMAND_T2 MTL_DEMAND_SN MRP_AD_DEMAND MRP_AD_DEMANDMRP_SN_FORECAST_DATES_T2 MRP_FORECAST_DATES_SN MRP_AD_FORECAST_DATES MRP_AD_DEPT_RESSMRP_SN_FORECAST_DSGN_T2 MRP_FORECAST_DSGN_SN MRP_AD_FORECAST_DSGN MRP_AD_DSCR_JOBS

MRP_SN_INV_COMPS_T2 BOM_INV_COMPS_SN MRP_AD_FLOW_SCHDS

MRP_SN_ITEM_CATS_T2 MTL_ITEM_CATS_SN MRP_AD_ITEM_CATEGORIES MRP_AD_FORECAST_DATESMRP_SN_LJ_OPR_NWK_T1 WSM_LJ_OPR_NWK_SN MRP_AD_LJ_OPR_NWK MRP_AD_FORECAST_DSGNMRP_SN_LJ_OPR_RES_INSTS_T1 WSM_LJ_OPR_RESS_INSTS_SN MRP_AD_LJ_OPR_RES_INSTS MRP_AD_INV_COMPS

MRP_SN_LJ_OPR_RESS_T1 WSM_LJ_OPR_RESS_SN MRP_AD_ITEM_CATEGORIES

MRP_SN_LJ_OPRS_T1 WSM_LJ_OPRS_SN MRP_AD_LJ_OPRS MRP_AD_LJ_OPRSMRP_SN_LJ_REQ_OPRS_T1 WSM_LJ_REQ_OPRS_SN MRP_AD_LJ_REQ_OPRS MRP_AD_LJ_OPR_NWKMRP_SN_MTRX_TMP_T2 MTL_MTRX_TMP_SN MRP_AD_MTRX_TMP MRP_AD_LJ_OPR_RESSMRP_SN_ODR_LINES_T2 OE_ODR_LINES_SN MRP_AD_ORDER_LINES_ALL MRP_AD_LJ_OPR_RES_INSTSMRP_SN_OH_QTYS_T2 MTL_OH_QTYS_SN MRP_AD_OH_QTYS MRP_AD_LJ_REQ_OPRSMRP_SN_OPR_NETWORKS_T2 BOM_OPR_NETWORKS_SN MRP_AD_OPR_NETWORKS MRP_AD_MTRX_TMPMRP_SN_OPR_RESS_T2 BOM_OPR_RESS_SN MRP_AD_OPR_RESS MRP_AD_OH_QTYS

MRP_SN_OPR_RTNS_T2 BOM_OPR_RTNS_SN MRP_AD_OPERATION_COMPONENTS

MRP_SN_OPR_SEQS_T2 BOM_OPR_SEQS_SN MRP_AD_OPR_NETWORKS

MRP_SN_REPT_ITEMS_T2 WIP_REPT_ITEMS_SN MRP_AD_PROCESS_EFFECTIVITY MRP_AD_OPR_RESSMRP_SN_RES_INST_CHNGS_T2 BOM_RES_INST_CHNGS_SN MRP_AD_RES_INSTANCE_REQS MRP_AD_OPR_RTNSMRP_SN_RESERVATIONS_T2 MTL_RESERVATIONS_SN MRP_AD_DEMAND MRP_AD_OPR_SEQSMRP_SN_SCHD_DATES_T2 MRP_SCHD_DATES_SN MRP_AD_SCHD_DATES MRP_AD_ORDER_LINES_ALLMRP_SN_SI_CAPA_T2 PO_SI_CAPA_SN MRP_AD_SI_CAPA MRP_AD_PROCESS_EFFECTIVITYMRP_SN_SUB_COMPS_T2 BOM_SUB_COMPS_SN MRP_AD_SUB_COMPS MRP_AD_REPT_ITEM_DEMANDSMRP_SN_SUB_OPR_RESS_T2 BOM_SUB_OPR_RESS_SN MRP_AD_SUB_OPR_RESS MRP_AD_REPT_ITEM_SUPPLIESMRP_SN_SUPPLY_T2 MTL_SUPPLY_SN MRP_AD_SUPPLY MRP_AD_REPT_SCHDSMRP_SN_TXN_REQUEST_LINES_T2 MTL_TXN_REQUEST_LINES_SN MRP_AD_TXN_REQUEST_LINES MRP_AD_RESOURCE_REQUIREMENTSMRP_SN_U_DEMAND_T2 MTL_U_DEMAND_SN MRP_AD_U_DEMAND MRP_AD_RES_CHNGSMRP_SN_U_SUPPLY_T2 MTL_U_SUPPLY_SN MRP_AD_U_SUPPLY MRP_AD_RES_INSTANCE_REQSMRP_SN_WIP_OPR_RES_INSTS_T1 WIP_OPR_RES_INSTS_SN MRP_AD_RES_INSTANCE_REQS MRP_AD_RES_INST_CHANGES

MRP_SN_WOPR_RESS_T2 WIP_WOPR_RESS_SN MRP_AD_SCHD_DATES

MRP_SN_WOPR_SUB_RESS_T1 WIP_WOPR_SUB_RESS_SN MRP_AD_WOPR_SUB_RESS MRP_AD_SI_CAPA

MRP_SN_WOPRS_T2 WIP_WOPRS_SN MRP_AD_SUB_COMPS

MRP_AD_SUB_OPR_RESSMRP_AD_SUPPLYMRP_AD_TRIPSMRP_AD_TRIP_STOPSMRP_AD_TXN_REQUEST_LINESMRP_AD_U_DEMANDMRP_AD_U_SUPPLYMRP_AD_WIP_COMP_DEMANDSMRP_AD_WIP_COMP_SUPPLIESMRP_AD_WLINESMRP_AD_WOPRSMRP_AD_WOPR_RESSMRP_AD_WOPR_SUB_RESSMRP_AD_WREQ_OPRS

AD tables exist only for entities that can be collected in Net Change mode of Data Collections

We will only remove data from these tables when you run Data Collections with Complete refresh and run for ALL Orgs

select * FROM dba_triggersWHERE triggering_event like 'DELETE' andtrigger_name LIKE 'MRP_SN%'ORDER BY TRIGGER_NAME;

SELECT * FROM DBA_TABLES WHERE TABLE_NAME LIKE 'MRP_AD%'ORDER BY TABLE_NAME;

MRP_AD_BOMSMRP_AD_INV_COMPSMRP_AD_SUB_COMPSMRP_AD_PROCESS_EFFECTIVITYMRP_AD_OPERATION_COMPONENTS

MRP_AD_INV_COMPSMRP_AD_SUB_COMPSMRP_AD_OPERATION_COMPONENTS

MRP_AD_LJ_OPR_RESSMRP_AD_LJ_OPR_RES_INSTS

MRP_AD_PROCESS_EFFECTIVITYMRP_AD_OPERATION_COMPONENTSMRP_AD_OPR_RESSMRP_AD_OPR_SEQSMRP_AD_OPR_RTNS

MRP_AD_OPERATION_COMPONENTSMRP_AD_OPR_SEQS

MRP_AD_RES_INSTANCE_REQSMRP_AD_RESOURCE_REQUIREMENTS

MRP_AD_RESOURCE_REQUIREMENTSMRP_AD_RES_INSTANCE_REQS

A B C D E

1

2

3

4

5

6

7

8

9

10

111213

14

15161718

19

202122

23

24252627282930

31

32

333435363738394041424344

45

46

47

4849505152535455565758596061

SQL queries used to produce the information used in this document

Checking the requests that were run during Data collections

query the snapshots used for data collections

SELECT name, query FROM all_snapshots WHERE name LIKE '%SN' ORDER BY name; query to find the SQL Query used for snapshots

SQL used to check these viewsselect view_name from all_views where view_name like 'MRP_AP%'

select view_name from all_views where view_name like 'MRP_AN%'

select view_name from all_views where view_name like 'MRP_AD%'

SQL you can use to check the view text and see what is queried in the views.select text from all_views where view_name like '&view_name';

select /*+ ORDERED USE_NL(x fcr fcp fcptl)*/ fcr.request_id "Request ID", fcp.concurrent_program_name "Shortname", substr(DECODE (FCR.DESCRIPTION, NULL, FCPTL.USER_CONCURRENT_PROGRAM_NAME, FCR.DESCRIPTION||' ('||FCPTL.USER_CONCURRENT_PROGRAM_NAME||')'),1,80)"Program Name", -- (fcr.actual_completion_date - fcr.actual_start_date)*1440 "Elapsed Time", -- oracle_process_id "Trace File ID" , fcr.phase_code "Phase", fcr.status_code "Status", -- to_char(fcr.request_date,'DD-MON-YYYY HH24:MI:SS') "Submitted", -- (fcr.actual_start_date - fcr.request_date)*1440 "Delay", -- to_char(fcr.actual_start_date,'DD-MON-YYYY HH24:MI:SS') "Start Time", -- to_char(fcr.actual_completion_date, 'DD-MON-YYYY HH24:MI:SS') "End Time", fcr.argument_text "Parameters" from (select /*+ index (fcr1 FND_CONCURRENT_REQUESTS_N3) */ fcr1.request_id from fnd_concurrent_requests fcr1 where 1=1 start with fcr1.request_id = &parent_request_id connect by prior fcr1.request_id = fcr1.parent_request_id) x, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcptl where fcr.request_id = x.request_id and fcr.concurrent_program_id = fcp.concurrent_program_id and fcr.program_application_id = fcp.application_id and fcp.application_id = fcptl.application_id and fcp.concurrent_program_id = fcptl.concurrent_program_id and fcptl.language = 'US' order by 1;

select owner, name, master from all_snapshots where name like '%SN' order by name, owner

A B

1

2

3

4

5

678

9

101112131415

16

17

12.1.3.3 Data Collections fixesAfter applying the following you will realize the following upgrades.EBS 12.1.3 Update packVCP 12.1.3.3 Patch # 10389190:R12.SCP_PF.B VCP 12.1.3.3 includes the following collections patch - ASCP COLLECTION RUP#14 PATCH FOR 12.1.3.3, Patch 10188734

Legacy

8737158 : Performnce enhancement for legacy load of routing operations. Before : Legacy load of routing operations is slow. After : Performnce improved for legacy load of routing operations.

8592829 : LEGACY COLLECTION PERFORMANCE ISSUE FOR RESOURCECHANGES.DAT Before : While loading datafile ResourceChanges.dat the process takes a very long time. After : While loading datafile ResourceChanges.dat, the process completes quickly.

8849237 : Legacy load for regions is not loading any records to ODSBefore : Legacy load for regions is not loading any records to ODSAfter : Regions data is now loaded to ODS.

9281879 : In legacy collections for entity bom components, operation_seq_num is not populated. Modified the code to populate this field.

9099440 : UNABLE TO LOAD IROSUPPLIES.DAT Before : Could not upload IROsupplies.dat through legacy upload After : Able to successfully upload IROsupplies.dat through legacy upload.

9143044 : Collect flat file self service prog routing.dat does not contain column for rank. Before : Unable to specify priority in dat file during legacy collections After : Able to specify priority in dat file during legacy collections

9085180 : RP:CERT:REL:WIP START DATE IS UPDATED INCORRECTLY IN EBS FOR RESCHEDULED WIP JOB.

After : a) The releases rescheduled jobs and planned order jobs give correct result. b) Yield factor is accounted for if there is any while releasing jobs.

General

8820722 : Before : While running collections,ODS load was erroring out on 12.2 instance when all entities are set to yes in planning data pull After : ODS load completes successfully when all entities are set to yes in planning data pull 7565280 : Before : Column 'unadjusted_resource_hours' in msc_resource_requirements is not populated. After : 'unadjusted_resource_hours' in msc_resource_requirements is populated

Before : a) For a fractional quantity in the WIP job,either in case of reschedule or in case of planned order job, the resulting released quantity is often incorrect.

b) When there is an operation yield, in case of unconstrained plan or user makes changes to the implement quantity, the start quantity needs to be changed accordingly to account for the yield factor.

8369178 : Before : On running the CP purge ODS data for collections,all the data with a matching sr_instance_id is deleted from the msc tables.

After : On running the CP purge ODS data for collections,only the collected data with a matching sr_instance_id is deleted from the msc tables.

8725891 : Before : Upload of Calendars with other entities; other entities do not loaded. After : All entities loaded properly even when collected with calendars.

8438047 : PROBLEM IN MSC_RELEASE_ISO - RECOMMEND FOR CANCELLATION.

8913331 : BP:12.2 TO 12.1: RP:ST2:COLL:NEW:SHIPPING METHODS AND TRANSIT TIME DATA NOT

9050923 : TST1212 XB3 |CERT|DRP: PO RESCHEDULE RECOMM ARE NOT RELEASED NO ERROR IN THE LOG. Before : When a DRP plan recommends a PO for reschedule, the PO was not getting rescheduled.

After : When a DRP plan recommends a PO for reschedule, the PO gets rescheduled correctly and the date is correctly updated on source

8995860 : FP 12.0 > 12.1 : INCORRECT DUE DATE CALCULATED FOR PO IN RCV FOR TARGET COLL. Before : Target Refresh,not adding post process Lead time to calculate the due date for po in receiving. After : Target Refresh,not adding post process Lead time to calculate the due date for po in receiving. 9039161 : APCC:12.1.2:XB3:COLLECTION LOG HAS WRONG PARAMETER VALUE - RESOURCE AVAILABILITY. Before : Log for Planning Data pull has wrong value for Res avail After : Log for Planning Data pull prints correct value for Res avail 7447541 : 12.1:cu1:spp:cert 1-1:issues with rel of piro with defective in depot org Before : RWO is getting collected as non standard wip jobs during recollections. After : RWO is getting collected correctly during recollections.

8904313 : CUSTOMER NAME INCORRECT IN COLLECTED DATA AFTER COMPLETE REFRESH COLLECTIONS. Before : Customer name changes are not reflected in the ODS tables. After : Customer name changes are collected into ODS tables.

9189942 : After 12.1.1 cu4 patch 9058835 - push plan errors with ora-00918. Before : Push plan errors out with ORA-00918: column ambiguously defined After : Push plan completes successfully.

8834908 : Before : Operation status is not collected in msc_resource_requirements After : operation status is collected in msc_resource_requirements for OPM

Performance Enhancements

8737158 : Performnce enhancement for legacy load of routing operations. Before : Legacy load of routing operations is slow.

Before : After running a Distribution Plan, if you release an internal requisition with Cancel recommendation, the CP 'MSC ISO release Program (MSC Create and Reschedule ISO)' is completed with warning

After : After running a Distribution Plan, if you release an internal requisition with Cancel recommendation, the CP 'MSC ISO release Program (MSC Create and Reschedule ISO)' completes successfully, and ISO is canceled on source.

Before : Copy Staging tables (Synchronize to R12.1 Instance) was collecting shipping method and transit time between orgs with wrong instance_id.

After : Copy Staging tables (Synchronize to R12.1 Instance) collects shipping method and transit time between orgs with correct instance_id.This is a backport of bug 8884744.

9192631 : Before : Update of charge account id in po_requistions_interface_all table is done for all the records irrespective of interface source code.

After : Update of charge account id in po_requistions_interface_all table is done for only those records which have interface source code='MSC'.

After : Performnce improved for legacy load of routing operations.

8524654 : Changed the where condition while updating msc_supplies so that the U1 index will be used. Before : Autorelease program hangs while releasing too many records. After : Performace of Autorelease program improved.

Partitions

8800601 : FP 11I>12.1 : MSCPDC - ORA-02149 ON MSC_NET_RES_INST_AVAIL

After : The missing partition was created and Collections completes successfully

8864752 : PLANNING DATA COLLECTION COMPLETES WITH ERROR ORA-00923 Before : Collections Error out during rollback of exchanging partition for some tables in case of any error during ods load. After : Rollback of exchange partition for some tables is completing

Rapid Planning

8837986 : This bug contains the following enhancements: 1. Copy staging tables from APS instance to MSC121 staging(Rapid Planning) instance. 2. Release from Staging instance (Rapid Planning) workbench to source ERP

Demantra

8839269 : This bug contains the enhancement done for RP to collect Demantra Forecast from EBS/APS server to the RP server.

Auto Release and Scheduling

8726490 : ASCP AUTO-RELEASE PROGRAM RELEASING PURCHASE ORDERS WITH ACTION AS NONE Before : Purchase Orders with Action None,were being auto-released. After : Auto-Release Program does not release Purchase Orders with Action type as NONE in the planner's workbench.

9064626 : AUTO RELEASE FROM ASCP NOT RELEASING RESCHEDULE -IN PR AND PO. Before : Auto Release of reschedule in recommendations for PO/PR entity not working fine. After : Auto Release of reschedule in recommendations for PO/PR entity working fine.

9107066 : DRP:CERT:12.1CU4|RELEASE OF PO MAKE TRIGGER ADDITIONAL REQUEST MSC ISO RELEASE

Before : Planning Data Pull was erroring out Procedure DELETE_MSC_TABLE:MSC_NET_RES_INST_AVAIL started. ORA-02149: Specified partition does not exist

On the 11510 APS server,while running Collections, we have an additional parameter called Synchronize to R12.1 instance in planning ODS load. This enables the user to select an instance (for which staging copy is enabled)to copy over the staging tables and launch Planning ODS load on the MSC121 instance.The Collected data on the MSC121 instance will carry the instance_id of the source as seen by the MSC121 destination.Thus the data will be exactly similar to if it was directly collected to the MSC121 destination from the 11510 EBS source.To enable staging copy, we have a checkbox on the instance definition screen on MSC121 destination.

9327355 : Before : Copy Staging tables to Rapid Planning instance concurrent program ending in warning.Data not getting collected into msc_trading_partners.

After : Copy Staging tables to Rapid Planning instance concurrent program ending successfully.Data is getting collected into msc_trading_partners .

After : Additional Request is not triggered.

Continuous collections

8846340 : Continuous collections is unable to decide the collection type and ignores the entity due to ORA-01861 Before : Continuous collections is unable to decide the collection type and ignores the entity due to ORA-01861 After : Continuous collections is able to decide the collection type for all entities.

9159025 : CONTINUOUS COLLECTIONS IS NOT COLLECTING FORECASTS when there is no change in the designator for 11i source.

After : Continuous collections collects Forecasts when there is no change in the forecast set and the forecast demands are changed

OPM

9470466 : Before : OPM batch fails to be created for Planned Order OPM batch fails to be rescheduled for Work Order After : OPM batch is created for Planned Order. OPM batch is rescheduled for Work Order.

Before : Every time a release is made from DRP plan, the concurrent program MSC ISO release Program (MSC Create and Reschedule ISO) is triggered.in addition to the actual CP.

Before : Continuous collections not collecting Forecasts when there is no change in the forecast set and the forecast demands are changed

USER_PROFILE_OPTION_NAMEMSC: Demand Priority Flexfield AttributeMSC: Aggregate Resource Name Flexfield AttributeMSC: Cost of Using a BOM/ Routing Flexfield AttributeMSC: Priority of Alternate Resources for an Operation Flexfield AttributeMSC: Priority for Substitute Items Flexfield AttributeMSC: Forecast Priority Flexfield AttributeMSC: Resource Group for a Line Flexfield AttributeMSC: Resource Type for an Operation Flexfield AttributeMSC: Simultaneous Resource Sequence Flexfield AttributeMSO: Penalty Cost Factor for Late Forecasts Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Item Material Capacity Flexfield AttributeMSO: Penalty Cost Factor for Late Item Demands Flexfield AttributeMSO: Resource Group for the Line Flexfield AttributeMSO: Penalty Cost Factor for Late Org Demands Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Org Material Capacity Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Org Resource Capacity Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Org Transportation Capacity Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Resource Capacity Flexfield AttributeMSO: Penalty Cost Factor for Late Sales Orders Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Material Capacity Flexfield AttributeMSO: Penalty Cost Factor for Exceeding Transportation Capacity Flexfield Attribute

Items Items

Organization Parameters Organization Parameters Organization Parameters Organization Parameters Department Resource Information

Department Resource Information

Attribute (Purchasing) Substitute Component Information

MTL Interorg ship methods

Bill of Material Information MRP Forecast Dates Additional Line Information Production Line

PROFILE_OPTION_NAME APPLICATION_IDMRP_DMD_PRIORITY_FLEX_NUM 704MSC_AGGREG_RES_NAME 724MSC_ALT_BOM_COST 724MSC_ALT_RES_PRIORITY 724MSC_BOM_SUBST_PRIORITY 724MSC_FCST_PRIORITY_FLEX_NUM 724MSC_LINE_RES_GROUP 724MSC_RESOURCE_TYPE 724MSC_SIMUL_RES_SEQ 724MSO_FCST_PENALTY 723MSO_ITEM_CAP_PENALTY 723MSO_ITEM_DMD_PENALTY 723MSO_LINE_RESOURCE_GROUP 723MSO_ORG_DMD_PENALTY 723MSO_ORG_ITEM_PENALTY 723MSO_ORG_RES_PENALTY 723MSO_ORG_TRSP_PENALTY 723MSO_RES_PENALTY 723MSO_SO_PENALTY 723MSO_SUP_CAP_PENALTY 723MSO_TRSP_PENALTY 723

Late Demands Penalty (Item) MTL_SYSTEM_ITEMS Material Over-Capacity Penalty (Item) MTL_SYSTEM_ITEMS

Late Demands Penalty (Org) MTL_PARAMETERS Material Over-Capacity Penalty (Org) MTL_PARAMETERS Resource Over-Capacity Penalty (Org) MTL_PARAMETERS Transport Over-Capacity Penalty (Org) MTL_PARAMETERS Aggregate Resources

Resource Over-Capacity Penalty (Resource)

Material Over-Capacity Penalty (Supplier) PO_ASL_ATTRIBUTES

Substitute Items Priority

Transport Over-Capacity Penalty (Ship Method)

BOM/Routing Cost BOM_BILL_OF_MATERIALS Late Forecasts MRP_FORECAST_DATES Late Sales Order Penalty SO_LINES Resource Group (Line) WIP_LINES

BOM_DEPARTMENT _RESOURCES

BOM_DEPARTMENT _RESOURCES

BOM_SUBSTITUTE_ COMPONENT

MTL_INTERORG_SHIP _METHOD

MSO: Penalty Cost Factor for Late Item Demands Flexfield Attribute MSO: Penalty Cost Factor for Exceeding Item Material Capacity Flexfield Attribute

MSO: Penalty cost factor for late demands (Organization) flexfield attribute MSO: Penalty cost factor for exceeding material capacity (Organization) flexfield MSO: Penalty cost factor for exceeding resource capacity (Organization) flexfield MSO: Penalty cost factor for exceeding transportation capacity (Organization) MSC: Aggregate Resource Name Flexfield Attribute

MSO: Penalty cost factor for exceeding resource capacity (Resource) flexfield

MSO: Penalty Cost Factor for Exceeding Material Capacity Flexfield Attribute

MSC: Priority for Substitute Items Flexfield Attribute

MSO: Penalty cost factor for exceeding transportation capacity flexfield attribute

MSC: Cost of Using a BOM/ Routing Flexfield Attribute MSO: Penalty cost factor for late forecasts MSO: Penalty cost factor for late sales orders MSC: Resource Group for a Line Flexfield Attribute

User Company Associations

User Supplies and Demands

Repair Orders

Leg coll key gen

Frame-work

Payback Supplies

Currency-Conv$

(Internal)$

External Repair $

MTL_USER_DEMANDMTL_USER_SUPPLY

MRP_AP_APPS_INSTANCES_ALL

mrp_ap_apps_instances

mtl_parameters ,

PJM_PROJECT_PARAMETERS ,

MRP_AP_UNIT_PAYBACK_QTY_V

MTL_SYSTEM_ITEMS_B

pjm_borrow_transactions

pjm_borrow_paybacks

mtl_unit_transactions

mtl_serial_numbers

GL_DAILY_RATES

FND_USERHZ_PARTIESPO_VENDOR_CONTACTSPO_VENDOR_SITES_ALL

CSD_REPAIRS$

CSD_REPAIR_JOB_XREF$

CSP_ REPAIR_ PO_HEADERS $

N

Y

Y

Y

N

N

N

Y

Y

MRP_AD_ERO

N

N

NA

mtl_u_demand_snmtl_u_supply_snmrp_ad_u_demandmrp_ad_u_supply

MRP_AD_ERO

mrp_ap_company_users_v

Mrp_ap_open_payback_qty_v

Mrp_ap_item_open_payback_qty_v

Mrp_ap_unit_payback_qty_v


mrp_ad_non_ro_wip_comp_dem_v$

mrp_ap_repair_demand_v$


mrp_ad_non_ro_wip_job_supp_v$


mrp_ap_non_ro_wip_job_v$

mrp_ap_repair_orders_v$

mrp_ap_ero_wip_job_supply_v$

mrp_ap_ero_wip_demand_v$

mrp_ap_non_ero_wip_job_supply_v$

mrp_ap_non_ero_wip_demand_v$

mrp_ad_non_ero_wip_job_supplies_v$

mrp_ad_non_ ero_ wip_comp_demands_v$

mrp_ap_ero_wip_job_supply_v$

mrp_ad_ero_wip_job_supplies_v$

mrp_ad_ ero_ wip_comp_demands_v$

Mrp_ap_cuurency_conv_v$


MSC_ST_DEMANDS

MSC_ST_SUPPLIES

MSC_ST_DEMANDS

MSC_ST_SUPPLIES

MSC_ST_OPEN_PAYBACKS

MSC_ST_CURRENCY_CONVERSIONS $

MSC_COMPANY_USERS


MSC_DEMANDS

MSC_SUPPLIES

MSC_DEMANDS

MSC_SUPPLIES

MSC_LOCAL_ID_ITEM

MSC_LOCAL_ID_SETUP

MSC_LOCAL_ID_MISC

MSC_APPS_INSTANCES

MSC_INSTANCE_ORGS

MSC_COLl_PARAMETERS

MSC_PLANS

MSC_INST_PARTITIONS

MSC_PLAN_PARTITIONS

MSD_AUDIT_SQL_STATEMENTS

MSC_SUPPLIES

MSCDEMANDS

MSC_CURRENCY_CONVERSIONS $

atp data collection parameters

Documents