My Oracle Support Banner

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

Last updated on JULY 08, 2020

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


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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