The blog provides the Oracle Payables Standard Programs provided in Oracle Account Payables R12. The Oracle Payables Standard Program helps in processing the Payables Invoices and get accounted into General Ledger for specified accounting period
Oracle Payables R12 Standard Programs
The below given are the Oracle Payable programs
| Oracle Payables R12 Standard Programs | Payables Program Description |
| AutoRate Program | The AutoRate Program enters the Exchange Rate Value based on matched invoice or payment currency, rate date, and rate type for the Invoices with No Exchange Rate defined. The AutoRate Program retrieves Exchange Rate, rate date, and rate type from the GL Daily Rates Table. |
| Create Procurement Card Issuer Invoice Program | The program creates invoices for the procurement card issuers in the Payables Open Interface tables and selects records for the given date range in AP_EXPENSE_FEED_DISTS and should have Validated Status. Submit Procurement Card Transactions Validation before running procurement card issuers program |
| Employee Update Program | The program updates employee type supplier records if the corresponding employee record has been changed |
| Expense Report Export Program | The program create Payables invoices from expense reports in Oracle Payables or Oracle Internet Expenses. Expense Report Export verifies all your expense report information to ensure it creates valid, fully-distributed invoices that are ready for validation. |
| Invoice Validation Program | The Invoice Validation program Verifies the matching tax, period status, exchange rate, and invoice distribution and automatically applies holds to exception invoices. If an invoice has a hold, manually release the hold or correct the error and then resubmit Invoice Validation |
| Mass Additions Create Program | The Mass Additions Create program transfers the capital invoice line distributions from Oracle Payables to Oracle Assets. The mass addition line appears in Oracle Assets with the ledger currency amount and thus Oracle Payables R12 sends the invoice distribution amount in the converted ledger currency for Foreign Currency Assets |
| Payables Open Interface Import Program | The Payables Open Interface Import program creates the Oracle Payables R12 invoices from invoice data in the Payables Open Interface tables received from the source as Quick Invoices , Supplier Invoices, Supplier Invoices transferred from Oracle XML Gateway, Third Party Invoices loaded using SQL Loader , Credit Card transactions , Lease Invoices from Oracle Property Manager, Lease Payments from Oracle Assets |
| Procurement Card Transaction Validation Report | Procurement Card Transactions Validation program validates the procurement card transactions received from the card issuer and identifies exceptions such as undefined card numbers, invalid transaction or posted currency codes, and invalid card codes |
| Payables Open Interface Purge Program | The Payables Open Interface Purge Program purges records from the Payables Open Interface tables (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE)which are successfully imported |
| Purging Records | The Purging records program helps to purge the transactions from Oracle Payables, Oracle Purchasing, and Oracle Supplier Scheduling records including invoices, purchase orders, suppliers, invoice payments, supplier schedules and purchase receipts which are no longer required |
| Supplier Merge Program | The Supplier Merge Program helps to merge duplicate suppliers into a single, consolidated supplier and merge transactions within the same supplier from one supplier site to a different supplier site. The program allows to merge all transactions for a supplier into a new supplier, or can merge unpaid invoices. The Supplier merge process cannot be Reverted. |
| Unaccounted Transactions Sweep Program | The Unaccounted Transactions Sweep Program transfers unaccounted transactions from one accounting period to another by changing the accounting date for all transactions to specified Open Period |
| Unapply Preupgrade Prepayments Program | The program helps to unapply the prepayment from the invoices |
| Update Income Tax Details Utility and Report | The program updates the Income Tax Type and/or Income Tax Region fields on invoice distributions required for invoice distributions of United States Federally Reportable suppliers because the fields are necessary for 1099 reporting |
| Update Matured Future Payment Status Program | The Payables program updates the status of matured bills payable from Issued to Negotiable. If the payment’s Maturity Date is on or before the Maturity Date parameter, then system updates the payment’s status and creates the journal entries to record the status change of the payment |