EAR 9.2: Assessment Rule User - SQL Statement Generated Is Showing ITEM Table Joined Though Rule Is Based On ITEM_ACTIVITY. (Doc ID 2159620.1)

Last updated on JULY 11, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Condition Monitor

ACTUAL BEHAVIOR
---------------
When creating assessment rule User for any table. ITEM table is also joining in SQL.

EXPECTED BEHAVIOR
-----------------------
If user is creating assessment rule for ITEM_ACTIVITY only that table should get selected.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Goto Setup financials - product related - Receivable - Credit/collection - Assessment Rule User.
2. Add new for table ITEM_ACTIVITY and check SQL statement It will show join for ITEM and ITEM_ACTIVITY.


BUSINESS IMPACT
-----------------------
If condition is for item_activity assumption is only that table is involved in SQL.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms