DEFAULT_WHERE in Form Personalization Is Not Honored in 'Autocreate' Form (Doc ID 2031313.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

On : 12.1.3 version, Purchase Order

DEFAULT_WHERE is not working through personalization in the Autocreate form.

The event is WHEN-NEW-BLOCK-INSTANCE or WHEN-NEW-FORM-INSTANCE.
Target Object: REQ_LINES

When query for requisitions the personalization seems to be ignored.

Reproducible Steps

1. Responsibility = Purchasing
2. Navigation = AutoCreate
3. On 'Find Requisition Lines' window, select 'Help > Diagnostic > Custom Code > Personalize' to open 'Form Personalization (AutoCreate Documents)' window
4. Create form personalization on Header level, enter
- Function Name = PO_POXBWVRP
- Sequence = < any value >
- Description = < any value >
- Level = Function
- Enabled (Checkbox) = Checked
5. Create form personalization on 'Condition' tab, enter
- Trigger Event = WHEN-NEW-BLOCK-INSTANCE  or WHEN-NEW-FORM-INSTANCE
- Trigger Object = REQ_LINES
- Condition = < Leave it blank >
- Processing Mode = Not in Enter-Query Mode
6. Create form personalization on 'Actions' tab
- Seq = < any value >
- Type = Property
- Description = < any value >
- Object Type = Block
- Target Object = REQ_LINES
- Property Name = DEFAULT_WHERE
- Value: 1 = 2
7. Click 'Apply Now' to save the change
8. Click 'Validate.
9. Close the 'Form Personalization (AutoCreate Documents)' window and back to 'Find Requisition Lines' window
10. Running a blind query by clicking the 'Find' button
11. Requisition lines were populated and it is expected to have no requisition lines populated after above Form Personalization had been setup

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.