E1: 31B: P31B61 View End Lots Displays Incorrect Results (Doc ID 3021066.1)

Last updated on MAY 07, 2024

Applies to:

Symptoms

P31B61 (View End Lots) displays incorrect results – e.g. returning more end lot records and fewer operation records than it should display for the query that is run.

Steps to Duplicate

1. Open the P31B61 to View End Lots.
2. Populate the From Date, Thru Date, and Block / Harvest code. In this example, this harvest record for Merlot grapes, against which two weigh tags, have been completed). Then, click Find.
3. This query should return two end lots (current tanks) after the crushing and subsequent wine making operations. However, the system processes for a lengthy period (up to ~10 minutes) and then displays 20+ end lot records, but only two of the displayed end lots actually contain material from the harvest record in the query. The other records are unrelated and involve different grape varieties and different vessels that are not part of the relevant dependency chains. Additionally, the operation history displayed by P31B61 is missing a number of operation records.
   
   

Cause

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