Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Is it possible to expand column FND_CONC_PP_ACTIONS.PUBLISHER_RETURN_RESULTS?

edited Apr 26, 2018 5:07AM in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

in EBS 12.2.5 (XDO 10.1.3.4.2)

From a very large XML data set the BIP process successfully generates the main output file but fails Bursting due to the column FND_CONC_PP_ACTIONS.PUBLISHER_RETURN_RESULTS getting filled up:

APP-FND-01564: ORACLE error 1406 in display_opp_results

Cause: display_opp_results failed due to ORA-01406: fetched column value was truncated.

The SQL statement being executed at the time of the error was:

SELECT ACTION_TYPE, PUBLISHER_RETURN_RESULTS FROM FND_CONC_PP_ACTIONS

There are hundreds of bursting records which eventually overwhelms this column.

The CP Purge program was used on the FND_CONC_PP_ACTIONS but did not relieve this error.

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