My Oracle Support Banner

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.

Symptoms

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) :
Condition:
Trigger Event = WHEN-NEW-FORM-INSTANCE
Processing Mode = Not in Enter-Query Mode
Actions:
Object Type = Block
Target Object = PNTXPPMT_BLK
Property Name = DEFAULT_WHERE
Value = 1=1

Cause

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
Symptoms
Cause
Solution
References


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