Users Cannot Change Passwords Within Performance Analyzer And Portfolio Analyzer (Doc ID 250109.1)

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.

Symptoms

Users cannot change their own passwords within Oracle Performance Analyzer and Portfolio Analyzer.  They receive the following error message:

SQL Funtion: [0] - SQL function not found! 
OCI Function: [4] -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:

The ORA-00922 error occurs.

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