Core Concurrent Processing - EBS (MOSC)

MOSC Banner

About add parameter

edited Jul 29, 2020 5:04AM in Core Concurrent Processing - EBS (MOSC) 3 commentsAnswered

Hi

Is there any suggestion about  below?

Requirement:

Display the program run time in the report .

In order to meet the requirement, I added a parameter 'p_run_time' from define window.

The value set is 'FND_STANDARD_DATE  and selected  'current date'.

Then , I added below formula to capture the  value of _p_run_time and want to display in the xml data.

function CF_RUN_DATEFormula return Char is

v_run_date varchar2(200);

begin

v_run_date := trunc(apps.fnd_date.canonical_to_date(:P_Current_date)) ;

return v_run_date;

exception

when others then

v_run_date := NULL;

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