Oracle Process Manufacturing Product Development and Process ExecutionTables, Views

	Oracle Process Manufacturing Process Execution – List of database tables GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_MAPPING_MIG GME_BATCH_SALES_ORDERS GME_BATCH_STEPS GME_BATCH_STEPS_MIG GME_BATCH_STEP_ACTIVITIES GME_BATCH_STEP_ACTIV_MIG GME_BATCH_STEP_CHARGES GME_BATCH_STEP_CHARGES_MIG GME_BATCH_STEP_DEPENDENCIES GME_BATCH_STEP_DEP_MIG GME_BATCH_STEP_ITEMS GME_BATCH_STEP_ITEMS_MIG GME_BATCH_STEP_RESOURCES GME_BATCH_STEP_RESOURCES_MIG GME_BATCH_STEP_RSRC_SUMMARY GME_BATCH_STEP_TRANSFERS GME_BATCH_STEP_TRANSFERS_MIG GME_BATCH_TXNS_MIG GME_ERES_GTMP GME_EXCEPTIONS_GTMP GME_GANTT_DOCUMENT_FILTER GME_INVENTORY_TXNS_GTMP GME_LAB_BATCH_LOTS GME_MATERIAL_DETAILS GME_MATERIAL_DETAILS_MIG GME_MATERIAL_DISPENSING_GTMP GME_MIGRATION_CONTROL GME_PARAMETERS GME_PENDING_PRODUCT_LOTS GME_PROCESS_PARAMETERS GME_PROCESS_PARAMETERS_MIG GME_RESOURCE_TXNS GME_RESOURCE_TXNS_GTMP GME_RESOURCE_TXNS_MIG GME_RESOURCE_TXNS_SUMMARY GME_SCALE_DETAIL GME_TEMP_EXCEPTIONS GME_TEXT_HEADER GME_TEXT__TL GME_TRANSACTION_PAIRS GME_UNALLOCATED_ITEMS_GTMP OPM Product Development Tables:
