Oracle Apps Fusion Training Home

OAF Personalization and Extensions A case study

Thursday, 12 January 2012 20:48 Senthilkumar Shanmugam

Abstract

OAF Personalization means personalize the user interface (UI) of Oracle Self-Service Web Applications without modifying any underlying code whereas OA Framework extensibility is geared to enable customers to add new functionality and override or extend existing business logic beyond what can be accomplished via personalization. In short it the programmatic approach for personalization.

In this article I will explain a case study for OAF Personalization and Extension by analyzing real time requirement and how we have to use OAF Personalization and OAF Extension to meet the requirement.

Business Requirement

Add Comment (0)

Last Updated ( Friday, 13 January 2012 04:29 ) Read more...

Further video training tutorials on R12 OAF Extension

Saturday, 07 January 2012 23:36 Anil Passi

Please find some video tutorials for OA Framework Training in R12

To watch these videos in crisp clear format, view them in HD

Add Comment (0)

Last Updated ( Saturday, 07 January 2012 23:54 ) Read more...

Building the FOD Schema in JDeveloper for ADF

Saturday, 07 January 2012 00:00 Anil Passi

JDeveloper 11g comes in built with a sample application called FOD, i.e. Fusion Order Demo. The recommendation is to navigate and experiment through this application after you have learn the basics of ADF.

The pre-requisites for installing the FOD are

1. Install the JDeveloper 11g, from here
http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html
2. Install Oracle XE Database, from here
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
3. Download the sample FOD application, from here
http://www.oracle.com/technetwork/developer-tools/jdev/index-095536.html

Follow the instruction in the URL for the FOD, and for some users the FOD will install smoothly.

However, in some cases, you may get the error similar to below
refreshSchema:

BUILD FAILED
C:\JDeveloper\demo\Infrastructure\Ant\build.xml:51: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:100: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:63: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:28: C:\Oracle\Middleware\jdeveloper\wlserver_10.3\server\lib not found.

Total time: 6 seconds

In order to resolve this issue, first find the JDeveloper installation location. In my case it is C:\Oracle\Middleware\jdeveloper

Add Comment (1)

Last Updated ( Saturday, 07 January 2012 23:52 ) Read more...

Add Attachment Region In Oa Framework Page

Friday, 23 December 2011 21:19 Dakshesh Patel

Business Requirement : - User needs to add Attachment (Upload/review attachment) Functionality in Any Existing OA framework page.

Solution :- You can add new Attachment Link or Attachment Table Type oa framework Region on that page using personalization.

Difference between Attchment link and attachment Table is When you add attachment table It will display List of Attachments on same page where you have added attachment Region and when you Add Attachment Link it will display link on Same page where You have added Attachment Region and when you click on that link page will Redirect to another page where all list of attachments will be shown.

1)Go to page where you want to add attachment link.
Ex : Framework Tutorial Toolbox ->Search / Drilldown.

Add Comment (6)

Last Updated ( Saturday, 24 December 2011 20:09 ) Read more...

Oa Framework - Xml Publisher Integration for R12

Sunday, 30 October 2011 09:36 Dakshesh Patel

Business Requirement : When User require report output from jsp/Oa framework page then They have to Run

concurrent program which is very tedious process for users and if user wants output in Excel/PDF/Word and in many other formats then they have to run concurrent program again and again for each different type of output file.

So Business requirement is that report output should be retrieved from Oa framework Page Just by single Button Click For Different Type Of Formats.

Sample Output :-

Solution : Creating Oa framework Report and Showing output of Report in Different Format We have to integrate oa framework and Xml Publisher.

For this solution first you have to create Oa framework page, Data Template and Data definition.

Add Comment (11)

Last Updated ( Sunday, 30 October 2011 11:12 ) Read more...

Organization Chart in R12 HRMS

Saturday, 29 October 2011 11:04 Dakshesh Patel

Business Requirement: Need to display organization hierarchy diagrammatically with vacant and occupied/Active positions in each organization.

Report Should display default organization hierarchy of business group associated with responsibility from which Report is Opened.
Report Should also display active and vacant positions of whole Hierarchy as well as for individual Divisions/Departments/Sections/Units.
Following should be format of individual Division/Department/Section/Units of Hierarchy

.

Organization name : Name Of Organization
Organization Type : Division /Department/Section /Unit
Active Positions      : No of Positions which are Occupied On Current date For
                                 Given Organization.
