1. What is bill looping? How would you check for any looping in bills?
Bill loops occur when a bill is assigned as a component to itself somewhere in the multilevel structure of the bill. The loop check program searches for such loops.
2. What is meant by Charge type in a Resource definition?
Charge type determines how each resource is charged in Work in Process. When an operation completes, Work in Process records the units applied to the job or repetitive schedule in the resource unit of measure. You can charge resources manually or automatically.
• Manual: Work in Process does not automatically charge this type of resource to a job or repetitive schedule. You must manually charge it to a job or repetitive schedule using Work in Process.
• PO Receipt: Automatically charge this resource upon receipt of a purchase order in Oracle Purchasing. The assemblies are not automatically moved to the next operation upon receipt, so you must manually move them using Work in Process.
• PO Move: Automatically charge this resource upon receipt of a purchase order in Oracle Purchasing and move the assemblies to the Queue intraoperation step of the next operation, or to the To move intraoperation step if this is the last operation.
• WIP Move: Work in Process automatically charges this type of resource to a job or repetitive schedule when you complete an operation.
3. What are supply types available for BOM in EBS?
A bill of material component field that controls issue transactions from inventory to work in process. Supply types supported by Work in Process include: Push, Assembly pull, Operation pull, Bulk, Supplier, Phantom, and Based on bill.
4. What is extended quantity in BOM?
Extended quantity takes into consideration scrap resulting from operations performed. Scrap is modeled in the system by specification of shrinkage rate.
The extended quantity of the component used in the parent item is calculated as follows:
((explosion quantity of parent item x component usage quantity) / component yield) / (1- shrinkage rate for parent)
5. What is Alternate resource? How to setup Alternate resource?
Alternate resources can be defined for each resource. You can define an alternate resource or set of alternate resources to describe a different manufacturing step used to produce the same product. Alternate resource is set at Routing > Operation Resource level.
6. What is Common BOM? How to create Common BOM?
An assembly that uses the bill of material of another assembly as its bill. This enables you to reduce your maintenance effort by sharing the same bill structure among two or more assemblies. For example, if you have identical bills of material that produce the same product in two different organizations, you can define common bills of material for the identical structures.
Common BOM are created based on primary BOM by specifying the organization to which the BOM needs to be referenced.
7. What is Planning Bill of Materials?
A bill of material for a planning item that contains a list of items and planning percentages. You can use a planning bill to facilitate master scheduling and/or material planning. The total output of a planning bill of material is not limited to 100% (it can exceed this number by any amount).
8. What is Simulation Sets?
A group of capacity modifications for resource shifts to simulate, plan, or schedule capacity.
9. What is difference between Cumulative Manufacturing lead time and Cumulative total lead time?
Cumulative manufacturing lead time
The total time required to make an item if you had all raw materials in stock but had to make all subassemblies level by level. Bills of Material automatically calculates this value. Purchased items have no cumulative manufacturing lead time.
Cumulative total lead time
The total time required to make an item if no inventory existed and you had to order all the raw materials and make all subassemblies level by level. Bills of Material automatically calculate this value.
10. How do you model by-products in BOM?
Material produced as a residual of a production process. By-product components are represented by negative usage in the bill of material for an assembly.
1. What are the differences between standard and non-standard discrete jobs?
Non-standard jobs are similar to standard jobs, however, there are noteworthy differences including:
• Non-standard jobs are more flexible than standard jobs. Because of this they can be used to manage such varying activities as rework, field service repair, upgrades, disassembly, maintenance, engineering prototypes, and other miscellaneous projects.
• Oracle planning products do not create planned orders or reschedule recommendations for non-standard jobs. You must manually define and reschedule non-standard jobs. However, if a non-standard job is assigned an assembly bill of material, a routing, or both, planning considers the job's material requirements as demand and its assemblies as supply.
• Oracle planning products do not deduct scrapped assemblies from the MRP net quantity, or deduct the MRP net quantity by the item shrinkage rate for non-standard jobs. As such, you must identify planned assembly shrinkage by entering an MRP net quantity that is less than the job quantity.
2. What is the difference between Discrete and Repetitive manufacturing?
Standard discrete jobs control the material, resources, and operations required to build an assembly and collect its manufacturing cost.
Non-standard discrete jobs control material and collect costs for miscellaneous manufacturing activity. They may or may not build an assembly. This type of activity can include rework, field service repair, upgrade, disassembly, maintenance, engineering prototypes, and other projects.
3. What is the purpose of using WIP accounting class?
Standard discrete accounting classes can be used to group job costs. For example, if you build subassemblies and finished goods, you can define your accounting classes so that you can separately value and report the costs associated with subassembly and finished goods production. Standard discrete accounting classes can be automatically defaulted when you create discrete jobs.
4. What is back flushing?
When you complete assemblies, all components with the supply type of Assembly pull are automatically backflushed. When components for assemblies under lot control, serial number control, or lot and serial control are backflushed upon assembly completion, you must assign lot and/or serial numbers to the components.
Backflush components are issued in the quantity and item as defined on the bill of material.
5. What would be scenario if the Discrete job on which OSP operation exists is closed before the receipt of OSP item?
If Discrete job which has OSP operation is closed before receipt of the OSP item, then the resource transaction would cost this transaction would error out.
Typically, system warns the user when user tries to close such discrete jobs.
6. What is the criteria system checks when linking Sales order to Discrete job?
When linking ATO sales orders and jobs, however, the following rules are applied:
• Assembly item cannot be a Pick-to-order item
• Sales order line item must be demanded, but not yet shipped
• Assembly item must be a standard item or an ATO item, not a model or an option
7. What is Outside processing? What are the modules involved in OSP?
Oracle Manufacturing enables you to include supplier-sourced components and resources in your manufacturing processes. Features include:
• Using specialized supplier skills in your manufacturing process to help lower engineering and manufacturing costs and increase production quality
• Using supplier capacity to increase your overall production capacity.
Outside processing items represent supplier-sourced items, resources, and services that you include in your build process. These items can be non-stocked items which represent the actual supplier contribution in your build process or you can define the assembly itself as an outside processing item. The outside processing item is the item on your requisition or purchase order and the item you receive in your purchase order receipts.
Modules involved are Inventory, Purchasing and WIP
8. What is the difference between Detailed Scheduling and Dynamic lead-time offsetting?
WIP Scheduling uses routing details for calculation job/operation start and end dates. This is called "Detailed Scheduling".
If you are using MRP/ASCP, Dynamic lead time offsetting is the scheduling method used and it uses the Fixed and Variable lead time defined in Item master.
9. If OSP requisition needs to be generated at the time of move transaction to that particular operation then what are the setups required for handling this scenario?
In WIP parameters form, specify Requisition creation time as At Operation.
10. Client wants to track the value of transactions that is being scrapped during an operation, what are the setups required to handle this scenario?
In WIP parameters form, specify one of the inter-operations steps as Scrap and Require Scrap account is checked.
1. What is the difference between ASCP and MRP?
ASCP allows users to perform holistic planning by taking into consideration multiple organizations in an EBS instance where MRP plan considers only one inventory organization and multiple plans needs to be created for multiple organizations. ASCP allows constraint planning thereby taking into consideration supplier, organization capacity where as MRP only facilitates unconstraint planning.
2. What is the difference in running an ECC and EDD plan?
ASCP plan with Enforce capacity constraints option ensures that all capacity constraints are honored which might result in demand due date getting pushed in to future.
ASCP plan with Enforce demand due date constraint option ensures that demand due date is given the priority and plan would overload Supplier or resource capacities to honor the Demand due date.
3. What is the role of Memory based planner?
The planning engine’s Memory Based Planner calculates the planned order demand due dates for dependent demands based on the actual requirement date with respect to lead-time. It saves the calculated requirement date based on the lead-time value for subsequent calculation.
4. Explain the process of data collection?
The data collection process consists of the Data Pull and the Operational Data Store (ODS) Load. The collection process lets you collect across Oracle Application Versions.
The two types of collections process are standard and continuous.
• Standard collections process: Using the standard collections process, you can manually run three types of collection methods including a complete refresh, a net change refresh, or a targeted refresh on specific business entities.
• Continuous collections process: The continuous collections process is an automated process of data collection that efficiently synchronizes the data on the planning server by looking up the sources. If you opt for continuous collections, the system automatically determine the type of collection that needs to be run on entities selected by you. The continuous collections process collects data from the sources with the least user intervention. The Continuous Collections concurrent program performs continuous collections.
5. What is the architecture of ASCP?
Oracle Advanced Planning Suite has a component architecture that separates the transaction data and associated processing (for example, inventory receipts and order entry) in a source instance from the planning calculations done in a destination instance. This allows planning calculations to be done on a different physical machine than the machine that performs transactions and results in better system response. It also allows planning calculations (demand planning, inventory planning, supply planning and order promising) to be applied simultaneously to information from across multiple source instances, which is useful when transaction information for a global supply chain is spread across multiple instances.
6. What is the purpose of exception messages?
The planning engine issues exception messages (exceptions) to:
• Alert you to a situation that may need your intervention, for example, a past due sales order
• Recommend that you perform an action, for example, change the date of a supply order
The planning engine issues certain exceptions for all plan types and others for only certain plan types.
The planning engine only issues exceptions against items and resources that have exception sets assigned to them.
7. What is meant by Hub and Spoke Planning?
Oracle Advanced Supply Chain Planning provides you with the option of using
demands from all planned orders during hub and spoke planning. When you use your plans as demand schedules to other plans, the planning engine considers all planned orders in the source plan as demands and explodes down the bills of material creating demands for the lower level components.
Hub and spoke planning uses a multi-plan approach where you can plan across the supply chain at the top level and then release planned orders to a lower level manufacturing plan for all MRP planned items. The top level plan includes only end items or end items with critical sub-assemblies, and typically only the final assembly plants. The lower level plan (MRP) is at the component level and includes the final assembly plants and the component manufacturing plants. Hub and spoke planning is a commonly used term for this type of subset planning.
8. What is the difference between component substitution and End item substitution?
Oracle ASCP supports two types of substitution: component substitution and end-item-level substitution.
The term end-item refers to the finished good or saleable product. End-item-level substitution is an acceptable business practice in many industries. It is often possible to fulfill customer demand on time when the requested item is not available by substituting a more functionally rich product. Substitution is also done to use up existing inventory of older, functionally equivalent items.
Component substitution refers to substitution of component of BOM with another component.
9. What is purpose of setting Demand Priority rules?
Demand Priority rules guide the constraint plan in terms of identifying supply for demand based on the user defined rule.
Demand quantities that are pegged to planned order supplies are considered in internal priority order. Demands with higher internal priority get the first opportunities to take up available resource and material capacities; demands with lower internal priorities can only use remaining resource and material capacities and are therefore more likely to be satisfied late.
10. How is organization security maintained in ASCP?
Organization security restricts plan information access to authorized individuals. Oracle ASCP allows users to associate job responsibilities to organizations for security purposes. This ensures that you see/change planning data in an organization only if you have a job responsibility associated with the organization.