Running the Load ProCard Stage process (PO_CCPCRDSTG) multiple times with exactly the same file, the
We have a unfortunate situation where an employee has loaded same file multiple times( Ran PO_CCPCRDSTG 3 times concurrently). The transactions are loaded into CC_TRANS_EC tables. PO_CCLOADLD has not been run by this employee yet.
The problem is that this file was already uploaded and processed by other user already( has run PO_CCPCRDSTG and PO_CCLOADLD and all the way to AP and GL posting).
Now our issue at hand is figuring out hopw to delete the data from CC_TRANS_EC table without effecting any other data. The Doc: