E1: 44H: R44H700 - Lot Start Workfile Generation / (N44H0053 – CreateJobAndAccountsFromTemplate) does not Update any Audit Fields when Table Data Fields are Updated After Running the R44H700 Over a Lot for the First Time (Doc ID 2957809.1)

Last updated on AUGUST 07, 2023

Applies to:

Symptoms

R44H700 - Lot Start Workfile Generation / N44H0053 – Create Job and Accounts from Template does not update audit fields when updating F44H501 - Sales Master Table.

When the R44H700 is first processed for a new Lot, the expected F44H711 Lot Start Workfile records are created and the F44H201 - Lot Master & F44H501 - Sales Master fields such as Business Unit & PS (Posting Stage) are updated in the tables.  The F44H201 audit fields are updated, but the F44H501 audit fields are not updated and remain unchanged. 

This issue can be demonstrated by following these steps:

1. P44H201 - Lot Master. Create a new Lot.  Add Cost Code Template (11010000) and Commitment Start Date (01/01/2023) to the Lot when creating the record.
2. After the Lot has been created, Row Exit to Release for Sale.  Release date is populated.
3. P44H500 -  Sales Workbench.  Add Plan/Elevation via House Revisions row exit and Buyer and Sales Date via New Buyer exit.
4. Use Databrowser to capture F44H201 - Lot Master and F44H501 Sales Master data.
5. Run R44H700 - Lot Start Workfile Generation over this lot with processing options set to to create budget from cost code template.
6. F44H711 - Lot Start Workfile Generation records are created for this Lot.
7. Use Databrowser to capture current F44H201 - Lot Master and F44H501 Sales Master data to see how or if data in the table has changed.
8. F44H201 & F44H501 Table fields such as Business Unit & PS (Posting Stage) are updated in the tables.
   
   1. F44H201 - "Audit" fields are updated.
   2. F44H501 - "Audit" fields are not updated even though the Business Unit field is populated/changed.
9. At a minimum, the F44H501 date and time updated fields should be updated, but none of the "audit fields" (Created By User, Date Created, Time Created, Original Work Stn ID, Original Pgm ID, Updated By, Date Updated, Time Updated, Work Stn ID, Program ID) are updated.

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.