Concurrent Output for Some Bespoke FND_FILE.PUT_LINE PL/SQL Programs is Only Generating the Output File, Zero Size, Intermittently
Last updated on JANUARY 16, 2017
Applies to:Oracle Concurrent Processing - Version 18.104.22.168 to 12.0.0 [Release 11.5 to 12]
Information in this document applies to any platform.
***Checked for relevance on 09-Oct-2013***
On 22.214.171.124/ RAC (2 Nodes)
Concurrent output for some bespoke FND_FILE.PUT_LINE PL/SQL programs is only generating output intermittently.
Concurrent output should be generating any time.
Have a 2 node RAC database set up, with 2 application tiers running the E-Business Suite and concurrent managers running on both in parallel.
Have a number of bespoke programs which at the end, print a summary of the work done via pl/sql using FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_success_msg) for example.
Randomly the output for these concurrent jobs is empty and can find no pattern.
Should find a simple line of text like 'Job complete , 20 records processed' or something like that.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms