My Oracle Support Banner

Customer Account Detail Roles gives ORA-00904 "CURRENT_ROLE_STATE" Invalid Identifier (Doc ID 2701811.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Advanced Collections - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms


In the Customer Account Detail form IEXACDTL form, clicking on a record in the Roles tab gives ORA-00904 "CURRENT_ROLE_STATE": invalid identifier

ERROR
-----------------------
ORA-00904: "CURRENT_ROLE_STATE": invalid identifier


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

Collections Agent>Collections
Query - Customer
View - Account - XXXX
Account Tab>Highlight Account
Click on Details button

Click on Roles Tab and error appears
ORA-00904: "CURRENT_ROLE_STATE": invalid identifier


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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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