My Oracle Support Banner

E-PIA: Drilling URL Query opening incorrect page on the target component (Doc ID 2087489.1)

Last updated on AUGUST 16, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.


When accessing a Drilling URL from a query created in Query Manager, an incorrect page is opened on the target component specified in the Component URL property of the Drilling URL.

This was reported to happen for several components under FSCM 9.2, such as Suppliers (VNDR_ID) component.

When creating a query that contains an expression of type Drilling URL, where on the Component URL expression property a specific page from a component should be accessed, after running the query and clicking the Drilling URL hyperlinks created, the user is taken to a different(incorrect) page than the one specified.

Clicking the Drilling URL hyperlink from the query results should result in user being directed to the correct page (i.e.: the one specified in the Drilling URL > Component URL > Page property).

1. Log in to PIA
2. Create a new query containing a Drilling URL expression that points to a component page.
  2.1. Add record VENDOR with fields SETID, VENDOR_ID and REMIT_VENDOR
  2.2. Add a new expression of type Drilling URL, press Component URL and add the following details:
    2.2.1. Menu = MAINTAIN_VENDORS; Market = GBL; Component = VNDR_ID; Page = VNDR_ADDRESS, Menu Action = Update
    2.2.2. URL Keys: add SETID = "SHARE" and VENDOR_ID = A.REMIT_VENDOR
    2.2.3. Map URL to Query Columns: select the A.REMIT_VENDOR field
3. Save the query
4. Go to the Run tab. Notice how the generated Drilling URL is in the correct form, containing correct navigation to page VNDR_ADDRESS, as seen below:
5. Click on the above Drilling URL hyperlink
6. A new page opens in the browser. Notice that the while the URL in the browser address bar remains as above, the page navigation is not correct. The user is actually on the Summary (VNDR_ID1_SUM) page, instead of the Address (VNDR_ADDRESS) page.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.