Issue: “The server” “is asking for your user name and password”. “The server reports that it is from XDB” Got the above error while accessing the apex application page and…
Read More<?xml version=”1.0″?> <dataTemplate name=”XX__AR_INVPRINT” description=”TW Invoice Printout for United States” defaultPackage=”XX_AR_INVPRINT_PKG” version=”1.0″> <parameters> <parameter name=”P_Report_Level” dataType = “character”></parameter> …
Read MoreReturn to Vendor of Purchase Order Receipts Script: Oracle EBS R12 Return to Vendor is done in two steps: “Return to Receiving” and then “Return to Vendor”. Follow below steps…
Read MoreDECLARE ln_user_id NUMBER:=1318; ln_po_header_id NUMBER; ln_vendor_id NUMBER; lv_segment1 VARCHAR2(20); ln_org_id NUMBER; ln_line_num NUMBER; …
Read MoreCREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_pwd; CREATE OR REPLACE PACKAGE BODY get_pwd AS …
Read MoreDECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); …
Read MoreDECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; …
Read MoreDECLARE l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE; l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); l_out_category_id NUMBER; g_prem VARCHAR2(10); BEGIN …
Read MoreDECLARE g_user_id fnd_user.user_id%TYPE :=NULL; l_appl_id fnd_application.application_id%TYPE; l_resp_id …
Read MoreDECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data …
Read More