URL's for Web Page Deeplinks in fusion with appropriate parameter attributes

 
As per Oracle:-
How To Drill Down To Fusion Financial Applications Transactions From OTBI ERP Reports (Doc ID 2603149.1)
 GOAL
OTBI provides users with the ability to create reports using real time transactional data. It offers capability to build rich, visual and interactive reports to meet unique reporting requirements.
 In addition to the existing reporting capabilities, it also provides the ability to drilldown from OTBI adhoc reports directly to the transaction details in Oracle Fusion Financials Applications.
 This is possible by leveraging the action link framework and using a set of pre-configured URL’s called Deeplinks which will allow users to configure drilldowns to supported transaction detail pages from the adhoc OTBI reports.

  
SOLUTION
At the time of writing this note, Deeplink feature is available for:
 1. Payables Invoices and Payments (Introduced in Rel 13 Update 18B)
   1.1 View Invoice Details
   1.2 Edit an Invoice
   1.3 Create Payment
   1.4 View Payment Details
 2. General Ledger Journals (Introduced in Rel 13 Update 18C)
   2.1 Edit a Journal
 3. Fixed Assets (Introduced in Rel 13 Update 19A)
   3.1 View Asset Details
   3.2 View Transaction Journal Entries
   3.3 View Depreciation Journal Entries
 4. Receivables (Introduced in Rel 13 Update 19C)
   4.1 Edit or Review Transaction
   4.2 Credit Transaction
   4.3 Apply On Account Credit Memo Transaction
   4.4 Adjust Transaction
   4.5 Create Receipt
   4.6 Manage Receipt
   4.7 Manage Customer
   4.8 Edit Customer Account
   4.9 Edit Customer Account Site
   4.10 Promise to Pay
   4.11 Manage Payments
 5. Subledger Accounting (Introduced in Rel 13 Update 19C)
   5.1 View a Journal Entry
 
 
 
URL deatils
Drill down from OTBI adhoc reports to Payables Invoices and Payments
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows
users to click on an object and navigate directly to the source application. Using this framework,
OTBI Financials has provided a capability to drill from an OTBI report to the Invoice and Payment
Details in the Oracle Fusion Payables Cloud.
 
The following table indicates the target page that users can drill to and the URL formats needed
for the drill from OTBI reports. Each of these URL’s accept parameters the details of which are
mentioned in the respective sections.
 
 

Action

Target Page in Fusion Apps

URL Format

 Functional Overview

 Parameters

View Invoice
Details

Manage
Invoices
in view mode

https://hostname/fscmUI/faces/
deeplink?
objType=@{1}&action=@{2}&o
bjKey=InvoiceId=@{3}

Drills to the Manage Invoices Page where
you can view the Invoice details.

AP_VIEWINVOICE
VIEW
Invoice ID

Edit an Invoice

Edit Invoice

https://hostname/fscmUI/faces/
deeplink?
objType=@{1}&action=@{2}&o
bjKey=InvoiceId=@{3}

Drills to the Edit Invoices Page where
you can edit the invoice.

AP_EDITINVOICE
EDIT
Invoice ID

Create
Payment

Create
Payment

https://hostname/fscmUI/faces/
deeplink?
objType=@{1}&action=@{2}

Drills to the Create Payment page where you can create a payment to apply to an invoice. Please
note that the target page here is the Create Payment page and not the Pay in Full page.

AP_PAYINVOICE
CREATE

View Payment
Details

Manage
Payments
in view mode

https://hostname
/fscmUI/faces/deeplink?
objType=@{1}&action=@{2}&o
bjKey=CheckId=@{3}

Drills to the Manage Payments Page
where you can view the Payment details.

AP_VIEWPAYMENT
VIEW
Check ID
 
 
 
Drill down from OTBI adhoc reports to General Ledger Journals
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows
users to click on an object and navigate directly to the source application. Using this framework,
OTBI Financials has provided a capability to drill from an OTBI report to Journal details in the
 
Oracle Fusion General Ledger Cloud.
The following table indicates the target page that users can drill to and the URL formats needed
for the drill from OTBI reports. Each URL accepts parameters the details of which are mentioned
in the respective sections.
 

Action

Target Page in Fusion Apps

URL Format

 Functional Overview

 Parameters

Edit a Journal

Edit Journal

https://hostname/fscmUI/faces/
deeplink?objType=@{1}&action
=@{2}&objKey=jeBatchId=@{3}
;jeHeaderId=@{4}

Drills to the Edit
Journal Page where
you can view / edit
the Journal details
based on the security
privileges.

GL_EDITJOURNAL
EDIT
Journal Batch ID
Journal Header ID
 
 
 
Drill down from OTBI adhoc reports to Fixed Assets
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows
users to click on an object and navigate directly to the source application. Using this framework,
OTBI Financials has provided a capability to drill from an OTBI report to Fixed Assets details in
the Oracle Fusion Fixed Assets Cloud.
The following table indicates the target page that users can drill to and the URL formats needed
for the drill from OTBI reports. Each URL accepts parameters the details of which are mentioned
in the respective sections.
 

Action

Target Page in Fusion Apps

URL Format

 Functional Overview

 Parameters

View Asset
Details

Asset Inquiry

https://hostname/fscmUI/faces/deepli
nk?objType=@{1}&action=@{2}&obj
Key=bookTypeCode=@{3};assetId=
@{4}

Drills to Asset Inquiry
page where you can
view Asset details.

FA_VIEWASSET
VIEW
Book Code ID
Asset ID

View Transaction Journal Entries

Review Journal Entries

