General Ledger - EBS (MOSC)

MOSC Banner

Personalisation of Budget Transfer window on R12

edited Sep 14, 2015 8:03AM in General Ledger - EBS (MOSC) Question

Hi,

We have the following requirement for the field "Batch Name" on "Budget Transfer" window on R12 GL.

When logged in with a particular responsibility, we need to have the batch name start with "CER-". And when validating the record, the system should verify that the batch name is starting with CER and if not, it should throw out an error message and prevents user from saving the record.

I have done the following:

1. When new record, initial value should be 'CER'

2. When validate record on "Budget Transfer" trigger object and condition ":BUDGET_TRANSFER.JE_BATCH_NAME not like 'CER-%'", then error message is given as well as "Builtin" action type of "Raise form trigger failure"

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