Issue:
The resource planning portlets not working. From the home menu , under Resource Management -->Resource Planning
the Role Capacity Histogram portlet and Role Capacity return the below error:
Error: System error. Contact system administrator.
Some examples of errors that might be shown in the app-ca.log for this issue:
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string
or
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string
Cause:
If both of these portlets are erroring, one typical cause is due to an incorrect NLS Date Format set in the Database. This parameter should match the guidelines for database parameters listed in the PPM Intallation guide based on your PPM version.
Resolution:
select * from nls_database_parameters;
select * from nls_instance_parameters;
select * from nls_session_parameters;
2. Verify that NLS_Date_Format is set to: YYYY-MM-DD hh24:mi.
3. If not, below are the steps to update the NLS Date Format:
alter system set nls_date_format="yyyy-mm-dd hh24:mi:ss" scope=spfile;
Additional Information:
TEC535754 Required Oracle Database Parameters for use with Clarity
TEC581262 If nls_date_format is incorrect, you cannot filter for timesheets by prior time period or current time period as it throws a system error.
TEC572798 Timesheet Browsing Error 500