Introduction: This script will used to extract the AR accounted receipts details. select ‘HEADERS’ “FILE_IDENTIFIER” ,DECODE(ou.name,’IM US BU’,’IM US OU’,’IM CA BU’,’IM Canada OU’,ou.name) “BU_NAME”, cr.RECEIPT_NUMBER “Receipt Numder”, cr.type,crh_current.status “Current…
Read MoreIntroduction: This procedure is used to extract the adjustments from EBS for Cloud Import. create or replace PROCEDURE XXXX_AR_ADJ_EXTRACT_CLOUD ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id IN NUMBER, p_trx_date_from…
Read MoreIntroduction: This is used to fix the invalid revenue account for AR invoice Auto accounting is used to determine the accounts when the distribution table is not populated. When Auto…
Read More/******************************************************************************** *PURPOSE: To Customer Locations information from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON; DECLARE — –Cursor to fetch location details — cursor cur_loc IS select hps.location_id…
Read Morecreate or replace procedure xx_Thirdpart_reg_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SITE_USE_ID NUMBER; LV_GST_NUM VARCHAR2 (20); begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE…
Read Morecreate or replace procedure xx_shipto_site_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SHIP_SITE_USE_ID NUMBER; begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE ARC.CUSTOMER_NAME = P_CUSTOMER;…
Read Morecreate or replace procedure xx_billto_site_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SITE_USE_ID NUMBER; begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE ARC.CUSTOMER_NAME = P_CUSTOMER;…
Read MoreSome of the Important Tables related to CSB: iby_trxn_summaries_all – Holds the information related the CSB current batch ( DEBIT_AUTHORIZATION_ID, MBATCHID (Holds CSB Msgid)). iby_debit_authorizations – Holds the information related to…
Read MoreWhen the Automatic Receipt master program is planned to execute on “28-FEB-20” and when there are a couple of invoices that were created with Due date as “24-FEB-20” and “29-FEB-20”…
Read MoreAutomatic Receipts and Direct Debit feature: Instead of manually entering receipts, you can use the Receivables automatic receipts feature to automatically generate receipts for customers with whom you have predefined…
Read More