ECC Run Data Load ECCRUNDL Errors: unable to find valid certification path (Doc ID 2919731.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

On : 12.2 version, Enterprise Command Center

When running ECCRUNDL: ECC Run Data Load  for any application (ex. AP, PO, FA, ICX, etc) the concurrent program fails in error:

ERROR
-----------------------
Log Level -> ERROR
Running Metadata Load
JobId -> -1
data load concurrent program failed
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
- Java Concurrent Request Id: 118843197
- Apps Context Session Id: 0x4d95e9c4
- JDBC Connection String: oracle.jdbc.driver.T4CConnection@4c0d6ce
- Database Session AUDSID: 407740919
- FND_GLOBAL Concurrent Request Id: 118843197

STEPS TO REPRODUCE
-----------------------
Note: This can occur in any EBS ECC product application (ex. Accounts Payables (AP), Purchasing (PO), Fixed Assets (FA), iProcurement (ICX), etc)

1. Log into the ECC Developer
2. Left menu frame > Home > Administration
3. Data Load Submission > Enter criteria for Data Load parameters:
- Application Name (select from List of Values (LOV))
- Data Set (select from LOV for specifics for the application selected above)
- Load Type (select from LOV desired Load Type)
- Default Language:US
- Languages: (select any other desired languages)
- Log Level (select type and level of debugging/tracing)
- Enable SQL Trace:  (Click checkbox for sql trace during concurrent request submittal)
4. Click Submit button
5. Data Load Tracking > Concurrent Requests screen displays
6. Locate concurrent request >  Review Status column
7. Red exclamation icon shows Failed > On far right of row locate down arrow to download log file
8. Log file captures error

Changes

ECC V5 to V8 upgrade.

Cause

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