My Oracle Support Banner

PO ECC_Strategic Sourcing Load Error PON_PCC_NEGOTIATIONS_UTIL_PVT.get_ecc_data_load_info with dataset pon-pcc-neg for job 999 ORA-00942: table or view does not exist (Doc ID 2791856.1)

Last updated on JULY 19, 2021

Applies to:

Oracle Sourcing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms


When attempting to run PO ECC Strategic Sourcing Data Load,
the following error occurs.

ERROR
-----------------------

ECCRUNDL: ECC Run Data Load

 Details of auditDataset#: 21347
  dataset: pon-pcc-neg
  startTime: Mon May 31 21:31:22 EDT 2021
  endTime: Mon May 31 21:31:55 EDT 2021
  status: FAILURE
  auditLoadRuleId:21348
  DatasetLoadRuleId:17954
  Load Type:FULL_LOAD
  sequence:1
  auditLoadDetailId:21349
  operation:REPLACE
  sqlQuery:select * from (SELECTAH.AUCTION_HEADER_ID||'-'|
  startTime: Mon May 31 21:31:55 EDT 2021
  endTime: Mon May 31 21:31:55 EDT 2021
  status: FAILURE
  statusMessage: There is an error while trying to ingest data for this load rule PON_PCC_NEGOTIATIONS_UTIL_PVT.get_ecc_data_load_info with dataset pon-pcc-neg for job 21,343 ORA-00942: table or view does not exist


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Purchasing repsonsibility > Requests > Submit New Request
2. Choose PO ECC Strategic Sourcing Data Load
3. Choose Full Load
4. Submit
5. Click View Log when finished the run.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.