Can Not Remove A Payment Document From A Payment Process Request (Doc ID 1644147.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

During the processing of a payment process request, in review proposed payments setup, when trying to remove a payment the following error happens:

You have encountered an unexpected error. Please contact the System Administrator for assistance




The error stack says the following:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT r.calling_app_id, r.created_by, r.payment_service_request_id, r.creation_date, r.call_app_pay_service_req_code, fa.application_name, fu.user_name, r.payment_service_request_status FROM iby_pay_service_requests r, fnd_application_vl fa, fnd_user fu WHERE r.payment_service_request_id = :1 AND r.calling_app_id = fa.application_id(+) AND r.created_by = fu.user_id(+) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:761) at oracle.apps.iby.disbursement.transaction.payment.webui.ReviewProposedPaymentsCO.processRequest(ReviewProposedPaymentsCO.java:76) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1191) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at ....

...

 ## Detail 0 ## java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
...

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms