WIP-Questions1. Which intra operation steps might you want to enable if you have a just-in-time production environment? Ans: You would probably enable only Run and To Move to model your environment.

2. You cannot move more assemblies than are available at a routing operation.a) True b) False

3.What are the three transaction available in WIP?Ans: Material transaction, Move transaction, Resource transaction.

4.When the lot based resource gets charged?Ans: When the first unit is moved, the lot based resources will be charged.

5.In a assembly, all the components have supply type as operational pull, they are serial controled. During move transaction, how we can select the serial numbers.Ans: During move transaction, a window “ Backflush” will popup, there we can select serial numbers.

6.For an assembly, the move transaction does not allow me to complete in that screen iteself? What will be the problem.Ans: The assembly will be serial control, therefore you have to complete it in completion transaction screen only

7.In an assembly, one of the item has supply type = bulk, what transaction should i perform.Ans: no need to perform any transaction, it is just a label.

8.In profile option, WIP: Define discrete job, it has been defined as concurrent. While creating a Discrete order, what concurrent will be running?Ans: WIP concurrent exploder.

9.Explain shopfloor status?Ans: Shop floor status are control move transactions which can be assigned to interaoperations steps. 

10.What are the two types of scheduling available in WIP?Ans: Dynamic lead time offsetting and Detailed scheduling.

11. Which status in discrete job cannot be reversed?Ans: Complete – No charges

12.Which field in Discrete job is non- editable before saving?Ans: UOM

13.How can we add material and Resource in a discrete job? What is the implicaiton of this action on bills and routing?Ans: In Job / Schedule details we can add materials and resource for the particulat order. This will be effect for this order only. Engineering BOM and Manufacturing BOM has no effect.

14.What is repetative schedule?

Ans: Repetative schedule builts an assembly on a line at specifited production rate and for specified number of days.

15.How can you reverse manual resource charges?Ans: You can manually charge the same resource to the job or schedule and enter a negative value in the Units Applied field.

16.In Repetative schedule, while associating line and assembly, what will happen if we enter hourly prodcution rate higher than the maximum hourly rate defined in production line?Ans: An error message will pupulate and wont allow to enter quantity greater than maximum hourly rate defined in production.

17.What are the different rescheduling options available in WIP?Ans: Forward , Backward and Midpoint.

18.For a purchased item, how “processing lead time” is calculated in WIP?Ans: WIP won't calculate “Processing lead time” for purchased item, we have to manually enter.

19.In OSP, what will happen if we receive quantity greater than PO quantity?Ans: we cannot close the job, it will be shown in pending transaction.

20. In an assembly, same component is used in operation 10 (first) & 50 (last). How to specify this in a bill?Ans: Use reference designators to generate a range of Notion numbers with referencing to the specific operations. This might be drawing conventions, general informations..Etc

21.I want to check what are all the components used for final assembly, their qty, the routing & availability of child assemblies in Inventory. After checking, I want to convert that into discrete job. What is the facility given by oracle to do the above scenario?Ans: Use “Simulate discrete Job” 

22.I use Substitute items in WIP material transaction?a) True b) False

23.What are the controls available to generate requisitions during OSP process?Ans: In WIP Parameters, Operation start time of OSP operation (Queue Stage in OSP),At the time of creation of Job/schedule, Manual

24.Can we add an operation after it starting prodction. ( partial move transaction)a) Yes b) No

25.Explain the status “ Pending Mass loaded” in Repetative scheduleAns: The out put of MRP will be “ Pending Mass loaded” , since MRP does not consider existing schedules. 

Descriptive Questions

1.What are the types of WIP accounting class available in Oracle?Ans: Standard, Asset non-standard, Expense non-standard, Repetitive, Standard lot

based, Expense non standard lot based, Maintenance.

2.Client is Pen manufacturer, He uses discrete manufacturing for his production. he sells pens and refills (as spare), During manufacturing of pen, refill is one of the component and it is non stocked . What setup to be done to manufacture and sell both pen and refill ( instead of defining two seperate items for refill)Ans: Create items Pen and refill with supply type push / pullCreat bill for pen, attach refill as its one of the component,Change the default supply tpe to Phantom. ( this will effect this particular bill only)

3.What is the difference between “ Complete” and “ Close” ?Ans: S.No Complete Close1 When completed, the WIP value gets decremented and Inventory value gets incremented When closed, the details are transferred to GL2 Valuation accounts gets hit Variance account gets hit

