Entries by Oracle ERP Apps Guide

, ,

Oracle Application OPM Interview Questions R12

1) What are the different types of manufacturing processes? And what are the primary differences between them? OR Explain Process Manufacturing v/s Discrete manufacturing? Discrete Manufacturing is the production of distinct items that use bills of material and routings to determine costs and lead times. Eg: Car manufacturing, Computer Manufacturing etc you get all the parts […]

, , ,

R12 – How to use Business Events in Oracle Workflow

Following is a simple step by step guide to use Business Events feature of Oracle Workflow in Oracle Applications (E-Business Suite). Step 1) Navigate to the workflow administrator responsibility and choose the Business Events function. Define a Business Event.Owner name should be application name and owner tag should be the application short name. Step 2) Define a […]

, ,

Methods to Calculate Actual Cost in Oracle Apps

Following are actual cost calculation methods:1. Period Weighted Average Cost (PWAC)This is the strict average cost of the raw material during the period, based on the total estimated receipt (or invoiced) price for the entire inventory quantity. The period weighted average cost is a strict average cost for the period based on Period Total Quantity […]

, , , , , , ,

Re-Compile Invalid Schema Objects in Oracle Database

Operations such as upgrades, patches and DDL changes can invalidate schema objects. Provided these changes don’t cause compilation failures the objects will be revalidated by on-demand automatic recompilation, but this can take an unacceptable time to complete, especially where complex dependencies are present. For this reason it makes sense to recompile invalid objects in advance […]

, , , ,

Opm Accounting Preprocessor debugging scripts in R12

Orgn: &&organization_id ==================SELECT * FROM mtl_parameters WHERE organization_id = &&organization_id;Item details FOR Item: &&inv_item_id =========================SELECT *FROM mtl_system_items_kfvWHERE organization_id =  &&organization_idAND inventory_item_id =  &&inv_item_id;Cost Type details FOR Cost Type: &&cost_type=================================SELECT * FROM cm_mthd_mst WHERE cost_mthd_code = ‘&&cost_type’;Period Balances FOR Item: &&inv_item_id Orgn: &&organization_id ==============================================SELECT pbal.inventory_item_id AS item_id,  pbal.primary_quantity       AS quantity,  pbal.organization_id        AS mtl_organization_id,  […]