Vacant Positions      :No of Positions Which Are not Occupied By Employee in
                                 Given Organization.

NOTE :
1)In Our case All Positions are Single Incumbent.
2)We are not Considering Business Group In Hierarchy our Hierarchy starts
   from Division.

BG => Group =>Division =>Department => Section =>Units
So our hierarchy starts from Highlighted part.

The following should be Design of Report which contains one drop down list for selecting Division and Based On that Division
Report Should Be populated for selected division’s Hierarchy.

Challenges :
1)This kind of report is not possible to develop with report builder(Rtf/Rdf) or Discoverer Report.
2)Using OA Framework, you can create some charts but OA framework does not support organization charts as per our requirements..

Possible options for solutions :-

Add Comment (5)

Last Updated ( Sunday, 30 October 2011 07:06 ) Read more...

Define Accrual Plan element And Accrual Plan Part 2

Tuesday, 25 October 2011 00:00 Dakshesh Patel

We have defined absence and absence element and create testing for leave in previous post. The part 1 of this article can be

accessed from this link. In this Post we will discuss about how to handle encashment, opening balance, adjustment and designing of accrual plan.

Create Element For Opening Balance.
NOTE : Go to ’01-JAN-1950’ using date track mode before creating element.
N: HRMS Super User  Total Compensation  Basic Element Description

Element Name	Annual Leave Opening Balance
Primary Classification	Information
Description	This Element Capture Opening balance.
Type	Non Recurring
Input Values	Opening Balance(Day)
	Effective Date(Date)
	Reason (Character)
	Future1 (Character)
	Future2 (Character)

Add Comment (2)

Last Updated ( Tuesday, 25 October 2011 09:20 ) Read more...

R12 HRMS Payroll- Define Absence Type and Absence Element (Accrual Plan Setup Doc Part 1)

Tuesday, 18 October 2011 09:09 Dakshesh Patel

Business Requirement : Organization require automated process for Accrual of 2 leaves at every month so yearly total 24 leaves employee can take

if at start of new calendar year all unused Annual leaves should carried out to next year Leave Balance.

Absence Management : Oracle provides seeded functionality which can capture leave related information and provide extensibility so you can make changes as per your requirement.
Absence management is provided in self service(Oa framework pages) as well as from core Hr(Oracle forms)
Navigation For Absence management :

1)Core HR:-
N : HRMS super (Responsibility) ||people(Menu) || Enter and maintain (Function)||Others ||Absence

Add Comment (3)

Last Updated ( Sunday, 23 October 2011 12:52 ) Read more...

SLA - Account Analysis Report - Out of memory error

Monday, 07 March 2011 14:59 Anil Passi

In large implementations with large transaction base in GL, it is very common to get java.lang.OutOfMemoryError" errors in the Output Post Processor log of the Subledger Accounting program Account Analysis Report. This report produces the output in BI Publisher.

To resolve this, you need to implement the steps below
1. Navigate to XML Publisher Administrator responsibility

2. Click Administration->Configuration

Add Comment (2)

Last Updated ( Saturday, 07 May 2011 15:03 ) Read more...

PO to AP to Fixed Assets

Friday, 25 March 2011 11:10 Ashish Kanak

This document demonstrates the cycle of Blanket PO -> PO -> AP Invoice -> Asset. Some screen shots are my instance specific. Please ignore the DFF fields.
Check approval access of User

Employee screen -This employee will be used as Buyer. Check his approval rights for approving purchase document.

Add Comment (1)

Last Updated ( Friday, 25 March 2011 12:52 ) Read more...

Generate BACS File in R12 Payables for Payment run

Friday, 25 March 2011 11:03 Ashish Kanak

Will post new article soon

Add Comment (3)

Last Updated ( Tuesday, 12 April 2011 04:10 )

Project Billing Cycle

Sunday, 20 March 2011 21:29 Ashish Kanak

Will post new article soon

Add Comment (6)

Last Updated ( Tuesday, 12 April 2011 04:11 )

Web ADI in HRMS - Part 1

Thursday, 10 March 2011 10:47 Sanjay Singh

We need to develop a new integrator which will be used to upload data into person EIT. Assume we have defined one EIT to store Training test details in Oracle which was one of the important inputs for Confirmation of employees. Creating data for each employee for each training using the seeded form was a time consuming task and as a result of which we had provided them an excel interface to upload data into system.

1. Pre-requisites for working on Development or use of WEBADIs 2

1.1 Set Profile Option 2