Sl.No	VIEW NAME	DESCRIPTION
1	FM_ACTV_MST	Activity master. Defines activities which are performed in operations.
2	FM_ARES_MST	Operation-specific alternate resource factors
3	FM_CONF_TBL	FM effectivity configuration.  Controls how formula effectivities are created.
4	FM_FMCT_CLS	Formula control classes -NOT USED-
5	FM_FORM_CLS	Formula classes - used to group formulas.
6	FM_FORM_EFF	Formula/routing effectivities. Conditions under which a Formula/Routing can be used
7	FM_FORM_MST	Formula header table
8	FM_FORM_MST_B	Formula header base table
9	FM_FORM_MST_TL	Formula header translation table
10	FM_IBOM_DTL	Detail table for Indented Bill of Materials Report
11	FM_IBOM_HDR	Header table used for Indented Bill Of Materials report
12	FM_MATL_DTL	Formula material details - contains products,byproducts and ingredient information
13	FM_OPRN_CLS	Formula operation class.  Used to group operations.
14	FM_OPRN_DTL	Operation details.  Specifies the resources, activities and their usage.
15	FM_OPRN_MST	Operation  master
16	FM_ROUT_CLS	Routing class - used to group routings.
17	FM_ROUT_DEP	Routing step dependencies
18	FM_ROUT_DTL	Routing details
19	FM_ROUT_HDR	Routing header
20	FM_ROUT_MTL	Routing Steps to Formula Lines Association
21	FM_TEXT_HDR	Table used to store text types for Formula Model
22	FM_TEXT_TBL_TL	FM Module Text Lines. Descriptive text for all tables in this module.
23	GMD_ACTIONS_B	OPM Quality Actions
24	GMD_ACTIONS_TL	OPM Quality Translation table
25	GMD_ACTIVITIES_B	Activities base table. Defines activities which are performed in operations.
26	GMD_ACTIVITIES_TL	Activities Translation Table
27	GMD_CHANGE_DISPOSITION	Change Disposition form history table
28	GMD_CHANGE_LOTS	Change Disposition form history - Lots affected
29	GMD_COA_DETAILS	Certificate of Analysis report details information
30	GMD_COA_HEADERS	Certificate of Analysis report header information
31	GMD_COA_RSLT_TEXT	Certificate of Analysis result text
32	GMD_COA_SPEC_HDR_TEXT	Certificate of Analysis report header text information
33	GMD_COA_SPEC_TEXT	Certificate of Analysis Specification text
34	GMD_COMPOSITE_RESULT_ASSOC	OPM Quality Composite Result Association
35	GMD_COMPOSITE_RESULTS	OPM Quality Composite results
36	GMD_COMPOSITE_SPEC_DISP	OPM Quality Composite Specification Display
37	GMD_COMPOSITIONAL_REQS	LCF - Compositional Requirements Table
38	GMD_CUSTOMER_SPEC_VRS	OPM Work-in-Process Specification validity rules
39	GMD_CUSTOMER_TESTS_B	Customer Tests
40	GMD_CUSTOMER_TESTS_TL	Customer Tests Translation table
41	GMD_EVENT_SPEC_DISP	OPM Quality Event Specification Display
42	GMD_FORMULA_ANALYSIS_DTL	Formula analysis detail table
43	GMD_FORMULA_ANALYSIS_HDR	Formula Analysis Header table.
44	GMD_FORMULA_CLASS_B	Formula classes base table - used to group formulas.
45	GMD_FORMULA_CLASS_TL	Formula Class translation table
46	GMD_FORMULA_SECURITY	Formula Security table
47	GMD_FORMULA_SECURITY_PROFILES	Formula Security Profiles
48	GMD_FORMULA_SECURITY_TEMP
49	GMD_FORMULA_SUBSTITUTION	Formula Substitution table holds the valid formulas which are valid for the context item substitution
50	GMD_FORMULATION_SPECS	LCF - Formulation Specification table
51	GMD_GRADES_B	QC grade code master.
52	GMD_GRADES_TL	QC Units Translation Table
53	GMD_HOLD_REASONS_B	OPM Quality Hold reasons
54	GMD_HOLD_REASONS_TL	OPM Quality Hold Reasons
55	GMD_INVENTORY_SPEC_VRS	OPM Quality Inventory Specification Validity Rules
56	GMD_ITEM_SUBSTITUTION_DTL	Substitution Detail table holds the replacement item(s) for the original item in the Substitution Table
57	GMD_ITEM_SUBSTITUTION_HDR_B	This is master table for the Item Substitution, which holds the item substitution details
58	GMD_ITEM_SUBSTITUTION_HDR_TL	This is translate table for the Item Substitution
59	GMD_LAB_FORMULA_ASSOC	Association for lab values that get converted to formulas
60	GMD_LAB_ORGN_ASSOC	Association for lab types that get converted to orgn codes
61	GMD_LCF_CATEGORY_DTL_GTMP
62	GMD_LCF_CATEGORY_HDR_GTMP
63	GMD_LCF_DETAILS_GTMP
64	GMD_LCF_EXTERNAL_COST	Source for, external cost values
65	GMD_LCF_TECH_DATA_GTMP
66	GMD_MASS_RESULTS_GT
67	GMD_MASS_SAMPLES	Sample IDs for Mass Results Entry
68	GMD_MATERIAL_DETAILS_GTMP
69	GMD_MATERIAL_HEADER_GTMP
70	GMD_MATERIAL_REQS	LCF - Material Requirements Table
71	GMD_MIGRATE_PARMS	Quality Migration Setup Table
72	GMD_MIGRATION	Stores error messages during data migration from 11i to 11i+
73	GMD_MONITORING_SPEC_VRS	OPM Quality for Monitoring Spec Validity Rule
74	GMD_MSNR_RESULTS	GMD Mass Search and Replace table for storing query results
75	GMD_OPERATION_ACTIVITIES	Operation Activity details
76	GMD_OPERATION_CLASS_B	Operation class base table.  Used to group operations.
77	GMD_OPERATION_CLASS_TL	Translation table for Operation Class
78	GMD_OPERATION_RESOURCES	Operation Resource details
79	GMD_OPERATIONS_B	Operations base table.
80	GMD_OPERATIONS_TL	Operations translation table.
81	GMD_OPRN_PROCESS_PARAMETERS	Table associating process parameters to operation resource
82	GMD_OPTIMIZER_HDR_GTMP
83	GMD_OPTIMIZER_LINE_GTMP
84	GMD_PARAMETERS	Stores the default statuses for Organization
85	GMD_PARAMETERS_DTL	GMD parameters line table
86	GMD_PARAMETERS_HDR	used instead of profiles
87	GMD_PARSED_EXPRESSION	This table stores the parsed expression for the technical parameter
88	GMD_PROCESS_LOSS	Routing Process Loss
89	GMD_QC_ASSAY_CLASS	Quality Assay Class.  Assay classes are quality test groupings.
90	GMD_QC_SPEC_MST_GTMP
91	GMD_QC_STATUS_B	OPM Quality Status
92	GMD_QC_STATUS_NEXT	OPM Quality target Status codes
93	GMD_QC_STATUS_TL	OPM Quality Status translation
94	GMD_QC_TEST_VALUES_B	OPM Test values
95	GMD_QC_TEST_VALUES_TL	OPM Test values Translation table
96	GMD_QC_TESTS_B	OPM QC Test
97	GMD_QC_TESTS_TL	OPM QC Test
98	GMD_QUALITY_CONFIG	OPM Quality Configuration
99	GMD_RECIPE_CUSTOMERS	This table stores recipe customer data
100	GMD_RECIPE_EFF_ASSOC	Recipe-Effectivity Association Table
101	GMD_RECIPE_GENERATION	Recipe Generation for automatic creation
102	GMD_RECIPE_ORGN_ACTIVITIES	This table stores updates to operation activity details  at the recipe level.
103	GMD_RECIPE_ORGN_RESOURCES	This table stores updates to operation resources at the recipe level.
104	GMD_RECIPE_PROCESS_LOSS	Stores process loss at the recipe level.
105	GMD_RECIPE_PROCESS_PARAMETERS	Table associating process parameters to Recipe orgn resource
106	GMD_RECIPE_ROUTING_STEPS	This table stores updates to routing steps at the recipe level.
107	GMD_RECIPE_STEP_MATERIALS	This table stores step material information at the recipe level.
108	GMD_RECIPE_VALIDITY_RULES	Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities).
109	GMD_RECIPES_B	Recipe header base table.
110	GMD_RECIPES_TL	Recipe Translation Table
111	GMD_REPLACE	Used for Mass Search and Replace
112	GMD_RESULTS	OPM Quality Results
113	GMD_ROUTING_CLASS_B	Routing class base table - used to group routings.
114	GMD_ROUTING_CLASS_TL	Translation Table for routing class
115	GMD_ROUTINGS_B	Routing header base table.
116	GMD_ROUTINGS_TL	Routings header translations table
117	GMD_SAMPLE_REPLICATES_GT
118	GMD_SAMPLE_SPEC_DISP	OPM Quality Sample Specification Display
119	GMD_SAMPLES	OPM Quality Samples
120	GMD_SAMPLES_LAB	OPM Quality Samples Lab
121	GMD_SAMPLING_EVENTS	OPM Quality Sampling Event
122	GMD_SAMPLING_PLANS_B	OPM Quality Sampling Plan
123	GMD_SAMPLING_PLANS_TL	OPM Quality Sampling Plan translation table
124	GMD_SECURITY_CONTROL	Defines the level Formula Security is contorlled per OPM Organization
125	GMD_SECURITY_PROFILES	Security Profiles give access to the object specified data.  For example, a Security Profile gives access to a User for Formula data.
126	GMD_SPEC_MAPPING	Table used to map old spec definition to new definition
127	GMD_SPEC_MAPPING_GTMP
128	GMD_SPEC_RESULTS	OPM Quality Specification Results
129	GMD_SPEC_TESTS_B	OPM Specification tests
130	GMD_SPEC_TESTS_TL	OPM Specification tests
131	GMD_SPECIFICATION_ATTRIBUTES	LCF - Formulation Specification Attributes Table
132	GMD_SPECIFICATIONS_B	OPM Quality Specifications
133	GMD_SPECIFICATIONS_TL	OPM Quality Specifications Translation
134	GMD_SPREAD_ERRORS_GTMP
135	GMD_SS_MATERIAL_SOURCES	Stability Study Material Sources
136	GMD_SS_STORAGE_HISTORY	Stability Study Variant Storage History
137	GMD_SS_STORAGE_PACKAGE	Stability Study Variant Storage Package
138	GMD_SS_TIME_POINTS	Stability Study Time Points
139	GMD_SS_VARIANTS	Stability Study Variants
140	GMD_STABILITY_SPEC_VRS	Stability Study Validity Rules
141	GMD_STABILITY_STUDIES_B	Stability Study
142	GMD_STABILITY_STUDIES_TL	Stability Study Translation table
143	GMD_STATUS_B	Base table for status code definitions.
144	GMD_STATUS_NEXT	This table stores information in regards to which status codes the current status can be changed to.
145	GMD_STATUS_TL	Status Code Translation Table
146	GMD_STORAGE_PLAN_DETAILS	Stability Study Storage Plan Details
147	GMD_STORAGE_PLANS_B	Stability Study Storage Plan
148	GMD_STORAGE_PLANS_TL	Stability Study Storage Plan Translation table
149	GMD_SUPPLIER_SPEC_VRS	OPM Work-in-Process Specification validity rules
150	GMD_TECH_PARAMETERS_B	Technical parameters header base table
151	GMD_TECH_PARAMETERS_TL	Technical parameters header translation  table
152	GMD_TECHNICAL_DATA_DTL	Technical Parameter data detail
153	GMD_TECHNICAL_DATA_HDR	Technical Parameter data header
154	GMD_TECHNICAL_REQS	LCF - Technical Requirements Table
155	GMD_TECHNICAL_SEQUENCE_DTL	Technical Parameter Sort Sequence Detail Table
156	GMD_TECHNICAL_SEQUENCE_HDR	Technical Parameter Sort Sequence Table
157	GMD_TEST_CLASSES_B	OPM Quality Test Classes
158	GMD_TEST_CLASSES_TL	OPM Quality test classes translation
159	GMD_TEST_GROUP_GT
160	GMD_TEST_INTERVAL_PLAN_PERIODS	Table for test interval plan periods
161	GMD_TEST_INTERVAL_PLANS_B	Base table for test interval plans
162	GMD_TEST_INTERVAL_PLANS_TL	Translation table for test interval plans
163	GMD_TEST_METHODS_B	OPM Quality Test Methods
164	GMD_TEST_METHODS_TL	OPM Quality test methods
165	GMD_TEST_VALUES_B
166	GMD_TEST_VALUES_TL
167	GMD_TESTS_B
168	GMD_TESTS_TL
169	GMD_UNITS_B	Units of measure for QC assays.
170	GMD_UNITS_TL	QC Units Translation Table
171	GMD_UOM_CONVERSIONS	UOM Conversions Based on Quality Results.
172	GMD_VAL_RULE_GTMP
173	GMD_VPD_SECURITY	Reflects whether NPD Security is Active or Inactive
174	GMD_WIP_SPEC_VRS	OPM Work-in-Process Specification validity rules
175	LM_FORM_DAT	OBSOLETE as of 11.5.6 (OPM PF.G)
176	LM_FORM_DTL	OBSOLETE as of 11.5.6 (OPM PF.G)
177	LM_FORM_MST	OBSOLETE as of 11.5.6 (OPM PF.G)
178	LM_ITEM_DAT	Laboratory management item data
179	LM_LTYP_MST	Laboratory type master
180	LM_PRLT_ASC	Laboratory technical parameter association
181	LM_SPRD_DTL	Table to store Lab Spreadsheet detail
182	LM_SPRD_FLS	Laboratory Spreadsheets files
183	LM_SPRD_PRM	Table used to store the technical paramter definitions that belong with the spreadsheet
184	LM_SPRD_TEC	Table used to store the values of the technical parameters on the spreadsheet
185	LM_TECH_DTL	Valid values for technical parameters
186	LM_TECH_HDR	Technical parameters header
187	LM_TEXT_HDR	Holds text types defined for Lab module
188	LM_TEXT_TBL_TL	LM Module Text Lines. Descriptive text for all tables in this module.
189	QC_ACTN_MST	QC action codes.
190	QC_ASSY_TYP	QC assay master.
191	QC_ASSY_VAL	Valid QC assay values.
192	QC_GRAD_MST	QC grade code master.
193	QC_HRES_MST	QC hold reason code master.
194	QC_RSLT_MST	QC results master.
195	QC_SMPL_MST	QC sample master.
196	QC_SPEC_MST	QC specification master.
197	QC_TEXT_HDR	Holds text types defined for QC module
198	QC_TEXT_TBL_TL	QC Module Text Lines. Descriptive text for all tables in this module.
199	QC_UNIT_MST	Units of measure for QC assays.
200
201	OPM Product Development Views:
202	VIEW NAME	DESCRIPTION
203	FM_FORM_EFF_VW1	Item Effectivity View
204	FM_FORM_EFF_VW3
205	FM_FORM_EFF_VW3_OLD	Item Effectivity view
206	FM_FORM_MST_V1	Formula Numbers View
207	FM_FORM_MST_V2	Formula Version View
208	FM_FORM_MST_VL	Form Version view
209	FM_OPRN_DTL_VW1	Operation detail view
210	FM_OPRN_MST_VW1	Operation master view
211	FM_ROUT_DTL_V1	Routingstep Number View
212	FM_ROUT_HDR_V1	Routing Number View
213	FM_ROUT_HDR_V2	Routing Version View
214	FM_ROUT_MTL_VW1	Backward compatibility view so existing GME code can continue looking at the FM_ROUT_MTL table rather than at GMD_RECIPE_STEP_MATERIALS.
215	FM_TEXT_TBL_VL	Formula Management Text View
216	GMD_ACTIONS_VL	OPM Quality Actions View
217	GMD_ACTIVITIES_VL	GMD_ACTIVITIES_VL is view of GMD_ACTIVITIES_B AND GMD_ACTIVITIES_TL
218	GMD_ALL_SPEC_VRS_VL
219	GMD_COM_SPEC_VRS_VL	View of base columns of all Specification Validity Rules tables
220	GMD_CUSTOMER_TESTS_VL	OPM Quality Customer tests View
221	GMD_CUST_VEND_MST_V1	Displays customer number and  vendor number depednig on the report type selected by the user
222	GMD_CUST_VEND_MST_V2	View of customer and vendors for value set of Customer/Vendor Test Result report
223	GMD_ERES_MATERIALS_VW	View of recipe material association
224	GMD_ERES_RECIPES_VW
225	GMD_FORMULA_CLASS_VL	View for Tables GMD_FORMULA_CLASS_B and GMD_FORMULA_CLASS_TL, basically holds the Formula Class Table information and MLS related information
226	GMD_GRADES_VL	QC GRADES Translation View
227	GMD_HOLD_REASONS_VL	OPM Quality Hold reasons
228	GMD_ITEM_SUBSTITUTION_HDR_VL
229	GMD_MATERIAL_EFFECTIVITIES_VW
230	GMD_MBR_MATERIAL_V1
231	GMD_MBR_OPRN_ACTIVITIY_V1	This view is used to retrieve Operation Activities information for Master BAtch Record XML generation
232	GMD_MBR_RECIPE_HEADER_V1	This view is used to generate XML for Recipe Header information in Master Batch Record Generation
233	GMD_MBR_RECIPE_RSRC_V1	This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
234	GMD_MBR_STEP_MATERIAL_V1
235	GMD_MBR_STEP_OPRN_V1	This view is used to retrieve Step information to generate Master Batch Record XML
236	GMD_OPERATIONS_VL	Operations view
237	GMD_OPERATION_CLASS_VL	View for Operation Class Base and translation tables
238	GMD_OPRN_PROCESS_PARAMETERS_V1	View of joining the overrides from operation resource and generic resource
239	GMD_ORG_ACCESS_VW	View that can be used in place of org_access_view for performance tuning
240	GMD_QC_E_ALL_SPEC_VRS_DISP_V
241	GMD_QC_E_COMPOSITE_RESULTS_V
242	GMD_QC_E_CUST_SAMPLE_DTLS_V
243	GMD_QC_E_CUST_SMPEVT_DTLS_V
244	GMD_QC_E_RESULTS_V
245	GMD_QC_E_SAMPLES_USED_V
246	GMD_QC_E_SAMPLE_RESULTS_V
247	GMD_QC_E_SPEC_TESTS_V
248	GMD_QC_E_SUPP_SAMPLE_DTLS_V
249	GMD_QC_E_SUPP_SMPEVT_DTLS_V
250	GMD_QC_E_TEST_INSTANCE_V
251	GMD_QC_E_WIP_SAMPLE_DTLS_V
252	GMD_QC_E_WIP_SMPEVT_DTLS_V
253	GMD_QC_STATUS_VL	OPM Quality Status View
254	GMD_QC_TESTS_VL	OPM Quality Manangement Tests View
255	GMD_QC_TEST_VALUES_VL	OPM Test values view
256	GMD_QM_E_MATERIAL_SOURCES_V
257	GMD_QM_E_STABILITY_STUDIES_V
258	GMD_QM_E_TIMEPOINTS_V	OPM Quality Timepoint ERES View
259	GMD_RECIPES_VL
260	GMD_ROUTINGS_VL	View for Routing header Base and translation tables
261	GMD_ROUTING_CLASS_VL	View for Routing Class Base and translation tables
262	GMD_SAMPLING_PLANS_VL	View for Sampling plans
263	GMD_SPECIFICATIONS_VL
264	GMD_SPEC_SUMMARY	View for Summary of Specifications
265	GMD_SPEC_TESTS_VL	OPM Specification tests View
266	GMD_STABILITY_STUDIES_VL
267	GMD_STATUS_VL	Status view
268	GMD_STORAGE_PLANS_VL	Multi-Lingual View for GMD_STORAGE_PLANS
269	GMD_TECHNICAL_DATA_VL
270	GMD_TECHNICAL_SEQUENCE_VL
271	GMD_TECH_PARAMETERS_VL
272	GMD_TESTS_VL
273	GMD_TEST_CLASSES_VL	OPM Quality Test Classes
274	GMD_TEST_INTERVAL_PLANS_VL	Multi-Lingual View for GMD_TEST_INTERVAL_PLANS
275	GMD_TEST_METHODS_VL	OPM QC Test Methods
276	GMD_TEST_VALUES_VL
277	GMD_UNITS_VL	QC Units Translation View
278	LM_TEXT_TBL_VL	Laboratory Management Text View
279	QC_TEXT_TBL_VL	QC Text View
280	QC_TRAN_VW1	Lot source view.
281	QC_TRAN_VW2	Where-used view.

