EBS Customizations (MOSC)

MOSC Banner

Use Forms Personalization on the Purchase Order Screen to Default a Value

edited Apr 8, 2014 12:00PM in EBS Customizations (MOSC) 5 commentsAnswered

I would like to use a forms personalization to default a value on the purchase order screen.  I want to take a value entered on a DFF on the requisition header and populate it on the PO form.  Below is what I am putting in the value field on the forms personalization screen.

=select attribute5 from po_requisition_headers_all

where segment1 = :PO_DISTRIBUTIONS.REQ_HEADER_REFERENCE_NUM

and org_id =

:PO_HEADERS.ORG_ID

When I validate, it returns the correct value, but it does not insert it into the related field when I go back to the PO screen.  What am I doing wrong?

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