CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Is is there any way we can retrieve all the conditions in sorted manner as per application.?

We need to display all the conditions in the report according to the application, in a sorted manner. The sorted conditions are present in the table por_amx_rules  but it is truncating as there are limitations with the table, where the maximum character length that can be extracted is 999.  Is there any way we can retrieve all the conditions in sorted manner as per application.?

Each rule contains multiple conditions, which are not stored in the por_amx_conditions table. However, this table also truncates individual conditions if the character length exceeds 999.

When we edit the conditions we can see all the values which were provided in the condition. Which means it must be coming from some Oracle seeded table.       

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