AP Invoice auto rejected After Upgrade To R12

(Doc ID 2325066.1)

Last updated on NOVEMBER 05, 2017

Applies to:

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

Symptoms

After upgrade to R12 , invoice approvals are not working. Invoices are getting auto rejeced
Following error is shown in the log when invoices are sent for approval

BusinessFault : {http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/invoiceApprovalService/}ServiceException. Client received SOAP Fault from server : JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122. Please contact service provider on details.

0com.oracle.bpel.client.BPELFault: faultName: {{http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/invoiceApprovalService/}ServiceException} messageType: {{http://xmlns.oracle.com/adf/svc/errors/}ServiceException} parts: {{ ServiceErrorMessage=<tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><tns:code>27122</tns:code><tns:message>JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27122. Please contact service provider on details.</tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:detail xsi:type="tns:ServiceErrorMessage"><tns:message>ORA-00904: "APINVOICESALL"."ROUTING_STATUS_LOOKUP_CODE": invalid identifier </tns:message><tns:severity>SEVERITY_ERROR</tns:severity><tns:exceptionClassName>java.sql.SQLSyntaxErrorException</tns:exceptionClassName></tns:detail><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"><ns0:fetchStart>0</ns0:fetchStart><ns0:fetchSize>-1</ns0:fetchSize><ns0:filter><ns0:group><ns0:conjunction>And</ns0:conjunction><ns0:upperCaseCompare>false</ns0:upperCaseCompare><ns0:item><ns0:upperCaseCompare>false</ns0:upperCaseCompare><ns0:attribute>InvoiceId</ns0:attribute><ns0:operator>=</ns0:operator><ns0:value>7499</ns0:value></ns0:item></ns0:group></ns0:filter><ns0:excludeAttribute>false</ns0:excludeAttribute></tns:sdoObject><tns:exceptionClassName>oracle.jbo.SQLStmtException</tns:exceptionClassName></tns:ServiceErrorMessage>} cause: {null}

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