Oracle Training - Defining Ledgers in General Ledger Part 1 - Oracle E-Business Suite R12 Video Lecture | Oracle EBS:Learn and Excel - Data & Analytics

in this demonstration we're going to
look at how to define a ledger in
general ledger and we'll start off by
building our chart of accounts by
building the accounting structure and
then we'll enter some values into the
value sets that we've created and then
we'll view the current calendar and also
we also view the the currencies and they
were gone and define the ledger to log
into Oracle e-business suite and you
select your general ledger
responsibilities from the navigator you
then select you the navigation to
creating your accounting key flexible
structure which is setup financials flex
fields key segments and then we'll
search for the general ledger accounting
flex field and we're going to create a
structure called y/o accounting flex so
I'm just going to add a new line in the
code and I'm going to type in y/o
underscore accounting underscore flex
and that's going to be called why your
accounting flex and I'm just going to
call it yummy accounting flex field this
could be the name of your company and
accounting flex field or which have a
name that you prefer I'm now going to
add my segments I'm going to create five
segments I created a company segment
Department account product and I'll have
a spare segment as well but select new
first segment I want to create is called
company and that will be in my first
column which is going to be segment one
and I'll just use number one for that
I'll create a value set for this in a
little while but just before that I'll
change a list of values to co-found save
come out of the form go into my value
set and I'll select value set I'm going
to use a value set that already exists
or if I wanted to a class II just create
one let me just create one just for
demonstration purposes so I'm going to
call it wine Oh on this call company
that's the new value set just going to
call it Yemi's in this company so far
let's say that I'm going to use this
time it could be long list of values it
could be a pop-up list or pop list or
I'm just going to select list of values
I could decide to have security or no
security or mainly we'll use this for my
cross validation rules and any other
security that I want to place within my
value so I'm going to put
non-hierarchical security there for my
type this is the format of the of the
field of the data that wants to go into
this field it could be character date
and so on I'll just select character for
now and I'll make a maximum size of the
field to be two characters I don't want
it to be numbers only I wanted to win
after new marriage and I also wanted to
be uppercase so I'm just going to select
uppercase and I wanted to write
justified and zero fill numbers so if I
entered one the number one in that field
it will come up with zero zero there's
also a zero one because I've got two
characters for the field
I told if I wanted to put in a minimum
value in a maximum value just to
restrict the range of values that I want
in that field from for the main for the
moment I'm just going to leave it as is
and I could also have a different
validation type for the field
and I'll just leave it independent so it
could be dependent on another field it
could be from a database and so on I
could have no validation as well so I'll
just leave it as independent save the
value and the value set which is the
construct of my field for company and
then I'll select why Oh company as my
value for the field I could if I wanted
to specify the Flex the qualifier so
just for this example I will actually
select a flexible qualifier for this
field and I'll just select my Flex a
qualifier and I'll make it mine my
balance and segment which is where I
want my debits and credits to balance or
my journals so I'm just going to select
my company segment as my balance and
segment save come out of the form assets
and flexy qualifiers for the for the
company segment but I didn't set it up
for all the others I'm going to set one
up for my account segment and for my
department I'll make department my cost
Center so I'll select cost center
segment for that and I'll make my
account the natural account
segment and this is a three key ones
that you would normally set up save come
out of the form I want to allow dynamic
inserts so anytime I create additional
account combination it will
automatically add that combination into
my account
so I'm going to save it allow dynamic
inserts I'm going to freeze my flexible
definition so if I want to make changes
to my structure I need to go back and
unfreeze it before doing that as well so
these actually create my structure for
me all the things that I can have is the
segment separator
I've got period air which is dots in
between each of the segments and once
I'm happy with my structure I can click
on compile and then this will then
compile my Flex field definition and
that's given me that it's been compiled
successfully and that's how I will
create my accounting structure next I
need to enter some values into some of
this structure there I've just created
so if I go into my setup financials flex
field key values I'm going to search for
the Y values that I actually created for
my segments so the first thing I'm going
to do is I'm going to select the
application which is general ledger
general ledger application and then
title is my accounting flex field and
then this structure is my y ou
accounting flex structure so that I can
find to find the details I can see that
in my company segment there is actually
no values here so I'm going to put value
for my company's segment I'm going to
put 0 0 and I'm going to put in the
description and call this head office
head office so that's just the value so
if I type in 0 0 that's going to be
referring to my head office
and then value zero one will be mine it
could just be my UK operations and then
T which will be our total for all
companies you can just call it the T
codes which is total for all companies
now in the values and hierarchy
qualifiers I'm going to make the total
all companies a parent in your segment
qualifiers allowed budgeting know a lot
of posting no click on ok save and
therefore the second segment which have
got Department can then enter some of
the values for my department which is my
cost Center save this and then my next
now you see that I've already got some
fielding already for my account now what
I'm going to do gonna add some
additional accounts just for us to see
how we can enter some additional ones
and also use the segment qualifiers 331
percentage I could use my ctrl f11
but I'm just going to use my query by
example run so there's 3 3 1 0 3 3 1 5
so I'm going to add a new one call them
4 3 1 2 which I'm going to call Y o
retained Y or retained earnings and you
my value soup and I'm going to make
these Allah
budgeting years allow posting years
account type is going to be my owner's
equity so that's my owners ownership and
stock account so if I just wanna share
shareholders equity account reconcile no
a third party control no going to click
on ok I've got cash as asset one one one
oh and you can see that the qualifiers
show need as an asset and I could have
some revenue account
let me just search for some revenue
accounts find revenue account will be my
four thousand numbers so if I search
from four thousand to four thousand two
hundred let's see what we've got
they can find I can see they've got a
revenue account that gives you all the
revenue accounts that's the revenue
account loss a goddamn allocations for
liability and also for expense accounts
as well so that's my account segments
set up I'm going to go to my product
product account that I've set up on the
system and my spare this is just the
default account sir that will set up for
my spare so that's all my segments
values and that's going to compile all
the hierarchies next I'm going to have a
look at the accounting calendar which is
found in my set up financials calendars
and then I've got types and I'm going to
look for all the different query enter
period type I'm going to search for
month
view query by example run you can see
that I've got 13 period calendar month
12 period calendar my I'm going to use
my 13 period calendar month for my my
ledger so that's my calendars that I'll
be using then I'm going to look at my
currencies that are enabled so if I go
into again if I going to set up
currencies define view query by example
enter view query by example run could
have done F 11 ctrl f11 and these are
all the currencies that are defined on
the system and it tells you which ones
are enabled and if you have effective
dates for the different currencies next
we'll define our ledger and in defining
our ledger we need to know the chart of
accounts structure which is our
accounting flexible structure that we
have we also need to know the currency
and also the calendar and also the
accounting convention we're going to be
using accruals which is now called the
four C's used to be called three C's
what is now called the forces which is
the convention accounting convention
been added to the C's