EBS Customizations (MOSC)

MOSC Banner

Form Personalization to add new column to an existing seeded LOV Query - Help

edited Dec 20, 2019 12:59AM in EBS Customizations (MOSC) 5 commentsAnswered

HI all,

I am on EBS R12.1.3 with 12c Database.

We have a requirement to add a new column in the LOV Query that's being displayed in standard LOV.

We just want to display "pay_group" along with the rest of the seeded LOV being displayed for Supplier Name.

I have been trying to use Form Personalization to achieve this.. But I get the error :  FRM-41826:Cannot replace group; Columns don't match LOV

I have been trying the below:

1. Form Personalization to -  Create Record Group From Query.

Original Seeded Query:

SELECT * FROM (SELECT /*+push_pred(emp) no_expand*/ pv.vendor_name party_name, pv.segment1 vendor_number, decode(sign(trunc(pv.start_date_active)-trunc(sysdate)), 1, 'No', decode(sign(trunc(pv.end_date_active)-trunc(sysdate)),-1,'No',0,'No', 'Yes'))  Active, hp.jgzz_fiscal_code num_1099, substr(hp.tax_reference,1,20) vat_registration_num, pv.vendor_id vendor_id, pv.hold_all_payments_flag hold_all_payments_flag, hp.party_id party_id, hp.party_number registry_id, 'SUPPLIER' party_type,/*

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