E1: 34: Forecast Revisions - P3460 Does Not Clear Error ID 1838 – 'No Records Selected' Even if Search Criteria Are Correct (Doc ID 2911563.1)

Last updated on NOVEMBER 30, 2022

Applies to:

Symptoms

When inquiring data in P3460, if the search criterion is not valid, the system triggers the following error correctly:
No Records Selected
Go to error..
CAUSE: The search information entered did not select any records.
RESOLUTION: Check the search information for validity or change the values to
expand the search range.
ER Details:
    Form   P3460_W3460B
    Event   Last Grid Record Has Been Read
    Line No   4
    Error ID   1838
However, if the user does not close the P3460 screen and then uses a valid search criterion, the system still does not clear error ID 1838 as it should, and it does not display the correct records.

The issue can be reproduced at will with the following steps:

1. P3460 - Find the forecast records of an item
2. P3460 - In the QBE, filter by an existing Request Date. Since the search criterion is valid, the system displays the corresponding record.
3. P3460 - In the QBE, filter by an invalid Request Date. The search criterion is not valid, therefore the system triggers Error ID  1838 – ‘No Records Selected’. This is correct.
   Error ID 1838 - No Records Selected
   Go to error..
   CAUSE: The search information entered did not select any records.
   RESOLUTION: Check the search information for validity or change the values to
   expand the search range.
   ER Details:
       Form   P3460_W3460B
       Event   Last Grid Record Has Been Read
       Line No   4
       Error ID   1838
4. P3460 - Remove the invalid Request Date and do a Find. The system still displays error ID  1838 – 'No Records Selected'. This is incorrect.
5. P3460 - In the QBE, re-add the valid / existing Request Date and press Find. System still displays Error ID  1838 incorrectly.
6. P3460 - Change the Item Number and press Find. Error ID  1838 – 'No Records Selected' is still displayed incorrectly. To retrieve other forecast records for different items / branch plants, the
   user needs to close the application and re-inquire.

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.