Record Level Tracking Process

For records level tracking, the columns in FIDELIO and FCONSOL Schema are as follows:

  • SUCCESS_ROWS >> FMS_TRAN_LOG

  • STATUS >> FMS_TRANS_AUDIT

  • ERROR>>FMS_TRANS_AUDIT

  • REMARKS>>FMS_TRANS_AUDIT

Status column is marked as required, initially status is 0. Then receiving side status become 7 or 8 (depending upon success or error) and the same is applied to the sending side. Sending side, retain records whose status is <> 7 for resending.

The record level tracking process is describe as the following steps:

  1. Sending Side: ACC >> Records in a Batch ID for example are 10 records with the status initial as 0 in the fms_trans_audit table. Each record in trans_log with the same batch_id will be inserted for batch level information and send it to the Receiver on the Receiving Side.
  2. Receiving Side: Receiver processes the batch_id and inserts 10 records in the fms_trans_audit table. For example, if 2 records are Error and 8 records are Success. The Receiving Side will send the same status to the Sender as a Response message.
  3. Sending Side: The Sender processes the response message and marks the status in the fms_trans_audit on the Sending Side. Each of success record is marked as 7 and it will be deleted. For each of error record is marked as 8 and the Sender will resend the failed records until they are fixed.

Note:

Some errors may require help from a support team or from a Database Administrator (DBA) consultant.

For example:

  • When you are trying to add data for a mandatory column but the column is missing from the database table.

  • The FMS Transfer entries are incorrect.