This chapter describes about bulk import.
This chapter covers the following topics:
The interface tables for TCA Bulk Import are:
Aside from the validations specified for each column, you should also be familiar with general validations that apply for entering data, for example through user interfaces.
If a column is described as not updateable, the import process ignores any passed value unless specified otherwise. This rule applies only to interface table records that update existing records in the TCA Registry.
Refer to the Oracle eBusiness Suite Electronic Technical Reference Manual for additional information about the interface tables, including:
Description of the column value
Data type
Column length
Requirement, whether the column needs a value or can be left null
Related Topics
Loading Data into the Interface Tables, Oracle Trading Community Architecture User Guide
The HZ_IMP_ADDRESSES_INT table contains address information to be imported into these TCA tables:
HZ_LOCATIONS
HZ_PARTY_SITES
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
SITE_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SITE_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
CORRECT_MOVE_INDICATOR | C, M, or NULL | None |
ADDRESS1 |
|
HZ_LOCATIONS.ADDRESS1 |
ADDRESS2 | None | HZ_LOCATIONS.ADDRESS2 |
ADDRESS3 | None | HZ_LOCATIONS.ADDRESS3 |
ADDRESS4 | None | HZ_LOCATIONS.ADDRESS4 |
ADDRESS_LINES_PHONETIC | None | HZ_LOCATIONS.ADDRESS_LINES_PHONETIC |
CITY | None | HZ_LOCATIONS.CITY |
CLLI_CODE | None | HZ_LOCATIONS.CLLI_CODE |
COUNTRY |
|
HZ_LOCATIONS.COUNTRY |
COUNTY | None | HZ_LOCATIONS.COUNTY |
DELIVERY_POINT_CODE | None | HZ_LOCATIONS.DELIVERY_POINT_CODE |
DESCRIPTION | None | HZ_LOCATIONS.DESCRIPTION |
LANGUAGE | Foreign key to FND_LANGUAGES.LANGUAGE_CODE with INSTALLED_FLAG in B (Base Language) or I (Installed Language) | HZ_LOCATIONS.LANGUAGE |
LOCATION_DIRECTIONS | None | HZ_LOCATIONS.LOCATION_DIRECTIONS |
POSTAL_CODE | None | HZ_LOCATIONS.POSTAL_CODE |
POSTAL_PLUS4_CODE | None | HZ_LOCATIONS.POSTAL_PLUS4_CODE |
PROVINCE | None | HZ_LOCATIONS.PROVINCE |
SALES_TAX_GEOCODE | None | HZ_LOCATIONS.SALES_TAX_GEOCODE |
SALES_TAX_INSIDE_CITY_LIMITS | None | HZ_LOCATIONS.SALES_TAX_INSIDE_CITY_LIMITS |
SHORT_DESCRIPTION | None | HZ_LOCATIONS.SHORT_DESCRIPTION |
STATE | None | HZ_LOCATIONS.STATE |
TIMEZONE_CODE | Foreign key to HZ_TIMEZONES.TIMEZONE_ID | HZ_LOCATIONS.TIMEZONE_ID |
ATTRIBUTE_CATEGORY | None | HZ_LOCATIONS.ATTRIBUTE_CATEGORY |
ATTRIBUTE1 to ATTRIBUTE20 | None | HZ_LOCATIONS.ATTRIBUTE1 to HZ_LOCATIONS.ATTRIBUTE20 |
ADDRESS1_STD |
|
HZ_LOCATIONS.ADDRESS1 |
ADDRESS2_STD | None | HZ_LOCATIONS.ADDRESS2 |
ADDRESS3_STD | None | HZ_LOCATIONS.ADDRESS3 |
ADDRESS4_STD | None | HZ_LOCATIONS.ADDRESS4 |
CITY_STD | None | HZ_LOCATIONS.CITY |
PROV_STATE_ADMIN_CODE_STD | None | HZ_LOCATIONS.STATE if HZ_IMP_ADDRESSES_INT.STATE is not null. Otherwise, HZ_LOCATIONS.PROVINCE if HZ_IMP_ADDRESSES_INT.PROVINCE is not null. If both HZ_IMP_ADDRESSES_INT.STATE and HZ_IMP_ADDRESSES_INT.PROVINCE are null, then HZ_LOCATIONS.STATE. |
COUNTY_STD | None | HZ_LOCATIONS.COUNTY |
COUNTRY_STD |
|
HZ_LOCATIONS.COUNTRY |
POSTAL_CODE_STD | None | HZ_LOCATIONS.POSTAL_CODE |
ACCEPT_STANDARDIZED_FLAG | None | None |
ADAPTER_CONTENT_SOURCE | None | None |
ADDR_VALID_STATUS_CODE | Populate only if ACCEPT_STANDARDIZED_FLAG is Y | HZ_LOCATIONS.VALIDATION_STATUS_CODE |
DATE_VALIDATED |
|
HZ_LOCATIONS.DATE_VALIDATED |
PARTY_SITE_NAME | None | HZ_PARTY_SITES.PARTY_SITE_NAME |
PARTY_SITE_NUMBER |
|
HZ_PARTY_SITES.PARTY_SITE_NUMBER |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
VALIDATION_BATCH_ID | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_PARTY_SITES.CREATED_BY_MODULE |
PRIMARY_FLAG | Y, N, or NULL | HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG |
The HZ_IMP_ADDRESSUSES_INT table contains address use information to be imported into the TCA table HZ_PARTY_SITE_USES.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
SITE_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SITE_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
SITE_USE_TYPE |
|
HZ_PARTY_SITE_USES.SITE_USE_TYPE |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_PARTY_SITES.CREATED_BY_MODULE |
PRIMARY_FLAG | Y, N, or NULL | HZ_PARTY_SITE_USES.PRIMARY_FLAG |
The HZ_IMP_CLASSIFICS_INT table contains classification information to be imported into the TCA table HZ_CODE_ASSIGNMENTS.
Within the same content source type, there should be no overlapping assignments for the same party and classification, or class category and class code combination.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
CLASS_CATEGORY |
|
HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY |
CLASS_CODE |
|
HZ_CODE_ASSIGNMENTS.CLASS_CODE |
START_DATE_ACTIVE |
|
HZ_CODE_ASSIGNMENTS.START_DATE_ACTIVE |
END_DATE_ACTIVE | Must be NULL or greater than START_DATE_ACTIVE | HZ_CODE_ASSIGNMENTS.END_DATE_ACTIVE |
RANK | None | HZ_CODE_ASSIGNMENTS.RANK |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory | HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE |
PRIMARY_FLAG | Y, N, or NULL | HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG |
The HZ_IMP_CONTACTPTS_INT table contains contact point information to be imported into the TCA table HZ_CONTACT_POINTS.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
CP_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
CP_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
SITE_ORIG_SYSTEM | ORIG_SYSTEM lookup | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SITE_ORIG_SYSTEM_REFERENCE | None | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
CONTACT_POINT_TYPE |
|
HZ_CONTACT_POINTS.CONTACT_POINT_TYPE |
CONTACT_POINT_PURPOSE | CONTACT_POINT_PURPOSE lookup. If WEB for CONTACT_POINT_TYPE, then CONTACT_POINT_PURPOSE_WEB lookup. | HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE |
EDI_ECE_TP_LOCATION_CODE | None | HZ_CONTACT_POINTS.EDI_ECE_TP_LOCATION_CODE |
EDI_ID_NUMBER | None | HZ_CONTACT_POINTS.EDI_ID_NUMBER |
EDI_PAYMENT_FORMAT | None | HZ_CONTACT_POINTS.EDI_PAYMENT_FORMAT |
EDI_PAYMENT_METHOD | None | HZ_CONTACT_POINTS.EDI_PAYMENT_METHOD |
EDI_REMITTANCE_INSTRUCTION | None | HZ_CONTACT_POINTS.EDI_REMITTANCE_INSTRUCTION |
EDI_REMITTANCE_METHOD | None | HZ_CONTACT_POINTS.EDI_REMITTANCE_METHOD |
EDI_TP_HEADER_ID | None | HZ_CONTACT_POINTS.EDI_TP_HEADER_ID |
EDI_TRANSACTION_HANDLING | None | HZ_CONTACT_POINTS.EDI_TRANSACTION_HANDLING |
EFT_PRINTING_PROGRAM_ID | None | HZ_CONTACT_POINTS.EFT_PRINTING_PROGRAM_ID |
EFT_SWIFT_CODE | None | HZ_CONTACT_POINTS.EFT_SWIFT_CODE |
EFT_TRANSMISSION_PROGRAM_ID | None | HZ_CONTACT_POINTS.EFT_TRANSMISSION_PROGRAM_ID |
EFT_USER_NUMBER | None | HZ_CONTACT_POINTS.EFT_USER_NUMBER |
EMAIL_ADDRESS | Mandatory if CONTACT_POINT_TYPE is EMAIL | HZ_CONTACT_POINTS.EMAIL_ADDRESS |
EMAIL_FORMAT | If CONTACT_POINT_TYPE is EMAIL:
|
HZ_CONTACT_POINTS.EMAIL_FORMAT |
PHONE_AREA_CODE | None | HZ_CONTACT_POINTS.PHONE_AREA_CODE |
PHONE_CALLING_CALENDAR | None | HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR |
PHONE_COUNTRY_CODE | Foreign key to HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE if CONTACT_POINT_TYPE is PHONE | HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE |
PHONE_EXTENSION | None | HZ_CONTACT_POINTS.PHONE_EXTENSION |
PHONE_LINE_TYPE |
|
HZ_CONTACT_POINTS.PHONE_LINE_TYPE |
PHONE_NUMBER | If CONTACT_POINT_TYPE is PHONE, either PHONE_NUMBER or RAW_PHONE_NUMBER must be passed, but not both at the same time | HZ_CONTACT_POINTS.PHONE_NUMBER |
RAW_PHONE_NUMBER | If CONTACT_POINT_TYPE is PHONE, either PHONE_NUMBER or RAW_PHONE_NUMBER must be passed, but not both at the same time | HZ_CONTACT_POINTS.RAW_PHONE_NUMBER |
TELEX_NUMBER | Mandatory if CONTACT_POINT_TYPE is TLX | HZ_CONTACT_POINTS.TELEX_NUMBER |
TIMEZONE_CODE | Foreign key to HZ_TIMEZONES.TIMEZONE_ID if CONTACT_POINT_TYPE is PHONE | HZ_CONTACT_POINTS.TIMEZONE_ID |
URL | Mandatory if CONTACT_POINT_TYPE is WEB | HZ_CONTACT_POINTS.URL |
WEB_TYPE | Mandatory if CONTACT_POINT_TYPE is WEB | HZ_CONTACT_POINTS.WEB_TYPE |
ATTRIBUTE_CATEGORY | None | HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY |
ATTRIBUTE1 TO ATTRIBUTE20 | None | HZ_CONTACT_POINTS.ATTRIBUTE1 to HZ_CONTACT_POINTS.ATTRIBUTE20 |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_CONTACT_POINTS.CREATED_BY_MODULE |
PRIMARY_FLAG | Y, N, or NULL | HZ_CONTACT_POINTS.PRIMARY_FLAG |
The HZ_IMP_CONTACTROLES_INT table contains contact role information to be imported into the TCA table HZ_ORG_CONTACT_ROLES.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
CONTACT_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
CONTACT_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
SUB_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SUB_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
ROLE_TYPE |
|
HZ_ORG_CONTACT_ROLES.ROLE_TYPE |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_ORG_CONTACT_ROLES.CREATED_BY_MODULE |
The HZ_IMP_CONTACTS_INT table contains contact information to be imported into these TCA tables:
HZ_RELATIONSHIPS
HZ_ORG_CONTACTS
HZ_PARTIES
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
CONTACT_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
CONTACT_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
SUB_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SUB_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
OBJ_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
OBJ_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
CONTACT_NUMBER | Use value if passed; otherwise, automatically generate from sequence | HZ_ORG_CONTACTS.CONTACT_NUMBER |
DEPARTMENT_CODE | DEPARTMENT_TYPE lookup | HZ_ORG_CONTACTS.DEPARTMENT_CODE |
DEPARTMENT | None | HZ_ORG_CONTACTS.DEPARTMENT |
TITLE | CONTACT_TITLE lookup | HZ_ORG_CONTACTS.TITLE |
JOB_TITLE | None | HZ_ORG_CONTACTS.JOB_TITLE |
JOB_TITLE_CODE | RESPONSIBILITY lookup | HZ_ORG_CONTACTS.JOB_TITLE_CODE |
DECISION_MAKER_FLAG | Y, N, or NULL | HZ_ORG_CONTACTS.DECISION_MAKER_FLAG |
REFERENCE_USE_FLAG | Y, N, or NULL | HZ_ORG_CONTACTS.REFERENCE_USE_FLAG |
COMMENTS | None | HZ_ORG_CONTACTS.COMMENTS |
RELATIONSHIP_TYPE |
|
HZ_RELATIONSHIPS.RELATIONSHIP_TYPE |
RELATIONSHIP_CODE |
|
HZ_RELATIONSHIPS.RELATIONSHIP_CODE |
START_DATE | Cannot be updated to NULL | HZ_RELATIONSHIPS.START_DATE |
END_DATE | None | HZ_RELATIONSHIPS.END_DATE |
REL_COMMENTS | None | HZ_RELATIONSHIPS.COMMENTS |
ATTRIBUTE_CATEGORY | None | HZ_RELATIONSHIPS.ATTRIBUTE_CATEGORY |
ATTRIBUTE1 to ATTRIBUTE20 | None | HZ_RELATIONSHIPS.ATTRIBUTE1 to HZ_RELATIONSHIPS.ATTRIBUTE20 |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_ORG_CONTACTS.CREATED_BY_MODULE |
The HZ_IMP_CREDITRTNGS_INT table contains credit rating information to be imported into the TCA table HZ_CREDIT_RATINGS.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
RATED_AS_OF_DATE | Not updateable | HZ_CREDIT_RATINGS.RATED_AS_OF_DATE |
RATING_ORGANIZATION | Not updateable | HZ_CREDIT_RATINGS.RATING_ORGANIZATION |
AVG_HIGH_CREDIT | None | HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT |
BANKRUPTCY_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.BANKRUPTCY_IND |
BUSINESS_DISCONTINUED | None | HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED |
CLAIMS_IND | None | HZ_CREDIT_RATINGS.CLAIMS_IND |
COMMENTS | None | HZ_CREDIT_RATINGS.COMMENTS |
CR_SCR_CLAS_EXPL | None | HZ_CREDIT_RATINGS.CR_SCR_CLAS_EXPL |
CREDIT_SCORE | None | HZ_CREDIT_RATINGS.CREDIT_SCORE |
CREDIT_SCORE_AGE | None | HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE |
CREDIT_SCORE_CLASS | None | HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS |
CREDIT_SCORE_COMMENTARY to CREDIT_SCORE_COMMENTARY10 | CREDIT_SCORE_COMMENTARY lookup | HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY to HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY10 |
CREDIT_SCORE_DATE | None | HZ_CREDIT_RATINGS.CREDIT_SCORE_DATE |
CREDIT_SCORE_INCD_DEFAULT | None | HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT |
CREDIT_SCORE_NATL_PERCENTILE | None | HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE |
CREDIT_SCORE_OVERRIDE_CODE | FAILURE_SCORE_OVERRIDE_CODE lookup | HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE |
CRIMINAL_PROCEEDING_IND | None | HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND |
DEBARMENT_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.DEBARMENT_IND |
DEBARMENTS_COUNT | None | HZ_CREDIT_RATINGS.DEBARMENTS_COUNT |
DEBARMENTS_DATE | None | HZ_CREDIT_RATINGS.DEBARMENTS_DATE |
DELQ_PMT_PCTG_FOR_ALL_FIRMS | None | HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS |
DELQ_PMT_RNG_PRCNT | None | HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT |
DESCRIPTION | None | HZ_CREDIT_RATINGS.DESCRIPTION |
DET_HISTORY_IND | None | HZ_CREDIT_RATINGS.DET_HISTORY_IND |
DISASTER_IND | None | HZ_CREDIT_RATINGS.DISASTER_IND |
FAILURE_SCORE | None | HZ_CREDIT_RATINGS.FAILURE_SCORE |
FAILURE_SCORE_AGE | None | HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE |
FAILURE_SCORE_CLASS | None | HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS |
FAILURE_SCORE_COMMENTARY to FAILURE_SCORE_COMMENTARY10 | FAILURE_SCORE_COMMENTARY lookup | HZ_CREDIT_RATINGS.FAILURE_SCORE_COMMENTARY to HZ_CREDIT_RATINGS.FAILURE_SCORE_COMMENTARY10 |
FAILURE_SCORE_DATE | None | HZ_CREDIT_RATINGS.FAILURE_SCORE_DATE |
FAILURE_SCORE_INCD_DEFAULT | None | HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT |
FAILURE_SCORE_NATNL_PERCENTILE | None | HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE |
FAILURE_SCORE_OVERRIDE_CODE | FAILURE_SCORE_OVERRIDE_CODE lookup | HZ_CREDIT_RATINGS.FAILURE_SCORE_OVERRIDE_CODE |
FINCL_EMBT_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.FINCL_EMBT_IND |
FINCL_LGL_EVENT_IND | None | HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND |
GLOBAL_FAILURE_SCORE | None | HZ_CREDIT_RATINGS.GLOBAL_FAILURE_SCORE |
HIGH_CREDIT | None | HZ_CREDIT_RATINGS.HIGH_CREDIT |
HIGH_RNG_DELQ_SCR | None | HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR |
JUDGEMENT_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.JUDGEMENT_IND |
LIEN_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.LIEN_IND |
LOW_RNG_DELQ_SCR | None | HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR |
MAXIMUM_CREDIT_CURRENCY_CODE | Foreign key to FND_CURRENCIES.CURRENCY_CODE with Y for CURRENCY_FLAG and Y or N for ENABLED_FLAG | HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE |
MAXIMUM_CREDIT_RECOMMENDATION | None | HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_RECOMMENDATION |
NEGV_PMT_EXPL | None | HZ_CREDIT_RATINGS.NEGV_PMT_EXPL |
NO_TRADE_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.NO_TRADE_IND |
NUM_PRNT_BKCY_CONVS | None | HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS |
NUM_PRNT_BKCY_FILING | None | HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING |
NUM_SPCL_EVENT | None | HZ_CREDIT_RATINGS.NUM_SPCL_EVENT |
NUM_TRADE_EXPERIENCES | None | HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES |
OPRG_SPEC_EVNT_IND | None | HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND |
OTHER_SPEC_EVNT_IND | None | HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND |
PAYDEX_COMMENT | None | HZ_CREDIT_RATINGS.PAYDEX_COMMENT |
PAYDEX_FIRM_COMMENT | None | HZ_CREDIT_RATINGS.PAYDEX_FIRM_COMMENT |
PAYDEX_FIRM_DAYS | None | HZ_CREDIT_RATINGS.PAYDEX_FIRM_DAYS |
PAYDEX_INDUSTRY_COMMENT | None | HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_COMMENT |
PAYDEX_INDUSTRY_DAYS | None | HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS |
PAYDEX_NORM | None | HZ_CREDIT_RATINGS.PAYDEX_NORM |
PAYDEX_SCORE | None | HZ_CREDIT_RATINGS.PAYDEX_SCORE |
PAYDEX_THREE_MONTHS_AGO | None | HZ_CREDIT_RATINGS.PAYDEX_THREE_MONTHS_AGO |
PRNT_BKCY_CHAPTER_CONV | None | HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV |
PRNT_BKCY_CONV_DATE | None | HZ_CREDIT_RATINGS.PRNT_BKCY_CONV_DATE |
PRNT_BKCY_CONV_DATE | None | HZ_CREDIT_RATINGS.PRNT_BKCY_CONV_DATE |
PRNT_BKCY_FILG_CHAPTER | None | HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER |
PRNT_BKCY_FILG_DATE | None | HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_DATE |
PRNT_BKCY_FILG_TYPE | None | HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE |
PRNT_HQ_BKCY_IND | PRNT_HQ_IND lookup | HZ_CREDIT_RATINGS.PRNT_HQ_BKCY_IND |
PUB_REC_EXPL | None | HZ_CREDIT_RATINGS.PUB_REC_EXPL |
RATING | None | HZ_CREDIT_RATINGS.RATING |
SECURED_FLNG_IND | None | HZ_CREDIT_RATINGS.SECURED_FLNG_IND |
SLOW_TRADE_EXPL | None | HZ_CREDIT_RATINGS.SLOW_TRADE_EXPL |
SPCL_EVENT_COMMENT | None | HZ_CREDIT_RATINGS.SPCL_EVENT_COMMENT |
SPCL_EVENT_UPDATE_DATE | None | HZ_CREDIT_RATINGS.SPCL_EVENT_UPDATE_DATE |
SPCL_EVNT_TXT | None | HZ_CREDIT_RATINGS.SPCL_EVNT_TXT |
SUIT_IND | Y, N, or NULL | HZ_CREDIT_RATINGS.SUIT_IND |
SUIT_JUDGE_IND | None | HZ_CREDIT_RATINGS.SUIT_JUDGE_IND |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_CREDIT_RATINGS.CREATED_BY_MODULE |
The HZ_IMP_FINNUMBERS_INT table contains financial number information to be imported into the TCA table HZ_FINANCIAL_NUMBERS.
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
TYPE_OF_FINANCIAL_REPORT | None | None |
DOCUMENT_REFERENCE | None | None |
DATE_REPORT_ISSUED | None | None |
ISSUED_PERIOD | None | None |
REPORT_START_DATE | None | None |
REPORT_END_DATE | None | None |
FINANCIAL_NUMBER_NAME |
|
HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER_NAME |
FINANCIAL_NUMBER | None | HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER |
FINANCIAL_NUMBER_CURRENCY | None | HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER_CURRENCY |
FINANCIAL_UNITS_APPLIED | None | HZ_FINANCIAL_NUMBERS.FINANCIAL_UNITS_APPLIED |
PROJECTED_ACTUAL_FLAG | None | HZ_FINANCIAL_NUMBERS.PROJECTED_ACTUAL_FLAG |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_FINANCIAL_NUMBERS.CREATED_BY_MODULE |
The HZ_IMP_FINREPORTS_INT table contains financial report information to be imported into the TCA table HZ_FINANCIAL_REPORTS.
This combination of values in these columns must be unique:
PARTY_ID
FINANCIAL_REPORT_TYPE
DOCUMENT_REFERENCE
DATE_REPORT_ISSUED
ISSUED_PERIOD or REPORT_START_DATE and REPORT_END_DATE
ACTUAL_CONTENT_SOURCE
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
TYPE_OF_FINANCIAL_REPORT | None | HZ_FINANCIAL_REPORTS.TYPE_OF_FINANCIAL_REPORT |
DOCUMENT_REFERENCE | None | HZ_FINANCIAL_REPORTS.DOCUMENT_REFERENCE |
DATE_REPORT_ISSUED | None | HZ_FINANCIAL_REPORTS.DATE_REPORT_ISSUED |
ISSUED_PERIOD | Either ISSUED_PERIOD alone or the REPORT_START_DATE and REPORT_END_DATE combination is mandatory. Cannot pass both. | HZ_FINANCIAL_REPORTS.ISSUED_PERIOD |
REPORT_START_DATE | Either ISSUED_PERIOD alone or the REPORT_START_DATE and REPORT_END_DATE combination is mandatory. Cannot pass both. | HZ_FINANCIAL_REPORTS.REPORT_START_DATE |
REPORT_END_DATE |
|
HZ_FINANCIAL_REPORTS.REPORT_END_DATE |
AUDIT_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.AUDIT_IND |
CONSOLIDATED_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.CONSOLIDATED_IND |
ESTIMATED_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.ESTIMATED_IND |
FINAL_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.FINAL_IND |
FISCAL_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.FISCAL_IND |
FORECAST_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.FORECAST_IND |
OPENING_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.OPENING_IND |
PROFORMA_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.PROFORMA_IND |
QUALIFIED_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.QUALIFIED_IND |
REQUIRING_AUTHORITY | None | HZ_FINANCIAL_REPORTS.REQUIRING_AUTHORITY |
RESTATED_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.RESTATED_IND |
SIGNED_BY_PRINCIPALS_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.SIGNED_BY_PRINCIPALS_IND |
TRIAL_BALANCE_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.TRIAL_BALANCE_IND |
UNBALANCED_IND | Y, N, or NULL | HZ_FINANCIAL_REPORTS.UNBALANCED_IND |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_FINANCIAL_REPORTS.CREATED_BY_MODULE |
The HZ_IMP_PARTIES_INT table contains party information to be imported into these TCA tables:
HZ_PARTIES
HZ_ORGANIZATION_PROFILES
HZ_PERSON_PROFILES
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
PARTY_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
PARTY_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
PARTY_TYPE |
|
HZ_PARTIES.PARTY_TYPE |
PARTY_ID |
|
None |
PARTY_NUMBER |
|
HZ_PARTIES.PARTY_NUMBER |
SALUTATION | None | HZ_PARTIES.SALUTATION |
ATTRIBUTE_CATEGORY | None | HZ_PARTIES.ATTRIBUTE_CATEGORY |
ATTRIBUTE1 to ATTRIBUTE24 | None | HZ_PARTIES.ATTRIBUTE1 to HZ_PARTIES.ATTRIBUTE24 |
JGZZ_FISCAL_CODE | None | HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE or HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE |
TAX_REFERENCE | OWN_RENT_IND lookup | HZ_ORGANIZATION_PROFILES.TAX_REFERENCE or HZ_PERSON_PROFILES.TAX_REFERENCE |
KNOWN_AS to KNOWN_AS5 | None | HZ_ORGANIZATION_PROFILES.KNOWN_AS to HZ_PARTIES.KNOWN_AS5 or HZ_PERSON_PROFILES.KNOWN_AS to HZ_PARTIES.KNOWN_AS5 |
RENT_OWN_IND | OWN_RENT_IND lookup | HZ_ORGANIZATION_PROFILES.RENT_OWN_IND or HZ_PERSON_PROFILES.RENT_OWN_IND |
ORGANIZATION_NAME |
|
HZ_ORGANIZATION_PROFILES.ORGANIZATION_NAME |
ORGANIZATION_NAME_PHONETIC | None | HZ_ORGANIZATION_PROFILES.ORGANIZATION_NAME_PHONETIC |
ORGANIZATION_TYPE | None | HZ_ORGANIZATION_PROFILES.ORGANIZATION_TYPE |
ANALYSIS_FY | None | HZ_ORGANIZATION_PROFILES.ANALYSIS_FY |
BRANCH_FLAG | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.BRANCH_FLAG |
BUSINESS_SCOPE | None | HZ_ORGANIZATION_PROFILES.BUSINESS_SCOPE |
CEO_NAME | None | HZ_ORGANIZATION_PROFILES.CEO_NAME |
CEO_TITLE | None | HZ_ORGANIZATION_PROFILES.CEO_TITLE |
CONG_DIST_CODE | None | HZ_ORGANIZATION_PROFILES.CONG_DIST_CODE |
CONTROL_YR | None | HZ_ORGANIZATION_PROFILES.CONTROL_YR |
CORPORATION_CLASS | None | HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS |
CURR_FY_POTENTIAL_REVENUE | None | HZ_ORGANIZATION_PROFILES.CURR_FY_POTENTIAL_REVENUE |
NEXT_FY_POTENTIAL_REVENUE | None | HZ_ORGANIZATION_PROFILES.NEXT_FY_POTENTIAL_REVENUE |
PREF_FUNCTIONAL_CURRENCY | None | HZ_ORGANIZATION_PROFILES.PREF_FUNCTIONAL_CURRENCY |
DISADV_8A_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.DISADV_8A_IND |
DO_NOT_CONFUSE_WITH | None | HZ_ORGANIZATION_PROFILES.DO_NOT_CONFUSE_WITH |
DUNS_NUMBER_C | None | HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C |
EMP_AT_PRIMARY_ADR | None | HZ_ORGANIZATION_PROFILES.EMP_AT_PRIMARY_ADR |
EMP_AT_PRIMARY_ADR_EST_IND | EMP_AT_PRIMARY_ADR_EST_IND lookup | HZ_ORGANIZATION_PROFILES.EMP_AT_PRIMARY_ADR_EST_IND |
EMP_AT_PRIMARY_ADR_MIN_IND | EMP_AT_PRIMARY_ADR_MIN_IND lookup | HZ_ORGANIZATION_PROFILES.EMP_AT_PRIMARY_ADR_MIN_IND |
EMP_AT_PRIMARY_ADR_TEXT | None | HZ_ORGANIZATION_PROFILES.EMP_AT_PRIMARY_ADR_TEXT |
EMPLOYEES_TOTAL | None | HZ_ORGANIZATION_PROFILES.EMPLOYEES_TOTAL |
DISPLAYED_DUNS | None | None |
EXPORT_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.EXPORT_IND |
FISCAL_YEAREND_MONTH | MONTH lookup | HZ_ORGANIZATION_PROFILES.FISCAL_YEAREND_MONTH |
GSA_INDICATOR_FLAG | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.GSA_INDICATOR_FLAG |
HQ_BRANCH_IND | HQ_BRANCH_IND lookup | HZ_ORGANIZATION_PROFILES.HQ_BRANCH_IND |
IMPORT_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.IMPORT_IND |
INCORP_YEAR | None | HZ_ORGANIZATION_PROFILES.INCORP_YEAR |
LABOR_SURPLUS_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.LABOR_SURPLUS_IND |
LEGAL_STATUS | LEGAL_STATUS lookup | HZ_ORGANIZATION_PROFILES.LEGAL_STATUS |
LINE_OF_BUSINESS | None | HZ_ORGANIZATION_PROFILES.LINE_OF_BUSINESS |
LOCAL_BUS_IDENTIFIER | None | HZ_ORGANIZATION_PROFILES.LOCAL_BUS_IDENTIFIER |
LOCAL_BUS_IDEN_TYPE | LOCAL_BUS_IDEN_TYPE lookup | HZ_ORGANIZATION_PROFILES.LOCAL_BUS_IDEN_TYPE |
MINORITY_OWNED_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.MINORITY_OWNED_IND |
MINORITY_OWNED_TYPE | None | HZ_ORGANIZATION_PROFILES.MINORITY_OWNED_TYPE |
MISSION_STATEMENT | None | HZ_ORGANIZATION_PROFILES.MISSION_STATEMENT |
OOB_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.OOB_IND |
PARENT_SUB_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.PARENT_SUB_IND |
PRINCIPAL_NAME | None | HZ_ORGANIZATION_PROFILES.PRINCIPAL_NAME |
PRINCIPAL_TITLE | None | HZ_ORGANIZATION_PROFILES.PRINCIPAL_TITLE |
PUBLIC_PRIVATE_OWNERSHIP_FLAG | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.PUBLIC_PRIVATE_OWNERSHIP_FLAG |
REGISTRATION_TYPE | REGISTRATION_TYPE lookup | HZ_ORGANIZATION_PROFILES.REGISTRATION_TYPE |
SMALL_BUS_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.SMALL_BUS_IND |
TOTAL_EMP_EST_IND | TOTAL_EMP_EST_IND lookup | HZ_ORGANIZATION_PROFILES.TOTAL_EMP_EST_IND |
TOTAL_EMP_MIN_IND | TOTAL_EMP_MIN_IND lookup | HZ_ORGANIZATION_PROFILES.TOTAL_EMP_MIN_IND |
TOTAL_EMPLOYEES_IND | TOTAL_EMPLOYEES_INDICATOR lookup | HZ_ORGANIZATION_PROFILES.TOTAL_EMPLOYEES_IND |
TOTAL_EMPLOYEES_TEXT | None | HZ_ORGANIZATION_PROFILES.TOTAL_EMPLOYEES_TEXT |
TOTAL_PAYMENTS | None | HZ_ORGANIZATION_PROFILES.TOTAL_PAYMENTS |
WOMAN_OWNED_IND | Y, N, or NULL | HZ_ORGANIZATION_PROFILES.WOMAN_OWNED_IND |
YEAR_ESTABLISHED | None | HZ_ORGANIZATION_PROFILES.YEAR_ESTABLISHED |
PERSON_FIRST_NAME |
|
HZ_PERSON_PROFILES.PERSON_FIRST_NAME |
PERSON_LAST_NAME |
|
HZ_PERSON_PROFILES.PERSON_LAST_NAME |
PERSON_MIDDLE_NAME | None | HZ_PERSON_PROFILES.PERSON_MIDDLE_NAME |
PERSON_INITIALS | None | HZ_PERSON_PROFILES.PERSON_INITIALS |
PERSON_NAME_SUFFIX | None | HZ_PERSON_PROFILES.PERSON_NAME_SUFFIX |
PERSON_PRE_NAME_ADJUNCT | CONTACT_TITLE lookup | HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT |
PERSON_PREVIOUS_LAST_NAME | None | HZ_PERSON_PROFILES.PERSON_PREVIOUS_LAST_NAME |
PERSON_TITLE | None | HZ_PERSON_PROFILES.PERSON_TITLE |
PERSON_FIRST_NAME_PHONETIC | None | HZ_PERSON_PROFILES.PERSON_FIRST_NAME_PHONETIC |
PERSON_LAST_NAME_PHONETIC | None | HZ_PERSON_PROFILES.PERSON_LAST_NAME_PHONETIC |
PERSON_MIDDLE_NAME_PHONETIC | None | HZ_PERSON_PROFILES.MIDDLE_NAME_PHONETIC |
PERSON_NAME_PHONETIC | None | HZ_PERSON_PROFILES.PERSON_NAME_PHONETIC |
PERSON_ACADEMIC_TITLE | None | HZ_PERSON_PROFILES.PERSON_ACADEMIC_TITLE |
DATE_OF_BIRTH |
|
HZ_PERSON_PROFILES.DATE_OF_BIRTH |
PLACE_OF_BIRTH | None | HZ_PERSON_PROFILES.PLACE_OF_BIRTH |
DATE_OF_DEATH |
|
HZ_PERSON_PROFILES.DATE_OF_DEATH |
DECEASED_FLAG |
|
HZ_PERSON_PROFILES.DECEASED_FLAG |
DECLARED_ETHNICITY | None | HZ_PERSON_PROFILES.DECLARED_ETHNICITY |
GENDER | None | HZ_PERSON_PROFILES.GENDER |
HEAD_OF_HOUSEHOLD_FLAG | Y, N, or NULL | HZ_PERSON_PROFILES.HEAD_OF_HOUSEHOLD_FLAG |
HOUSEHOLD_INCOME | None | HZ_PERSON_PROFILES.HOUSEHOLD_INCOME |
HOUSEHOLD_SIZE | None | HZ_PERSON_PROFILES.HOUSEHOLD_SIZE |
MARITAL_STATUS | MARITAL_STATUS lookup | HZ_PERSON_PROFILES.MARITAL_STATUS |
MARITAL_STATUS_EFFECTIVE_DATE | None | HZ_PERSON_PROFILES.MARITAL_STATUS_EFFECTIVE_DATE |
PERSON_IDEN_TYPE | None | HZ_PERSON_PROFILES.PERSON_IDEN_TYPE |
PERSON_IDENTIFIER | None | HZ_PERSON_PROFILES.PERSON_IDENTIFIER |
PERSONAL_INCOME | None | HZ_PERSON_PROFILES.PERSONAL_INCOME |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_ORGANIZATION_PROFILES.CREATED_BY_MODULE or HZ_PERSON_PROFILES.CREATED_BY_MODULE |
The HZ_IMP_RELSHIPS_INT table contains relationship information to be imported into these TCA tables:
HZ_RELATIONSHIPS
HZ_PARTIES
HZ_ORG_CONTACTS (Optional)
This table lists the columns in the interface table, as well as the validation and destination.
Column | Validation | Destination |
---|---|---|
BATCH_ID | Mandatory | None |
SUB_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
SUB_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
OBJ_ORIG_SYSTEM |
|
HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM |
OBJ_ORIG_SYSTEM_REFERENCE | Mandatory | HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE |
INSERT_UPDATE_FLAG | I, U, or NULL | None |
RELATIONSHIP_TYPE |
|
HZ_RELATIONSHIPS.RELATIONSHIP_TYPE |
RELATIONSHIP_CODE |
|
HZ_RELATIONSHIPS.RELATIONSHIP_CODE |
START_DATE | Cannot be updated to NULL | HZ_RELATIONSHIPS.START_DATE |
END_DATE | None | HZ_RELATIONSHIPS.END_DATE |
COMMENTS | None | HZ_RELATIONSHIPS.COMMENTS |
ATTRIBUTE_CATEGORY | None | HZ_RELATIONSHIPS.ATTRIBUTE_CATEGORY |
ATTRIBUTE1 to ATTRIBUTE20 | None | HZ_RELATIONSHIPS.ATTRIBUTE1 to HZ_RELATIONSHIPS.ATTRIBUTE20 |
INTERFACE_STATUS | None | None |
ACTION_FLAG | None | None |
ERROR_ID | None | None |
CREATION_DATE | None | None |
CREATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_DATE | None | None |
LAST_UPDATED_BY | Foreign key to FND_USER.USER_ID | None |
LAST_UPDATE_LOGIN | Foreign key to FND_LOGINS.LOGIN_ID | None |
REQUEST_ID | Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID | None |
PROGRAM_APPLICATION_ID | Foreign key to FND_APPLICATION.APPLICATION_ID | None |
PROGRAM_ID | Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID | None |
PROGRAM_UPDATE_DATE | None | None |
CREATED_BY_MODULE | Mandatory and not updateable unless current value in TCA is NULL | HZ_RELATIONSHIPS.CREATED_BY_MODULE |