Home » Applications » Oracle Fusion Apps & E-Business Suite » unable to query Inventory items thru the front end (Oracle inventory-11.5.10.2)
unable to query Inventory items thru the front end [message #283699] Wed, 28 November 2007 00:21 Go to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Hi,

We are working on 11.5.10.2 version. We found a strange problem. Though the Items are present in MTL_SYSTEM_ITEMS. SEGMENT1 Column, these could not be queried from the front end.

We are unable to query the item in Master Inventory organization nor in the Child orgs. These happens only for some item numbers.

What could be the possible reasons?

Thanks & Regards
Vinod

Report message to a moderator

Re: unable to query Inventory items thru the front end [message #284024 is a reply to message #283699] Wed, 28 November 2007 10:40 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
what error it gives you?

Report message to a moderator

Re: unable to query Inventory items thru the front end [message #284119 is a reply to message #283699] Wed, 28 November 2007 23:43 Go to previous message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
The error is similar to when an item is not defined in the system (APP_FND-00906)

Anyhow, I have solved the issue. It is caused b'cos of the Value set definition attatched to the SYSTEM ITEMS flexfield
The valueset was defined as to use UPPER CASE ONLY .

Hope this meek solution can be used !!!

Thanks & Regards
Vinod

Report message to a moderator

Previous Topic: Oracle Financial Cash Management Practice Questions
Next Topic: Open balance letter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 23:28:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.