PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How do I fix SQL-07 errors in SYSAUDIT

After running the FSCM 9.1 MP5 update in our Demo environment, the SYSAUDIT report shows a number of records in the SQL-07 section (Record Views/Dynamic Views Without SQL Definitions)--by way of example, the first three items listed are MIN_MNU_REQ, MIN_ASR_GET_DVW and MIN_LKUP_RS_DVW.  PeopleBooks indicates that the solution for this is the following--

          "Complete the entry of the record view or dynamic view before attempting to build or create the view. Each record should be opened, and the SQL should be entered as required."

How can I determine what the SQL is supposed to be, and, in the case of Dynamic Views, where does this need to be defined?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center