How is data deleted from the interface tables after it has been loaded ?
After loading the data from the interface tables into the system successfully, the data is not being removed (cleaned) from the interfaces.They will have process_code = 'ACCEPT' in the interface tables.
To remove the processed data from the interface, a concurrent program is available. The program name is : purge purchasing open interface processed data(POXPOIPR)
Run this program with paramenter purge accepted data = Yes
Then the process_code = 'ACCEPTED' records will be removed from the interface tables.
No comments:
Post a Comment