The Cool Fox

Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Follow the below steps to setup hotkeys: Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto Help -> About -> Properties Tab and search for ide.system.dir this is system directory In the system directory, there are two directories which need to be cleaned: .diagnostics and .history Now create the following batch file (.bat) with above-copied directories....

[Fusion] How to use multi selection LOV in Oracle Fusion BIP Report?

In this post we will see how to use multi select LOV in Oracle Fusion BIP Report. Login to Fusion BI Catalog of your fusion instance by using the below URL: https://<server>.fa.ocs.oraclecloud.com/analytics/saw.dll?bieehome Once logged in, create new Data Model by clicking Catalog -> Data Model It will present you untitled Data Model. Now, click on New Data Set button and choose SQL Query as type of the Data Set from the list. Enter the name of Data Set like Q1 and choose Data Source as ApplicationDB_FSCM and provide the SQL query We have the below query SELECT aia.invoice_id ,aida.invoice_distribution_id ,aila.line_number ,( SELECT hou.name FROM HR_OPERATING_UNITS hou where hou.organization_id=aia.org_id) org_name ,( SELECT ps.vendor_name FROM poz_suppliers_v ps WHERE ps.vendor_id=aia.vendor_id ) v...

Change look and feel of Oracle JDeveloper to Windows

To change the look and feel of Oracle JDeveloper to Windows, follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In the Environment section, change the Look and Feel from Oracle to Windows

[OIC] Trigger OIC REST Integration from Oracle Fusion BIP Report

In this post we will see how to trigger the OIC REST Integration from Oracle Fusion BIP Report. Prerequisites: Access to OIC Console to create integration. Make sure you have ServiceDeveloper or ServiceAdministrator access. OIC REST Integration which can be invoked by using Basic Authentication. Make sure you have one generic OIC user which can be used to setup OIC Connection in Oracle Fusion BIP. For this generic user we need to have username and password available and it should not be SSO user, i.e. it should be of type non-federated account. Access to Oracle Fusion BIP with Admin access to add new data sources, i.e. user must have BI Administrator Role Steps: Create an OIC REST Based Integration with Parameters and which returns XML type response. Create a Data Source for OIC Integration instance in which you need to put hostname of OIC Intance and generic user credentials Create an Oracle Fusion BIP Report with XML Feed type data set to trigger the integrat...

[OAF] How to display logs on screen in Oracle OAF?

There are various levels at which you can display logs in Oracle OAF. In this post we will see how to display OAF Logs on screen at Level 1 i.e. Statement . OAF levels are: Statement Procedure Event Exception Error Unexpected Login to EBS and navigate to Settings -> Diagnostics Set Diagnostic as Show Log on Screen Set Log Level as Statement (1) and press Go button Now, in Java Files you can write diagnostics. Like below in controller file public void processFormRequest ( OAPageContext pageContext, OAWebBean webBean) { super . processFormRequest (pageContext, webBean); pageContext . writeDiagnostics ( this , "Inside Controller" , 1 ); //Here 1 is for Statement }

Powered by Blogger