1. Creating and Administering Analytics and Reports for Procurement
  2. Deep Links for Procurement

Deep Links for Procurement

You can use deep links to open pages without navigating through the menu structure.

When you add deep links to a business intelligence report or a company website, users can simply click those links to go directly to the application pages they need to use, without any additional clicks or navigation. You can find all of the available deep links in the Deep Links work area. Some deep links, such as those assigned the NONE action, are ready to use as is. Other deep links, such as those assigned the VIEW action, require you to edit the link details before you can use them.

This table lists Procurement deep links that are available in the Deep Links work area.

Product

Deep Link (Object Type, Action)

Short Description of Purpose

ObjKey Needed? (Y/N)

Name and Description of ObjKey Parameter

ObjKey Parameter Values

Oracle Purchasing

View Order

(PURCHASE_ORDER,

VIEW)

View Order

PURCHASE_ORDER, NONE

Opens a specific purchase order for viewing on the View Order page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Order

(PURCHASE_ORDER_

LOBUSER,NONE)

Opens a specific purchase order for viewing on the View Order page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Order

(PURCHASE_ORDER_APUSER,NONE)

Opens a specific purchase order for viewing on the View Order page in the Invoice work area.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Agreement

(PURCHASE_AGREE

MENT,VIEW)

View Agreement

(PURCHASE_AGREE

MENT,NONE)

Opens a specific purchase agreement for viewing on the View Agreement page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Order

(PURCHASE_ORDER_REQUESTER,NONE)

Opens a specific purchase order for viewing on the View Order page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Change Order

(PURCHASE_ORDER_CHANGE,VIEW)

View Change Order

(PURCHASE_ORDER_CHANGE,NONE)

Opens a specific purchase order change order for viewing on the View Order page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Change Orde as Requester

(PURCHASE_ORDER_CHANGE_REQ,VIEW)

View Change Order as Requester

(PURCHASE_ORDER_CHANGE_REQ,NONE)

Opens a specific purchase order change order for viewing on the View Order page in the Self Service Procurement work area.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Purchasing

View Agreement Change Order

(PURCHASE_AGREEMENT_CHANGE,VIEW)

View Agreement Change Order

(PURCHASE_AGREEMENT_CHANGE,NONE)

Opens a specific purchase agreement change order for viewing on the View Order page.

Y

PO_HEADER_ID: Unique identifier of a purchasing document.

PO_HEADER_ID column in the PO_HEADERS_ALL table.

Oracle Sourcing

View Negotiation

(NEGOTIATION,VIEW)

Opens a specific negotiation on the View Negotiation page.

Y

AUCTION_HEADER_ID: Unique identifier of a negotiation.

AUCTION_HEADER_ID column in the PON_AUCTION_HEADERS_ALL table.

Oracle Sourcing

Manage Negotiations

(NEGOTIATION,NONE)

Opens the Manage Negotiations page in the Procurement work area.

N

N/A

N/A

Oracle Sourcing

View Negotiation

(NEGOTIATION_

SUPPLIERUSER,VIEW)

Opens a specific negotiation on the View Negotiation page in the Supplier portal.

Y

AUCTION_HEADER_ID: Unique identifier of a negotiation.

AUCTION_HEADER_ID column in the PON_AUCTION_HEADERS_ALL table.

Oracle Sourcing

Active Negotiations

(NEGOTIATION_

SUPPLIERUSER,NONE)

Opens the Active Negotiations page in the Supplier portal.

N

N/A

N/A

Oracle Supplier Model

View Supplier

(SUPPLIER,VIEW)

View Supplier

(SUPPLIER,NONE)

Opens a specific supplier on the View Supplier page.

Y

SupplierNumber: Number that uniquely identifies the supplier.

SupplierName: Name of the supplier.

SupplierNumber

SEGMENT1 column in the POZ_SUPPLIERS table.

SupplierName

PARTY_NAME column in the HZ_PARTIES table.

Oracle Supplier Model

View Supplier

(SUPPLIER_POUSER,

VIEW)

View Supplier

(SUPPLIER_POUSER,

NONE)

Opens a specific supplier on the View Supplier page in the Purchasing work area.

