Alternate Options for Using LISTAGG Function
If we have a Requirement to Concatenate the list of values in to a Single Field than we can achieve it with LISTAGG Function. As Listagg Function having Size limitation…
Read MoreGST Number Updation for a Customer Record
PL/SQL Anonymous Block to update Customer GST number: As we do not have any Standard API / Process to update the GST number in Oracle, the only way to correct…
Read MoreReasons for an AP invoice not selected in a Payment Batch
AP invoice should not be selected by any other PPR The payment schedule’s relevant date should be between the PPR’s Pay From and Pay Through dates. The relevant date…
Read MoreAP-AR Netting Technical Overview
Oracle AP/AR Netting allows you to net your Payable invoice balances against your Receivables invoice balances for those Customers who are also your Suppliers. If you have a customer who…
Read MoreWhat does AP Invoice Validation process do Internally when actioned
Invoice Validate is also one another step to ensure/Validate the Invoice Data by the System user before it submits for the Payment. Invoice Validation also validates the required information that…
Read MoreUnderstanding the Customer Creation Page in TCA perspective
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 MoreCSB related table Info and related Table Status & Queries
Some 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 MorePossibilities of having Different Receipt Maturity dates in a Single batch
When 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 related programs
Automatic 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