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

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms