AP-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 MoreSecurity Rules extract query
SQL 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 MoreThe Doyensys and TTK Healthcare Journey
TTK Healthcare is an established name in the Indian healthcare industry with a leading presence in consumer products, pharmaceuticals, bio-medical devices, foods and maps. TTK Healthcare and Doyensys share a…
Read MoreFull details about oracle database startup and shutdown in background
Here this blog is useful to understand what will happen while giving startup or shutdown database commands in background. Full details about oracle database startup and shutdown in background.…
Read MoreIMPDP Hangs – Wait For Unread Message On Broadcast Channel
If IMPDP hangs long time, and if checking in v$sessionwait shows it is waiting on “wait for unread message on broadcast channel”, check the alert log. You may see something…
Read More