My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.