If you experience enrollment problems during system testing, or while in production, you can generate a trace file of a PL/SQL procedure to track the source of the problem for an individual user. The hr_utility.set_location function generates output that lets you examine the flow of code execution for key APIs and business processes.
Set the profile option OAB: Enable Self-Service Benefits Trace to select the module that you want to trace.
Note: You should set the profile option for only one user at a time.
Using a system administrator responsibility, open the Find System Profiles Value window to set the profile option for a user.
Deselect the Site check box.
Select the User check box.
Select the person for whom you are running the trace from the User list.
Select the OAB: Enable Self-Service Benefits profile option in the Profile field.
Click Find.
In the System Profile Values window, select a User value for the profile option.
BENACTBR (Activity Base Rate): This user value traces the rates computation process.
BENDISRT (Distribute Rates): This user value traces a user-entered rate change that calculates other dependent rates, such as parent/child rates or annual-to-communicated rates.
BENELINF (Election Information): This user value traces the enrollment process when the user changes elections on the Benefits Selections Page and clicks Next.
BENOLLET (On-Line Life Event): This user value traces the Participation Process for a single user. For example, when the user clicks Next on the Dependents and Beneficiaries page.
Save your work.
Close the System Profile Values window.
Run your test case in Self-Service Benefits based on the profile option you selected.
Note: The browser window stops responding while the page waits for the trace pipe to open for the user.
To view the results of the trace, enter the following command on a server where you can access the application database. The example below shows the command for the BENELINF value of the profile option.
$PAY_TOP/bin/PYUPIP <apps userid>/<apps pwd>@<dbname> BENELINF > PYUPIP.txt
Read the PYUPIP.txt file to analyze the results of the trace.
Additional Information: You can upload the trace file to Oracle Support for analysis as part of a Technical Assistance Request.
Close your test browser session.
After you complete the trace, navigate to the System Profile Values window and clear any value from the OAB: Enable Self-Service Benefits profile option.
Warning: If you do not return the profile option value to null, the Self-Service application stops responding while the page waits for the trace pipe to open for the user the next time they access Self-Service Benefits.