EBS Customizations (MOSC)

MOSC Banner

Need to add more rows to multi-row Autoquery block using Forms Personalization

edited Jul 23, 2016 5:01AM in EBS Customizations (MOSC) 1 commentAnswered

In OM there's the Enter Order form, where in the the Additional Line Information option there's a form with several tabs. One of them is the "Invoices / Credit Memos", which does an autoquery on a view. This view, though, limits the results to only shows AR invoices created by OM. However, we have a 3rd party tool, certified by Oracle, which also creates AR invoices related to the OM orders and I would like to "add" these invoices to the result set.

How can I do it?

I was thinking about, if I could, changing the base view of the block(oe_ra_customer_trx_perf_v) and add a "custom" view with all the invoices. This is a query-only form and the additional information is FYI only, no processing will be done on them.

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