Transaction Recovery Cron Job

Transaction means...

• Successful responses from Gateways
• but somehow failed to insert to IMS DB.
• Fallback of JMS retry
• How old a transaction can be recovered from the log?
  • Default: today and yesterday
  • Override: any day you want to look back 

Recovery means...

• Auto reconciles missing transactions using ML clearing files loaded by iHUB.
• Since iHUB has clearing files for Chase (Master Merchant) and Amex, it doesn't handle other Gateways!
• PayAPI writes all DB insert failures to CSV logs.
• CSV Logs + iHUB (mas_txn_replica joins clearing_table) => found missing transactions
• Insert CSV logs + CC_NUM from iHUB => MAS_TXN
• Configurable iHUB DB look back days: default is 3 days.

Cron means...

• We setup the executable Java jar in the Linux cron tab. 
• Runs twice (1:10am & 9:10pm PST) a day: one from each data center. Thus, you receive two emails. 

Job means...

• The implementation uses Spring Batch job on top of Spring Boot.
• Defines a reconciled workflow with multiple steps.