ADF ListView Component

ADF ListView Component

ADF ListView component displays a List of Items based on rows of a collection model.If you are working in Jdeveloper11g(11.1.1.7) version then you would notice that when you try to drop in a collection onto a page then the same does not show List View component to select from.Same is available from the component palette for selection seems to be an issue with Jdeveloper.

Jdeveloper11g(11.1.1.7)

Do not see an issue with Jdeveloper12c.

Jdeveloper12c

This component works pretty much like a Table component when it comes to the binding level.How to use this component in 11g as we need to drop this component from the component palette and then provide the property values manually.Easy way for the same is to first drop your collection as a table component (would prefer a read only table component) then drop in the list view component.Now add a list item component into the list view as shown below

Now copy the value available in Table component value property and provide the same into the list view components value property as below,also provide the selection listener value as similar to Table component value to the list view component.Also make the selection property for list view component as Single.

Similarly provide the binding values for the list item component as the value is available in the output text component under column of the table component value would be something like this - #{row.EmployeeId} i have copied it to the output text as #{item.EmployeeId} just to differentiate that this is a list items value the way it happens in 12c.

Now it show a warning in the output text component as the variable item is yet to be defined.Define the same at the listview level var property

Delete the table component which was used as basis for setting the properties of the list view component.After all the property are set list view item is now ready to use which will be rendered as below

Reference - https://www.youtube.com/watch?v=9aLLn_NIrZI

Exporting Data from ADF Table

Exporting Data from ADF Table

In this post we shall look at how to export data from an ADF table.To export data from an ADF table we shall use an export collection action listener from the operations component panel of ADF Faces.

General steps which i followed to export data from ADF Table declaratively.

• Inside a Layout container had a panel collection component
• Under this layout container have a panel collection component used
• Inside the panel collection dropped an read only ADF table
• Now we can either use the toolbar facet or menu facet of panel collection component
• In the current example have used toolbar facet have tried it with menu facet also the steps are the same.
• Toolbar facet of panel collection drop a toolbar and drop a button into the toolbar, give the button an appropriate text

Inside the button drop an export collection action listener a dialog opens up asking for two mandatory attributes for this listener which are as mentioned below:

i) ExportedId - ID of the component to be exported

ii) type - export type. The only currently supported value is 'excelHTML'

Other optional parameters are

iii) filename - file name for the exported content

iv) title - the title of the worksheet of the exported content

v) exportedRows - rows to include in the exported content

specific reason to use panel collection is to wrap my collection component which is the table as it provides toolbar and menu facets

Note:
Only the following can be exported:

Value of value holder components (such as input and output components).

Value of selectItem components used in selelctOneChoice and selectOneListbox components (the value of selectItem components in other selection components are not exported).

Value of the text attribute of a command component.


Value of the shortDesc attribute on image and icon components.

Following is the sample code snippet of my demo app.

<af:panelStretchLayout id="psl1">
          <f:facet name="center">
            <af:panelCollection id="pc1">
              <f:facet name="menus"/>
              <f:facet name="toolbar">
                <af:toolbar id="t1">
                  <af:commandToolbarButton text="ExporttoExcel"
                                           id="ctb1">
                    <af:exportCollectionActionListener type="excelHTML"
                                                       exportedId="datatoexport"
                                                       filename="Employee"
                                                       title="EmployeeExport"/>
                  </af:commandToolbarButton>
                </af:toolbar>
              </f:facet>
              <f:facet name="statusbar"/>
              <af:table value="#{bindings.ExportEmp.collectionModel}" var="row"
                        rows="#{bindings.ExportEmp.rangeSize}"
                        emptyText="#{bindings.ExportEmp.viewable ? 'No data to display.' : 'Access Denied.'}"
                        fetchSize="#{bindings.ExportEmp.rangeSize}"
                        rowBandingInterval="0"
                        selectionListener="#{bindings.ExportEmp.collectionModel.makeCurrent}"

                        rowSelection="multiple" id="datatoexport">

This is how the application looks when it is run

Once you click the export excel button a dialog appears on whether to save the data

Saved excel file worksheet title has the title as given in the export collection action listener title property

Uploaded is the sample app here

References:

1.  Export data from Tables,Trees
2.  Export Collection Action Listener

Deleting a Jdeveloper Extension

DELETING A JDEVELOPER EXTENSION

As per checks done looks like there is no user interface to delete an extension from Jdeveloper.But we can go ahead with disabling an extension from Jdeveloper.

1) Go to Tools -> Preferences -> Extensions from Jdeveloper and then uncheck the extesions which you want to disable as shown below 

 But if we want to really delete an extension from Jdeveloper then the only option looks to be do it manually.Prior to executing this manual step first stop any Jdeveloper running instances and then do the manual activity of deleting an extension.

