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