Skip to main content

After upgrading from 23R2 to 25r1 we can’t get sql reports to run either scheduled or unscheduled. 

 Many report only produce a small amount of data and all of the reports will run manually. through pl/sql developer. 

 

 

 

 

 

 

In 23R2 documentation it tells you: 

Using the Application Owner Prefix (&AO)

The application owner prefix (&AO) is a crucial element when working with SQL queries in IFS Applications. It ensures proper access control and data security by differentiating objects belonging to different applications. When writing your SQL query, include the &AO prefix with ".." before the name of each database object you are referencing.

SELECT * from &AO..Customer;

But that requirement was removed in 24R2.

If this is not the problem perhaps you can provide an example of what is not running and the setup?

Terms & ConditionsCookie settingsAccessibility statement