Historically, the customer data model was owned by Oracle Receivables (AR). However, as the data model changed and more complex relationships and attributes had to be tracked and monitored, the…
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 MoreSQL is used to extract the security rules that are defined in the system. The parameter is Accounting Flex Structure SELECT ffvr.flex_value_rule_name, ffvr.description, ffvr.error_message, DECODE( ffvrl.include_exclude_indicator, ‘I’, ‘Include’, ‘E’, ‘Exclude’,…
Read MoreIntroduction A flexfield is a customizable flexible data field that you can customize according to business needs without coding. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is…
Read MoreThe prepayment matching program is the child program of the Autoinvoice import program and it is expected to trigger immediately after the Autoinvoice import is completed as per the intended…
Read MoreThe below is the query which will provide the supplier bank details: SELECT vendor_name supplier_name, segment1 supplier_number, ass.vendor_site_code site_code, ieba.bank_account_name, ieba.bank_account_num, ieba.masked_bank_account_num, (select user_name from apps.fnd_user where user_id=ieba.last_updated_by) updated_by, to_char(ieba.last_update_date,’dd-Mon-yy…
Read MoreVarious Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…
Read Morecreate or replace PROCEDURE xx_open_period ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, errmsg OUT VARCHAR2, p_from_org_id IN NUMBER, p_to_org_id IN NUMBER ) IS l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_org_id…
Read More