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: Every month needs to be run the…
Read MoreOPM – 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 be run the lot…
Read MoreOPM 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 would help in simplifying OPM Period…
Read MoreOPM – 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 the lot…
Read MoreDeferred 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 transaction for…
Read MoreAccount 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_id sts_sob_id, plcy.legal_entity_id, glp.period_year FROM gl_periods glp, gl_period_statuses sts, gl_sets_of_books gsob, gmf_fiscal_policies plcy WHERE glp.period_set_name = gsob.period_set_name AND glp.period_type = gsob.accounted_period_type…
Read MoreCost 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_Comparison_Period-Cost_in_Curr_Period),2)Cost_Varaice ,decode(Cost_in_Comparison_Period,0,0,(round(((Cost_in_Comparison_Period-Cost_in_Curr_Period)/Cost_in_Comparison_Period),2)*100)) Cost_Varaice_prec ,ORGANIZATION_CODE ,Current_period ,Comp_period from(select msi.SEGMENT1 Item_code ,msi.DESCRIPTION Item_description ,nvl(cst.ACCTG_COST,0) Cost_in_Curr_Period ,nvl((select cst1.ACCTG_COST from gl_item_cst cst1 ,gmf_period_statuses gps1 where 1=1 and cst1.INVENTORY_ITEM_ID=cst.INVENTORY_ITEM_ID and…
Read MoreHow 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 gic.inventory_item_id = :P_item_id AND oap.rec_type = ‘ORG_PERIOD’ AND oap.period_name =:P_period_name AND…
Read MoreAn 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 Co-Product and By Product are different? Setup Step:1…
Read More