Un Costed Sales Order Line in R12

UNCosted Lines in Sales Order 　

　

 The number of processed rows in MTL_MATERIAL_TRANSACTIONS:
select count (*)
from MTL_MATERIAL_TRANSACTIONS
where COSTED_FLAG like NULL;
To resubmit the erred records in the MTL_MATERIAL_TRANSACTIONS table, it
must be done via a SQL statement by updating the costed_flag = ‘N’ and the
transaction_group_id = NULL.
Update MTL_MATERIAL_TRANSACTIONS
set COSTED_FLAG = ‘N’,
set TRANSACTION_GROUP_ID = NULL
where COSTED_FLAG = ‘E’ or COSTED_FLAG = ‘N’;



You can also Cross check data with this

We need a test instance to test this script

　

　1. Please run the following SQL to identify the transactions in error.

select * from mtl_material_transactions where costed_flag IN ('E','N');

2. In case the isssue is in the interface table, please run:

select

count(process_flag) total,

process_flag pflag,

substr(error_code,1,40) Code,

substr(error_explanation,1,65) Explan

from

mtl_transactions_interface

group by

process_flag, error_code, error_explanation;

3. Also check the temp table with the sql

select

count(process_flag),

process_flag,

substr(error_code,1,40) Code,

substr(error_explanation,1,65) Explan

