E1: 15: When Querying for Leases and Leaving the Effective Date From Blank in the Header, in Work With Units (P15217) It Will Show the Vacated Date Blank and in Table Unit Master (F1507) the Vacated Date (DV) Becomes Blank (Doc ID 2975574.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

When querying for leases and leaving the Effective Date From blank in the header in Work With Units (P15217), the grid will show the Vacated Date = blank and also in table Unit Master (F1507) the Vacated Date (DV) becomes blank.

Steps:
1. Open Work With Units (P15217), leave Effective Date From and Thru as defaulted (populated with the current date), select “Show All Units” radio button and inquire on one unit that was vacated before the current date. Notice the Vacant Since is populated correctly and also in F1507 Vacated Date is populated correctly.  
2. Set the Effective Date From to blank and re-inquire. Notice the Vacated Date is blank in the P15217 and also in the F1507.

Changes

Cause

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