"ORA-00904: NOT_AFTER_DATE: INVALID IDENTIFIER" Error Occurs when Printing Return Report

(Doc ID 2133184.1)

Last updated on MAY 09, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.1.9 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix is already scheduled for future release. This article will be updated as official patch becomes available.

In the Store Inventory Management (SIM) application, we find that when a return report is printed, the report errors with the following error:

Steps to Reproduce:

1. Log in to SIM and navigate to Shipping/Receiving -> Returns.
2. Click on the 'Filter' button and retrieve a dispatched return.
3. Select the record and click on the "Print" button.
4. Select the printer and click 'OK'.  Note the error.


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 hundreds of Community platforms