4.In a Routing, an items’ manufacturing process is as per below..10- Assembly20 -Cleaning 30- Labeling 40- Inspection 50- Packing ,Here 40, Inspection is an occasional operation, not always be done. & 20. Cleaning is always done but non-critical. Hence these are requested not to be done while performing “ Move transaction “ in-order to have less manual effort. How to designate this requirement?Ans:In standard operation, 20. Cleaning – Disable “ Count Point” & Select “ Auto charge”. This will not default this particular operation in the move transaction. This way can skip that particular operation.40. Inspection, Count point & Auto charge to be disabled. Hence whenever occasional need calls, Add this operation to the Job by Job/Schedule Operations.

5.Create Discrete JOB for 10 nos, complete only 5 leave the remaining is Rejection. Hence this rejected qty not to be considered while booking sales order? What setup to be done so that can be avoided?Ans: Create a Sub-Inventory and disable “Allow reservation – No”. (Call it as Rejection sub inventory) Assign this DJ – Routing __ completion sub inv, so as rejected components can be moved here while Making “Move transaction” Can check in the Availability window in the sales order screen, Available to reserve qty. 

6.What are some reasons Oracle Work in Process would prevent you from performing a completion transaction?Ans: There is no available quantity in the To Move step of the last operation in the routing.–There is a shop floor status preventing movement from the To Move step of the last operation in the routing.–The job/schedule status prevents transactions.–The item is not transact able

7.what is the difference between Standard and Non-standard discrete jobs?Ans: 

S.No Standard DJ Non-Standard DJ1 Standard DJ controls material and operation required to build assemblies and collect manufacturing cost Non-standard DJ controls miscellaneous activities eg: Rework, repair2 Assembly in mandatory Assembly is not mandatory3 We can “ Firm” Cannot check “ Firm”4 Bill reference field is grey out Can enter item / assembly5 Revision is not optional Revision is mandatory if the assembly has revision6 Both Valuation and variance will be hit Only Variance will be hit

8.What are the status of DJ ( both user status and Processing status)Ans S.No User status Processing Status1 Unreleased Pending routing load2 released Failed routing loadComplete Pending bill loadComplete – No charge Failed bill loadCancel Pending schedulingHold Pending closedClosed Failed close 

9.Can i complete an assembly with out order? Explain in detail

Ans: Yes, In Workorder less completion we can complete an assembly with out order.Ther are 4 options available: WIP assembly compeltion , WIP assembly return, WIP assembly scrap, WIP return from scrap. 

10.How to unclose an order, what are the prequestes for forecast

Ans: In Close Discrete jobs form query with the order number. Tools--> Unclose.The prequestes are a) Job status should be closed.b) Accounting period should be open

Standard Versus Non-Standard JobsStandard discrete jobs control the material, resources, and operations required to buildan assembly and collect its manufacturing cost.Non-standard discrete jobs control material and collect costs for miscellaneousmanufacturing activity. They may or may not build an assembly. This type of activitycan include rework, field service repair, upgrade, disassembly, maintenance,engineering prototypes, and other projects

Oracle Work In ProcessOracle Work in Process is the core of Oracle’s Discrete Manufacturing Solution. Oracle Work in Process by itself provides a complete production management system that improves productivity, quality, and responsiveness while maximizing throughput and production. In conjunction with other modules within Oracle Discrete Manufacturing foot print, Oracle Work in Process provides support for enterprise wide quality management, lot and serial genealogy and traceability and support for various methods of planning

and cost accounting, irrespective of whether your entire manufacturing is in-house or you use services of contract manufacturers.Thanks & Regards,S.Grace Paul ReganPosted by S.Grace Paul Regan at 2:03 AM 2 comments:   

Thursday, May 27, 2010Discrete JobsDefinite quantity of job used to manufacture the quantity.II. Types of Jobsi. Standardii. Non- StandardStandard Job will have the assembly with the defined Bill, Routing structure from BOM.Job Type of Standard identifies the job as being: A discrete job that controls the material and operationrequirements used to build assemblies and collect manufacturing costsNonstandard Job Type identifies the job as being:A discrete job that controls the material and collects costs formiscellaneous activities, such as:ReworkField service repairUpgradeDisassembleMaintenanceEngineering prototypesThanks & Regards,S.Grace Paul ReganPosted by S.Grace Paul Regan at 11:22 PM No comments:   