1.2 Enable the Macros options for your excel sheet 2

2. Creation of a new Upload Integrator 4

2.1 Business requirement 4

2.2 Create the Wrapper Package 4

2.3 Define the Custom Integrator 6

2.4 Define the Layout for the integrator 9

2.5 Defining the Form Function for Integrator 13

2.6 Assign Function to Custom Menu

Add Comment (27)

Last Updated ( Thursday, 10 March 2011 11:56 ) Read more...

E Business Tax R12 - EBiz Tax Implementation Steps

Wednesday, 02 February 2011 23:38 Anil Passi

This article contains step by step implementation guide with examples for EBiz Tax in R12.

IMPORTANT - To view this article, you must have access to http://docs.google.com

It will take upto a minute for this document to load.

Add Comment (12)

Last Updated ( Saturday, 22 January 2011 19:03 ) Read more...

Control or Third Party Accounts in R12 General Ledger

Tuesday, 21 December 2010 06:12 Anil Passi

Very often the GL Super Users create manual journals either directly from the screens or using the Web ADI to upload the journals straight into General Ledger. However account codes used in these manual journals are secured via value set security and the cross validation rules. But this level of security is not enough. For the sake of an example, the GL Users must not be allowed to tamper with the amount of expenditure a company has made on Office Furniture for their offices. Let us say that all the GL Account segment value Office Furniture related expenses are 5115.

A feature named Third Party account is a feature of R12 which helps keep the Subledger like Payables or Receivables in sync with General Ledger.

The control account functionality of 11i is now called Third Party account in R12. Some accounts should only be entered via the Subledger, and not be allowed for manual journal creation in GL. Hence for those entries, we can enable the qualifier to flag those as Third Party account.
In the value set definition screen, query the segment value as shown in image below. In this case, the Account Segment value is 5115. Against the segment qualifier, in Third Party Control Account, select value = Supplier, because in this example we will control the charges to this account segment via Payables whilst ensuring that Supplier details are specified. In other words, this configuration will ensure that you cannot put a charge against office supplier into GL unless you have specified the Supplier from whom the goods were purchased.

Add Comment (9)

SLA Part 11 - Steps to Customize of SLA - Subledger Accounting

Friday, 17 December 2010 07:17 Anil Passi

We have thus far seen the basic fundamentals and a simplistic scenario of Subledger Accounting. In the example that we

saw, we created components required for the SLA configuration from ground zero. That is also known as the bottom up approach, where you build the lower level components and then move up the chain to attach your SLA configuration to your Ledger[11i SetOfBook equivalent in R12].
However you never ever use that approach in real life for modules such as Oracle Payables, Oracle Receivables, Oracle Cash Management, Oracle Fixed Assets or Oracle Project Accounting etc. The reason is that, SLA comes pre-configured for all the widely used modules in the EBusiness Suite. All the commonly used rules are already seeded into the SLA config by Oracle, hence all you need to do is to customize those components.

Before we see the steps for customization of SLA, let us first do some questions and answers

Question - I can customize the account generator in Procurement and Fixed Assets. Do I really ever need to customize “Subledger Accounting” in such cases?
Answer- The pre-configured SLA by Oracle will use the accounts generated in respective modules as the source. The seeded ADR's will in most cases return the very same accounts that are generated in the respective modules. Effectively "garbage in garbage out", or you can say "quality of the account that goes into SLA, and the same quality accounts are then sent to General Ledger". The message from seeded SLA in most cases is “What you feed to SLA will also be fed into the Oracle General Ledger”. Therefore if you have already customized the account generation workflow in the respective module then you do not require customization in SLA. In fact, the customizations on the seeded SLA configurations must be kept to bare minimum. Although SLA provides you with ability to override accounting definition, however the main reason for creation of SLA was to implement multiple shadow accountings against ledgers.

Add Comment (14)

Last Updated ( Friday, 17 December 2010 10:22 ) Read more...

SLA Part 10 - Testing and explaination of SLA Config

Monday, 13 December 2010 00:00 Anil Passi

In the SLA articles Part 1 to Part 6, we understood the basic concepts of Subledger Accounting.
In the SLA articles Part 7 to Part 9, we configured SLA for Payables as an example.

In this article, we will test the configuration to see the results of the configuration performed in Part 7 to Part 9 of the SLA articles. We will also explain the results of the test.

Our SLA setup was done for Payables, hence we will create an Invoice in Payables and check the accounting entries to reconcile those against our SLA setup.