Catalog Upload Errors Out - Loaded Has Encountered An Unexpected Purchasing Document Open Interface error (Doc ID 1683955.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Release 12.1.3 version, Loading external catalog

When attempting to Upload the 'TESTLOAD_DEV31.txt' the following error occurs.
Due to this issue, users cannot cannot load any lines without error.


ERROR:
The Loaded has encountered an unexpected Purchasing Document Open Interface error.
Please Run the Concurrent Program, Purge Purchasing Open Interface Processed Data
to see the detailed errors
.
java.lang.Exception
at oracle.apps.icx.icatalog.loader.processors.DataRootElementProcessor.catalogProcess(DataRootElementProcessor.java:426)
at oracle.apps.icx.icatalog.loader.processors.DataRootElementProcessor.process(DataRootElementProcessor.java:79)
at oracle.apps.icx.icatalog.loader.handlers.DataRootLineHandler.endDocument(DataRootLineHandler.java:140)
at oracle.apps.icx.icatalog.loader.handlers.ItemLineHandler.endDocument(ItemLineHandler.java:499)
at oracle.apps.icx.icatalog.loader.parsers.DataTXTParser.parse(DataTXTParser.java:96)
at oracle.apps.icx.icatalog.loader.CatalogTXTLoaderBase.processJob(CatalogTXTLoaderBase.java:42)
at oracle.apps.icx.icatalog.loader.CatalogLoaderBase.service(CatalogLoaderBase.java:141)
at oracle.apps.icx.icatalog.loader.LoadRequest.start(LoadRequest.java:151)
at oracle.apps.icx.icatalog.loader.LoadRequest.runProgram(LoadRequest.java:49)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

FND DEBUG LOG SHOWS:
Start of subprogram.
End of subprogram.
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_LINE_PROCESS_PVT. Procedure copy_lines.40;SQLERRM = ORA-06531: Reference to uninitialized collection
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_LINE_PROCESS_PVT. Procedure split_lines.20;SQLERRM = ORA-06531: Reference to uninitialized collection
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_sync.70;SQLERRM = ORA-06531: Reference to uninitialized collection
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.40;SQLERRM = ORA-06531: Reference to uninitialized collection
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.30;SQLERRM = ORA-06531: Reference to uninitialized collection
Start of subprogram.
End of subprogram.
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-06531: Reference to uninitialized collection
Start of subprogram.
Start of subprogram.
.

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Sign on to Application
2. Select Responsibility: iProcurement Catalog Administration
4. Navigation: iProcurement Administration - Home Page
5. Choose BPA Blanker Purchase Agreement 222
6. Choose Template 'TESTLOAD_DEV31.txt'
5. Load finished with error:
  java.lang.Exception
  at oracle.apps.icx.icatalog.loader.processors.DataRootElementProcessor.catalogProcess(DataRootElementProcessor.java:426)
  at oracle.apps.icx.icatalog.loader.processors.DataRootElementProcessor.process(DataRootElementProcessor.java:79)
  at oracle.apps.icx.icatalog.loader.handlers.DataRootLineHandler.endDocument(DataRootLineHandler.java:140)
  at oracle.apps.icx.icatalog.loader.handlers.ItemLineHandler.endDocument(ItemLineHandler.java:499)
  at oracle.apps.icx.icatalog.loader.parsers.DataTXTParser.parse(DataTXTParser.java:96)
  at oracle.apps.icx.icatalog.loader.CatalogTXTLoaderBase.processJob(CatalogTXTLoaderBase.java:42)
  at oracle.apps.icx.icatalog.loader.CatalogLoaderBase.service(CatalogLoaderBase.java:141)
  at oracle.apps.icx.icatalog.loader.LoadRequest.start(LoadRequest.java:151)
  at oracle.apps.icx.icatalog.loader.LoadRequest.runProgram(LoadRequest.java:49)
  at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

The issue also occurs when submitting the program in Purchasing responsibility
1. Navigation: Buyer Work Center -> Agreements
2. Select the blanket agreement.
3. Attempt to load a catalog.  This spawns a concurrent request.  An error can be seen:

Error: The loader has encountered an unexpected error. A concurrent job request was submitted but did not complete.
          See concurrent job log for more information.

The concurrent request log file contains the above errors.



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