R12.PN: DEFAULT_WHERE Personalization Is Not Working In PNTXPPMT (Export Billings to Receivables )
(Doc ID 2619154.1)
Last updated on DECEMBER 10, 2019
Applies to:Oracle Property Manager - Version 12.1.3 and later
Information in this document applies to any platform.
The customer is trying to set the following Personalization on Export Billings to Receivable form, in order to prevent the blind query:
Export to AR (form)> Help > Diagnostics > Custom Code > Personalize
Form Personalizations (form) :
Trigger Event = WHEN-NEW-FORM-INSTANCE
Processing Mode = Not in Enter-Query Mode
Object Type = Block
Target Object = PNTXPPMT_BLK
Property Name = DEFAULT_WHERE
Value = 1=1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document