World Bank:
Introduction of myself: Well it’s a pleasure to introduce myself. Myself Dillip Kumar Jena holding MBA(Finance) from Madras ni!ersity" as #ell as $ompleted B.com % M.$om" $&('nter')"$A**'. ' am ha!ing more than ++ years of e,perience in the field of finance and Audits out of #hich ++ yrs of e,perience in -racle Apps .' started my -racle career #ith DJ td in Month of /0,,.' ha!e #or1ed on !arious 1inds of pro2ects" they are &upport" 'mplementation" ost production support" pgradation pro2ects and 3a!ing good 1no#ledge on 'ndia locali4ation and #ell !ersed #ith pro2ect accounting. My first pro2ect #as A td it’s a flagship company of A 5roup manufacturing &teering parts located at $hennai. 't’s a &upport pro2ect #here ' #as handling day to day issues. My 6e,t pro2ect #as B td located at Mum7ai" it’s an up gradation pro2ect from 88.9.80./ to 8/.8.8 !ersion .:hen my ne,t pro2ect #as $ td" and it’s an end to end implementation pro2ect and its flagship company of $ group #hich 7elongs to ser!ice. $urrently #or1ing on D td" td" D ltd. is a fast emerging emerging leader in the field of ;uality testing and online monitoring and ser!ices for the te,tile industry #orld#ide. D td is a part of the < /80Mn D group" located at Kol1atta. 't’s a =e implementation pro2ect. 6o# ' am gi!ing post production support" and my responsi7ilities are to sol!e the day to day issue and gi!ing the ne# end user training" raising the ser!ice re;uest #ith oracle" interacting #ith end users for clarification on issues" and defining the F&5 reports for re!enue and e,penses" and 5i!ing assistance to the generate the M'& reports to :echnical :eam" reparing the process for the customi4ed reports" $onducting the meeting for 7etter understanding the issues and clarifications. 'nteract #ith DBA for Data7ase issue" and for apply the patch for relating issue and running the scripts and Data Fi,es.
GL interview questions :
Question
Answer
What is M=$>
Multiple reporting currencies are a set of uni;ue feature #hich permits an organi4ation to report in multiple functional currency.
What are the =esponsi7ility setups>
Data group" Menu group" =e;uest group
3o# to prepare F&5>
=o# set" $olumn set
What is a =oll up 5roup>
't is to identify a group of parent !alues for reporting or other application urposes. 't is used to create summary accounts for reporting purposes.
What is :ranslation>
:ranslation is the process #hich pic1s up the foreign :ranslation currency 7alances and con!erts them into functional currency 7alances (for a particular period"&-B"etc). &o 7asically the translation process #ill generate additional additional records in the gl?7alances ta7le. 't only operates at the 7alances le!el and not on the transactions@2ournals le!el. 't pic1s up the periods rate defined for that period.(not the daily rates).
What is =e!aluation>
=e!aluation is a process #hich is typically run periodically to account for the loss@gain in the foreign currency. As As an e," if there is a transaction is foreign currency and an d it could ha!e gained some !alue due to the economic differences. &o re!aluation process #ill ta1e notice of this and create the ne# 2ournals #hich account for the net loss@gain. &o these 2ournals #ill ha!e to post again. =e!aluation =e!a luation process #ill not update the gl?7alances.
What is $umulati!e translation Ad2ustment Account>
't is to account the net difference needed to 7alance the translated $-A #hile doing the translation.
What is =ecurring 2ournal> :ypes :ypes of =ecurring 2ournal>
A recurring recurring 2ournal is a 2ournal entry that should 7e entered and posted periodically. *ach time the 2ournal should ha!e the same accounts 7ut the amounts could 7e different. :o create a recurring 2ournal" you define a recurring 2ournal template that you use to generate almost automatically the 2ournals periodically. =ecurring Journal templates can include fi,ed amounts or formulas to find amounts 7ased on 7alances of predetermined accounts. Types:-=egular"&1eleton"Formula&tatistical"Formula$urrency
What is the difference in structure 7et#een =8/ and 88i>
$ in 88i #hereas $ in =8/"&A"M-A$
What is :ranslation>
:ranslation is the process #hich pic1s up the foreign :ranslation currency 7alances and con!erts them into functional currency 7alances (for a particular period"&-B"etc). &o 7asically the translation process #ill generate additional additional records in the gl?7alances ta7le. 't only operates at the 7alances le!el and not on the transactions@2ournals le!el. 't pic1s up the periods rate defined for that period.(not the daily rates).
What is =e!aluation>
=e!aluation is a process #hich is typically run periodically to account for the loss@gain in the foreign currency. As As an e," if there is a transaction is foreign currency and an d it could ha!e gained some !alue due to the economic differences. &o re!aluation process #ill ta1e notice of this and create the ne# 2ournals #hich account for the net loss@gain. &o these 2ournals #ill ha!e to post again. =e!aluation =e!a luation process #ill not update the gl?7alances.
What is $umulati!e translation Ad2ustment Account>
't is to account the net difference needed to 7alance the translated $-A #hile doing the translation.
What is =ecurring 2ournal> :ypes :ypes of =ecurring 2ournal>
A recurring recurring 2ournal is a 2ournal entry that should 7e entered and posted periodically. *ach time the 2ournal should ha!e the same accounts 7ut the amounts could 7e different. :o create a recurring 2ournal" you define a recurring 2ournal template that you use to generate almost automatically the 2ournals periodically. =ecurring Journal templates can include fi,ed amounts or formulas to find amounts 7ased on 7alances of predetermined accounts. Types:-=egular"&1eleton"Formula&tatistical"Formula$urrency
What is the difference in structure 7et#een =8/ and 88i>
$ in 88i #hereas $ in =8/"&A"M-A$
-n #hat 7asis #e create operating units>
edger and legal entity
What is org?id and organisation?id>
-rg?'d means - 'd and organisation?'d means 'n!entory -rg 'D
What is B= 800 and #hich stage #e are preparing>
'ts a document for all set up .Before ser Manual it has to sign off.
What is Fle,field>
A fle,field fle,field is a field made up of su7 fields or segments.
What is KFF (Key Fle,field)>
't 7uilds uni;ue entity identifiers (Data stored in the &*5M*6: fields.).'ts mandatory fle,field for arranging code of com7ination #hich consists of C fle,field.5 "A"FA"A="3=E
What is Key fle,field name in 5>
Accounting Key Fle,field
What is DFF (Descripti!e Fle,field)>
:o store the additional information (Data stored in A::='B:*& fields)
3o# to create DFF>
5o to DFF ;uery as 7ased on application and create DFF.
Why Allo# Dynamic 'nserts>
Allo# dynamic option is to create ne# code com7ination and also modify the code com7ination can 7e done other#ise not possi7le.
se of $ross alidate &egments>
controls the com7inations of !alues you can create #hen you enter !alues for 1ey fle,fields
What is segment> 3o# many no. of segments in Accounting Fle,field>
A segment is a single su7 field #ithin a fle,field.A segment is represented in data7ase as a single ta7le column. Ma,imum 0 segment"8 Attri7ute in DFF
3o# many
'n -racle 5"We can create 6 no. -f fle,field structures.
fle,field structures can you create for 5> What is !alue set>
't is a set of !alues
Gou do not al#ays #ant a user to enter 2un1 free te,t into Why do #e need all the fields. 3ence" -racle Apps uses !alue set to !alidate !alue sets> that correct data is 7eing entered in the fields in screen. 's !alue set attached to all the fields that re;uire !alidations>
6o
Where lies the usage of !alue sets>
alue sets are attached to segments in Fle,fields. Gou can argue that !alue sets are also attached to parameters of concurrent program(7ut in reality oracle treats parameters as Descripti!e Fle,fields)
3o# many Different 6o security"3ierarchical"6on3eirarchical &ecurity :ype in !alue set> What are the 6ame"&ecurity type"ma,imum no"indepedent"list of field in $reation !alues"pper case"$har of alueset> What are the format types and !alidation types a!aila7le in !alue set>
Format typeH$haracter"Date "Date time"&tandard date"standard datetime":ime Validation Type:Dependent"'ndepedent"6one"air"&pecial"ta7le":ranslata7le indepedent":ranslata7le dependent
What is Fle,field ;ualifiers>
A fle,field ;ualifier identifies a particular segment of a 1ey fle,field.
:ypes and urpose of Fle,field Iualifier>
Balancing segment"6atural Account"$ost centre"management"&econdary trac1ing"'ntercompany
What is the use of Management Fle,field Iualifier>
:his #ould ;ualify a segment to 7e the management segment if that segment has management responsi7ility and you can facilitate setting of =ead" Write access permissions #hile defining Data access set in 5.
What is the use of &econdary :rac1ing Fle,field Iualifier>
:his attri7ute is used to identify the secondary trac1ing segment to process income statement closing" translation and re!aluation.
What is &egment ;ualifiers>
A segment ;ualifier identifies a particular type of !alue in a single segment of a 1ey fle,field
What are types of &egment Iualifier>
For $ompany and cost centerHAllo# posting "Allo# 7udgeting For 6atural AccountHAllo# posting "Allo# 7udg eting"Account :ype":hird party $ontrol Account"=econcile Asset"*,pense"ia7ility"-#nership@&toc1holder *;uity"=e!enue
3o# do you define parent $hild relationship for segment !alues>
'n segment !alue ena7le the parent !alue"define the child range and enter the lo# high ranges of child !alue.
What is &ecurity =ule>
't restricts the access of different segment !alues for different responsi7ilities.
What is $=($ross !alidation rule)>
$= restricts particular code of com7ination at $-A le!el.
What are the period types> What are the period types pro!ided in 5>
A nit of time "such as one #ee1 "t#o #ee1s or a month on #hich your accounting calender is 7ased.Types:-Month"Gear"Iuarter"3alf Gr"3alf month"Wee1
What are period status in 5>
6e!er -pened"-pen"$losed"ermanently closed"future
What is an Accounting calender>
't is to specify the no. -f periods in the year for the purpose of transaction and maintaining accounting data.
3o# to $reating $alender>
6ame"refi, month"type"year"6um"from":o"'f ad2ustment then clic1 on Ad2usting
What is transaction calender>
:his calender determines #hich days in a#ee1 are 7usiness days and specifies other non 7usiness days such as holidays.Use:-'t must 7e assigned for set of 7oo1s for #hich a!erage 7alanceing is ena7le to control transaction posting.
What is monetary currency>
't is currency #hich has a monetary !alue.
What is con!ersion type>
A process that con!erts foreign currency transaction in to functional currency.'.e.$orporate"reporting"spot"user
What is 2ournal &ource>
't is an indicator 7y #hich 5 identifies and Differntiates the origin of 2ournal entries #hich is mandatory to create a ne# 2ournal.
What is 2ournal $ategory>
Journal category specify #hat 1ind of transaction the Journal entry represents.'t determines the nature of 2ournal entry i1e purchase"paya7le"recei!a7le etc #hich is mandatory to create a 2ournal.
3o# to create 6e# Journal $ategories>
&et up"2ournal"category
3o# to setup Journal Appro!al>
'n ledger tic1 on ena7le 2ournal appro!al"then source ena7le 2ournal appro!al
3o# #e can post su7ledger entries to 5 #ithout any concurrent. >
5o to ledger su7ledger application then assign post in 5 as yes for module #ise.
3o# to ost all Journals in single stro1e>
=un rogram Automatic osting"*lse go to setup2ournalAutopost
What is edger &ets>
edgers sets allo# you to group multiple ledgers together to achie!e processing efficiencies. For e,ample" you can open or close periods for multiple ledgers simultaneously" translation@=e!aluation 7alances for all ledgers in a ledger set" run recurring 2ournals that update 7alances for multiple ledgers" or run consolidated financial reportsand F&5 report that summari4e 7alances across multiple ledgers in a ledger set.All ledgers in a ledger set must share the same chart of accounts and accounting calendar/period type combination.
What is Data Access &ets>
Data Access &ets ena7le you to specify read only or read and #rite access for a legal entity" ledger" Balancing &egment alue or Management segment alue.
3o# to define Document &e;uence for Journals>
&ys admin"Application create and assign as aumatic and manual
3o# to find Journals *ntered today>
Journal find screen"clic1 more"dates created from "to
=e!erse a Journal -ptions a!aila7le>
Ges"At 2ournal screen "re!erse ta7 else setup 2ournalAuto reverse
$an ' correct su7 ledger entries from 5>
Ges"at 2ournal import "correct option
$an ' delete su7 ledger entries>
=un re;uest rogram Delete Journal 'mport Data"parameter &ource"re;uest 'D"edger
Key reports in 5>
:rial 7alance"Account Analysis report(8C0)"F&5 reports"
9 :a7les relating to 5>
5?BD5*: 5?BD5*:?types 5?DA'G?=A:*& 5?$onsolidation 5?Balances