Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Extract WhereUsed Information of all items in SCM

Organization Name
Diversey Inc.
Description
I had opened an SR in the Support portal -
![]() |
SR 3-20166077801 |
to understand how to get the Whereused information of items from Reports and Analytics. I was told to run the ESS Job for WhereUsed information and got blank as results, if I did not specify an item number in the job criteria. Specifying one item as parameter to the job, enables the WhereUsed Quick Preview table to get populated. It looks like we can specify upto 100 items separated by comma for one job run. But the item numbers have to be specified in order to see the information in the Quick Preview. There is no automated way of extracting all the items in the environment and running this job on a schedule to get the information reflected in the Where Used Preview. Submitting this request to get the process automated for all items in the environment.
Use Case and Business Need
We can specify upto 100 items separated by comma for one job run. But the item numbers have to be specified in order to see the information in the Wher Used Quick Preview. There is no automated way of extracting all the items in the environment and running this job on a schedule to get the information reflected in the Where Used Preview. Submitting this request to get the process automated for all items in the environment.
Original Idea Number: 0e73d5e3aa