General Ledger - EBS (MOSC)

MOSC Banner

Personalization on Post Journals Form in GL.

edited Sep 6, 2017 9:55AM in General Ledger - EBS (MOSC) 2 commentsAnswered

n Post Journals form in GL. We have made Personalization to have Batch Name, Batch ID and Journal Voucher Created User

Trigger Event: WHEN-NEW-ITEM-INSTANCE

Trigger Object : BATCHES.DEFAULT_PERIOD_NAME

Condition: :BATCHES.STATUS <> 'P'

Seq: 1

Type: Message

Message Type: Hint

Message text

=(select distinct a.batch_name||'    Creator = '||c.user_name||'   Batch ID = '||a.je_batch_id

  from GL_JE_HEADERS_V a,

  fnd_user c where c.user_id = a.created_by and a.JE_BATCH_ID = :BATCHES.JE_BATCH_ID)

------------------

is it safe to do Personalization here like above

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