My Oracle Support Banner

How To Query The Leases With Approval Status 'Submitted' in Oracle Property Manager's Leases Forms PNTLEASE And PNQLEASE? (Doc ID 1547356.1)

Last updated on AUGUST 21, 2018

Applies to:

Oracle Property Manager - Version 12.1.1 and later
Information in this document applies to any platform.
PNTLEASE.fmb
PNQLEASE.fmb

Goal

 The field 'Approval Status' in the Find window of the PN Leases form or PN view lease history form shows only 2 values , 'Final' and 'Draft' while there could be leases with approval status 'Submitted' when PN Lease approval workflow functionality is used.

 How to find such leases while the 'Submitted' value does not exist in the List of values of the Approval status field?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.