'Error_code as 'Transaction processor error and Error Explanation as 'Negative balances not allowed'

'Pending Transactions' 

Transaction Pending in the  MTL_MATERIAL_TRANSACTIONS_TEMP Table, if you are unable to clear please you this Data Fix Suggested by Oracle .

Error_code as 'Transaction
processor error and Error Explanation as 'Negative balances not allowed'

check MTL_MATERIAL_TRANSACTIONS_TEMP table
the values

•  process_flag,
•  lock_flag,
•  transaction_mode 

Then Use this Update Script :

 Update MTL_MATERIAL_TRANSACTIONS_TEMP
Set PROCESS_FLAG = 'Y',
LOCK_FLAG = 'N',
TRANSACTION_MODE = 3,
ERROR_CODE = NULL
Where TRANSACTION_HEADER_ID = '& TRANSACTION_HEADER_ID';

Oracle Period End Processing/Closing, Preliminary/Final Close

Oracle Period End Processing/Closing, Preliminary/Final Close  11i and R12

Introduction

Period End Processing - Summary

1. A summary of the period-end procedures for each of the Financials applications
2. An indication of the order in which the steps should be undertaken.

Modules :

Payables

1. Complete All Transactions for the Period Being Closed
2. Run the Payables AutoApproval Process for All Invoices / Invoice Batches
3. Review & Resolve Amounts to Post to the General Ledger
4. Reconcile Payments to Bank Statement Activity for the Period
5. Transfer All Approved Invoices Payments, Reconciled Payments to the General Ledger
6. Review the Payables to General Ledger Posting Process After Completion
7. Submit the Unaccounted Transactions Sweep Program
8. Close the Current Oracle Payables Period
9. Accrue Uninvoiced Receipts
10. Reconcile Oracle Payables Activity for the Period
11. Run Mass Additions Transfer to Oracle Assets
12. Open the Next Payables Period
13. Run Reports for Tax Reporting Purposes (Optional)
14. Run the Key Indicators Report (Optional)
15. Purge Transactions (Optional)

Purchasing

1. Complete All Transactions for the Period Being Closed
2. Review the Current and Future Commitments (Optional)
3. Review the Outstanding and Overdue Purchase Orders (Optional)
4. Follow up Receipts-Check with Suppliers
5. Identify and Review Un-invoiced Receipts (Period End Accruals)
6. Follow Up Outstanding Invoices
7. Complete the Oracle Payables- Period End Process
8. Run Receipt Accruals - Period End Process
9. Reconcile Accounts - Perpetual Accruals
10. Perform Year End Encumbrance Processing. (Optional)
11. Close the Current Purchasing Period.
12. Open the Next Purchasing Period.
13. Run Standard Period End Reports (Optional)

Inventory/WIP

1. Complete All Transactions for the Period Being Closed.
2. Check Inventory and Work In Process Transaction Interfaces.
3. Check Oracle Order Management Transaction Process.
4. Review Inventory Transactions.
5. Balance the Perpetual Inventory.
6. Validate Work In Process Inventory.
7. Transfer Summary or Detail Transactions
Close the Current Oracle Payables and Oracle Purchasing Periods 8.
9. Close the Current Inventory Period
10. Open the Next Inventory Period
11. Run Standard Period End Reports (Optional)

Order Management

1. Complete All Transactions for the Period Being Closed
2. Ensure all Interfaces are Completed for the Period (Optional)
3. Review Open Orders and Check the Workflow Status
4. Review Held Orders
5. Review Discounts
6. Review Backorders
7. Review and Correct Order Exceptions
8. Reconcile to Inventory
9. Reconcile to Receivables (Optional)
10. Run Standard Period End Reports

Receivables

1. Complete All Transactions for the Period Being Closed
2. Reconcile Transaction Activity for the Period
3. Reconcile Outstanding Customer Balances
4. Review the Unapplied Receipts Register
5. Reconcile receipts.
6. Reconcile Receipts to Bank Statement Activity for the Period
7. Post to the General Ledger
8. Reconcile the General Ledger Transfer Process
9. Reconcile the Journal Import Process
10. Print Invoices
11. Print Statements (Optional)
12. Print Dunning (Reminder) Letters (Optional)
13. Close the Current Oracle Receivables Period
14. Reconcile Posted Journal Entries
15. Review Unposted Items Report
16. Open the Next Oracle Receivables Period
17. Run Reports for Tax Reporting Purposes (Optional)
18. Run Archive and Purge programs (Optional)

Assets

1. Complete All Transactions for the Period Being Closed
2. Assign All Assets to Distribution Lines
3. Run Calculate Gains and Losses (Optional)
4. Run Depreciation
5. Create Journal Entries
6. Rollback Depreciation and/or Rollback Journal Entries (Optional)
7. Create Deferred Depreciation Journal Entries (Optional)
8. Depreciation Projections(Optional)
9. Review and Post Journal Entries
10. Reconcile Oracle Assets to Oracle General Ledger Using Reports.
11. Run Responsibility Reports (Optional)
12. Archive and Purge Transactions (Optional)

Projects

1. Change the Current Oracle Projects Period Status from Open to Pending Close
2. Open the Next Oracle Projects Period
3. Complete All Maintenance Activities
4. Run Maintenance Processes
5. Complete All Transaction Entry for the Period Being Closed
6. Run the Final Cost Distribution Processes
7. Interface Transactions to Other Applications (AP, GL, FA)
8. Generate Draft Revenue for All Projects
9. Generate Invoices
10. Run Final Project Costing and Revenue Management Reports
11. Transfer Invoices to Oracle Receivables
12. Interface Revenue to General ledger (Project Billing Only)
13. Run Period Close Exception and Tieback Reports
14. Change the Current Period Oracle Projects Status from Pending Close to Closed
15. Advance the PA Reporting Period (Optional)
16. Update Project Summary Amounts
17. Restore Access to User Maintenance Activities
18. Permanently Close the Oracle Projects Period (Optional)
19. Reconcile Cost Distribution Lines with General Ledger (Optional)

Cash Management

1. Load Bank Statements
2. Reconcile Bank Statements
3. Create Miscellaneous Transactions
4. Review Auto Reconciliation Execution Report
5. Resolve Exceptions on the Auto Receonciliation Execution Report
6. Run Bank Statement Detail Report
7. Run Transactions Available for Reconciliation Report
8. Resolve Un-reconciled Statement Lines
9. Run the GL Reconciliation Report
10. Run the Account Analysis Report for the General Ledger Cash Account
11. Review the Account Analysis Report
12. Correct any Invalid Entries to the General Ledger Cash Account (Optional)
13. Perform the Bank Reconciliation

General Ledger

1. Ensure the Next Accounting Period Status is Set to Future Entry
2. Complete Oracle Sub-ledger Interfaces to Oracle General Ledger
3. Upload Journals from ADI (Applications Desktop Integrator) to Oracle General Ledger
4. Complete Non-Oracle Sub-ledger Interfaces to Oracle General Ledger (Optional)
5. Generate Reversal Journals (Optional)
6. Generate Recurring Journals (Optional)
7. Generate Mass Allocation Journals (Optional)
8. Review and Verify Journal Details of Unposted Journal Entries
9. Post All Journal Batches
10. Run General Ledger Trial Balances and Preliminary Financial Statement Generator Reports (FSGs)
11. Revalue Balances (Optional)
12. Translate Balances (Optional)
13. Consolidate Sets of Books (Optional)
14. Review and Correct Balances (Perform Reconciliations)
15. Enter Adjustments and / or Accruals and Post
16. Perform Final Adjustments
17. Close the Current Oracle Gneral Ledger Period
18. Open the Next Oracle General Ledger Period
19. Run Financial Reports for the Closed Period
20. Run Reports for Tax Reporting Purposes (Optional)
21. Perform Encumbrance Year End Procedures (Optional)

OPM Inventory Tables R12

BISOPM_ONHANDSALE_SUM

BIS_OPM_PROD_SUM

GMI_AUTO_ALLOCATION_BATCH

GMI_CATEGORY_SETS

GMI_CLOS_WAREHOUSES

GMI_DISCRETE_TRANSFERS

GMI_DISCRETE_TRANSFER_LINES

GMI_DISCRETE_TRANSFER_LOTS

GMI_ITEMS_XML_INTERFACE

GMI_ITEM_CATEGORIES

GMI_ITEM_CONV_AUDIT

GMI_ITEM_CONV_AUDIT_DETAILS

GMI_ITEM_ORGANIZATIONS

GMI_LOTS_CONV_XML_INTERFACE

GMI_LOTS_XML_INTERFACE

GMI_LOT_TRACE

GMI_MASSTRANS_CTL

GMI_MIGRATION_PARAMETERS

GMI_OBSOLETE_ITEM_COLUMNS

GMI_QUANTITY_XML_INTERFACE

GMI_SUBLOT_GENERATE

GMI_TRAN_TMP

IC_ADJS_JNL

IC_ALLC_CLS

IC_ALOT_PRM

IC_CLDR_DTL

IC_CLDR_HDR

IC_CLDR_HDR_B

IC_CLDR_HDR_TL

IC_COMD_CDS

IC_COST_CLS

IC_CRUL_CLS

IC_CTMS_CLS

IC_CYCL_ADT

IC_CYCL_DTL

IC_CYCL_ERR

IC_CYCL_HDR

IC_CYCL_MSC

IC_DECM_MST

IC_FRGT_CLS

IC_GLED_CLS

IC_INVN_CLS

IC_INVN_TYP

IC_ITEM_CDT

IC_ITEM_CNV

IC_ITEM_CPG

IC_ITEM_HIERARCHY

IC_ITEM_MST

IC_ITEM_MST_B

IC_ITEM_MST_B_MIG

IC_ITEM_MST_TL

IC_ITEM_WHS

IC_JRNL_MST

IC_LOCT_INV

IC_LOCT_MST

IC_LOTS_CPG

IC_LOTS_MST

IC_LOTS_MST_MIG

IC_LOTS_STS

IC_PERD_BAL

IC_PHYS_CNT

IC_PHYS_ERR

IC_PKGS_MST

IC_PLNT_INV

IC_PRCE_CLS

IC_PRCH_CLS

IC_PURG_PRM

IC_RANK_MST

IC_SALE_CLS

IC_SHIP_CLS

IC_STAT_RPT

IC_STOR_CLS

IC_SUMM_INV

IC_TAXN_ASC

IC_TAXN_CLS

IC_TEXT_HDR

IC_TEXT_TBL_TL

IC_TRAN_ARC

IC_TRAN_CMP

IC_TRAN_PND

IC_TXN_REQUEST_HEADERS

IC_TXN_REQUEST_LINES

IC_WHSE_INV

IC_WHSE_MST

IC_WHSE_REL

IC_WHSE_STS

IC_XFER_MST

IN_ADDR_MST

IN_CTRY_MST

IN_ITEM_MST

IN_REGN_MST

IN_STAT_CTL

IN_STAT_DTL

IN_STAT_HDR

IN_STAT_MSG

IN_TEXT_HDR

IN_TEXT_TBL_TL

IN_TOFD_MST

SY_WF_ITEM_ROLES

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.