EBS Customizations (MOSC)

MOSC Banner

seeded form Personalization

edited Jul 24, 2012 9:32PM in EBS Customizations (MOSC) 2 commentsAnswered ✓
I want to personalize the invoice form in payables;
When record in distributions is validated, the invoice amount should be updated to the sum of the distributions amount .
So the trigger is when record is validated
and the action is property set the item's (invoice amount) value.
The value is my problem, I put :block_name.item_name but an error happens because of wrong format
this problem is solved by calling  to_number  function to correctly format it
Now another error is raised :

FRM-40831: truncation occurred: value too long for field invoice_amount_dsp
TRUNC(TO_NUMBER(:LINE_SUM_FOLDER.D_SUM_DIST_TOTAL,2)

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