Form Personalization to add new column to an existing seeded LOV Query - Help
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,/*