Payment accounting stuck in partial status.

Hi All,

We have a payment which is accounted as Partial. We created a data fix to account this payment and manual JE was created in GL.

Data Fix:

Begin

update xla_events
set event_status_code='P', Process_status_code='P'
where event_id=63494431;

DBMS_OUTPUT.PUT_LINE ( SQL%ROWCOUNT || ' Rows Updated in xla_events table ');

update apps.xla_ae_headers
set GL_TRANSFER_STATUS_CODE='Y',ACCOUNTING_ENTRY_STATUS_CODE='F'
where application_id=200
and description='Payment Created , Payment Number: 48 , Payment Date: 09-APR-15 , Bank Name: HCY USA AP WIRES , Payment Currency Code USD';

DBMS_OUTPUT.PUT_LINE ( SQL%ROWCOUNT || ' Rows Updated in xla_ae_headers table ');