Expired Lots Report (XML) INVTRELT_XML Does Not Show Serial Numbers

(Doc ID 2011940.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INVTRELT_XML.xml
INVTRELT_XML.rtf

Symptoms

On : 12.1.3 version, LOTSERATT

ACTUAL BEHAVIOR

When executing the Expired Lots Report (xml), the associated serial number is not populated in the serial number column of the report. However, if the Regular Expired Lots Report is run for the same item, expiration date, the serial number column IS populated

EXPECTED BEHAVIOR

Expect that Expired Lots Report (xml) will provide the same information as does the Expired Lots Report.

STEPS

The issue can be reproduced at will with the following steps:
1. Navigate to Inventory / reports / select organization / single report
2. Query Report Expired Lots Report (xml) or Expired Lots Report
3. Enter expiration date and item range
4. Launch report


Cause

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