Oracle Concurrent Program – Passing UserName

Posted on by

Oracle Concurrent program. Passing User Name to PL-SQL through Parameter. (Oracle APPS , Oracle EBS)

In this post,  I will explain how can you pass  User Name or any other profile parameter to your procedure or Report.

 

 

Q: How to pass current username to PL-SQL program through concurrent program in Oracle APPs.

Q: How to pass profile parameter in concurrent Program Parameter

 

Using Application Developer responsibility, I have defined a new parameter in OA.

This parameter has a default type “Profile” .

Parameter: Username
Description: Username
Activated: Yes
LOV: 30 char
Default Type: Profile
Default Value: USERNAME
Mandatory: Yes — If set no No, the value from $PROFILES$.LOGIN_ID is not retrieved

 

Following snap shot is self explanatory.