Enable/Disable IR Download button based on User Role
By default IR region allows to either enable Download button to all users or disable Download button to all users. Suppose if there is a requirement to enable/disable download button…
Read MoreCascading Select list in IR Oracle APEX
By default the Interactive Reporting Region allows end users to customize reports. This interactive reporting region allows users to customize the layout of the data by choosing the columns they…
Read MoreSQL query to get oracle form personalization details
Overview: Below query give the form personalization details. Query: SELECT DISTINCT a.ID, a.SEQUENCE, a.function_name, a.form_name, a.enabled, c.user_form_name, d.application_name, a.description, a.trigger_event, a.trigger_object, a.condition, ca.* FROM fnd_form_custom_rules a, fnd_form b, fnd_form_tl…
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 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