Financial Management - PSFT (MOSC)

MOSC Banner

When running Auto Maintenance AR_AUTOMNT App Engine, I get an error [Cannot insert the value NULL in

edited Nov 24, 2015 5:10PM in Financial Management - PSFT (MOSC) 4 commentsAnswered

The App Engine AR_AUTOMNT, fails on the following SQL

UPDATE PS_MT_ITEM_TAO4 SET WORKSHEET_FLG = 'N'

(

SELECT T.WORKSHEET_FLG FROM PS_MT_TOTAL_TAO4 T

WHERE T.PROCESS_INSTANCE = 415295

AND T.CORPORATE_SETID = PS_MT_ITEM_TAO4.CORPORATE_SETID

AND T.CORPORATE_CUST_ID = PS_MT_ITEM_TAO4.CORPORATE_CUST_ID

AND T.MATCH_GROUP_ID = PS_MT_ITEM_TAO4.MATCH_GROUP_ID

)

WHERE PROCESS_INSTANCE = 415295

This is due to the PS_MT_TOTAL_TAO4 not having all the MATCHING_GROUP_IDs. Leaving the PS_MT_ITEM_TAO4.WORKSHEET_FLG  set NULL values for non-matching MATCHING_GROUP_IDs.

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