Go to your <MiddlewareHome>/jdeveloper/jdev/extensions directory and then take a back up of this directory before deleting any specific extensions.

Say i want to delete BPM extension from Jdeveloper then search for JAR files with name like oracle.bpm.* as shown below

Now run Jdeveloper and see whether it is working fine after the deletion of the JAR files from the extension directory.If it is working fine then you can clean up your extension directory back up accordingly.

Changing JDeveloper Font Size

CHANGING JDEVELOPER FONT SIZE

Ever wondered on how to change the font size of JDeveloper as we might me working on different screens may be on laptop or big desktop monitor.So people would really like to customize the font size as per their wish the JDeveloper font size then that would be really useful.

Came across this setting as part of my search and efforts to change the Jdeveloper font size as per my wishes.

In order to set the font size for the Jdeveloper IDE you need to modify the ide.properties file to set the font size.

It is typically available under 

Windows:

C:\Users\{user_name}\AppData\Roaming\JDeveloper\system11.<Versiopn>\o.jdeveloper\ide.properties

Linux:

For Linux just do a find for ide.properties file under your Jdeveloper home and set the font size as per your wish.

Value which i have set the font size is 15 as below in the file.

Ide.FontSize=15

In fact the ide.properties file is so self explanatory it has lot of comments documented in it on how to set the font sizes for a specific locale and look and feel etc.

Tested the same with a larger font size of 45 on my laptop below are the images for the same.

Ide.FontSize=15

Ide.FontSize=45

Reference:https://community.oracle.com/thread/2282785

Fusion Applications Transaction Database

Fusion Applications Transaction Database

In this post we shall cover on details related to Database Schema installation required for a Fusion Applications.As Fusion Applications is built on top of Fusion Middleware products it requires a significant amount of database schemas catering to the requirements of different Fusion Middleware products used.

Following is a brief snapshot on different schemas which will typically be installed in a Fusion Applications transaction database.

Out of all the schemas installed specific schemas for Fusion Applications functionality and business logic are the ones mentioned below

• FUSION
• FUSION_RUNTIME
• FUSION_DYNAMIC
• FUSION_AQ
• FUSION_BI
• FUSION_DQ
• FUSION_ODI_STAGE
• FUSION_SETUP

Rest of the other schemas are related to the specific Fusion Middleware related infrastructure components.

Let us look at the details of few of the schemas related to Fusion Applications

FUSION : This is the owner of all the objects that belong to Fusion Applications.All the corresponding rights and powers such as owning tables and objects, providing grants to FUSION_RUNTIME.  It is used for patching and has grants to many internal DBMS functions.

FUSION_RUNTIME : This is the runtime user.Used to run the Applications.Contains no DB objects.

FUSION_DYNAMIC : This is the schema that owns the objects that are dynamically created through ADM_DDL.ADM_DDL is a package that acts as a wrapper around the DDL statement. ADM_DDL support operations like truncate table, create index etc.

Looking at the schemas all application UI's related to Fusion Applications are run from FUSION_RUNTIME schema, so any development done has to be tested against runtime schema.

Now the specific details of other related technology schemas are 

AS Common Schemas	Includes:
Enterprise Scheduler Service	FUSION_ORA_ESS
Metadata Services	CRM_FUSION_MDS_SOA
	FIN_FUSION_MDS_SOA
	HCM_FUSION_MDS_SOA
	OIC_FUSION_MDS_SOA
	PRC_FUSION_MDS_SOA
	PRJ_FUSION_MDS_SOA
	SCM_FUSION_MDS_SOA
	SETUP_FUSION_MDS_SOA
	FUSION_MDS (complete MDS schema for Fusion Applications related customizations,ESS jobs etc which is related to Fusion Applications functionalities)
	FUSION_MDS_ESS
	FUSION_MDS_SPACES
Secure Enterprise Search	SEARCHSYS
Oracle Data Integrator	FUSION_ODI
Master and Work Repository
Enterprise Content Management	Includes:
Oracle Content Server 11g - Complete	FUSION_OCSERVER11G
Oracle Imaging and Process Management	FUSION_IPM
Oracle Business Intelligence (Platform)	FUSION_BIPLATFORM
Oracle BI Applications Schemas	Includes:
Oracle Transactional BI	FUSION_OTBI
WebLogic Server Communication Services	Includes:
SIP Infrastructure Location Service	FUSION_ORASDPLS
Presence	FUSION_ORASDPXDMS
SIP Infrastructure Subscriber Data Service	FUSION_ORASDPSDS
SOA and BPM Infrastructure	Includes:
User Messaging Service	FUSION_ORASDPM
SOA Infrastructure	CRM_FUSION_SOAINFRA
SOA Infrastructure	FIN_FUSION_SOAINFRA
SOA Infrastructure	HCM_FUSION_SOAINFRA
SOA Infrastructure	OIC_FUSION_SOAINFRA
SOA Infrastructure	PRC_FUSION_SOAINFRA
SOA Infrastructure	PRJ_FUSION_SOAINFRA
SOA Infrastructure	SCM_FUSION_SOAINFRA
SOA Infrastructure	SETUP_FUSION_SOAINFRA
WebCenter Suite	Includes:
WebCenter Spaces	FUSION_WEBCENTER
Portlet Producers	FUSION_PORTLET
Activity Graph and Analytics	FUSION_ACTIVITIES
Discussions	FUSION_DISCUSSIONS
	FUSION_DISCUSSIONS_CRAWLER
