After specifying an external system's application integration, you can create a link
to the system from a table or graph in your Oracle Fusion Cloud Supply Chain Planning module
by supplying the page path and linking parameters.
Tip: To create a link to a page or report in an external system, examine the
target URL. Then, enter the required information for the base URL, page or report
path, and linking parameters so that the rendered link meets the external system's
requirements. Use supported tokens instead of actual values in the linking
parameters to pass contextual values during runtime.
-
In your table or graph in the Demand Management, Demand and Supply Planning,
Planning Central, Replenishment Planning, Sales and Operations Planning, or
Supply Planning work area, click .
The Manage Links dialog box opens.
Note: You can create links to external
systems from only pivot tables and not regular tables.
-
On the To External System tab, click the Create
icon.
The Create Link to External System dialog box opens.
-
In Name, enter a unique name for the combination of the
application integration and page path for which you're creating the link.
This name is displayed when you click in the table or graph.
-
In Description, enter the link description.
-
In Application Name, select the application integration
that was previously specified on the Create Application Integration page.
The base URL that you entered on the page is displayed in the
Base
URL field and can't be changed.
Tip: You can reuse
the same application integration in links to external systems so long as you
don't need to change the base URL.
-
In Page Path, enter the path to the page or report in
the external system.
To restrict the displayed data to the current plan in the linked,
predefined or user-defined analysis or report in Oracle Transactional
Business Intelligence (OTBI), Oracle Analytics Cloud, or Oracle Analytics
Publisher, specify these tokens:
- #PlanName#: Append this token to the page path to pass the name of the
current plan in the Oracle Supply Chain Planning work area.
- #PlanId#: Append this token to the page path to pass the ID of the
current plan in the Oracle Supply Chain Planning work area.
Ensure that the path doesn't contain the host or port details because
they're derived from the application integration.
-
Click OK.
The link is displayed on the To External System tab in the Manage Links dialog
box.
-
With the link name selected, in the Linking Parameters section, click the
Add Row icon.
A blank row appears in the Linking Parameters section.
You can save the link
only when it has at least one valid combination of a parameter and
value.
-
In Dimension, select a dimension that you want to pass
along with the link to the external system.
The available dimensions are those selected for the table or graph on the
Hierarchies tab in the Selector Tool.
The Level field
becomes available.
If you selected the Time dimension, the
Date Format field is enabled.
-
Select a level that you want to pass along with the link to the external
system.
The available levels are those selected for the table or graph on the
Hierarchies tab in the Selector Tool.
-
In Parameter, enter a unique name for the parameter
through which you want to pass the dimension, level, and value to the external
system page or report.
Ensure that the name meets the external system's nomenclature rules for
parameters.
-
In Value, enter a token for passing the selected level
member in the table or graph. The information in this field should be in the
decoded format for URLs.
You can specify these tokens:
- #MemberName#: Use this token to pass the member name. For example, the
token can contain the name of the item, organization, customer, week, or
month.
- #MemberId#: Use this token to pass the internal ID of the member.
- #StartDate#: Use this token to pass the start date of the time bucket
for your selection in the table or graph.
- #EndDate#: Use this token to pass the end date of the time bucket for
your selection in the table or graph.
When you use the link, the tokens are replaced by the actual values for
your selection in the table or graph.
-
In Date Format, select the format in which the value for
the Time dimension must be passed to the external system page or report.
-
Configure additional parameters by repeating Steps 8 through 13.
-
Click Save and Close.
The link is added to the External Links group that's available when you click for the table or graph.