Invoice Approval Not Reflected In Holds & Approval Section Of Invoice Lines (Doc ID 2259361.1)

Last updated on APRIL 26, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Manage Invoices-Audit Invoices

When attempting to review approval history on the Holds and Approvals tab - there is no line for "APPROVED" even though the WFAPPROVAL_STATUS is WFAPPROVED
Reviewing the AP_INV_APRVL_HIST_ALL table there is no line with a RETURN of "APPROVED"
Looking at the SOA server
the following error occurs.

ERROR
-----------------------
Error
[BusinessFault : {http://xmlns.oracle.com/apps/financials/payables/invoices/transactions/invoiceApprovalService/}ServiceException. Client received SOAP Fault from server : MOAC Priv Name cannot be null; Initialize MOAC
Unable to invoke endpoint URI "http://fin-internal.oracleoutsourcing.com:10603/finApInvTransactions/InvoiceApprovalBCService" successfully due to: javax.xml.soap.SOAPException: javax.xml.soap.SOAPException: Message send failed: Read timed out
oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException: Client received SOAP Fault from server : JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=Null connection passed to attachSession

Also from workflow trace
 Nov 14, 2016 10:00:04 PM Updated variable "InvokeAttTaskAttachmentsToUCMAsync_addTaskDetailsAttachmentsToUCMAsync_InputVariable"Updated variable "InvokeAttTaskAttachmentsToUCMAsync_addTaskDetailsAttachmentsToUCMAsync_InputVariable"
Nov 14, 2016 10:00:04 PM Completed assignCompleted assign
InvokeAttTaskAttachmentsToUCMAsync (pending)InvokeAttTaskAttachmentsToUCMAsync (pending)
Nov 14, 2016 10:00:04 PM Started invocation of operation "addTaskDetailsAttachmentsToUCMAsync" on partner "ApprovalHistoryUtilService_Idempotent".Started invocation of operation "addTaskDetailsAttachmentsToUCMAsync" on partner "ApprovalHistoryUtilService_Idempotent".
Nov 14, 2016 10:00:04 PM Invoked 1-way operation "addTaskDetailsAttachmentsToUCMAsync" on partner "ApprovalHistoryUtilService_Idempotent".Invoked 1-way operation "addTaskDetailsAttachmentsToUCMAsync" on partner "ApprovalHistoryUtilService_Idempotent".
View Payload
Nov 14, 2016 10:02:05 PM The transaction was rolled back. The work performed for bpel instance "534809" was rolled back to the previous dehydration point, but the audit trail has been saved.You can recover the instance from the recovery console by resubmitting the callback message or activity for execution.The transaction was rolled back. The work performed for bpel instance "534809" was rolled back to the previous dehydration point, but the audit trail has been saved.You can recover the instance from the recovery console by resubmitting the callback message or activity for execution.

Identify the issue by the following query
select * from ap_invoices_all WHERE WFAPPROVAL_STATUS = 'WFAPPROVED' and
invoice_id not in (select distinct invoice_id from AP_INV_APRVL_HIST_ALL where
RESPONSE = 'APPROVED')


The status of the transaction is FAULTED.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter a manual invoice
2. Submit for Approval

Due to this issue, users cannot determine if an invoice went through the entire approval process or not.

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