This table shows the interface tables and the TCA tables that the data would be imported into. The interface tables do not include any columns that have been made obsolete in TCA.
| Entity | Interface Table | TCA Table |
|---|---|---|
| Addresses | HZ_IMP_ADDRESSES_INT | HZ_LOCATIONS HZ_PARTY_SITES |
| Address Uses | HZ_IMP_ADDRESSUSES_INT | HZ_PARTY_SITE_USES |
| Classifications | HZ_IMP_CLASSIFICS_INT | HZ_CODE_ASSIGNMENTS |
| Credit Ratings | HZ_IMP_CREDITRTNGS_INT | HZ_CREDIT_RATINGS |
| Contact Points | HZ_IMP_CONTACTPTS_INT | HZ_CONTACT_POINTS |
| Financial Numbers | HZ_IMP_FINNUMBERS_INT | HZ_FINANCIAL_NUMBERS |
| Financial Reports | HZ_IMP_FINREPORTS_INT | HZ_FINANCIAL_REPORTS |
| Parties | HZ_IMP_PARTIES_INT | HZ_PARTIES HZ_PERSON_PROFILES HZ_ORGANIZATION_PROFILES |
| Relationships | HZ_IMP_RELSHIPS_INT | HZ_RELATIONSHIPS HZ_ORG_CONTACTS (optional) HZ_PARTIES |
| Contacts | HZ_IMP_CONTACTS_INT | HZ_RELATIONSHIPS HZ_ORG_CONTACTS HZ_PARTIES |
| Contact Roles | HZ_IMP_CONTACTROLES_INT | HZ_ORG_CONTACT_ROLES |
See: Bulk Import Interface Tables, Oracle Trading Community Architecture Reference Guide.
The parent and child relationships among the import interface tables are:
HZ_IMP_PARTIES_INT is the parent of all interface tables.
HZ_IMP_FINREPORTS_INT is the parent of HZ_IMP_FINNUMBERS_INT.
HZ_IMP_ADDRESSES_INT is the parent of HZ_IMP_ADDRESSUSES_INT.
HZ_IMP_CONTACTS_INT is the parent of HZ_IMP_CONTACTROLES_INT, and potentially HZ_IMP_ADDRESSES_INT and HZ_IMP_CONTACTPTS_INT because addresses and contact points can be defined at the contact level.
If a child entity record has an error, the parent entity record can still be imported if it has no errors. If a parent entity record has errors, however, all related child entity records will also fail.