Entries by Oracle ERP Apps Guide

, ,

Setting Org Context in Oracle Apps

Setting the Multi Org Context : METHOD 1: begin    MO_GLOBAL.SET_POLICY_CONTEXT(ACCESS_MODE,ORG_ID);end; Example: begin    MO_GLOBAL.SET_POLICY_CONTEXT(‘S’,101);end; S – Denotes that the current session will work for Single Org_id (101) M – Denotes that the current session will work for Multiple Org_id   METHOD 2: beginmo_global.init (<APPLICATION SHORT NAME>);end; Example : beginmo_global.init (‘AR’);end; Query : select Application_short_name , application_namefrom   […]

/by
, ,

API – AR Invoice (Transaction) Creation

CREATE OR REPLACE procedure APPS.xx_ar_invoice_apiis l_return_status varchar2(1); l_msg_count number; l_msg_data varchar2(2000); l_batch_source_rec ar_invoice_api_pub.batch_source_rec_type; l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type; l_cust_trx_id number;BEGIN begin MO_GLOBAL.SET_POLICY_CONTEXT(‘S’,82); end; fnd_global.apps_initialize(1090,20678,222); l_batch_source_rec.batch_source_id := 1001; l_trx_header_tbl(1).trx_header_id := 9898; l_trx_header_tbl(1).trx_date := sysdate; l_trx_header_tbl(1).trx_currency := ‘AED’; l_trx_header_tbl(1).cust_trx_type_id := 1000; l_trx_header_tbl(1).bill_to_customer_id := 1139; l_trx_header_tbl(1).term_id := 1000; l_trx_header_tbl(1).finance_charges := ‘N’; l_trx_header_tbl(1).status_trx := ‘OP’; l_trx_header_tbl(1).printing_option […]

/by
, ,

API – Stock Locator Creation

INVENTORY MANAGER > SETUP > ORGANIZATIONS > STOCK LOCATORSCREATE TABLE XX_STOCK_LOCATOR_STAGING (LOCATOR_CONCAT_SEGMENTS VARCHAR2(2000))———————————————————————————–create or replace procedure XX_CREATE_STOCK_LOCATORSisl_msg_data VARCHAR2(100);l_msg_count NUMBER;l_return_status VARCHAR2(1);l_locator_id NUMBER;l_locator_exists VARCHAR2(1);l_org_id NUMBER := 1350; /*Organization_id */l_organization_code VARCHAR2(10) := ‘201’; /*Organization_Code */l_sub_code VARCHAR2(10) ; /*Variable for Subinventory*/l_concatenated_segments VARCHAR2(100); /*Variable for Locator Segment*/–l_user_id NUMBER := 1262; /* User ID From FND_users Table */–l_resp_id NUMBER := 20634; […]

/by
, ,

Custom.pll in Oracle Application

Custom Library (custom.pll) allows to extend/customize Oracle Applications form(Oracle Form) without changing or modifying Oracle Applications code. Examples may include enforcing a new business rule, opening a form using zoom etc. Most of the things that we can do using custom.pll, we can achieve that using Forms Personalization. Since Custom.pll takes the full advantage of […]

/by