Yearly Archives: 2021

Query to find the special characters in a Payment batch

Query to find the special characters in a Payment Batch   If we have encountered any special characters in Invoice Description or at the supplier bank account level, our payment…

Read More

ORA 02049: Distributed Transaction Timeout waiting for lock

ORA 02049: Distributed Transaction Timeout waiting for lock This error occurs when a session is trying to modify a table’s row in a remote database through a database link that…

Read More

Expense report ORPHAN Record deletion with Script

Expense report ORPHAN Record deletion with Script   Sometimes, we can see that the expense report can have some orphan events and this is system bug which will happen very…

Read More

Upgrading a CDB & PDB from 12c to19c using Manual Upgrade

In this article we are going to see how to upgrade a oracle 12c container database from 12c to 19c using manual upgrade method. Here we are going to proceed…

Read More

Synchronizing the Expense Report Status

Synchronizing the Expense Report Status Normally when any employee submits the expense report, it will go to the supervisor for approval and after the approval it will go for audit…

Read More

Automate configuration with the Data loader

Automate configuration with the Data loader   Sometimes, data may be huge and need to push the data to the oracle applications. Either it may be transactional data and master…

Read More

Accounts Payables Trial Balance Mismatch

Accounts Payables Trial Balance Mismatch Normally we will do the reconciliation between AP to GL to make sure our liability account/control account is matching in both Payables and General Ledger.…

Read More

Active Suppliers with Payment terms and Payment Methods in EBS R12

Active Suppliers with Payment terms and Payment Methods in EBS R12   Business team or the vendor team will look for the active vendors which are associated with the payment…

Read More

Automate your payments from Oracle to Financial Institution

Automate your payments from Oracle to Financial Institution The overall purpose of the blog is to import payments information from Payables module to Bank of America web bank interface. There…

Read More

ORACLE GOLDEN GATE ERROR OGG-00868

In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…

Read More