Interface_status column in ra_interface_distributions_all table is not being updated to 'P'.

We could see the distributions are getting successfully inserted into ra_cust_trx_line_gl_dist_all for the invoices but, the interface_status column in ra_interface_distributions_all table is not being updated to 'P'. this is causing multiple duplicate lines and resulting in amount issues.

But the same column in ra_interface_lines_all is correctly updated.

For Example:

We have already an invoice created for A1 org with some distributions, and when the intercompany invoice is getting created for A2 org, it is picking up the A2 org's distributions along with A1 org's distributions too which is leading to duplicate lines. not sure if those distributions are being picked based on order number.