Mass 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 MoreGL Data Extract in EBS for both Receivables and Payables
exec mo_global.set_policy_context(‘S’,:&p_org_id); SELECT DISTINCT gjb.NAME journal_batch_name, gjh.NAME, gjh.default_effective_date gldate, msi.segment1 item, NULL brand, rct.bill_to_site_use_id bill_to_site_use_id, hca.account_number customer, gcc.segment3 “GL ACCT 3”, gcc.segment1 company, rct.interface_header_attribute2 ordertype, rctt.NAME ar_transaction_type, rctl.sales_order order_number, rct.trx_number…
Read MoreOrcale EBS-Query to get active users along with their active responsibilities
LIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilities. SQL Query: Execute the…
Read MoreOracle EBS-Query to get Service Contract Details
Query to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_number as the parameter. SQL Query:…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreMove concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group
Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…
Read MoreInventory Onhand By Location Report
Introduction: This SQL query is used to fetch the data Inventory Onhand By Location Cause of the issue: Business wants a report that details Inventory Onhand By Location How do…
Read MoreBacklog Report With Freight Details
Introduction: This SQL query is used to fetching the data Backlog Orders with freight Details Cause of the issue: Business wants a report that details of Backlog Orders…
Read More