General Ledger - EBS (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center