Financial Management - PSFT (MOSC)

MOSC Banner

Mass Update Invoice Media

edited May 8, 2020 5:02AM in Financial Management - PSFT (MOSC) 2 commentsAnswered

We are trying to mass update the invoice media for our bills - from P (print) to Email as attachment (A). We have SQL updated PS_CONTACT_CST_DOC. However when we proceed to create a bill the default invoice media (in the Address ) remains PRINT. The single action invoice run control does not seem to override this either - . We find that when we make the change online via contact the media is updated accordingly thru the bills.

Could we be missing a flag? or record? or is a save peoplecode issue?

Fields updated

COMM_METHOD 'A'

DOCUMENT_CD  'INVC'

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