Y

SupplierNumber: Number that uniquely identifies the supplier.

SupplierName: Name of the supplier.

SupplierNumber

SEGMENT1 column in the POZ_SUPPLIERS table.

SupplierName

PARTY_NAME column in the HZ_PARTIES table.

Oracle Supplier Qualification

View Qualification

(QUALIFICATION,VIEW)

Opens a specific qualification on the View Qualification page.

Y

QUALIFICATIONS_ID: Unique identifier of the qualification.

QUALIFICATIONS_ID column in the POQ_QUALIFICATIONS table.

Oracle Supplier Qualification

Manage Qualifications

(QUALIFICATION,NONE)

Opens the Manage Qualifications page in the Supplier Qualification work area.

N

N/A

N/A

Oracle Supplier Qualification

View Assessment

(ASSESSMENT,VIEW)

Opens a specific assessment on the View Assessment page.

Y

ASSESSMENT_ID: Unique identifier of the assessment.

ASSESSMENT_ID column in the POQ_ASSESSMENTS table.

Oracle Supplier Qualification

Manage Assessments

(ASSESSMENT,NONE)

Opens the Manage Assessment page in the Supplier Qualification work area.

N

N/A

N/A

Oracle Supplier Qualification

View Initiative

(INITIATIVE,VIEW)

Opens a specific initiative on the View Initiative page.

Y

InitiativeId: Unique identifier of the initiative.

INITIATIVE_ID column in the POQ_INITIATIVES table.

Oracle Supplier Qualification

Manage Initiatives

(INITIATIVE,NONE)

Opens the Manage Initiative page in the Supplier Qualification work area.

N

N/A

N/A

Oracle Self Service Procurement

View Requisition Lines

(PURCHASE_REQUIS

ITION_PRCAGENT,NONE)

Opens the View Requisition Lines page in the Purchasing work area so that the user can search for a requisition line.

N

N/A

N/A

Oracle Self Service Procurement

View Requisition Details

(PURCHASE_REQUIS

ITION_PRCAGENT,VIEW)

Opens a specific requisition for viewing on the View Requisition Details page.

Y

REQUISITION_HEADER_ID: Unique identifier of a requisition.

REQUISITION_HEADER_ID column in the POR_REQUISITION_HEADERS_ALL table.

Oracle Self Service Procurement

View Requisition Details

(PURCHASE_REQUISITION_LOBUSER,VIEW)

Opens a specific requisition for viewing on the View Requisition Details page.

Y

REQUISITION_HEADER_ID: Unique identifier of a requisition.

REQUISITION_HEADER_ID column in the POR_REQUISITION_HEADERS_ALL table.

Oracle Self Service Procurement

Manage Requisitions

(PURCHASE_REQUIS

ITION_LOBUSER,NONE)

Opens the Manage Requisition page in the Self Service Procurement work area so that the user can search for a requisition.

N

N/A

N/A
Note: In Purchasing and Supplier Model, deep links that have NONE or VIEW action, open a specific page and need an ObjKey.

This table lists the target audience and security requirements for different Procurement deep links.

Deep Link (Object Type, Action)

Target Audience

Security Requirements

Examples

View Order

(PURCHASE_ORDER,VIEW)

View Order

(PURCHASE_ORDER,NONE)

Buyer

Function Security:

  • View Purchase Order

  • View Purchase Order Work Area

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER&objKey=poHeaderId=111111&action=VIEW

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER&objKey=poHeaderId=111111

View Order

(PURCHASE_ORDER_

LOBUSER,NONE)

Purchase Analyst

Function Security:

  • View Purchase Order

  • View Purchase Order Work Area

Data Security:

  • Requisitioning business units for which they're authorized

  • For the financial business unit associated with their primary assignment

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER_LOBUSER&objKey=poHeaderId=111111

View Order

(PURCHASE_ORDER_APUSER,

NONE)

AP Specialist

Function Security:

  • View Purchase Order

  • View Invoice Work Area

Data Security:

  • Bill-to business units for which they're authorized

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHeaderId=111111

View Agreement

(PURCHASE_AGREEMENT,VIEW)