Wednesday, May 26, 2010WIP Accounting Classes

WIP Accounting classes are used to assign valuation and variance accounts for jobs. The data below Shows the wip accounting classes to be used for different type of jobs in SSL.S.No -------- Discrete Job Type --------------------WIP Accounting Class1 ------------Standard -------------------------------Standard2 ------------Non Standard Asset --------------------Non Std A3 ------------Non Standard Expense -----------------Non Std Ex

Thanks & Regards,S.Grace Paul Regan.

Posted by S.Grace Paul Regan at 11:31 PM No comments:   

Tuesday, May 25, 2010Supply Typei. Based on BillComponents required for the Bill has to be issued. Method of issuing the components is given as supply type in Bill of Material. If we can use the same , select based on Bill.ii. PushIf all the components to be used as PUSH type, select PUSH. In PUSH, we need to issue

the components through WIP Component Issue transactions before starting the Job.iii. Operation PullComponents Issue will be taken care of by the system itself. Once the operation is completed, required components will be pulled from the mentioned supply subinventory .iv. Assembly PullOnce the assembly is completed, required components for that assembly will be pulled from the given supply subinventory.v. SupplierIssue of item by supplier, need not to transact this item . It is only for reference only to the WIP Person as this component need not to be used.vi .BulkBulk component requirements can be viewed and are displayed on reports. They can be used to communicate to the shop floor that bulk components must be used but need not be transacted.Bulk supply type components are not backflushed nor do they default when issuing all components for an assembly. we can, however, manually issue specific bulk components to a discrete job or repetitive schedule.

Thanks & Regards,S.Grace Paul Regan.Posted by S.Grace Paul Regan at 5:51 AM No comments:   

Tuesday, August 25, 2009Return back components after Operation Pull and Assembly PullBackflush transactions 'pull' components with Operation Pull and Assembly Pull supply types from inventory onto jobs and repetitive schedules. Backflush transactions can be launched by: o completing assemblies at operations using the Move Transactions windowo moving and completing assemblies into inventory using the Move Transactions windowo completing assemblies into inventory using the Completion Transactions windowo receiving assemblies from an outside processing operation using the Oracle Purchasing, Enter Receipts windowMove transactions imported through the Open Move Transaction Interface can also create backflush transactions. Transactions imported through the Oracle Inventory, Inventory Transactions Interface can also create backflush transactions. Additional Information: Backflushing reduces the number of manual material transactions required to process the discrete jobs and repetitive schedules.Reverse Backflush TransactionsYou can reverse backflush transactions and automatically return backflushed components back to inventory. For example, pull components that are backflushed as you move assemblies forward in a routing are automatically returned to inventory when you move assemblies backwards. Reverse backflush transactions can be created as you do the following: o reverse operation completion transactions using the Move Transactions window o return completed assemblies from inventory to jobs and schedules using the Completion Transactionso move and return assemblies from inventory to jobs and schedules using the Move Transactions windowo return or correct transaction receipts in the Enter Returns or Enter Corrections windows in Oracle Purchasing.Move transactions imported through the Oracle Work in Process Open Move Transaction

Interface can also reverse backflush transactions as can return transactions imported through the Inventory Transaction Interface. 

Note: You can, if necessary, issue and return pull components to and from jobs and schedules to inventory using the 'Specific Component' option in WIP Material Transactions windowBackflush Supply Subinventories and LocatorsSufficient inventory must exist in a component's source subinventory and locator for backflush transactions to complete successfully. If there is insufficient on-hand inventory to satisfy backflush demand, the supply subinventory balance is forced negative even if the Oracle Inventory Allow Negative Balance parameter is set to No. The one exception is if the component you are backflushing is under lot, serial, or lot and serial number control. In this case you cannot complete the backflush transaction until you select a subinventory and locator that contains a sufficient quantity of valid lot and/or serial numbered items. Supply subinventories and locator can be defined at the item or bill of material component level. If they are not defined, the system uses the supply subinventory and locator specified by the WIP Backflush Supply Subinventory and Locator Parameters when components are backflushed. To ensure adequate supply for backflush transactions, you can replenish supply subinventories and locators as required. Revision ControlFor component items under revision control, the system always defaults the revision based on the item's current revision as of the date of the transaction. 

Thanks & Regards, S.Grace Paul ReganPosted by S.Grace Paul Regan at 11:04 PM No comments:   

