My Oracle Support Banner

EAM: Receiving Error "A SQL error occurred. Please consult your system log for details." on The Impairment Worksheet Page > Business Unit Lookup After Enabling User ID Level Security (Doc ID 2865961.1)

Last updated on APRIL 29, 2022

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Receiving error "A SQL error occurred. Please consult your system log for details." on The Impairment Worksheet Page > Business Unit Lookup After Enabling User ID Level Security


The issue can be reproduced at will with the following steps:

Setup:
1. Enable User ID Level Security by Business Unit
Navigation: Set Up Financials/Supply Chain > Security > Activate Row-level Security
2. Review DEMO VP1 Business Unit Security
Navigation: Set Up Financials/Supply Chain > Security > Unit by User ID
3. Apply Security Setups
Navigation: Set Up Financials/Supply Chain > Security > Apply Security Setups
4. Enable Impairment Process for Business Unit US001;
Navigation: Set Up Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition | Business Unit/Book Feature Tab
 
Replication:
1. Log in as VP1
2. Navigate to: Asset Management > Asset Transactions > Financial Transactions > Impairment Worksheet
3. Click on the Business Unit Lookup
4. The following error pops up:


Detailed DEMO Replication Steps Attached.

Changes

 The issue occurs after enabling the User ID Level Security by Business Unit

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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