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
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) |