Oracle has provided an API IEX_DISPUTE_PUB.CREATE_DISPUTE which is part of Advanced Collections to create a dispute on an Invoice Transaction. Below is the sample API… Read More »PL/SQL API to Create Dispute on an Invoice Transaction
Here is the query to list Active Customers and their Sites Information /********************************************************** *PURPOSE: To list customers and their sites information * *AUTHOR: Shailender Thallam… Read More »Query to list Active Customers and their Sites Information
Here is the query to find link of Sales Orders with their corresponding Invoices /************************************************************************** *PURPOSE: To find link of Sales Orders with their corresponding… Read More »Join condition between RA_CUSTOMER_TRX_ALL and OE_ORDER_HEADERS_ALL/LINES_ALL
To create Customer Contacts we need to use a series of APIs in a sequential manner, in this post I will explain you how to… Read More »API to Create Customer Contacts
We can use standard API HZ_LOCATION_V2PUB.UPDATE_LOCATION to update the existing customer address stored in the HZ_LOCATIONS table. /******************************************************************************** *PURPOSE: To Customer Locations information from back-end… Read More »Script to Update Customer Locations – HZ_LOCATION_V2PUB.UPDATE_LOCATION
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find Customer, Customer Account and Customer Sites Information
Here is a query to extract complete AR Invoice information Note: Set org context before running this query — EXECUTE mo_global.set_policy_context(’S’,81); —- execute mo_global.set_policy_context(‘S’,81); –… Read More »SQL Query to extract complete AR Invoice Information
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find out Duplicate Customer Contacts