Oracle OIE - American Express Transaction Loader and Validation Program
Can anyone direct me to documentation on the processes which this program contains? What tables does it update, how does it handle data errors like a duplicate file being processed or duplicate transaction or credit card record, etc.? Will the program fail or does it have error handling to log the error on the duplicate transaction and continue loading the remaining transactions? I haven't been able to find any description of processing which occurs in this program.
I know it loads credit card transaction records from the KR1025 file to the the ap_credit_card_trxns_all, but it appears to also write records into ap_cards_all table. Are records written into the cards table built from data on the type 1 transaction record? What other tables are updated when it runs? Any information will be very helpful!