Add a Hyperlink to a Monthly Bill Report on the Billing Page

To let benefits administrators more easily access the relevant monthly bill report, you can include hyperlinks to the report on the Billing page.

Before you start

1. On the Oracle Business Intelligence server, create the billing data model. Make sure it accepts Person_Id and Bill_Charge_Id.
2. Create the monthly bill report and layout using the new billing data model.

   Use these parameters:

   • PersonId: #{sessionScope.configuratoinMap.pPersonId}

   • BillChargeId: #{row.BillChargeId}

   • Condition for Bill Status (Where Bill Status not equal to Open)JJ: #{rowStatus ne 'ORA_OPEN'

   Here's a sample report link:

   ../../analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&
   bipPath=%2FCustom%2FHuman%20Capital%20Management%2FPerson%20Monthly%20Bill%20Report.xdo&bipParams={%22_xmode%22:%224%22,%22_xiasynch%22:
   %22%22,%22_xpf%22:%22%22,%22_xpt%22:%220%22,%22_dFlag%22:%22false%22,%22_edIndex%22:%220%22,%22_dIndex%22:%220%22,%22_rToken%22:
   %22%22,%22_ranDiag%22:%22false%22,%22_xdo%22:
   %22%2FCustom%2FHuman%20Capital%20Management%2FPerson%20Monthly%20Bill%20Report.xdo%22,%22_paramspBillChargeId%22:%22#
   {row.BillChargeId}%22,%22_paramspPersonId%22:%22#
   {sessionScope.configurationMap.pPersonId}%22,%22_xt%22:%22Person%20Monthly%20Bill%20Report%20Layout%22,%22_xf%22:%22pdf%22,%22_xautorun%22:%22true%22}&
   _linkToReport=true

3. Test the report. Make sure to keep the Open Report link handy.
4. Create a Sandbox and Make It Active

Here's what to do

1. Go to Navigator > Configuration > Sandboxes.
2. Enter your sandbox.
3. Go to and open the benefits administration Billing page.
4. On the Settings and Actions menu, click Edit Pages.
5. Confirm that the edit page header has Edit Layer: Site - SITE.
6. On the View menu, select Source.
7. Add the hyperlink.
   1. In the Benefit Coverage Charges section, click the Benefits Coverage Charges field label.
   2. On the Confirm Shared Component Edit dialog box, click Edit.
   3. On the Source pane toolbar, click the Add content into the selected component icon.
   4. On the Add Content dialog box, in the Components row, click Open.
   5. In the Hyperlink row, click +Add.
   6. Click Close.
8. Configure the hyperlink.
   1. On the page, click the Click edit icon to define hyperlink text.
   2. On the Source pane toolbar, click the Show the properties of Hyperlink icon.
   3. On the Component Properties: Hyperlink dialog box, in the Destination field, enter the URL to the monthly billing report.
   4. To open the report in a new tab, in the Target Frame field, enter _blank.
   5. In the Text field, enter the link text, such as Open monthly bill report.
   6. Select the Visible check box.
   7. In the Visible field, select Expression Builder.
   8. On the Expression Editor dialog box, in the Type a value or expression field, enter this expression:

      #{row.Status ne 'ORA_OPEN'}

   9. Click OK.
   10. On the Component Properties: Hyperlink dialog box, click Apply.
   11. Click OK.
9. To render your changes, on the page, click Close.
10. To verify your changes, on the Sandbox Mode: Edit menu, select Preview as if Published (Context: All).
11. To publish your changes, on the <YourSandboxName> menu, select Publish.