Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

EBS Advanced Supply Chain Planning (MSC)

To download the description for the business views in a PDF format, click EBS Advanced Supply Chain Planning (MSC).

No.

Views

Description

1

MSC BOM Component Details

This view returns information on components and their associated assembly items. This information is displayed on the Planner Workbench Components window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a BOM component, a bill sequence, and an assembly item.

2

MSC Critical Activities

This view returns information on the critical activities of a plan. This information is displayed on the Critical Activities window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a demand order number, a supply order number, a critical item name, a critical path number, a demand priority number, a supply organization code, and a source instance code.

3

MSC Daily Plans

This view returns information about the details of the planned items for the manufacturing calendar dates on which a supply or demand transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, a category set name, a source instance code, a planned organization code, and a manufacturing calendar date

4

MSC Demand Details

This view returns information on the demand details of a plan. This information is displayed on the Demand or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each demand transaction per plan.

5

MSC Designator Details

This view returns information on the details of the different designators (names) defined as part of Supply Chain Planning and Advanced Supply Chain Planning. The designators created as part of Oracle Advanced Supply Chain Planning are displayed on the Supply Chain Plan Names window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a designator name, a source instance code, and an organization code.

6

MSC Exceptions

This view returns information on the exception details generated by a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

7

MSC Forecast Consumptions

This view returns information on the forecast consumptions of a plan. This information is derived from the forecasts and sales orders information retrieved from the source systems and used in the Oracle Advanced Supply Chain Planning module of the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a planned organization code, a forecast name, a sales order number, a sales order quantity, and a forecast quantity.

8

MSC Item Category Details

This view returns information on the categories of items that are used in plans. A record is returned for each category of an item.

9

MSC Item Details

This view returns information on the items that are being planned. This information is displayed on the Items window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, and an item name.

10

MSC Item Exception Details

This view returns the item exception details of a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each item exception per plan.

11

MSC Item Exception Summary

This view returns summarized information on all item exceptions generated by a plan. This information is displayed on the Exceptions Summary window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, an exception group, an exception type, an item, a category set name, and an item category.

12

MSC Item Substitute Dtls

This view returns information on the substitute items to be considered for all planned items during the planning process. A record is returned for each substitute of a planned item as defined in the source inventory system.

13

MSC Item Supplier Details

This view returns information on the item supplier details of a plan. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a supplier name, an item name, a plan name, a planned organization code, a source instance code, a supplier site, an item category name, a category set name, and a using organization code.

14

MSC Late Order Exceptions

This view returns information on the late order exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

15

MSC Manufacturing Periods

The view returns information on dates of the manufacturing calendar periods. This information is displayed on the Calendar window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a manufacturing organization code, a manufacturing period name, a manufacturing period start date, a general ledger period start date, and a period set name.

16

MSC Mtrl Rsc Capacity Excp

This view returns information on the material and resource capacity exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

17

MSC Pegging Details

The view returns information on the pegging details of a plan. This information is displayed on the Supply, Demand, and Supply/Demand windows of the Oracle Advance Supply Chain Planning module. A record is returned for each demand and the supply that is satisfying that demand.

18

MSC Period Plans

This view returns information about the details of the planned items for the manufacturing periods during which a demand or supply transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, an item category description, a category set name, a source instance code, a planned organization code, and the start date of a manufacturing period.

19

MSC Plan Options

This view returns information on supply chain plans and their options. This information is displayed on the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each plan.

20

MSC Planned Organizations

This view returns information on the organizations that are being planned as part of a supply chain plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name and a planned organization code.

21

MSC Reschedule Exceptions

This view returns information on the reschedule exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan, item, and item category.

22

MSC Resource Details

This view returns information on the resources that are used in the planning process. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization, a department code, a resource description, and a resource code.

23

MSC Routing Operation Dtls

This view returns information on routing operations performed during the manufacturing of an assembly. This information is displayed on the Routing Operations window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan, a routing sequence, an operation sequence, and an operation component.

24

MSC Routing Oprn Resources

This view returns information on the resources associated with routing operations. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a source instance code, a using assembly item, an operation sequence number, a planned organization code, a department code, a resource usage, an alternate routing designator, a resource code, and a routing type.

25

MSC Rsrc Requirement Dtls

This view returns information on the required resources suggested by a plan. This information is displayed on the Resource Requirements window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, and a resource requirement.

26

MSC Safety Stock Details

This view returns information on the safety stock details of all the items. This information is displayed on the Safety Stock window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, an item name, an effective start date of the safety stock, a planning group, a project number, a task number, and a demand unit number.