from

mtl_material_transactions_temp

group by

process_flag, error_code, error_explanation;

unique constraint (MSC.MSC_ITEM_SOURCING_U1) violated

Run the following SQL against this table to find the bad rows:

select
mis.inventory_item_id item_id
, mis.organization_id org_id
, mis.source_organization_id src_org
, mis.assignment_id asg_id
, mis.sourcing_rule_id src_rul_id
, mis.assignment_type asg_typ
from
msc_item_sourcing_bad mis,
(select
ORGANIZATION_ID,
SR_INSTANCE_ID,
INVENTORY_ITEM_ID,
SOURCE_ORGANIZATION_ID,
SR_INSTANCE_ID2,
SUPPLIER_ID,
SUPPLIER_SITE_ID,
EFFECTIVE_DATE,
SHIP_METHOD,
CUSTOMER_ID,
CUSTOMER_SITE_ID,
ZONE_ID,
ASSIGNMENT_SET_TYPE,
RANK,
CIRCULAR_SRC,
ITEM_TYPE_VALUE,
count(*)
from msc_item_sourcing_bad
group by
ORGANIZATION_ID,
SR_INSTANCE_ID,
INVENTORY_ITEM_ID,
SOURCE_ORGANIZATION_ID,
SR_INSTANCE_ID2,
SUPPLIER_ID,
SUPPLIER_SITE_ID,
EFFECTIVE_DATE,
SHIP_METHOD,
CUSTOMER_ID,
CUSTOMER_SITE_ID,
ZONE_ID,
ASSIGNMENT_SET_TYPE,
RANK,
CIRCULAR_SRC,
ITEM_TYPE_VALUE
having count(*) > 1
order by
INVENTORY_ITEM_ID
, ORGANIZATION_ID
,SOURCE_ORGANIZATION_ID ) dup_src
where
and mis.inventory_item_id = dup_src.inventory_item_id
and mis.organization_id = dup_src.organization_id
and mis.source_organization_id = dup_src.source_organization_id;