Monday, November 17, 2008

Discrete Job StatusesDiscrete job statuses describe the various stages in the life cycle of a job and control theactivities that you can perform on it.User Controlled StatusesYou can manually change user-controlled statuses. For example, you can change a job'sstatus to Released to initiate the production cycle. Some user-controlled statuses areautomatically changed based on other events. For example, when you complete a job,its status is changed to Complete.Released The job is available for production and can be transactedagainst. When a job is changed to this status, the datereleased is automatically set to the current date and, if arouting exists, the job quantity is moved to the Queueintraoperation step of the first routing operation.You can change jobs to this status as you define them.Unreleased The job is not released for transaction activity. You canupdate but cannot transact against it.You can assign a status of Unreleased if there are no netissue, move, resource, completion, or scrap chargesassociated with the job and no purchase orders or purchaserequisitions linked to the job.

Complete The job is completed but accepting transactions andcharges. Jobs are automatically updated to this status whenthe quantity completed into inventory equals the job

quantity.You can manually assign this status only when you updatethe job, not when you define it.Complete-No Charges The job is complete and accepting no further activity. Youcannot update or transact against it, but you can change itsstatus to Complete. You can assign this status only whenyou update the job.On Hold You can update the job but cannot transact against it. Youcan assign this status to a job when you define it.Cancelled The job was cancelled before completion. You cannotupdate the job or transact against it, but you can change itsstatus. You can assign this status only when you update thejob.Closed The job is closed and accepting no further activity. Job areautomatically updated to this status upon successfulcompletion of the job close process. You can change jobswith this status to another status if the accounting periodthat the job was completed in is still open and if yourfunctional security setup permits.

Purging Discrete JobsYou can use the Purge Discrete Jobs window to purge information associated withdiscrete jobs that were closed in a now closed accounting period. You can purge alldiscrete job information or just selected information: details (material requirements,resource requirements, and operations), associated ATO configurations, or associatedmove and/or resource cost transactions.Before purging a job, you can view detail and ATO sales order information for that job.You can also print one or all of the reports in the Discrete Job Packet for the job

Prerequisitesr You must have at least one closed period for your organization. See: Period Close,Oracle Cost Management User's Guide.To find jobs to purge:1. Navigate to the Purge Discrete Jobs window. The Find Discrete Jobs windowappears.2. Query to find one or more discrete jobs. See: Finding Discrete Jobs, page 3-82.The Purge Discrete Jobs Summary window appears with the results of your query

Oracle ASCP, better known as Oracle Advanced Supply Chain Planning corresponds to MRP2 in the evolution of  planning systems. MRP1 took care of unconstrained planning and mostly addressed the BOM explosion and lead time offset  requirements for simplistic planning. But since MRP1 did not take care of in-house and out-sourced, vendors’ capacities  the need for an advanced planning system which can take care of

such constraints was realized and Oracle enhanced its  simple MRP solution to come out with a more advanced constrained based planning solution.  This let to the advent of Oracle ASCP module.

Oracle ASCP comes as a separate module in Oracle Applications suite with separate licensing requirements.

Let me start by dwelling onto some of the initial topics on ASCP configuration from system perspective.

Typically there are two kinds of architectures supported to incorporate Oracle ASCP module with your ERP system.

1. Centralized Architecture

2. Distributed Architecture

Centralized architecture essentially means that your transactional modules and planning module be sitting on the  same application instance and would be pointing to the same database for data storage. This architecture is preferred  where the transactional data volume is not very high. Since planning engine can put significant amount of load on  the hardware it is very important to assess the overall data volume load at the inception of ASCP implementation itself.  From IT costing perspective centralized architecture is good because there are obvious cost savings that can be seen  as this requires only one application tier and one database tier. But then as mentioned earlier this decision should  be strictly governed by the current data volume and the kind of growth you are expecting for your business in future.Distributed architecture, as the name suggests points to having planning modules installed on a different instance. Again the decision to go for this architecture has to be governed by the transactional data volume. This architecture has the inherent benefit that you can always keep your planning data separate and continue your planning functions even when your transactional system is down to due maintenance or patching activities etc.To start with I would keep this post till here only and would dig deeper in the future posts. To highlight what could be coming your way in future I would put down some of the topics here: Technical architecture of ASCP, Engine logic for optimization, mapping constraints in EBS, plan output analysis etc