Audit	Includes:
	FUSION_IAU
	FUSION_IAU_APPEND
	FUSION_IAU_VIEWER
Oracle Social Network	Includes:
	FUSION_SOCIAL
	FUSION_SOCIAL_VIEWS
	FUSION_SOCIAL_CEF

Mostly the above mentioned are related to Fusion Middleware Infrastructure component related schemas whose features are used in Fusion Applications

 References : i) Fusion Applications Transaction Database

                      ii) Fusion Database Schemas

Fusion Applications to E-Business Suite Security Mapping

Fusion Applications to E-Business Suite Security Mapping

For some one who is starting to work on Fusion Applications moving from E-Business Suite, initially they may feel it hard to relate to the security components of E-Business Suite to Fusion Applications.

How to relate to E-Business Suite security components to Fusion Applications security components.

By relating it should make the work a bit simpler as the foot print of E-Business Suite is huge part of Applications Unlimited series and Fusion Applications is the latest enterprise applications offering with the use of best of the technologies.

Following Table will give you an insight on how to map Fusion Applications related security components to E-Business Suite security components.This is an effort to give an overview of components which were seen in E-Business Suite to their corresponding equivalents in Fusion Applications.

Oracle Fusion Applications	E-Business Suite
Data Role	Responsibility
Job Role	Top Level Menu
Duty Role	Sub Menu
Privilege	Form Function
Data Security	Form Function
Permission	Executable

Difference Between R12 General Ledger Calendar Definition And Fusion General Ledger Calendar Definition

Difference Between R12 and Fusion General Ledger Calendar Definition

Oracle Fusion General Ledger is a product of Oracle Fusion Applications.This document details out the difference between Oracle EBusiness Suite R12 and Oracle Fusion General Ledger Calendar Setup helping you to better understand the differences.

Calendar Setup Steps in R12 E-Business Suite

Calendar setup is a two step process in E-Business Suite

1) Define Period Types

2) Define Accounting Calendar using the Period Type defined in the earlier step

Once you define your calendar and navigate out of the Accounting Calendar setup screen the Calendar Validation Report will be submitted with an option to validate the current calendar or all the defined calendars.

Calendar Setup Steps in Oracle Fusion General Ledger

Calendar setup in Oracle Fusion General Ledger is a much more simplified process which combines both the steps of Accounting Calendar definition in a single setup flow.

Below screen shots would give an overview of the setup process of Accounting Calendar. Accounting Calendar is available under Define Calendars Task list as Manage Accounting Calendars Task

Click on the Manage Accounting Calendars Task which will take you to the Accounting Calendar setup screen.

This is a simplified screen where you define the details of your Accounting Calendar and default options are provided for making it easy to define calendars based on frequently used period frequency and adjusting period frequency. In case more flexibility is required period and adjusting frequency can be chosen as Other.

Once you fill up the other details then click Next to go on to the screen where you define the period details for your calendar.

After defining the required periods for your calendar you can save the changes. This will fire the calendar validation for the period ranges defined for any overlap of period date ranges and gaps in the period date range definition.

The tables affected while defining calendar in E-Business Suite and Oracle Fusion General Ledger are the same: GL_PERIOD_TYPES for the calendar type definition, GL_PERIOD_SETS for the calendar name details and GL_PERIODS for the individual period details in the calendar.GL_DATE_PERIOD_MAP stores the correlation between dates and non-adjusting periods for each accounting calendar and period type combination.

Details which are entered in the first screen in Fusion Calendar definition like the frequency,adjustment periods etc are stored in GL_CALENDARS a major table addition in Fusion.Also addition of an ENTERPRISE_ID column in Oracle Fusion General Ledger for GL_PERIODS table which provides the Business group details available.

The significant difference between the Accounting Calendar definitions in E-Business Suite and Oracle Fusion General Ledger is that, in Fusion, the definition is greatly simplified.  Fusion General Ledger provides the flexibility of default calendar templates for period frequency (ie Monthly) and online calendar validation while saving the calendar details

For further table related details in Fusion Applications can refer to Fusion Applications OER