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 JANUARY 16, 2017

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.
***Checked for relevance on 09-Oct-2013***

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


 

Cause

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