PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

pscbo_stats v2 - error while implementing

edited Mar 5, 2013 5:47AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered
I am getting the following error when trying to implement pscbo_stats v2 on PeopleTools 8.52.05, Oracle 11.2.0.3 environment.

SQL> EXEC pscbo_stats.quick_config;
BEGIN pscbo_stats.quick_config; END;

*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
ORA-06512: at "SYSADM.PSCBO_STATS", line 1263
ORA-06512: at line 1

It may be due to the mismatch in the field data type in PSDDLMODEL and pscbo_psddlmodel_history shown below. Anybody get similar errors?

desc PSDDLMODEL
Name Null Type
--------------- -------- ----------
STATEMENT_TYPE NOT NULL NUMBER(38)
PLATFORMID NOT NULL NUMBER(38)
SIZING_SET NOT NULL NUMBER(38)
PARMCOUNT NOT NULL NUMBER(38)
MODEL_STATEMENT NOT NULL LONG()

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center