Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Active Invoice in Oracle Fusion with inactive Code combinations

edited Aug 28, 2024 2:21PM in Reporting and Analytics for ERP 1 comment

Summary:3-37815901131 : Reports for Inactive GL Code Combinations

Problem Summary: Assistance Needed with Invoice Approval Status

I am seeking assistance in identifying specific invoices within our system. The requirements are as follows:

  1. Identify Active Invoices: I need a list of invoices that are currently active but have not yet been approved.
  2. Check Code Combination Status: Among these invoices, I want to know which ones were created before their corresponding code combinations became inactive.

We are currently facing challenges in retrieving this information. If you have any SQL scripts or queries that can help facilitate this process, that would be extremely beneficial.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!