View Agreement

(PURCHASE_AGREEMENT,NONE)

Buyer

Function Security:

  • View Purchase Agreement

  • View Purchase Agreement Work Area

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_AGREEMENT&objKey=poHeaderId=111111&action=VIEW

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_AGREEMENT&objKey=poHeaderId=111111

View Order

(PURCHASE_ORDER_REQUESTER,NONE)

Requester

Function Security:

  • Manage Requisitions
  • View PO as Requester OR View PO
  • View Requisition All

Data Security:

  • Requisitioning business units for which they're authorized
  • If the user has the View Requisition All privilege, then they have access to all POs for the authorized BUs else they need to be a requester or preparer

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER_REQUESTER&objKey=poHeaderId=111111

View Change Order

(PURCHASE_ORDER_CHANGE,VIEW)

View Change Order

(PURCHASE_ORDER_CHANGE,NONE)

Buyer

Function Security:

  • View Purchase Order
  • View Purchase Order Work Area

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER_CHANGE&objKey=poHeaderId=111111

View Change Order as Requester

(PURCHASE_ORDER_CHANGE_REQ,VIEW)

View Change Order as Requester

(PURCHASE_ORDER_CHANGE_REQ,NONE)

Requester

Function Security:

  • Manage Requisitions
  • View PO as Requester OR View PO

Data Security:

  • Requisitioning business units for which they're authorized
  • If the user has the View Requisition All privilege, then they have access to all POs for the authorized BUs else they need to be a requester or preparer
  • User must be originator of the change order

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_ORDER_CHANGE_REQ&objKey=poHeaderId=111111

View Agreement Change Order

(PURCHASE_AGREEMENT_CHANGE,VIEW)

View Agreement Change Order

(PURCHASE_AGREEMENT_CHANGE,NONE)

Buyer

Function Security:

  • View Purchase Agreement
  • View Purchase Agreement Work Area

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_AGREEMENT_CHANGE&objKey=poHeaderId=111111

View Negotiation

(NEGOTIATION,VIEW)

Category Manager/ Sourcing Project Collaborator

Function Security:

  • View Supplier Negotiation Work Area

  • View Supplier Negotiation

Data Security:

  • Negotiation owner (Category manager), or

  • A member of the Collaboration team, or

  • An active agent for the procurement business unit with access to manage negotiations and is allowed to have VIEW or FULL access to other agents documents

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=NEGOTIATION&action=VIEW&objKey=AuctionHeaderId=111111

Manage Negotiations

(NEGOTIATION,NONE)

Category Manager/ Sourcing Project Collaborator

Function Security:

  • View Supplier Negotiation Work Area

Data Security:

  • Negotiation owner (Category manager), or

  • A member of the Collaboration team, or

  • An active agent for the procurement business unit with access to manage negotiations and is allowed to have VIEW or FULL access to other agents documents

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=NEGOTIATION&action=NONE

View Negotiation

(NEGOTIATION_SUPPLIERUSER,

VIEW)

Supplier Bidder

Function Security:

  • View Supplier Negotiation

  • Access Suppliers Work Area Overview

Data Security:

  • Supplier Data Access

  • Negotiation Response Rule to Restrict to Invited Suppliers

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=NEGOTIATION_SUPPLIERUSER&action=VIEW&objKey=AuctionHeaderId=111111

Active Negotiations

(NEGOTIATION_SUPPLIERUSER,

NONE)

Supplier Bidder

Function Security:

  • View Supplier Negotiation

  • Access Suppliers Work Area Overview

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=NEGOTIATION_SUPPLIERUSER&action=NONE

View Supplier

(SUPPLIER,VIEW)

View Supplier

(SUPPLIER,NONE)

Supplier Administrator/ Manager

Function Security:

  • Suppliers Work Area

  • View or Maintain Supplier

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=SUPPLIER&objKey=supplierNumber=111111&action=VIEW

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=SUPPLIER&objKey=supplierName=Vision_Corporation

View Supplier

(SUPPLIER_POUSER,VIEW)

View Supplier

(SUPPLIER_POUSER,NONE)

Buyer

