Financial Management - PSFT (MOSC)

MOSC Banner

AP Matching and AP voucher build processes are failing after applying Bundle 11 for 9.1 (Update id 8

edited Nov 3, 2011 3:42AM in Financial Management - PSFT (MOSC) 1 comment
After applying Bundle 11 for 9.1 (Update id 855538), Matching and Voucher build processes are failing with below error

ERROR
-------------

Return: 1400 - ORA-01400: cannot insert NULL into
("EMDBO"."PS_TSE_VCHRLN_FLD"."MESSAGE_PARM4") Failed SQL stmt:INSERT INTO
PS_TSE_VCHRLN_FLD (TSE_JOBID , TSE_PROC_INSTANCE , TSE_SET_NBR , TSE_EDI
T_TYPE , TSE_FIELDNAME , BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM ,
MESSAGE_SET_NBR , MESSAGE_NBR , MESSAGE_PARM , MESSAGE_PARM2 ,
MESSAGE_PARM3) SELECT 'AP_VCHRBLD' , 11914 , 1 , 'A' , 'SCHED_NBR' ,
LINE.BUSINESS_UNIT , LINE.VOUCHER_ID , LINE.VOUCHER_LINE_NUM , 7220 , 326 ,
' ' , ' ' , ' ' FROM PS_VCHR_LINE_TMP5 LINE WHERE LINE.PROCESS_INSTANCE =

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