AutoInvoice Program Overview in Oracle Applications – Receivables

AutoInvoice Overview

AutoInvoice is a powerful, flexible tool you can use to import and validate transaction data from other financial systems and create invoices, debit memos, credit memos, and on-account credits in Oracle Public Sector Receivables. You use a custom feeder program to transfers transaction data from an external system into the AutoInvoice interface tables. AutoInvoice then selects data from the interface tables and creates transaction in Receivables. Receivables rejects transactions with invalid information to ensure the integrity of your data.

Period Closure Activities For Oracle Apps Implementation

The following is a note on the period closure process entailing the checking of transactional data, running of transfers of transactional data to the General ledger, reviewing/reconciling of reports and closure of periods in Oracle’s modules. These activities can be taken up roughly in the sequence in which they have been detailed below. Several of these activities (like GL transfers, reconciliations) can be performed concurrently prior to the closure of periods. However, the specific activity of closing of periods in respective/relevant modules should take the following order:

Refer the blog post for: 
Oracle Apps Financials period closure monitoring scripts

Closing the AP Month - How it works and what to do

Oracle Apps Period End Process Steps

A summary of the period-end procedures for each of the application modules is detailed below. The steps should be followed in the order in which it is showed:

Oracle Apps Financials period closure monitoring scripts

Accounts Payable:

To find whether any orphan entry exist (this prevents period close)

Select *

from apps.ap_ae_lines_all

Where ae_header_id in(

Select ae_header_id