Now using the SQL output, you can correct the bad records and resolve the issue

Oracle Process Manufacturing Process Execution User's Guide

1  Understanding Process Execution

This chapter provides the fundamentals of Oracle Process Manufacturing Process Execution. It presents the basic tasks, responsibilities, and process flow required to produce a product. You are given a basic understanding of navigation and workbenches.

2  Setting Up

The Oracle Process Manufacturing Process Execution application is seamlessly integrated to the Product Development application. Therefore, setup in Oracle Process Manufacturing Process Execution is limited to modifications that are associated to recipes and validity rules in order to produce the production batch. This topic provides the setup requirements.

3  Firm Planned Orders

This topic provides a general understanding of firm planned orders, including how to find one once it is created on the Create Batch/Firm Planned Order window. You are shown how to modify a firm planned order, how to select validity rules, and reroute it. You are also shown how to reschedule the firm planned order. This topic also discusses how to convert the firm planned order to a batch, how to display material details in the order, and how to scale the firm planned order. Creating a firm planned order is similar to creating a batch.

Refer to “Creating a Batch or Firm Planned Order” for more information on creating a firm planned order.

4  Batch Creation

This topic provides a basic understanding of batches and batch status. You are shown how to find a batch, create a batch or firm planned order, select validity rules for a batch, reroute a batch, pick a batch, and how to edit a batch. The process of finding and editing batch details is presented. You are also shown how to find individual batch steps and edit specific information in them, including batch step dependencies, and step activities. Other topics covered are the editing of batch step resources, the association of batch steps to items, and using the theoretical yield calculation. You are shown how to scale a batch or firm planned order, and how to reschedule a batch.

