Pre-requisites for OFSAAI F2T with Checksum Evaluation (Doc ID 2723421.1)

Last updated on NOVEMBER 01, 2020

Applies to:

Symptoms

F2T with checksum validation:

1. Create a F2T definition with check sum property. Save the definition with proper mappings.
2. Create a .dat file in FTPSHARE area in-line with the checksum properties.
3. Create a batch using above definition then execute the batch.
4. Notice Batch is successful in Monitor screen.
5. In the task logs , we see the below message which says the checksum is by passed but data is loaded in the table:

[INFO][BACKEND][OFSAA][F2TCPP] Fic_Loading : GetCheckSum : No column mapped or specified to identify the records loaded in this run
[INFO][BACKEND][OFSAA][F2TCPP] Fic_Loading : GetCheckSum : Checksum cannot be computed for the table :xxxxxxx

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.