Technology Stack - EBS (MOSC)

MOSC Banner

need to populate value using select statement in form personalization

edited Aug 20, 2021 11:03AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hello experts

I have a requirement where i need to pull a single row value from a select statement . I developed one personalization, but couldn't able to run my select statment.

Evert time it is giving null, because i may not following proper syntax.

Action tab of form personalization:

Property Name : value

=(select distinct comments

from apps.ap_invoice_lines_all aila, apps.ap_invoices_all aia, apps.po_headers_all pha

where  aia.invoice_id = aila.invoice_id

and      aila.po_header_id =  :LINE_SUM_FOLDER.PO_HEADER_ID

and      pha.po_header_id = aila.po_header_id

)

Can you suggest me the correct syntax , so that my query starts giving rows.

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