https://hostname/fscmUI/faces/deepli nk?objType=@{1}&action=@{2}&obj Key=pSourceIdInt1=@{3};pValuation Method=@{4}

Drills to Review Journal Entries page where you can view
the journal details or drill down further.

FA_TRX_VIEWJOU
RNAL
VIEW
Asset Transaction
Header ID
Book Code ID

View Depreciation Journal Entries

Review Journal Entries

https://hostname/fscmUI/faces/deepli nk?objType=@{1}&action=@{2}&obj Key=pLedgerId=@{3};pSourceIdInt1= @{4};pSourceIdInt2=@{5};pSourceId Char1=@{6};pEntityCode=@{7};pEve ntClassCode=@{8};pEventTypeCode
=@{9}

Drills to Review Journal Entries page where you can view the journal details or drill down further.

FA_DPRN_VIEWJO
URNAL
VIEW
Ledger Key ID
Asset ID
Period Counter ID
Book Code ID
DEPRECIATION
DEPRECIATION
DEPRECIATION
 
 
 
Drill down from OTBI adhoc reports to Receivables
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows
users to click on an object and navigate directly to the source application. Using this framework,
OTBI Financials has provided a capability to drill from an OTBI report to Receivables details in
the Oracle Fusion Receivables Cloud.
The following table indicates the target page that users can drill to and the URL formats needed
for the drill from OTBI reports. Each URL accepts parameters the details of which are mentioned
in the respective sections.
 
 
 

Action

Target Page in Fusion Apps

URL Format

Edit or Review Transaction

Edit/Review Transaction UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction

Credit Transaction

Credit Transaction UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction

Apply On Account Credit Memo Transaction

Apply Credit Memo UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction

Adjust Transaction

Manage Adjustments UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction

Create Receipt

Create Receipt UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey

Manage Receipt

Manage Receipt UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=receiptNum

Manage Customer

Manage Customers UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey

Edit Customer Account

Edit Account UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=accountNu 

Edit Customer Account Site

Edit Site UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=accountNu 

Promise to Pay

Promise to Pay UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction

Manage Payments

Manage Payments UI

https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=transaction
 
 
 
Drill down from OTBI adhoc reports to Subledger Accounting Journals
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows
users to click on an object and navigate directly to the source application. Using this framework,
OTBI Financials has provided a capability to drill from an OTBI report to Subledger Accounting
Journal details in the Oracle Fusion Subledger Accounting Cloud.
The following table indicates the target page that users can drill to and the URL formats needed
for the drill from OTBI reports. Each URL accepts parameters the details of which are mentioned
in the respective sections.
 

a

Target Page in Fusion Apps

URL Format

Functional Overview

Parameters

View a Journal Entry

View Journal Entries

https://hostname/fscmUI/faces/deepli nk?objType=@{1}&action=@{2}&obj Key=applicationId=@{3};aeHeaderId
=@{4};closeMainTaskOnExit=@{5}

Drills to the View Journal Entry Page where you can view the Journal entries.

XLA_SUBLEDGER_
VIEWJOURNAL
VIEW
Application ID
Journal Header ID
OTBI
 
 
 
x

Comments

Post a Comment

Popular posts from this blog

E-Text Report In Fusion | Types of E-Text reports

 WHAT IS Oracle Fusion E-Text Report ? An eText template is an RTF-based template that is used to generate text output  for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). How it generate the output for User or Bank? At runtime, BI Publisher applies this template to an input XML data file to create an output text file. that can be transmitted to a bank or other customer.  Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data. Example :- Bank payment file , Bank MT940 File .. etc what is look and feel of this file ? Note:  There are two types of eText templates:  1. fixed-position based (EFT templates)  2. Delimiter-based (EDI templates) What IS EFT File? An EFT is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text). Link for download:- EFT :-  https://docs.google....
Read more

Supplier API's

API's for Create Supplier, Create Supplier Site, Create Supplier Site Contacts --======================================================================= -------------Supplier API ------------- 1. First Write a CURSOR for Required Data 2. FND_GLOBAL.APPS_INITIALIZE 3. Pass required Values in Proper way. 4. API :- For Supplier Create (pos_vendor_pub_pkg.create_vendor)    API :- For Supplier Site Create (pos_vendor_pub_pkg.create_vendor_site)    API :- For Supplier Create Contact (ap_vendor_pub_pkg.create_vendor_contact) 5. Run API 6. Checking ------------------------------  Query For APPS_INITIALIZE   --------------------------------------------- select 'USER_ID' REMARKS , user_name NAME, user_id ID from fnd_user where user_name like 'DEVELOPER' union select 'RESPONSIBILITY_ID' NAME, responsibility_name , RESPONSIBILITY_ID from fnd_responsibility_tl where responsibility_name like 'Payables Manager' union s...
Read more

How to pass default Parameter in cursor

--==================================================== --Parameterized Cursors /* Syntax of Parameterized Cursor :- CURSOR cur _ name (parameter list may be one, two, or more or Default ) IS SELECT statement; OPEN cur _ name (Parameter value) */ EMPNO ENAME HIREDATE DOB GENDER SAL DEPTNO COMM 1000 Sachin 11-Sep-85 01-Mar-20 M 25000 20 1002 Rena 01-Aug-82 11-Mar-20 F 125000 20 1008 Sonu 11-Sep-85 01-Mar-20 M 2500 10 100 1003 Chavi 25-Mar-81 15-Feb-20 F 5000 20 1006 Ravi 11-Sep-89 01-Mar-19 M 2500 10 100 1005 Vinod 18-Sep-86 01-Mar-20 ...
Read more