Catalog Data Extract - Classifications And Catalog Data Extract - Items Completed With No Records
Last updated on APRIL 27, 2017
Applies to:
Oracle iProcurement - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]Information in this document applies to any platform.
Symptoms
On : 12.2 version, Loading external catalog
Catalog Data Extract - Classifications and Catalog Data Extract - Items completed with no records
As part of the upgrade process we were instructed to run these two programs:
'Catalog Data Extract - Classifications' : Output generated with no records.
'Catalog Data Extract - Items' : The following output generated with 895 rows with essentially this error is shown for various orgs:
03/07/17 14:06:01:22 The following item was not extracted because the item is either not defined as purchasable
or is an outside processing item: 123456. The item exists in the following inventory organization: ACME INVENTORY ORGANISATION.
03/07/17 14:06:01:22 The following item was not extracted because the item is either not defined as purchasable
or is an outside processing item: 78910123. The item exists in the following inventory organization: ACME UK INV ORG.
03/07/17 14:06:01:23 The following item was not extracted because the item is either not defined as purchasable
or is an outside processing item: 456789. The item exists in the following inventory organization: ACMEE NL INV ORG.
. . .
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Catalog Data Extract - Classifications and Catalog Data Extract - Items process
as part of 11i to 12.2 upgrade process
2. 'Catalog Data Extract - Classifications' runs in about 2 minutes with no output
3. 'Catalog Data Extract - Items' runs for about 3 hours the above reported results
Changes
Upgrade to 12.2 release
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