Hi,
I am looking for a way to dynamically change the status of the FND_CONC_REQUESTS in order to tell a user that a batch failed. The problem is that if I change the status to 'E', because I consider that there is a problem, Oracle Application will change it back to 'C' if there isn't a "proper" error, i.e. pl/sql error for example.
How can I force a process to finish in error ?
I am looking for a way to dynamically change the status of the FND_CONC_REQUESTS in order to tell a user that a batch failed. The problem is that if I change the status to 'E', because I consider that there is a problem, Oracle Application will change it back to 'C' if there isn't a "proper" error, i.e. pl/sql error for example.
How can I force a process to finish in error ?