Monday, March 2, 2009

Oracle Apps WIP KEY Tables

Oracle Apps WIP KEY Tables
WIP_LINES
WIP_LINES stores production line information. Each row includes a line name, maximum and minimum rate information, throughput for rate based lines (lead time), and the start and stop time information that determines the amount of time per day that the line is available. Oracle Work in Process uses this information when you associate a line with a repetitive assembly and when you define a repetitive schedule on the line. Production line information is optional for discrete jobs.
WIP_OPERATIONS
WIP_OPERATIONS stores information about job and repetitive schedule operations. Each row represents a specific operation and includes an operation sequence number, which orders the operations for the job or repetitive schedule. Each row also includes the assembly quantity completed at an operation, the quantity at each intraoperation step, the department associated with an operation, the scheduled start and completion dates for an operation, the operation’s count point andbackflush types and other operation attributes. In general, Oracle Work in Process uses this information to control and monitor assembly production on the shop floor.
WIP_ENTITIES
WIP_ENTITIES stores information about jobs, repetitive assemblies, and flow schedules. Each row includes a unique entity name, the entity type,and the assembly being built. Oracle Work in Process uses this information to control production activities and to ensure that entities with duplicate names are not created.
WIP_DISCRETE_JOBS
WIP_DISCRETE_JOBS stores discrete job information. Each row represents a discrete job, and contains information about the assembly being built, the revision of the assembly, the job quantity, the status of the job, the material control method, accounting information, and job schedule dates. Oracle Work in Process uses this information to control discrete production. WIP_TRANSACTIONS
WIP_TRANSACTIONS stores information about WIP resource transactions. Each row represents a single resource transaction and includes a unique transaction Identifier, a transaction date, the job or repetitive schedule charged, the WIP operation and resource charges, and the number of units of measure applied. Oracle Work in Process uses this information to track resource charges and to calculate the values stored in WIP_TRANSACTION_ACCOUNTS.

Oracle Work in Process (WIP) Tables

wip_move_transactions

wip_discrete_jobs

wip_repetitive_schedules

wip_move_txn_interface

wip_cost_txn_interface

wip_job_shedule_interface

wip_job_dtls_interface

11 comments:

Unknown said...

Can you please provide answers to These questions.

1) How did you generate the PDF on the report builder?


2) How will you develop the report if my organization is having two operating units one is in India and one is US. I want two operating units data in the report separately? How?


3) If I run the report with query like select * from emp? First which trigger will fire?


4) In which directory init.ora is stored.


5) I want to get a particular report periodically to my email account how?


6) Where you will execute your pl/sql code in reports i.e. in which trigger?


7) Performance point of view which is good? Decode or case?


8) How u reduce the time execution of query?


9) How do you track a Request Set? If an error occurs in the first program in a Request Set, I need to control the execution of other programs in the Request Set, How do you achieve this


11) How can I join if I have one set of books and 5 operating units?


12) How will you debug your reports?


13) Suppose I have written one report no data is found. How will you tell the user that no data found. After the end of report means last page user should be able to see the message end of report


14) Can we set Index for primary key? If so what is the name of the Index?


15) How to find how many ‘a’ are there in the specified string ‘aasfdhhjkgjaaaa’?


16) Can we pass Pl/sql table as a parameter to another procedure or not if so how to pass?


17) Can you use placeholder column with out using formula column?


18) How do you stop inserting records after 50 records are inserted from flat file through sql*loader


19) Why an application is needed in creation of responsibility at 3 places, After Responsibility Name, After Data Group, After Request Group?


20) I need one gap for every 3 rows in a report. How?


21) Is v$parameter updatable?


22) Develop a report to change color for maximum and minimum salaries, what is the logic?


23) Try to find positive salary on one column and negative salary on one column


24) Try to find total members belong to each department and find all the total members


25) Can I have a report with out data model query?


26) I need to return two values from a function. How?


27) How u reduce the time execution of query?


28) I developed a master child report using link option. One report I have developed using joins in single query and I separated by dragging the master group. Now the question which performs better. Why?


29) When you query Multi-Org tables in SQL*Plus or any tool (like TOAD), we get zero rows, though actually those tables got data? What is the reason? What do you do then?


30) What is auto reduction?


31) Can we define cursor inside package if so how to call cursors inside the package?


32) When you will go for XML reports and when you will go for Discoverer reports.


33) How will you get the legacy system from your client?


34) Once we transfer the Invoice Data from AP to GL in which column we can find that

We have transferred or not?


35) What are hidden values?


36) Can you generate the numbers in triggers?


37) How to print your client name in the report?


38) Suppose we have created one table value set and in that we are getting duplicate rows. How can we avoid the duplicate rows from table value set?


39) How many ways are there to receive the flat file from the client?


40) Instead of flat file, we will receive other one from client .what is that?

41) We use standard program to move values from interface table to base tables. Instead of the using the standard program, I want to use API .what is that API?


42) Instead of using the staging table can we use the global temporary table?


43) In between the MD50 and MD70 we receive one issue. What is that?


48) Suppose I have given a functional spec, What are the steps we do from receiving functional spec (md50) to delivery process?


44) If supplier will send bid quotation? Is it possible to create standard PO?


45) Suppose I have 100 records are there? 50 records went to interface table and 50 records are errored out? Now what we have to do? Either correcting/deleting/updatable? if u are correcting means how to correct it?


46) What is the difference between supplier and vendor?


47) In which table the damaged good information is stored?


50) How will you register the concurrent program through UNIX?


51) While customizing how will you work with bit maps. What will you do before customizing and before ftp the file to the local directory?

Unknown said...

A good job Sunil.
keep it up.

Unknown said...

This is the right time for graduates who completed their graduation and looking for job.Almost all companies are starts recruiting the efficient persons.So,Graduates get ready for getting the right job. There are so many job openings for all graduates in both IT/non-IT side. This is very useful to you,utilize it.

Unknown said...

can u explain me how the values from lookups table get retrived to the Apps Form

Shilpi said...

Can u pls tell me how to find the job number of an WIP Item?
I have the Inventory_item_id of te item.I can find out whether that item is wip item or not from MTL_SYSTEM_iTEMS_B table.Pls help me in finding out the job number(wip_entity_id) of that item.
Waiting for ur reply.
Thanks in advance.

iphone application development said...

can you show me that how many apps you have developed ?

Unknown said...
This comment has been removed by the author.
Anonymous said...


thanks for sharing this wonderful information.It helps us to know about latest technology.It provides the useful information about devops technologies.


Salesforce Training in Chennai

Unknown said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Ancy merina said...
This comment has been removed by the author.
Unknown said...

Calgary government has certain requirements for Calgary roofing companies. However, it is the homeowner’s responsibility to make sure those requirements are met and fulfilled.
roofing services calgary