Update the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the project and…
Read MoreAPI Script To Update Supplier Details
This blog has the script to update the supplier details using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR. Cause of the issue: Some of the fields are not visible and don’t have option to…
Read MoreOracle PLSQL to Generate XML Tag Using Standard Functionality
declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;
Read MoreOracle R12 SQL Query – Price List or Fee Schedule for Customer
select HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_headers qph,APPS.HZ_CUST_ACCOUNTS_ALL HCAA,APPS.HZ_CUST_ACCT_SITES_ALL HCASA,APPS.HZ_CUST_SITE_USES_ALL HCSUA,APPS.HZ_PARTIES HPWhere hcaa.account_number = –Customer Account Numberand HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDand HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_IDAND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_IDAND HCAA.PARTY_ID=HP.PARTY_ID
Read MoreShipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (32767); l_changedattributetabtype wsh_delivery_details_pub.changedattributetabtype; BEGIN fnd_global.APPS_INITIALIZE (0, 21676, 385); — Provide user_id, resp_id and…
Read MoreQuery to extract modifiers have been applied to a particular sales order
oracle-ebs-modifier-applied-against-so SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID, b.list_line_no “Modifier Line No”, a.description “Modifier Description”, a.comments, b.list_line_type_code, d.qualifier_context, a.orig_org_id, a.active_flag, b.start_date_active, b.end_date_active, a.list_type_code, b.modifier_level_code, b.organization_id, f.order_number, b.pricing_phase_id, b.last_update_date, b.list_line_no, d.header_quals_exist_flag, d.qualifier_datatype, d.qualifier_attribute, d.segment_id,…
Read MoreQuery to extract payment terms associated with a customer
oracle-ebs-customer-payment-terms SELECT customer_name, site_use_code, location, payment_term_id, name FROM apps.hz_cust_site_uses_all a1, hz_cust_acct_sites_all a2, ar_customers a3, ra_terms a4 WHERE a1.cust_acct_site_id = a2.cust_acct_site_id AND a2.cust_account_id = a3.customer_id …
Read MoreMass Update the Customer Matesr Price List
Introduction: We have a requirement when the new pricelist has been created that needs to be updated in the customer master account level and Bill To and Ship To level,…
Read MoreUnapply Incorrect Closed Claims
Introduction: We have a Receipt with a “Claim Investigation” where the Claim # was not populated. The below script will help to resolve that issue. w do we solve:…
Read MoreApplying Claim in AR Receipts
declare ln_trx_number VARCHAR2 (50); v_api_version NUMBER := 1.0; — V_init_msg_list VARCHAR2(1) := FND_API.G_FALSE; v_init_msg_list VARCHAR2 (1) := fnd_api.g_true; v_commit VARCHAR2 (1) := fnd_api.g_false; v_validation_level …
Read More