FND_REQUEST.SUBMIT_REQUEST() Always Return zero.
GL Purge and archive using PL/Sql Script-
We are trying to archive and purge GL tables ie ,account balances, as well as journal batches, entries, lines, and associated journal references for one or more accounting periods, provided the periods are permanently closed using Pl/Sql Script not by GL Archive /Purge Oracle Forms .
We are calling GLPURGE Concurrent Program from Oracle Apps front end. The package in turn calls the standard "Fnd_request.submit_request" function.
It is working fine this way.
But when we execute the same GLPURGE Concurrent through a PL/Sql script, the "Fnd_request.submit_request" function returns 0.