EBS Technical

Fusion – Create Supplier, Supplier Site, Supplier Contact Payload – Webservice

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <sup:Supplier>SV supplier01 Corporation</sup:Supplier> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:AlternateName>SV supplier 01</sup:AlternateName> <sup:SupplierBusinessClassifications> <sup:Operation>CREATE</sup:Operation> <sup:BusinessClassification>WOMAN_OWNED</sup:BusinessClassification> <sup:CertifyingAgency>Association for Women Owned Business</sup:CertifyingAgency> <sup:CertificateNumber>AS105</sup:CertificateNumber>…

Read More

Fusion – Sample Payload To Update Descriptive Flexfield On Internet Supplier Portal Invoice

Sample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/” xmlns:erp=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/”> <soapenv:Header/> <soapenv:Body> <typ:updateDffEntityDetails> <typ:operationMode>single</typ:operationMode> <typ:object> <erp:EntityName>Payables Invoice</erp:EntityName> <erp:ContextValue>JLxMXPayablesInformation</erp:ContextValue> <erp:UserKeyA>DFF-1</erp:UserKeyA> <erp:UserKeyB>Vision Operations sample</erp:UserKeyB> <erp:UserKeyC>XXHealth Care</erp:UserKeyC> <erp:UserKeyD>12136</erp:UserKeyD>…

Read More

EBS – API to Create Bank Branch Account creation in single procedure

CREATE OR REPLACE PROCEDURE INSERT_SINGLE_BANKS IS x_response_rec apps.iby_fndcpt_common_pub.result_rec_type; l_init_msg_list VARCHAR2 (2000); o_bank_id NUMBER; x_return_status VARCHAR2 (3000); l_msg_count NUMBER; l_msg_data VARCHAR2 (3000); l_msg_dummy VARCHAR2 (3000); l_output VARCHAR2 (3000); l_extbank_rec apps.iby_ext_bankacct_pub.extbank_rec_type; l_ext_bank_branch_rec…

Read More

Query to Fetch the price adjustment not populated in order lines for the Customer have the Accrual in Trade Management

Introduction: This script will help to extract the price adjustment not populated in order lines for the Customer have the Accrual in Trade Management Script: 1. Modifiers Exist For Customer,…

Read More

Sales Order Release Hold

create or replace PACKAGE xdmc_release_hold_pkg AUTHID CURRENT_USER AS PROCEDURE call_fnd_global ( p_user_id NUMBER, p_resp_id NUMBER, p_resp_appl_id NUMBER ); PROCEDURE xdmc_release_hold ( errbuf OUT VARCHAR2, retcode OUT NUMBER, p_order_number IN NUMBER…

Read More

API to create Miscellaneous Receipt in Inventory.

Objective. The objective of the below API is used to increase the onhand quantity in Inventory through Miscellaneous Receipt. Sample Code. set serveroutput on declare l_api_version NUMBER := 1.0; l_init_msg_list…

Read More

Open Account Balances Data Manager (XLATBDMG) / Accounts Payable Trial Balance (APTBRPT) Performance Issue in R12

The “Accounts Payable Trial Balance” / “Open Account Balances Data Manager” report having severe performance issues. The rebuild it self taken more than 4 hours. Also there was too much…

Read More

Update the Scheduled Ship Date in Order lines Using API

Introduction: This Post illustrates the steps to Update the schedule ship date in Order Lines using API. Script to Update the Scheduled Ship Date in Order Lines DECLARE p_scheduled_ship_date DATE…

Read More

How to check the record history updates on Vendor Master Data

Using the below query we can track the DML operations made on Supplier’s.It is useful script for Auditing and Tracking purposes.   select DISTINCT a.segment1 vendor_number,A.VENDOR_NAME,c.name org_name,a.creation_date supplier_creation_date, (select user_name…

Read More

Query to get price list details for an item

Introduction This blog explains how to get pricelist details for an item #Code# SELECT QLH_TL.NAME “List Price” ,QLH_TL.DESCRIPTION “Description” ,QLH_TL.VERSION_NO “Version” ,QLH_B.LIST_TYPE_CODE “List Type” ,QLH_B.CURRENCY_CODE “Curr Code” ,MSI.SEGMENT1 “Item Number”…

Read More