Edi Yanto (何 萬 新)

Changing LOV using Forms Personalization on Oracle Apps R12

Posted on: April 26, 2009


The below steps are change the LOV in “Supplier” field in the “Define User” form using Form Personalization (just want to list the suppliers who have the location in” NY (New York)”) on Oracle Apps R12:

  1. Open the Define User Form on System Administrator Responsibility (Security > Users > Define)
  2. Open the Personalization form using the navigation “Help > Diagnostics > Custom Code > Personalize”
  3. Enter the sequence number as 10 and description “Change Value of Supplier LOV”
  4. Select the Trigger Event as “WHEN-NEW-FORM-INSTANCE” and save the changes
  5. On Actions tab, enter or select the following values
    • Sequence = 10
    • Type = Builtin
    • Description = Create New Record Group
    • Language = All
    • Enabled = Yes
  6. On the right side of Actions tab, enter or select the following values
    • Builtin Type = Create Record Group from Query
    • Arguments = select full_name, supplier_name, supplier_location, supplier_contact_id from icx_supplier_contact_lov where supplier_location like ‘%NY%’ order by full_name, supplier_name, supplier_location
    • Group Name = EY_SUPPLIER_GROUP
  7. Click on the “Validate” button, then click on “Apply Now” button
  8. On next Actions tab, enter or select the following values
    • Sequence = 20
    • Type = Property
    • Description = Assign New Record Group
    • Language = All
    • Enabled = Yes
  9. On the right side of Actions tab, enter or select the following values
    • Object Type = LOV
    • Target Object = SUPPLIER_LOV
    • Property Name = GROUP_NAME
    • Value = EY_SUPPLIER_GROUP
  10. Validate All (Menu Tool > Validate All), Apply and Save the changes
  11. Close the Define User form and open it again.

This slideshow requires JavaScript.

9 Responses to "Changing LOV using Forms Personalization on Oracle Apps R12"

[…] Changing LOV using Forms Personalization on Oracle Apps R12 – Starting VMware Server Hangs/Crashes on Windows Vista – Where Context XML File in Oracle Apps […]

Like

The info about forms personalization was very useful..thanks

Like

I have a record with 5 columns and the first column has a LOV,
How can I enable/able the LOV using a condition thru Forms Personalization?

Like

Mr Edi yang saya hormati,

saya ikuti step di atas . dan berhasil

namun bila kasusnya saya ubah untuk FORM RETURN, maksud sya supaya saat return maka yang muncul hanya po po yang unbilled saja( walau itu menyimpang dari best practise) kok gagal ya.

berikut query nya

select distinct poh.SEGMENT1,hro.NAME, poh.TYPE_LOOKUP_CODE, pov.VENDOR_NAME,hre.FULL_NAME from po_headers_all poh,
PO_LINE_LOCATIONS_V pol
,po_vendors pov
,hr_all_organization_units_tl hro
,hr_employees hre
where poh.PO_HEADER_ID=pol.PO_HEADER_ID
and poh.VENDOR_ID=pov.VENDOR_ID
and poh.ORG_ID=hro.ORGANIZATION_ID
and pol.QUANTITY_BILLED = 0
and poh.AGENT_ID=hre.EMPLOYEE_ID
and poh.TYPE_LOOKUP_CODE not in (‘QUOTATION’,’RFQ’)

mohon bantuannya
Terima kasih banyak.

Like

Dear Pak Edi Yanto,

Saya coba membuat group LOV baru melului personalize Form, untuk LOV Trading Partner Name di Form Invoice Modul Paybles, saya sudah ikutin step2 yang bapak paparkan diatas, tapi muncul Error : FRM-41826 : Cannot replace group; columns don’t match LOV, pertanyaan saya apakah melalui Personalize Form kita tidak dapat membuat query group sendiri mengganti query bawaan LOV standard, dan kira2 bagaimana caranya untuk mentrace query pembentuk LOV.

Terima Kasih

Like

@yusrijal, jika Anda mau merubah kolom-kolom yang mau ditampilkan, maka harus dipastikan bahwa nama kolom, tipe data, dan jumlah kolom dari LOV yang ingin diubah harus sama dengan yg didefine sebelumnya.
apakah Anda sudah cek query dari LOV tsb seperti apa? Anda bisa lihat query yg ada di LOV tsb lewat Oracle Form Builder.

@Yulisar GP, seperti yg saya jelaskan ke Bapak Yusrijal bahwa nama kolom, tipe data dan jumlah kolom dari record group baru yg dibuat harus sama dgn aslinya..
Error : FRM-41826 : Cannot replace group; columns don’t match LOV menandakan jumlah kolom atau tipe data kolom tidak sama.

Melalui PF, Anda bisa membuat record group sendiri untuk menggantikan query bawaan LOV standard dan untuk mengetahui query pembentuk LOV standard tsb adalah dgn meng-download form yg dimaksud kemudian dicek dgn menggunakan Oracle Form builder untuk melihat querynya di record group LOV tsb.

Berikut adalah step2 untuk menggantikan record group yg digunakan LOV:

Condition
Trigger Event: WHEN-NEW-FORM-INSTANCE level.
Processing Mode: Not in Enter-Query-Mode.
Set the appropriate Context Level.
Actions
#1
Type: Builtin
Builtin Type: Create Group from Query
Argument:
Group Name:

#2
Type: Property
Object Type: LOV
Target Object:
Property Name: GROUP_NAME
Value:

For Example, the following forms personalization changes will change the record group in the sales order screen according to customer provided information:

Condition
===========
Trigger Event = WHEN-NEW-ITEM-INSTANCE
Trigger Object = ORDER.ORDER_TYPE

Actions
===========
Property
Object Type = LOV
Target Object = Order_Type
Property name – GROUP_NAME
Value = YF_OT

In Builtin > Create New RG >Language/All > ENABLED
Builtin type = Create Record Group from Query

In Arguement section please use the following SQL:

SELECT OTTT.TRANSACTION_TYPE_id, OTTT.NAME, OTTT.DESCRIPTION
FROM OE_TRANSACTION_TYPES_TL OTTT, OE_TRANSACTION_TYPES_ALL OTTA
WHERE LANGUAGE = USERENV(‘LANG’)
AND OTTA.TRANSACTION_TYPE_ID = OTTT.TRANSACTION_TYPE_ID
AND OTTA.TRANSACTION_TYPE_CODE = ‘ORDER’
AND OTTA.ORG_ID = 136;

Semoga membantu….

Like

@Ever, I think you can’t be conditionally disabled it through Form Personalization, but you maybe can do it through CUSTOM.pll. However the proposed workaround is display a message when you clicked it..

Like

Terima Kasih banyak Pak Edi Yanto, arahan bapak sangat membantu, kendala yang saya hadapi sekarang sudah solve

Like

it’s ur appreceiate that u doing greate job as respected teacher
thanks a lots,

Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,368 other followers


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications






Follow me on Twitter

Archives

April 2009
M T W T F S S
« Mar   May »
 12345
6789101112
13141516171819
20212223242526
27282930  

Visitors

Categories

Blog Stats

  • 140,586 hits

Users Online

web counter

Pages

%d bloggers like this: