OAF Deployment – CustomJar
Below is the sample shell script ( createjar.sh ) to create Custom Jar for R12.2.* →Read more
OAF – Popup Region on Button Event
Lets Understand the components involved in designing the above sample OAF Page – OpenPoupPG Popup Region – PendingWithDetailsRN – Region Path : /xxsar/oracle/apps/fnd/webui/PendingWithDetailsRN Shared Region : /xxsar/oracle/apps/fnd/webui/PendingWithDetailsRN In the main Page – Create the below : Region Style : popRN of style : popUp points to the shared region Create the button with the below […] →Read more
OAF – Dynamically adding view attribute, Dynamically creating view object
How to dynamically add view attribute to existing VO Following code can be used for dynamically adding new view attribute to existing standard VO How to dynamically create query based view object →Read more
Oracle BI Publisher – Bursting With Multiple Data Model Queries
As the split by logic requires only one parent – it is always advised to design queries in a dependent manner, considering one parent with the child under it In the below Data Model — G4 is the parent with three children linked with : KEY Bursting level they are split by the Parent G4 […] →Read more
Oracle Fusion BI Publisher – SFTP and PGP Configuration
Fusion Applications BI Publisher : How to request configuration of Public/Private key encryption for delivery from BI Publisher to external FTP Servers ( Doc ID 1987283.1 ) GOAL This document details how to setup the Public/Private key encryption for an external (to the Oracle Cloud) FTP Server in a Fusion Applications BI Publisher installation. SOLUTION […] →Read more
Oracle Cloud Fusion – Customer Conversion Tables
OAF/ADF – Get Current Date and time
Get Current Date and time We usually need to get current date and time in java class. It is easy to get current date for java.util.Date class. java.util.Date date = new java.util.Date(); This date object gives current date and time. To use this date and time this can be formatted in needed date format as […] →Read more
ICS (OIC) – New Feature to Test REST API within the ICS Console
Test Integration feature allows users to test a non-scheduled integration with REST endpoint by invoking it directly from OIC console without relying on any third party software. Prerequisite for Test Integration Feature Enable feature flag: oic.ics.featureflag.spa.designer oic.ics.console.integration.invoke-integration-support The minimum Oracle Integration version required for the feature is 191110.1400.32380 Click on Test on the active Integration, it works […] →Read more
OAF Basic Data Type Conversion Methods For Frequent Usage
Source Data Type Target Data Type Conversion Sample oracle.jbo.domain.Number int Number Id = row.getId(); int idIntValue = Id.intValue(); oracle.jbo.domain.Date String Date dobDomainDate = row.getDob(); String dobStr = dobDomainDate.toString(); 1. Conversion of java String to java.sql.date private java.sql.Date stringToDate(String dateS) { ///String into […] →Read more
OAF_Page Deployment
1. Use the below script to load PG.xml / RN.xml to MDS C:\jdev\jdevbin\oaext\bin import C:\sridhar\jdev\jdevhome\jdev\myprojects\myprojects\moto\oracle\apps\fnd\webui\ComponentListPG.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=glo.dev.com)(PORT=1521))(CONNECT_DATA=(SID=VIS)))” -rootDir C:\sridhar\jdev\jdevhome\jdev\myprojects 2. List of DB Components(Tables,PLSQL-API’s) In-Respect to OAF Table Name Description JDR_PATHS Stores document paths, packages and there parent child relationship. Primary Key: PATH_DOCID JDR_COMPONENTS Stores components on documents and OA Framework […] →Read more