Introduction: 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 MoreSET SERVEROUTPUT ON; SET DEFINE OFF; DECLARE l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE; –l_party_obj_version NUMBER; x_profile_id NUMBER; x_return_status VARCHAR2(1); x_msg_count NUMBER; x_msg_data VARCHAR2(4000); CURSOR C1 IS SELECT ICNU.CUST_NUMBER, ICNU.CURR_NAME, ICNU.CORRECT_NAME, ICNU.STATUS, HCA.PARTY_ID,…
Read Morecustomer-bank-account This is to know how to add multiple customers which share the same bank account details. user cannot add the bank details directly, using oracle specified process in this…
Read More