Generating Self-Service Benefits Trace Files

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.

arrow icon   To generate a Self-Service Benefits trace file:

  1. Deselect the Site check box.

  2. Select the User check box.

  3. Select the person for whom you are running the trace from the User list.

  4. Select the OAB: Enable Self-Service Benefits profile option in the Profile field.

  5. Click Find.

  6. In the System Profile Values window, select a User value for the profile option.

  7. Save your work.

  8. Close the System Profile Values window.

  9. 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.

  10. 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
  11. 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.

  12. Close your test browser session.

  13. 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.