My Oracle Support Banner

Procurement Command Center (Enterprise Command Center), Error Occurs When Running the PO PCC ECC Data Load. (Doc ID 2676739.1)

Last updated on JULY 07, 2020

Applies to:

Oracle Purchasing - Version 12.2.8 and later
Information in this document applies to any platform.
ECCRUNDL: ECC Run Data Load

Symptoms

In Oracle Purchasing, Release 12.2.8, with Procurement Command Center (Enterprise Command Center) v4, 

Getting error when running the PO PCC ECC Data Load

ERROR

ERROR 1.o.e.i.u.s.i.IRDataLoadServiceImpl - mAuditRequest.getApplication().getApplicationShortName() po_pcc, datasetKey null loadtype FULL_LOAD11:03:56.293 [pool-4-thread-2] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - getSingleResult()
did not retrieve any entities.; nested exception is javax.persistence.NoResultException: getSingleResult() did not retrieve any entities.org.springframework.dao.EmptyResultDataAccessException: getSingleResult() did not retrieve any entities.; nested exception is javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:392) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE] at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible
(AbstractEntityManagerFactoryBean.java:491) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE] at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
..


Steps to reproduce:

1. Responsibility: Purchasing

2. Navigate to: Reports > Run

3. Submit the request "PO PCC ECC Data Load"
   Parameters:
   - System Name = EBS
   - Load Type = FULL_LOAD
   - Log Level = Error

This spawns two requests:
 - PO PCC ECC Data Load - completed successfully
 - ECC - Run Data Load - completed with error

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
Cause
Solution
References


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