27

MSC Schedules

This view returns information on demand and supply schedules associated with a plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, and a schedule name.

28

MSC Sourcing Rule Assigns

This view returns information on sourcing rules and bills of distribution associated with the assignment set. This information is displayed on the Sourcing Rule / Bill of Distribution Assignments window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each assignment.

29

MSC Sourcing Rule Details

This view provides information on the sourcing rules and bills of distribution. This information is displayed on the Sourcing Rule or Bills of Distribution window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. For sourcing rules, a record is returned for each combination of a sourcing rule name, an effective start date, an effective end date, a shipping organization, a source type, a sourcing rank, a supplier name, and a supplier site. For bills of distribution, a record is returned for each combination of a sourcing rule name, a receiving organization, an effective start date, an effective end date, a source type, a sourcing rank, a supplier name, and a shipping organization.

30

MSC Subs Alts Exceptions

The view returns information on the exceptions relating to substitutes and the alternates used for a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

31

MSC Supplier Capacity Dtls

This view returns information on the supplier capacity details for all inventory items. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, a supplier number, a supplier site, an item name, a category set, and an item category.

32

MSC Supply Chain Bills

This view returns information on the details of supply chain bills. This information is displayed on the Supply Chain Bill window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan, organization, item or assembly item, component item description, and the item's sourcing information.

33

MSC Supply Details

This view returns information on the supply details of a plan. This information is displayed on the Supply or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each supply transaction per plan.

34

MSC Vertical Plan Details

This view returns information on the vertical plan details of the planned items. This information is displayed on the Vertical Plan window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for every demand or supply transaction per plan name, source instance code, planned organization code, item name, and due date.

35

MSC Weekly Plans

This view returns information about the details of the planned items for the manufacturing calendar weeks during which a demand or supply transaction was performed. A record is returned for each combination of a plan name, an item name, a source instance code, a planned organization code, a category set name, and the start date of a manufacturing week.

Published:

EBS Advanced Supply Chain Planning (MSC)

To download the description for the business views in a PDF format, click EBS Advanced Supply Chain Planning (MSC).

No.

Views

Description

1

MSC BOM Component Details

This view returns information on components and their associated assembly items. This information is displayed on the Planner Workbench Components window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a BOM component, a bill sequence, and an assembly item.

2

MSC Critical Activities

This view returns information on the critical activities of a plan. This information is displayed on the Critical Activities window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a demand order number, a supply order number, a critical item name, a critical path number, a demand priority number, a supply organization code, and a source instance code.

3

MSC Daily Plans

This view returns information about the details of the planned items for the manufacturing calendar dates on which a supply or demand transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, a category set name, a source instance code, a planned organization code, and a manufacturing calendar date

4

MSC Demand Details

This view returns information on the demand details of a plan. This information is displayed on the Demand or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each demand transaction per plan.

5

MSC Designator Details

This view returns information on the details of the different designators (names) defined as part of Supply Chain Planning and Advanced Supply Chain Planning. The designators created as part of Oracle Advanced Supply Chain Planning are displayed on the Supply Chain Plan Names window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a designator name, a source instance code, and an organization code.

6

MSC Exceptions

This view returns information on the exception details generated by a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

7

MSC Forecast Consumptions

This view returns information on the forecast consumptions of a plan. This information is derived from the forecasts and sales orders information retrieved from the source systems and used in the Oracle Advanced Supply Chain Planning module of the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a planned organization code, a forecast name, a sales order number, a sales order quantity, and a forecast quantity.

8

MSC Item Category Details

This view returns information on the categories of items that are used in plans. A record is returned for each category of an item.

9

MSC Item Details

This view returns information on the items that are being planned. This information is displayed on the Items window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, and an item name.

10

MSC Item Exception Details

This view returns the item exception details of a plan. This information is displayed on the Exceptions Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each item exception per plan.

11

MSC Item Exception Summary

This view returns summarized information on all item exceptions generated by a plan. This information is displayed on the Exceptions Summary window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, an exception group, an exception type, an item, a category set name, and an item category.

12

MSC Item Substitute Dtls

This view returns information on the substitute items to be considered for all planned items during the planning process. A record is returned for each substitute of a planned item as defined in the source inventory system.

13

MSC Item Supplier Details

This view returns information on the item supplier details of a plan. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a supplier name, an item name, a plan name, a planned organization code, a source instance code, a supplier site, an item category name, a category set name, and a using organization code.

14

MSC Late Order Exceptions

This view returns information on the late order exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

15

MSC Manufacturing Periods

The view returns information on dates of the manufacturing calendar periods. This information is displayed on the Calendar window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a manufacturing organization code, a manufacturing period name, a manufacturing period start date, a general ledger period start date, and a period set name.

16

MSC Mtrl Rsc Capacity Excp

This view returns information on the material and resource capacity exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

17

MSC Pegging Details

The view returns information on the pegging details of a plan. This information is displayed on the Supply, Demand, and Supply/Demand windows of the Oracle Advance Supply Chain Planning module. A record is returned for each demand and the supply that is satisfying that demand.

18

MSC Period Plans

This view returns information about the details of the planned items for the manufacturing periods during which a demand or supply transaction was performed. A record is returned for each combination of a plan name, an item name, an item category name, an item category description, a category set name, a source instance code, a planned organization code, and the start date of a manufacturing period.

19

MSC Plan Options

This view returns information on supply chain plans and their options. This information is displayed on the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each plan.

20

MSC Planned Organizations

This view returns information on the organizations that are being planned as part of a supply chain plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name and a planned organization code.

21

MSC Reschedule Exceptions

This view returns information on the reschedule exception details generated by a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan, item, and item category.

22

MSC Resource Details

This view returns information on the resources that are used in the planning process. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization, a department code, a resource description, and a resource code.

23

MSC Routing Operation Dtls

This view returns information on routing operations performed during the manufacturing of an assembly. This information is displayed on the Routing Operations window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan, a routing sequence, an operation sequence, and an operation component.

24

MSC Routing Oprn Resources

This view returns information on the resources associated with routing operations. This information is displayed on the Resources window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, an item name, a source instance code, a using assembly item, an operation sequence number, a planned organization code, a department code, a resource usage, an alternate routing designator, a resource code, and a routing type.

25

MSC Rsrc Requirement Dtls

This view returns information on the required resources suggested by a plan. This information is displayed on the Resource Requirements window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, and a resource requirement.

26

MSC Safety Stock Details

This view returns information on the safety stock details of all the items. This information is displayed on the Safety Stock window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a source instance code, a plan name, a planned organization code, an item name, an effective start date of the safety stock, a planning group, a project number, a task number, and a demand unit number.

27

MSC Schedules

This view returns information on demand and supply schedules associated with a plan. This information is displayed on the Organizations tab of the Plan Options window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a planned organization code, and a schedule name.

28

MSC Sourcing Rule Assigns

This view returns information on sourcing rules and bills of distribution associated with the assignment set. This information is displayed on the Sourcing Rule / Bill of Distribution Assignments window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each assignment.

29

MSC Sourcing Rule Details

This view provides information on the sourcing rules and bills of distribution. This information is displayed on the Sourcing Rule or Bills of Distribution window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. For sourcing rules, a record is returned for each combination of a sourcing rule name, an effective start date, an effective end date, a shipping organization, a source type, a sourcing rank, a supplier name, and a supplier site. For bills of distribution, a record is returned for each combination of a sourcing rule name, a receiving organization, an effective start date, an effective end date, a source type, a sourcing rank, a supplier name, and a shipping organization.

30

MSC Subs Alts Exceptions

The view returns information on the exceptions relating to substitutes and the alternates used for a plan. This information is displayed on the Exception Details window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each exception per plan.

31

MSC Supplier Capacity Dtls

This view returns information on the supplier capacity details for all inventory items. This information is displayed on the Supplier Capacity window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan name, a source instance code, a planned organization code, a supplier number, a supplier site, an item name, a category set, and an item category.

32

MSC Supply Chain Bills

This view returns information on the details of supply chain bills. This information is displayed on the Supply Chain Bill window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each combination of a plan, organization, item or assembly item, component item description, and the item's sourcing information.

33

MSC Supply Details

This view returns information on the supply details of a plan. This information is displayed on the Supply or Supply/Demand window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for each supply transaction per plan.

34

MSC Vertical Plan Details

This view returns information on the vertical plan details of the planned items. This information is displayed on the Vertical Plan window of the Oracle Advanced Supply Chain Planning module in the Oracle Advanced Planning suite. A record is returned for every demand or supply transaction per plan name, source instance code, planned organization code, item name, and due date.

35

MSC Weekly Plans

This view returns information about the details of the planned items for the manufacturing calendar weeks during which a demand or supply transaction was performed. A record is returned for each combination of a plan name, an item name, a source instance code, a planned organization code, a category set name, and the start date of a manufacturing week.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk