Financial Management - PSFT (MOSC)

MOSC Banner

SQL Statement not generating correctly for Assessment Rule User

edited May 30, 2019 8:57PM in Financial Management - PSFT (MOSC) 2 commentsAnswered ✓

PeopleSoft Receivables 9.2, Image 26

Condition Monitor Setups

Assessment Rule User- Setup Financials, Product Related, Receivables, Credit/Collections, Assessment Rule User

I am trying to test an User Assessment Rule but the SQL statement does not seem to be generating correctly.

Not sure if this is a user error or a bug. I am trying to test some simple conditions to check how these rules work.

Any help would be appreciated.

Below is a User Defined Assessment Rule I created in the DEMO environment.

The SQL that is generated for the above user criteria is as below.

Not sure why the PS_ITEM

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