You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

HDL error: Attempt to set a parameter name that does not occur in the SQL: pEffectiveDatedFlag

edited Feb 24, 2025 7:36PM in HCM Data Loader (HDL) 2 comments

Getting HDL load error of:

  • Error 1 : An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: Attempt to set a parameter name that does not occur in the SQL: pEffectiveDatedFlag.

While attempting to load a single HDL file for the TaxWithholding business object in 25A I get that error. It worked fine in 24D.

HCM 25A

Error Stack

java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: pEffectiveDatedFlag at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:11898) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:661) at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setObjectAtName(Unknown Source) at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:4581) at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3724) at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:25504) at oracle.apps.hcm.common.core.HcmViewObjectImpl.bindParametersForCollection(HcmViewObjectImpl.java:8324) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1487) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:1051) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:9231) at oracle.apps.fnd.applcore.oaext.model.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:2851) at oracle.apps.hcm.common.core.HcmViewObjectImpl.executeQueryForCollection(HcmViewObjectImpl.java:8561) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1528) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2965) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2940) at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2934) at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1695) at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:4227) at oracle.apps.hcm.common.core.helper.BaseKeyAttributeHelper.findMatchingValue(BaseKeyAttributeHelper.java:1550) at oracle.apps.hcm.payrolls.cir.service.common.helper.CardDirCardIdHelper.findMatchingValue(CardDirCardIdHelper.java:111) at oracle.apps.hcm.common.core.helper.BaseKeyAttributeHelper.getObjectId(BaseKeyAttributeHelper.java:220) at oracle.apps.hcm.common.core.helper.BaseKeyAttributeHelper.resolve(BaseKeyAttributeHelper.java:2112) at oracle.apps.hcm.common.core.helper.KeyHelperContext.executeHelper(KeyHelperContext.java:807) at oracle.apps.hcm.common.core.helper.KeyHelperContext.resolve(KeyHelperContext.java:451) at oracle.apps.hcm.common.core.helper.KeyHelperContext.resolve(KeyHelperContext.java:928) at sun.reflect.GeneratedMethodAccessor2186.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:501) at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:101) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1217) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1041) at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHelper.java:999) at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:990) at oracle.jbo.script.groovy.ExprGroovyScriptEngineImpl.invokeJavaMethod(ExprGroovyScriptEngineImpl.java:619) at oracle.jbo.script.ExprScriptContext.invokeJavaMethod(ExprScriptContext.java:462) at oracle.jbo.script.ExprValueSupplierWrapper.invokeMethod(ExprValueSupplierWrapper.java:275) at sun.reflect.GeneratedMethodAccessor1623.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:501) at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:101)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!