5  Batch Materials

Understand and use batch reservations, material move orders, and inventory transactions. Understand differences between high-level reservations and detailed-level reservations. Create detailed-level reservations. Understand material transactions. View move orders and enter pending product lots. Understand how to manage inventory shortages and to reserve a batch as a supply source for inventory reservations. Cross-integrate the Process Execution application with Mobile Supply Chain applications for Oracle Process Manufacturing.

6  Ingredient Picking Workbench

Understand how to find and pick ingredients for a batch. View the batch list summary information and identify picking materials and the ingredient summary.

7  Batch Production

This topic provides procedures for releasing and unreleasing a batch. Procedures are presented for editing batch steps in production, editing resource transactions, and recording batch operation work in process. The procedure for checking lot status when yielding product presents the business rules that are enforced when yielding batch material into an existing lot. You are given an understanding of and procedures for incremental backflushing. Discussions of activity factors and charges are provided to enhance your understanding of how these are used in the Oracle Process Manufacturing Process Execution application.

8  Batch Completion

This topic provides a basic understanding of batch completion, including how to complete a batch and revert a completed batch to work in process. You are shown how to close and reopen a batch.

9  Inquiries

This topic shows you how to run and interpret inquiries for a production schedule, work in process, material variances, batch step variances, resource variances, and resource usage.

