Is there a way to process the identified duplicate data by AR_PAYLOAD other than SQL Update?
As we know, AR_PAYLOAD processes the data from the staging tables and it identifies that if there are invalid data like in my instance "Duplicates", it insert a value on the data's Process Instance field so it will not be processed by the AR_PAYLOAD anymore.
My question, is there other way to process the deposit in the Staging Table that was tagged as invalid other than SQL Update? Since the client needs still needs that deposit and the other data (which is duplicate) is the only one that should be eliminated by the program, but they are both not being processed by the AR_PAYLOAD program.