API and interface

Difference between API and interface

What is the difference between API and interface?

An API is nothing but “Application Programming Interface”. 

API – it’s validating the record(s) and inserting directly into base tables. (if any error occurs, it’s just thrown an error at run time.)

Interface – Loads the data through interface table(s) and error-out record(s) histories' available in the same interface tables or provided error tables.

Purge Interface Tables

2. 'Purge Interface Tables' concurrent program:

MSCPST module: Purge Interface Tables

This concurrent program deletes the records from the MSC staging tables.

It takes instance_code as a 1st parameter and deletes records for the instance only when st_status for this instance is not in G_ST_PULLING,G_ST_COLLECTING and G_ST_PRE_PROCESSING (if the tables are not currently in use).If the instance_code is null then it will delete records from all instances after checking the st_status.
It also takes a 2nd parameter , whether to delete only errored out records or all legacy data. The check for st_status before deletion will only take place when 'delete only rejected records’ parameter is set to NO.

This package (file name = MSCCLPSB.pls) is used to PURGE LEGACY DATA OF INTERFACE TABLES
It is deleting records from the following tables:
MSC_ST_BOMS
MSC_ST_BOM_COMPONENTS
MSC_ST_CALENDARS
MSC_ST_CALENDAR_EXCEPTIONS
MSC_ST_CATEGORY_SETS
MSC_ST_COMPANY_USERS
MSC_ST_COMPONENT_SUBSTITUTES
MSC_ST_CO_PRODUCTS
MSC_ST_DEMANDS
MSC_ST_DEMAND_CLASSES
MSC_ST_DEPARTMENT_RESOURCES
MSC_ST_DESIGNATORS
MSC_ST_GROUPS
MSC_ST_GROUP_COMPANIES
MSC_ST_INTERORG_SHIP_METHODS
MSC_ST_ITEM_CATEGORIES
MSC_ST_ITEM_CUSTOMERS
MSC_ST_ITEM_SOURCING
MSC_ST_ITEM_SUBSTITUTES
MSC_ST_ITEM_SUPPLIERS
MSC_ST_LOCATION_ASSOCIATIONS
MSC_ST_OPERATION_NETWORKS
MSC_ST_OPERATION_RESOURCES
MSC_ST_PARTNER_CONTACTS
MSC_ST_PLANNERS
MSC_ST_PROJECT_TASKS
MSC_ST_RESERVATIONS
MSC_ST_RESOURCE_CHANGES
MSC_ST_RESOURCE_GROUPS
MSC_ST_RESOURCE_REQUIREMENTS
MSC_ST_RESOURCE_SHIFTS
MSC_ST_ROUTINGS
MSC_ST_ROUTING_OPERATIONS
MSC_ST_SAFETY_STOCKS
MSC_ST_SALES_ORDERS
MSC_ST_SHIFT_EXCEPTIONS
MSC_ST_SHIFT_TIMES
MSC_ST_SUB_INVENTORIES
MSC_ST_SUPPLIER_CAPACITIES
MSC_ST_SUPPLIER_FLEX_FENCES
MSC_ST_SUPPLIES
MSC_ST_SYSTEM_ITEMS
MSC_ST_TRADING_PARTNERS
MSC_ST_TRADING_PARTNER_SITES
MSC_ST_UNITS_OF_MEASURE
MSC_ST_UOM_CLASS_CONVERSIONS
MSC_ST_UOM_CONVERSIONS
MSC_ST_WORKDAY_PATTERNS

Planning Data Collection - Purge Staging Tables

1. 'Planning Data Collection - Purge Staging Tables' :

MSCPDCP module: Planning Data Collection - Purge Staging Tables
File name is: MSCCLBAB.pls
This concurrent program deletes records from the following tables:

