Generally after running Payment Process Request, we can get the XML data in the log file of ‘Format Payment Instructions with Text Output’ using which… Read More »XML Data of AP Check Payments – Format Payments Instructions in R12
Oracle has provided an extensible user hook “IBY_FD_EXTRACT_EXT_PUB” to add custom tags as part of seeded payment XML extract generated by Oracle Payment process. This… Read More »Customizing Oracle Payments XML extract to include Custom XML Tags
Paybles Interface Table Purpose of Table AP_INVOICES_INTERFACE AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. Invoice data comes from sources… Read More »Payables Interface Tables
Sales Orders Interface is an open interface for entering, changing or canceling orders and returns. It can be used to bring in orders from external… Read More »Oracle Sales Orders Interface/Conversion
General Ledger Interface Tables Purpose of Table GL_INTERFACE GL_INTERFACE is used to import journal entry batches through Journal Import.Base Tables: GL_JE_HEADERS GL_JE_LINES GL_INTERFACE_CONTROL GL_INTERFACE_CONTROL is… Read More »General Ledger Interface Tables
/*********************************************************************** *PURPOSE: SQL Query to Convert Comma separated String values to Rows * *AUTHOR: Shailender Thallam * ***********************************************************************/ WITH DATA AS ( SELECT ‘word1, word2,… Read More »SQL Query to Convert Comma separated String values to Rows
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