Function Security:

  • View or Maintain Supplier

  • View Purchase Order Work Area

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=SUPPLIER_POUSER&objKey=supplierNumber=111111&action=VIEW

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=SUPPLIER_POUSER&objKey=supplierName=Vision_Corporation

View Qualification

(QUALIFICATION,VIEW)

Supplier Qualification Manager

Function Security:

  • View Supplier Qualification

  • View Supplier Qualification Work Area

Data Security:

  • Qualification owner, or

  • A member of the Evaluation team or,

  • An active agent for the procurement business unit with access to manage supplier qualifications and is allowed to have VIEW or FULL access to other agents documents

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=QUALIFICATION&objKey=qualificationId=111111&action=VIEW

Manage Qualifications

(QUALIFICATION,NONE)

Supplier Qualification Manager

Function Security:

  • Search Supplier Qualification

  • View Supplier Qualification Work Area

Data Security:

  • An active agent for the procurement business unit

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=QUALIFICATION&action=NONE

View Assessment

(ASSESSMENT,VIEW)

Supplier Qualification Manager

Function Security:

  • View Supplier Assessment

  • View Supplier Qualification Work Area

Data Security:

  • Assessment owner, or

  • A member of the Evaluation team or,

  • An active agent for the procurement business unit with access to Manage Supplier Qualifications and is allowed to have VIEW or FULL access to other agents documents

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=ASSESSMENT&objKey=assessmentId=111111&action=VIEW

Manage Assessments

(ASSESSMENT,NONE)

Supplier Qualification Manager

Function Security:

  • Search Supplier Assessment

  • View Supplier Qualification Work Area

Data Security:

  • An active agent for the procurement business unit

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=ASSESSMENT&action=NONE

View Initiative

(INITIATIVE,VIEW)

Supplier Qualification Manager

Function Security:

  • View Supplier Qualification Initiative

  • View Supplier Qualification Work Area

Data Security:

  • Initiative owner, or

  • A member of the Evaluation team or,

  • An active agent for the procurement business unit with access to Manage Supplier Qualifications and is allowed to have VIEW or FULL access to other agents' documents.

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=INITIATIVE&objKey=initiativeId=111111&action=VIEW

Manage Initiatives

(INITIATIVE,NONE)

Supplier Qualification Manager

Function Security:

  • Search Supplier Qualification Initiative

  • View Supplier Qualification Work Area

Data Security:

  • An active agent for the procurement business unit.

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=INITIATIVE&action=NONE

View Requisition Lines

(PURCHASE_REQUISITION_

PRCAGENT,NONE)

Procurement Agent Running OTBI Reports

Function Security:

  • View Requisitions

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_REQUISITION_PRCAGENT&action=NONE

View Requisition Details

(PURCHASE_REQUISITION_

PRCAGENT,VIEW)

Procurement Agent Running OTBI Reports

Function Security:

  • Purchase Order Work Area

  • View Requisition (As Buyer)

Data Security:

  • Procurement Agent Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=NEGOTIATION&objKey=requisitionHeaderId=111111&action=VIEW

View Requisition Details

(PURCHASE_REQUISITION_

LOBUSER,VIEW)

Line of Business User Running OTBI Reports

Function Security:

  • Manage Requisitions

Data Security:

  • Purchase Analysis, Manage User Data Access, and Primary BU

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_REQUISITION_LOBUSER&objKey=requisitionHeaderId=111111&action=VIEW

Manage Requisitions

(PURCHASE_REQUISITION_

LOBUSER,NONE)

Line of Business User Running OTBI Reports

Function Security:

  • Manage Requisitions

Data Security:

  • Manage User Data Access

https://pod.oraclecloud.com/fndSetup/faces/deeplink?objType=PURCHASE_REQUISITION_LOBUSER&action=NONE

To know how to construct deep links to purchasing transactions from analyses and reports, refer to the Navigating to Purchasing Transactions from Reports white paper that's available on My Oracle Support (Document ID 2444555.1).

To know how to construct deep links to supplier profiles from analyses and reports, refer to the Navigating to Supplier Profile from Reports white paper that's available on My Oracle Support (Document ID 2556026.1).