Thursday, January 11, 2018

How to use Profile Option In Oracle E-Business Suite Reports

Salam Alaikum,

   Many times we must use the profile options in our developed reports in Oracle E-Business Suite, and in order to do so we must add a simple code to the custom report (in the RDF File).

  In Oracle R12 and with the introduction of Multi Org Feature, we must initialize in the custom report in order to initialize the global variables in the context of the user running the report.

*if you need to check out a list of the most used profile options and a simple description about them you can check the below link:

   The API SRW.USER_EXIT('FND SRWINIT') needs to called in the BeforeReport Trigger.

&

   The API SRW.USER_EXIT('FND SRWEXIT') needs to called in the AfterReport Trigger.

 
Hope you found it useful, feel free to leave a comment if have any note on the subject.  

Oracle Apps (E-Business Suite) List of Profile Options

Salam Alaikum,

   I share with you today a simple bit of information that can be very useful about some profile options.

   In the next post i will talk about how to use them in Oracle Reports.

Variable
Description
USERNAME
Your user's current Oracle Application Object Library username.
USER_ID
Your user's current Oracle Application Object Library user ID.
RESP_ID
Your user's current responsibility ID.
APPL_SHRT_ NAME
The short name of the application connected to your user's current responsibility.
RESP_APPL_ID
The application ID of the application connected to your user's current responsibility.
FORM_NAME
The name of the current form. Not available for concurrent programs.
FORM_ID
The form ID of the current form. Not available for concurrent programs.
FORM_APPL_ NAME
The name of the application for which the current form is registered. Not available for concurrent programs.
FORM_APPL_ID
The application ID of the application for which the current form is registered. Not available for concurrent programs.
LOGON_DATE
Your user's logon date for the current session.
LAST_LOGON_ DATE
Your user's logon date for the previous session.
LOGIN_ID
Your user's Sign-On Audit login ID in Oracle Application Object Library.
CONC_ REQUEST_ID
The request ID associated with a particular instance of your running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the REQUEST_ID Who column.
CONC_ PROGRAM_ID
The program ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_ID Who column.
CONC_ PROGRAM_ APPLICATION_ ID
The application ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_APPLICATION_ID Who column.
CONC_LOGIN_ ID
The login ID associated with a running concurrent program. You can only use this profile option in a concurrent program. You can use this profile option to fill the LAST_UPDATE_LOGIN Who column.
CONC_PRINT_ OUTPUT
The value Yes or No that you enter in the Print Output field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program. This profile option determines whether the concurrent managers print the concurrent program's output to the printer.
CONC_PRINT_ STYLE
The print style of your concurrent program's output that you enter in the Print Style field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program.
 

  Hope you found it useful, feel free to leave a comment if have any note on the subject.