My Oracle Support Banner

R12. AP: XLA: XLA_EVENT.EVENT_STATUS_CODE is Updated Unexpectedly to U (Doc ID 2233893.1)

Last updated on FEBRUARY 17, 2019

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,
users can create payment without rate and the EVENT_STATUS_CODE of the Payment Created event will be set to I(Incomplete).

But ysers 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.
Invoice number "A"
Invoice number "B"

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: XXXX
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: XXXX
EVENT_STATUS_CODE: U
----------

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.