EAP: Error selecting Actions > My Preferences > Payables > Average Payment Days When Row Level Security Is Turned on - Internal loop setting defaults: APOP_PREF_WRK.BANK_SETID (Doc ID 2969102.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

Row Level Security is turned on.  When on the Fluid Home page and navigating to Actions (3 vertical dots in the upper right hand corner) > My Preferences page, an error occurs when selecting Payables > Average Payment Days.

ERROR
Internal loop setting defaults: APOP_PREF_WRK.BANK_SETID.

The component processor detected a continuous loop while setting related display fields. This occurs when one related display sets a field which causes the setting of another field, which in turn causes the original field to be recalculated. Review the page and related records using the Application Designer to determine which fields are interacting adversely.

STEPS
1. Navigate to Set Up Financials/Supply Chain > Security > Activate Row-level
    a. Type of Security = User ID level Security
    b. Secured Fields = SetID

2. Navigate to Set Up Financials/Supply Chain > Security > TableSet by User ID
    a. Display User ID = XXX
    b. SetID = YYYYY and ZZZZZ

3. Navigate to Set Up Financials/Supply Chain > Security > Apply Security Setups
    a. Run Apply Security Setups

4. Navigate to Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences
    a. Display User ID = XXX
    b. On the Overall Preferences page, Business Unit is blank and SetID = YYYYY

5. On the Fluid Home page, navigate to Actions (3 vertical dots in the upper right hand corner) > My Preferences page
     a. Select Payables > Average Payment Days

6. Above error occurs

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.