---------------- BOM --------------------
MSC_ST_BOM_COMPONENTS
MSC_ST_BOMS
MSC_ST_COMPONENT_SUBSTITUTES
MSC_ST_ROUTINGS
MSC_ST_ROUTING_OPERATIONS
MSC_ST_OPERATION_RESOURCES
MSC_ST_OPERATION_RESOURCE_SEQS
MSC_ST_PROCESS_EFFECTIVITY
MSC_ST_OPERATION_COMPONENTS
---------------- BOR -------------------
MSC_ST_BILL_OF_RESOURCES
MSC_ST_BOR_REQUIREMENTS
---------------- CALENDAR_DATE -------------
MSC_ST_CALENDAR_DATES
MSC_ST_PERIOD_START_DATES
MSC_ST_CAL_YEAR_START_DATES
MSC_ST_CAL_WEEK_START_DATES
MSC_ST_RESOURCE_SHIFTS
MSC_ST_CALENDAR_SHIFTS
MSC_ST_SHIFT_DATES
MSC_ST_RESOURCE_CHANGES
MSC_ST_SHIFT_TIMES
MSC_ST_SHIFT_EXCEPTIONS
MSC_ST_NET_RESOURCE_AVAIL
---------------- CATEGORY -------------
MSC_ST_ITEM_CATEGORIES
MSC_ST_CATEGORY_SETS
---------------- DEMAND -------------
MSC_ST_DEMANDS
---------------- SALES ORDER -------------
MSC_ST_SALES_ORDERS
---------------- HARD RESERVATION -------------
MSC_ST_RESERVATIONS
---------------- ITEM -------------
MSC_ST_SYSTEM_ITEMS
---------------- RESOURCE -------------
MSC_ST_DEPARTMENT_RESOURCES
MSC_ST_SIMULATION_SETS
MSC_ST_RESOURCE_GROUPS
---------------- SAFETY STOCK-------------
MSC_ST_SAFETY_STOCKS
---------------- SCHEDULE DESIGNATOR -------------
MSC_ST_DESIGNATORS
---------------- SOURCING -------------
MSC_ST_ASSIGNMENT_SETS
MSC_ST_SOURCING_RULES
MSC_ST_SR_ASSIGNMENTS
MSC_ST_SR_RECEIPT_ORG
MSC_ST_SR_SOURCE_ORG
MSC_ST_INTERORG_SHIP_METHODS
---------------- SUB INVENTORY -------------
MSC_ST_SUB_INVENTORIES
---------------- SUPPLIER CAPACITY -------------
MSC_ST_ITEM_SUPPLIERS
MSC_ST_SUPPLIER_CAPACITIES
MSC_ST_SUPPLIER_FLEX_FENCES
---------------- SUPPLY -------------
MSC_ST_SUPPLIES
--------------- RESOURCE REQUIREMENT -------------
MSC_ST_RESOURCE_REQUIREMENTS
---------------- TRADING PARTNER -------------
MSC_ST_TRADING_PARTNERS
MSC_ST_TRADING_PARTNER_SITES
MSC_ST_LOCATION_ASSOCIATIONS
---------------- UNIT NUMBER -------------
MSC_ST_UNIT_NUMBERS
---------------- PROJECT -------------
MSC_ST_PROJECTS
MSC_ST_PROJECT_TASKS
---------------- PARAMETER -------------
MSC_ST_PARAMETERS
---------------- UOM -------------
MSC_ST_UNITS_OF_MEASURE
MSC_ST_UOM_CLASS_CONVERSIONS
MSC_ST_UOM_CONVERSIONS
---------------- BIS -------------
MSC_ST_BIS_PFMC_MEASURES
MSC_ST_BIS_TARGET_LEVELS
MSC_ST_BIS_TARGETS
MSC_ST_BIS_BUSINESS_PLANS
MSC_ST_BIS_PERIODS
---------------- ATP RULES -------------
MSC_ST_ATP_RULES
--------------- PLANNERS -------------
MSC_ST_PLANNERS
---------------- DEMAND CLASS -------------
MSC_ST_DEMAND_CLASSES
---------------- PARTNER CONTACTS -----------
MSC_ST_PARTNER_CONTACTS

Oracle ASCP Plan Types

In R12, you can launch three type of plans:
• Production Plan
• Manufacturing Plan
• Master Plan

For MPS Planning item level, you should run Production Plan
And for MRP Planning Item, you should run Manufacturing plan.

Please see the explanation from Dev in similar question from other customers in Oracle Technical forum:

"The below are the 3 plan types :
1. MPP (Master Plan)
2. MPS (Production Plan)
3. MRP (Manufacturing Plan)

A. In 11.5.9, we had three plan types: DRP (Distribution Plan), MPS (Production Plan) and MRP (Manufacturing Plan)
B. In 11.5.10, we had three plan types: MPP, MPS and MRP. We changed the DRP name to MPP.
Why? Because in R12, we introduced a new Distribution Planning engine and having the term DRP used for the old plan type would have caused more confusion than MPP."