Blog / Category
OPM. Process Manufacturing
11 articles in this category
Procedure to create Quality Test Values alone in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Test Values alone using oracle seeded API. Cause of the issu…
Procedure to create Quality Spec & Quality Spec Values in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec & Quality Spec Values using oracle seeded API. Cause of…
OPM – Inventory Reconciliation Report
OPM – Inventory Reconciliation Report Introduction: This report will provide item wise inventory reconciliation value detail for period wise. Cause of the issue…
OPM – Intransit Value Report
OPM – Intransit Value Details Introduction: This report will provide item wise intransit value detail for period wise. Cause of the issue: Every month needs to…
OPM Query to identify DCOGS Transactions
Introduction: This blog shares the query to identify DCOGS Transactions. Cause of the Issue: This blog shares the query to identify DCOGS Transactions. This wou…
OPM – Work in Process Report
OPM – Work in Process Report Introduction: This report will provide Work in Process items detail period wise. Cause of the issue: Every month needs to be run th…
Deferred Cost of Goods Sold Report
Introduction: This report will provide deferred cost of the good sold. Cause of the issue: Every month needs to be run the lot of programs to process the transa…
Account Preprocessor Period details Query
SELECT DISTINCT glp.period_num, glp.period_name, glp.period_set_name, sts.start_date, sts.end_date, sts.closing_status, gsob.set_of_books_id, sts.set_of_books_i…
Cost Comparison Report Of OPM
select Item_code ,Item_description ,round(Cost_in_Curr_Period,2)Cost_in_Curr_Period ,round(Cost_in_Comparison_Period,2)Cost_in_Comparison_Period ,round((Cost_in…
How to get item cost for period wise.
SELECT ACCTG_COST FROM gl_item_cst gic, org_acct_periods_v oap WHERE 1 = 1 AND gic.organization_id = oap.organization_id AND gic.organization_id =:P_org_id AND…
An Overview of Oracle Process Manufacturing – A Functional Guide to Setup & Process
What is Oracle Process Manufacturing? How many modules are covering Oracle Process Manufacturing? What are the Major Functionalities in Product Development? Is…