You may have sometime the need to change some data in your application.
Apex is a great tool that allow you to develop and deploy rapidly a web based application.
Here for our example, we must access to a vendor Apex form to change some values on it.
Our goal is to have the report below in OBIEE with one link by vendor that points to the Apex vendor form and that the Apex form show us the data of the vendor.
Consider the following example:
http://pocserver01:7777/pls/apex/f?p=103:2:1451367446716618::::P2_MDM_SOURCE_SYSTEM_ID,P2_VENDOR_ID:SAP7:DEC-001
Where:
To run this example application, we would use the URL:
http://pocserver01:7777/pls/apex/f?p=103:2:::::P2_MDM_SOURCE_SYSTEM_ID,P2_VENDOR_ID:SAP4,DEC-001
When users log in, they receive unique session numbers.
Here below, you have a picture of the example report. Assume that we want to add a link on the vendor id column. This link will go directly in the Apex Interface in the Vendor form on the good vendor data.
The goal is to add the URL above and that we change for each line the value of the parameters with the value of this column :
First, we must say that the column is in a HTML format.
Second, we must change te value in the formula screen to add the link in HTML language.
"Source System"."Source System Id" || ',' || "Vendor"."Vendor Id" || '>' || "Vendor"."Vendor Id" || ''
Save and you are done, you obtain a link to Apex Vendor Form with different values for each line.
If you click on the first line, you will access to the edit form from the vendor DEC-001 for the source system SAP7.