Cash Advance Approval Not Working error: "JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122." (Doc ID 2158861.1)

Last updated on JULY 08, 2016

Applies to:

Oracle Fusion Expenses Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.10.0.0 version, Manage Expenses-Approve Expense Report

Cash Advance approval not working.

Cash advance needs to get routed to the supervisor. However, it is not going to the supervisor.

Fault message show as below:

<bpelFault><faultType>0</faultType><entityInternalNestedError xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>com.oracle.bpel.client.BPELFault: faultName: {{http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseWorkflowService/}ServiceException} messageType: {{http://xmlns.oracle.com/adf/svc/errors/}ServiceException} parts: {{ ServiceErrorMessage=&lt;tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">&lt;tns:code>27122&lt;/tns:code>&lt;tns:message>JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122. Please contact service provider on details.&lt;/tns:message>&lt;tns:severity>SEVERITY_ERROR&lt;/tns:severity>&lt;tns:detail xsi:type="tns:ServiceErrorMessage">&lt;tns:message>ORA-00907: missing right parenthesis &lt;/tns:message>&lt;tns:severity>SEVERITY_ERROR&lt;/tns:severity>&lt;tns:exceptionClassName>java.sql.SQLSyntaxErrorException&lt;/tns:exceptionClassName>&lt;/tns:detail>&lt;tns:sdoObject
xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/"
xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:type="ns0:FindCriteria">&lt;ns0:fetchStart>0&lt;/ns0:fetchStart>&lt;ns0:fetchSize>-1&lt;/ns0:fetchSize>&lt;ns0:filter>&lt;ns0:group>&lt;ns0:conjunction>And&lt;/ns0:conjunction>&lt;ns0:upperCaseCompare>false&lt;/ns0:upperCaseCompare>&lt;ns0:item>&lt;ns0:upperCaseCompare>false&lt;/ns0:upperCaseCompare>&lt;ns0:attribute>CashAdvanceId&lt;/ns0:attribute>&lt;ns0:operator>=&lt;/ns0:operator>&lt;ns0:value>300000072734640&lt;/ns0:value>&lt;/ns0:item>&lt;/ns0:group>&lt;/ns0:filter>&lt;ns0:excludeAttribute>false&lt;/ns0:excludeAttribute>&lt;/tns:sdoObject>&lt;tns:exceptionClassName>oracle.jbo.SQLStmtException&lt;/tns:exceptionClassName>&lt;/tns:ServiceErrorMessage>} cause: {null} </summary></part></entityInternalNestedError></bpelFault>


 

Solution

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