Last updated on NOVEMBER 04, 2016
Applies to:Oracle Financial Data Manager - Version: 4.5 to 4.5.39 - Release: to 4.5
Oracle Profitability Manager - Version: 4.5 to 4.5.39 - Release: to 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5
Checked for relevance on 13-Jan-2010.
Users cannot change their own passwords within Oracle Performance Analyzer and Portfolio Analyzer. They receive the following error message:
SQL Funtion:  - SQL function not found!
OCI Function:  -oexec(), oexn()
Oracle Error: ORA-00922: missing or invalid option
Driver Function: drv_oci::Execute()
The problem only occurs when users have been advised that their password will expire in "x" number of days. If users go in and select change password within these two applications prior to the receiving the password warning, it will successfully change the password.
Note: Other OFSA Applications like Balance and Control seem to work properly.
Steps to replicate:
- Receive warning that the password will expire in x days
- Log into Oracle Performance Analyzer
- Go to Options > Change Password
- Enter password information
The ORA-00922 error occurs.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms