Oracle Apps Fusion Training Home

OFSAA - FTP - Funds Transfer Pricing Explained

Tuesday, 31 January 2012 02:24 Anil Passi

How does a bank know if their loans are profitable? Or how do they know if their savings division is profitable. Or how does a bank know which branch is profitable or loss making? The answer to these questions is calculated by the Fund Transfer Pricing engine.

On one side the banks borrow and other side the banks lend. Overall interest income [lending] minus interest expense [borrowing] is called Net Interest Income [NII]. When NII is positive, then the bank is performing well. FTP helps you monitor the NII per customer account level, that can be rolled up to branch level which in turn can be rolled up to Bank level, thus allowing you to monitor the profitability of the bank at any level.

The treasury division sits in the middle as a broker of asset generating and liability generating divisions. Within the Treasury you have a central funding unit and another is marketing unit. Central funding unit sends its position to Treasury, so that Treasury knows whether to borrow or lend/invest. Marketing division is responsible for selling complete range of Treasury products such as FX, Derivatives as well as deposits to the customers of the bank.
To know the profitability, banks need to create a benchmark yield curve. And over the yield curve they deploy both assets and liabilities. The rate at which money is transferred by central funding unit to the branches is called transfer rate.

Central funding Unit takes the interest rate risk. Central Unit absorbs the loss if interest rate increases in the wider market and whilst the branch will get funds at pre-agreed price.

Add Comment (1)

Last Updated ( Tuesday, 31 January 2012 02:39 ) Read more...

OFSAA Data Model - High Level

Tuesday, 31 January 2012 02:02 Anil Passi

The data model in OFSAA is divided in multiple layers; however two key areas are Ledger Stat and Instrument tables.
The purpose of these is as described below This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Ledger Stat	Ledger Stat captures ending balances, average balances, income & expense
	Ledger Stat in OFSAA is one of the sources for the transfer pricing and profitability process, for example the amount of expenses incurred in running a bank branch can be derived from the ledger stat.
	Ledger Stat contains balance sheet and capital allocations
Notes on Ledger Stat	Only one ledger stat table exists in each OFSAA instance
@apps2fusion (Copyright)	New columns cannot be added
	Custom ledger stat tables cannot be registered
	General Ledger or FAH balances can feed into Ledger Stat. The decision between FAH or GL feeding into Ledger Stat depends upon the level of granularity desired in Ledger Stat.

Add Comment (3)

Last Updated ( Tuesday, 31 January 2012 02:11 ) Read more...

OFSAA - What is Asset Liability Management - ALM

Sunday, 29 January 2012 01:41 Anil Passi

Institutions over a period of time accumulate profits, and these become their wealth. Using Asset Liability Management [ALM], OFSAA can calculate liquidity of the balance sheet and can calculate as if scenarios in the event of changes to interest rates. Sticky assets can affect the banking books. ALM requires continuous monitoring, and this should happen on a daily basis.

If on 1st of month you lend some funds on long term and you borrow some in short term. In such scenario, by mid-month you may not have enough liquidity. ALM engine can identify and report such liquidity gaps ahead of time.

The ALM takes Asset type into account and allows you to segregate all the assets according to the time buckets. This helps in liquidity calculation.

Objectives of ALM

Manage liquidity risk

Foreign currency risk

Interest rate risk

Overview of features in ALM

Assets

Advances, Term loan, Working Capital, Overnight Deposits are all assets.

Investments of type Equities and Bonds are also assets.

Cash is also an asset

Market Repo is an asset

Repo is a repurchase agreement is when Anil gives Mike his Dell Server Machine for £1000, with a promise of purchasing it back for £1100 after 2 months. It’s Repo for Anil and reverse-repo for Mike.

Add Comment (0)

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 (1)

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 (2)

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 (7)

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 (6)

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 (2)

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