AP Invoices Tables Information
The below diagram illustrates the AP Invoices table information. We can see the flow of how AP Invoices load into Oracle and all the way to GL batch post.
Custom Check Printing in Oracle Apps R12
We will discuss about Custom check printing in Oracle Apps. Sometimes AP team in the organization has to send the checks to the Suppliers/Employees(Internal Employee Expenses), so we need a one check format according to the Bank guidelines. Oracle provides couple of predefined check formats in the system but most of the times we have to add our custom formats. Here we will cover below Topics 1. Download Standard Check Format 2. Add your company logo and address 3. Add…
Delete Expense Report From Interface Tables
In this article, we will talk about how to delete the Oracle expenses. The workflow(Expenses – APEXP) will delete the Rejected Expenses from the system after certain days. Manually delete the expenses from Oracle using API. Auto Delete/System Delete: If the user submits expense and approver rejected that expense. User/submitter will get notified to once the expense got rejected and expense will sit in users queue for 31 days. If the user doesn’t respond to an expense within 31 days,…
Bank Reconcile Process in Oracle Apps R12
Bank Re-conciliation with BAI2 file format: – Oracle EBS provides a flexibility to load the bank reconcile statements to oracle cash management (CE) tables. After successful load we can reconcile the bank provided transaction details with our Oracle Payables or Oracle Receivables or Oracle General Ledger. If want to reconcile transactions against a bank statement, we need to enter the bank statement information into Oracle Cash Management by running the below program in CE application: Bank Statement Loader program Transactions…
Bank Setups in Oracle Apps R12
