Oracle Fusion AP Invoice - Changed GL Code Combination Query

Liaqat Hussain

Hello Members,

I hope you're doing well.

I have a query regarding Oracle Fusion Accounts Payables (AP) module.

When an invoice is created in the AP module, it gets posted to a specific GL code combination. However, if later the code combination (GL string) is changed or updated, I would like to know how to extract that updated combination from the system.

Specifically, I need to query the updated (changed) code combination against the same invoice.

Could anyone please guide me:

Which tables track such changes?

How can I get the latest/changed GL combination linked to an invoice?

Your support would be greatly appreciated.

Regards,

Walid

gclampitt

Hello the majority of Finance tables are not data-tracked like HR.
If you change the GL combination, you are just overwriting it, so the previous value is lost.

I think the only way to track the previous value, is to turn on auditing but this would add an overhead to the system, so its not really recommended unless absolutely required.

There will be several posts in this forum around auditing