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

Oracle Apps production support queries while period closure

Oracle apps people working in production support projects usually get into trouble at the time of Inventory period closure and financials period closure. They need to track the issues which hold up the period (Inv / AR / AP) closure. Here are some of the most frequently use queries

• Oracle Apps Inventory period closure monitoring scripts
• Oracle Apps Financials period closure monitoring scripts