Bulk Import

This chapter covers the following topics:

Bulk Import Interface Tables

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:

Related Topics

Loading Data into the Interface Tables, Oracle Trading Community Architecture User Guide

HZ_IMP_ADDRESSES_INT

The HZ_IMP_ADDRESSES_INT table contains address information to be imported into these TCA tables:

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
PARTY_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
SITE_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory for records to be inserted as new

  • Cannot be updated to NULL

 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

  • Mandatory for records to be inserted as new

  • Cannot be updated to NULL

  • Foreign key to FND_TERRITORIES.TERRITORY_CODE

 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

  • Mandatory for records to be inserted as new

  • Cannot be updated to NULL

 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

  • Mandatory

  • Foreign key to FND_TERRITORIES.TERRITORY_CODE

 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

  • Populate only if ACCEPT_STANDARDIZED_FLAG is Y

  • Cannot pass for update if CONTENT_SOURCE_TYPE in HZ_LOCATIONS is USER_ENTERED

 HZ_LOCATIONS.DATE_VALIDATED
PARTY_SITE_NAME None HZ_PARTY_SITES.PARTY_SITE_NAME
PARTY_SITE_NUMBER

  • Not updateable

  • Cannot be updated to NULL

  • Must be unique

  • Use value if passed; otherwise, automatically generate from sequence

 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

HZ_IMP_ADDRESSUSES_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
PARTY_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
SITE_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory and not updateable

  • PARTY_SITE_USE_CODE lookup

  • Combination of SITE_USE_TYPE and PARTY_SITE_ID must be unique for active party site use records

 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

HZ_IMP_CLASSIFICS_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory and not updateable

  • Cannot be updated to NULL

  • Foreign key to HZ_CLASS_CATEGORIES

 HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY
CLASS_CODE

  • Mandatory and not updateable

  • Cannot be updated to NULL

  • Must be a valid lookup code from the lookup type same as class category

 HZ_CODE_ASSIGNMENTS.CLASS_CODE
START_DATE_ACTIVE

  • Mandatory

  • Cannot be updated to NULL

 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

HZ_IMP_CONTACTPTS_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
CP_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
PARTY_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory for inserts and not updateable

  • EDI value allowed only for party of type Organization

  • COMMUNICATION_TYPE lookup

  • Cannot be updated to NULL

 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:

  • Cannot update to NULL

  • EMAIL_FORMAT lookup

 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

  • Mandatory if CONTACT_POINT_TYPE is PHONE

  • PHONE_LINE_TYPE lookup

 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

HZ_IMP_CONTACTROLES_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
CONTACT_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
SUB_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory

  • Cannot be updated to NULL

  • CONTACT_ROLE_TYPE lookup

  • Combination of ROLE_TYPE and ORG_CONTACT_ID must be unique

 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

HZ_IMP_CONTACTS_INT

The HZ_IMP_CONTACTS_INT table contains contact information to be imported into these TCA tables:

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
CONTACT_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
SUB_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
SUB_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
OBJ_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory and not updateable

  • Cannot be updated to NULL

 HZ_RELATIONSHIPS.RELATIONSHIP_TYPE
RELATIONSHIP_CODE

  • Mandatory and not updateable

  • PARTY_RELATIONS_TYPE lookup

  • Cannot be updated to NULL

 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

HZ_IMP_CREDITRTNGS_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 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

HZ_IMP_FINNUMBERS_INT

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

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • FIN_NUM_NAME lookup

  • Combination of FINANCIAL_NUMBER_NAME and FINANCIAL_REPORT_ID must be unique

 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

HZ_IMP_FINREPORTS_INT

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:

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

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Equal to or greater than REPORT_START_DATE.

  • Can and must be populated only if REPORT_START_DATE has value.

  • Either ISSUED_PERIOD alone or the REPORT_START_DATE and REPORT_END_DATE combination is mandatory. Cannot pass both.

 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

HZ_IMP_PARTIES_INT

The HZ_IMP_PARTIES_INT table contains party information to be imported into these TCA tables:

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

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory and not updateable

  • PARTY_TYPE lookup

  • Value must be PERSON or ORGANIZATION

 HZ_PARTIES.PARTY_TYPE
PARTY_ID

  • For internal use only. Any passed value is ignored.

  • Cannot be updated to NULL.

 None
PARTY_NUMBER

  • Not updateable

  • Must be unique

  • Cannot be updated to NULL

  • Use value if passed; otherwise, automatically generate from sequence

 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

  • Mandatory

  • Cannot be updated to NULL

 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

  • A value must be passed for either PERSON_FIRST_NAME or PERSON_LAST_NAME

  • Cannot be updated to NULL

 HZ_PERSON_PROFILES.PERSON_FIRST_NAME
PERSON_LAST_NAME

  • A value must be passed for either PERSON_FIRST_NAME or PERSON_LAST_NAME

  • Cannot be updated to NULL

 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

  • Cannot be later than the system date

  • If DATE_OF_DEATH and DATE_OF_BIRTH are both passed, then the date of death must be later than the date of birth

 HZ_PERSON_PROFILES.DATE_OF_BIRTH
PLACE_OF_BIRTH None HZ_PERSON_PROFILES.PLACE_OF_BIRTH
DATE_OF_DEATH

  • Cannot be later than the system date

  • If DATE_OF_DEATH and DATE_OF_BIRTH are both passed, then the date of death must be later than the date of birth

 HZ_PERSON_PROFILES.DATE_OF_DEATH
DECEASED_FLAG

  • Y, N, or NULL

  • If DATE_OF_DEATH is not NULL, then DECEASED_FLAG must be Y

 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

HZ_IMP_RELSHIPS_INT

The HZ_IMP_RELSHIPS_INT table contains relationship information to be imported into these TCA tables:

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

  • Mandatory

  • ORIG_SYSTEM lookup

 HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM
SUB_ORIG_SYSTEM_REFERENCE Mandatory HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REFERENCE
OBJ_ORIG_SYSTEM

  • Mandatory

  • ORIG_SYSTEM lookup

 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

  • Mandatory and not updateable

  • Cannot be updated to NULL

 HZ_RELATIONSHIPS.RELATIONSHIP_TYPE
RELATIONSHIP_CODE

  • Mandatory and not updateable

  • PARTY_RELATIONS_TYPE lookup

  • Cannot be updated to NULL

 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