EAM :PI Occurence Multiple Effective Dated Rows Displays SQL Error For Location

(Doc ID 2228967.1)

Last updated on FEBRUARY 24, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, PUM # 18.Physical Inventory

PI Occurence Multiple Eff. Dated Rows
Creating an Inventory Occurrence with In List criteria will display all effective dated rows for a particular Location.

A fatal Peoplecode sql error occured.

The issue can be reproduced at will with the following steps:
1. Add a new effective dated row for location.
2. Create a new instance.
3. List criteria will display all the effective dated rows

The issue has the following business impact:

Due to this issue, users cannot  have created PI 


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