XLA_EVENT.EVENT_STATUS_CODE UPDATED UNEXPECTEDLY
Last updated on FEBRUARY 20, 2017
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
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.
1.Create two foreign currency invoices.
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.
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!
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms