EBS Customizations (MOSC)

MOSC Banner

Invalid number shows in diagnostic > display database error when trying to save custom form in ebs 1

edited Jun 10, 2016 12:15AM in EBS Customizations (MOSC) Question

help,

subsidary code is an LOV  datatype varchar2

vendor site id  datatype varchar2

for rule seq 5

trigger event : WHEN-NEW-FORM-INSTANCE

processing mode : not in enter-query mode

for Actions seq 10

object type : global variable

targer object : xx_vendor_site_id_csa

property : initial value

value : "NULL"

for Actions seq 20

object type : global variable

targer object : xx_vendor_site_id_csa

property : VALUE

value : TO_CHAR(${item.site.vendor_site_id.value})

when trying to save its nothing happen then i checked diagnostic > display database error and its throws invalid number.

can anyone explain what should i do?

Tagged:

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