Symptoms

• In 11i.5.10 release while setting up ARNL flexfields sometimes it is not possible to save the entered values.

• In 11i.5.10 release the ARNL remittance request runs into error: ORA-04063: package body "APPS.XXDBI_BATCHES_PKG" has errors has been detected in LOAD_AI_LINES

When writing quickly a query on customers (e.g. to check the data migration), it's not always easy to find your way through the TCA tables. I use this overview of tables with (foreign) keys to make life a bit easier. Hint: try to start with the views, as they contain already a lot of useful information!