How to navigate to fusion Sales Order page from otbi analysis aggregated field

saurabh.dixit

We are trying to develop an OTBI report showing past due orders as a bar graph with range of days and count of orders in that range. Requirement is to click on 'count of orders' bar for a range and it should take to fusion page listing all those orders so user can open any of those orders and take action on it.

Dimple-Nagesh-Support-Oracle

Hello saurabh.dixit ,
You can try using Deep linking to SUI pages :
Please refer the following : URL Pattern of Deep Link: https://<pod-name>/fndSetup/faces/deeplink?objType=<objID>&objKey=<name1=value1;name2=value2>&action=<action>&returnApp=<returnappURL>&returnAppParams=<returnAppParameter>

To direct users to a product-specific action page,you need to add specific parameters to the deep link URL. This tabledescribes the parameters and gives you some examples of parametervalues.

	Parameter		Description		Example of Parameter Values
	pod-name		The host name.		pod.oraclecloud.com
	objType		The object type, such as work areas.		SUPPLIER
	objKey		The object identifier.		SupplierNumber
	action		The action that users can do on the page that theURL opens up, for example to edit something. Here are a few things to know: If you don't add any value forthe action parameter, this value is considered as NONE by default. So users will be taken to a high-levelpage, such as an overview page or a search page. If the value you added for theaction parameter doesn't match with any action on the UI, or the userdoesn't have the privileges to access that action, they will be takento a high-level page.		NONE VIEW CREATE EDIT
	returnAppURL		The application URL where users will be automaticallyredirected to when they try to return to the previous page, or afterthey complete their task. If you're using a third party URL, make sure theapplication name is registered using the Manage Integration of AdditionalApplications page in the Setup and Maintenance work area.		MyOracle
	returnAppParams		Parameters for the return application URL.		type=photo

Try this and let me know if that helps.

More details : https://docs.oracle.com/en/cloud/saas/applications-common/24d/oaext/deep-links.html#Where-to-Find-Information-About-Product-Specific-Deep-Links
https://docs.oracle.com/en/cloud/saas/subscription-management/fasmq/how-can-i-create-a-deep-link-to-the-order-creation-page.html
More ref: https://community.oracle.com/customerconnect/discussion/593191/how-to-open-sales-order-view-page-from-shipment-lines-by-using-deep-links

Thanks,
Dimple N

saurabh.dixit

Thanks for responding. However please elaborate how would I pass key values in deep link when user clicks on a bar graph with count N.

If bar graph shows order count N, clicking on it should open OM page with those N orders listed.