EBS Customizations (MOSC)

MOSC Banner

Copying variable from one form and use them to populate another form

edited Jan 19, 2010 2:22AM in EBS Customizations (MOSC) 6 commentsAnswered ✓
 I am trying to copy variables from the Service Request form in Telesales and use them as bind variable to a query that populates a field in the Requisitions form in Purchasing.

I tried copy(NAME_IN('INCIDENT_TRACKING.INCIDENT_ADDRESS),'GLOBAL.INCIDENT_ADDRESS') from Service Request form; and then pass 'GLOBAL.INCIDENT_ADDRESS' to my query as a variable in another form. 'GLOBAL.INCIDENT_ADDRESS' is not being passed to Requisitions form query.

I also tried creating a package that gets the global variables and pass them over to the Requisitions form but no joy either.

xxvg_create_ir_k.create_ir (p_incident_address     => NAME_IN('INCIDENT_TRACKING.INCIDENT_ADDRESS'),

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