Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label Date Conversion

Posts

[OIC] How to convert date in dd/mm/yyyy format to dd-mm-yyyy format in OIC?

on November 30, 2024

Date Conversion OIC OIC Mapper Oracle OIC

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 BIP6 BIP Refresh Time1 BIP Report1 Call Fusion BIP Report2 Change Password1 Code Combinations2

Compute Instance1 Database1 Date Conversion1 DB Adapter2 Development1 EBS3 ESS Jobs3 Examine1 FBDI3 Fusion BIP2 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 NVL2 NVL in OIC2 OCI4 OCI Compute2 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OIC2 OIC Mapper2 Oracle11 Oracle ADF17 Oracle APEX1 Oracle Apps57 Oracle Apps R124 Oracle BIP5 Oracle Cloud7 Oracle Cloud Free Tier1 Oracle cloud Infrastructure4 Oracle Cloud Security1 Oracle Cloud VM1 oracle ebs3 Oracle ERP1 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion45 Oracle Fusion BIP1 Oracle Fusion ERP10 Oracle Fusion Financials10 Oracle Integration Cloud3 Oracle OAF16 Oracle OCI9 Oracle OIC20 Oracle SOA 12c10 Oracle SQL9 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST2 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL7 SQL Queries6 SQL Query2 SSH1 Value Sets1 VBCS1 Virtual Machine1 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

Clearing Oracle JDeveloper temp and cache directory with hotkeys

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

All rights reserved