Is it possible to expand column FND_CONC_PP_ACTIONS.PUBLISHER_RETURN_RESULTS?
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.