10  Reports and Concurrent Programs

This topic explains several preformatted reports that assist you in the picking of production batch materials, ticketing of materials to use in production, evaluating scheduled batch and firm planned order production activities, assessing variances in actual and calculated batch yield, and evaluating unusual usage cost variances. The procedures for running the Item Substitution for Batches, Ingredient Picking, and Migration Recreate Open Batches concurrent programs are presented.

11  Process Execution Workbench

The Process Execution Workbench is a navigator that lets you view summary information about batches and firm planned orders by organization, batch, firm planned order, product, and status. There are two tabs located on the navigator - Batches and Firm Planned Orders. Click either tab to access the summary information that you are interested in. The batch and firm planned order summary information windows provide access to batch and firm planned order maintenance windows so that you can review or edit the data. You can also create custom views that provide a convenient method to locate and access a batch or firm planned order.

12  Production Scheduler Workbench

This topic provides a basic understanding of the Production Scheduler Workbench including the bucketed load for a selected set of plant resources, continuous resource load, and a chart of activities to assist in the rescheduling of batches and firm planned orders. The Gantt Chart lets you change plant assignments, adjust bucket sizes, and filter batches and firm planned orders based on selected criteria.

Is there any difference from Oracle Discrete Manufacturing

Here are the List of APIs for Integration in OPM (Adopted)

• Production / POC
  • Start Resource Usage
  • End Resource Usage
  • Close Batch
  • Cancel Batch
  • Release, Certify, and Close Step
  • Post Resource Transaction
  • Incremental Resource Transaction
  • Timed Resource Transaction
• Costing
  • Item Cost
  • Resource Cost
  • Allocation Definition
  • Burden Details
• Formula
  • Create Formula
  • Insert Ingredients, (By)Products
  • Create Formula Usage Rules
• Inventory
  • Create Item
  • Create Lot
  • Create Item/Lot UOM Conversion
  • Create, Adjust, or Move Inventory
  • Change Lot Status or QC Grade
• Quality
  • Assays
  • Specifications
  • Samples
  • Sample Labels
  • Results