Concurrent Output for Some Bespoke FND_FILE.PUT_LINE PL/SQL Programs is Only Generating the Output File, Zero Size, Intermittently
(Doc ID 1446171.1)
Last updated on AUGUST 11, 2024
Applies to:
Oracle Concurrent Processing - Version 11.5.10.2 to 12.0.0 [Release 11.5 to 12]Information in this document applies to any platform.
Symptoms
On 11.5.10.2/ 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.
Changes
No known changes.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |