Entries by Oracle ERP Apps Guide

, , , , , ,

R12 – Assign Inventory Item to an Child Organization using API

EGO_ITEM_PUB package provides functionality for maintaining items, item revisions, etc. We can use ASSIGN_ITEM_TO_ORG procedure to assign one item to an organization.The procedure definition is: PROCEDURE Assign_Item_To_Org( p_api_version IN NUMBER ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE ,p_commit IN VARCHAR2 DEFAULT G_FALSE ,p_Inventory_Item_Id IN NUMBER DEFAULT G_MISS_NUM ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR ,p_Organization_Id IN NUMBER DEFAULT G_MISS_NUM […]

/by
, ,

FRM-92050 Failed to Connect to Server

Many Oracle ERP Users facing Problems in accessing oracle Forms. FRM-92050 Failed to Connect to Server.This can be solved by setting following steps. Navigate to Tools (Menu bar at top of Internet Explorer) > Internet Options > Security Tab. Click Internet -> Custom Level Set the Enable XSS filter to “Disable” This will disable XSS Filter […]

/by
, , , , ,

R12 – OPM Operations Creation using API

DECLARE   CURSOR c_operation IS      SELECT DISTINCT oprn_no             , oprn_desc             , process_qty_uom             , oprn_vers             , delete_mark             , effective_start_date             , operation_status          […]

/by
, , , , ,

R12 – OPM Routing Creation using API

DECLARE   CURSOR c_routing_header IS      SELECT DISTINCT ROUTING_NO,             ROUTING_VERS,             ROUTING_DESC,             EFFECTIVE_START_DATE,             ROUTING_QTY,             ROUTING_UOM,             OWNER_ID,             OWNER_ORGANIZATION_ID,          […]

/by
, , , , , ,

R12 – OPM Formula Creation using API

API Material:DECLARE   CURSOR c_master IS      SELECT *        FROM nfi_gmd_recipe       WHERE flag = ‘V’         AND routing_no IS NOT NULL;     CURSOR c_formula (      p_formula_id  number   )   IS      SELECT *        FROM FM_MATL_DTL       WHERE formula_id = p_formula_id      […]

/by