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 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