XLA_EVENT.EVENT_STATUS_CODE UPDATED UNEXPECTEDLY (Doc ID 2233893.1)

Last updated on FEBRUARY 20, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

As known,
when payables option Require Exchange Rate Entry is off,
we can create payment without rate and the EVENT_STATUS_CODE of the Payment Created event will be set to I(Incomplete).

But we found when creating payment on payment workbench,
by certain steps,
it will update EVENT_STATUS_CODE from I to U(Unprocessed) unexpectedly for
the event of ANOTHER payment that customer is not operating on.

Reproducible steps
----------
1.Create two foreign currency invoices.
20161103_s001
20161103_s002

2.On invoice workbench, find the first invoice and do Pay in Full

3.On payment workbench, enter required fields and save.
Note message APP-SQLAP-10020 will be shown, click OK.

Now check the XLA_EVENT table, we can see the EVENT_STATUS_CODE of the payment event is set to I
which is correct.

XLA_EVENTS (Payment)
EVENT_ID: 2140216
EVENT_STATUS_CODE: I

4.Click close icon X of payment workbench, go back to invoice workbench.
And find the second invoice.

5.Do Pay in Full for the second invoice.

6.After payment workbench open,
go back to check the EVENT_STATUS_CODE of the first payment's event,
it's changed to U unexpectedly!

XLA_EVENTS (Payment)
EVENT_ID: 2140216
EVENT_STATUS_CODE: U
----------

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