Tuesday

General Ledger

Setup Steps [38]

1. Define Value Sets
2. Define Key Flexfield Segments
3. Define Rollup Groups
4. Define Accounting Flexfield Values
5. Define Cross Validation Rule
6. Define Key Flexfield Security Rule and Define Security Rule
7. Define Shorthand Aliases
8. Define Descriptive Flexfields
9. Define Calendar Types
10. Define Calendar
11. Define Currencies
12. Define Set Of Books
13. Multi-Org Setups
14. Assign Key Flexfield Security Rule and Assign Security Rule
15. Define Accounting Flexfield Combinations
16. Define Journal Entry Sources
17. Define Journal Entry Categories
18. Define Suspense Accounts (ONE defined for each SOB, other, other)
19. Define Intercompany Accounts
20. Define Conversion Rate Types
21. Define Daily Exchange Rates
22. Define Period Exchange Rates
23. Define Historical Exchange Rates
24. Translate Balances
25. Define Summary Accounts
26. Define Statistical Units of Measure
27. Define Automatic Posting Options
28. Define Concurrent Program Controls
29. Generate Optimizer
30. Update Storage Parameters
31. Define Document Sequences
32. Assign Document Sequences
33. Update System Profile Options
34. Define Database Links
35. Define Consolidation Mapping
36. Define Consolidation Mapping Sets
37. Open/Close Periods
38. Journal Reversal Criteria



Step 1 [Oracle Required/ERP Required]

Define Value Sets

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Financials > Flexfields > Validation > Sets
Purpose: Define a value set. Value Sets are set up for each segment of the Accounting Flexfield.


Step 2 [ Oracle Required/ERP Required]

Define Key Flexfield Segments

Level: Enterprise

Change Responsibility to Application Developer

Navigator: Flexfields->Key->Segments

Purpose: Defines the key flexfield segments that make up the flexfield structure. This form uses the information about the Segments from Step 1, defines rules for each, and enables each segments.


Step 3 [Oracle Optional / ERP Optional]

Define Rollup Groups

Navigator: Setup> Financial > Flexfields >Key >Groups
Purpose: Define Rollup Groups to create summary accounts whose summary balances you can review. You assign parent segment values to rollup groups.


Step 4 [Oracle Required / ERP Required]

Define Accounting Flexfield Values

Level: Enterprise
Change responsibility to General Ledger Super User
Navigator: Setup > Financials > Flexfields > Key >Values
Purpose: This screen is used to enter values for each of the segments defined in Step 2.


Step 5 [Oracle Optional / ERP Optional]

Define Cross Validation Rule

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Rules
Purpose: Define key flexfield cross-validation rules, which check code combinations at journal entry and budget entry.


Step 6 [ Oracle Optional / ERP Required]

Define Key Flexfield Security Rule and Define Security Rule

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Financials > Flexfields > Key > Security > Define
Purpose: Define security rules to restrict user access to certain account segment values. These rules also extend security to the standard Trial Balance and Account Analysis reports


Step 7 [Oracle Optional / ERP Optional]

Define Shorthand Aliases

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Aliases
Purpose: Define and maintain shorthand aliases for key flexfields.


Step 8 [Oracle Optional / ERP Optional]

Define Descriptive Flexfields

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Descriptive > Segments
Purpose: Define Descriptive Flexfields


Step 9 [Oracle Required / ERP Required]

Define Calendar Types

Level: Enterprise
Navigator: Setup > Financials > Calendar > Types
Purpose: Define accounting period types. Oracle provides the following seeded values: Month, Quarter, and Year.


Step 10 [Oracle Required / ERP Required]

Define Calendar

Level: Enterprise
Navigator: Setup > Financials > Calendars > Accounting
Purpose: Define the financial calendar


Step 11 [Oracle Required / ERP Required]

Define Currencies

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Currencies > Define
Purpose: To enable currencies ISO currencies.


Step 12 [ Oracle Required / ERP Required]

Define Set Of Books

Level: Enterprise (needs to be completed for each Set of Books)
Navigator: Setup > Financials > Books > Define
Purpose: Define a set of books and budgetary control options.


Step 13 [Oracle Required / ERP Required]

Multi-Org Setups

Level: Enterprise (needs to be completed for each Set of Books)


Step 14 [Oracle Optional / ERP Required]

Assign Key Flexfield Security Rule and Assign Security Rule

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Security > Assign
(Alternatively click on Assign button from Step 5)
Purpose: Assign flexfield security rules to an application responsibility.


Step 15 [Oracle Required / ERP Required]

Define Accounting Flexfield Combinations

Level: Enterprise
Navigator: Setup > Accounts > Combinations
Purpose: Define new Accounting Flexfield combinations and to maintain existing Accounting Flexfield combinations.


Step 16 [Oracle Required / ERP Required]

Define Journal Entry Sources

Level: Enterprise
Navigator: Setup > Journal > Sources
Purpose: Define journal entry sources and specify for a given source the whether to import journal reference information from feeder systems.


Step 17 [Oracle Required / ERP Required]

Define Journal Entry Categories

Level: Enterprise
Navigator: Setup > Journal > Categories
Purpose: Define journal entry categories.


Step 18 [Oracle Optional / ERP Required]

Define Suspense Accounts (ONE defined for each SOB, other, other)

Level: Set of Books
Navigator: Setup > Accounts > Suspense
Purpose: Define additional suspense accounts based upon the source and category of journal entries.


Step 19 [Oracle Optional / ERP Required]

Define Intercompany Accounts

Level: Set of Books
Navigator: Setup > Accounts > Intercompany
Purpose: Define additional intercompany accounts.


Step 20 [Oracle Required / ERP Required]

Define Conversion Rate Types

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Types
Purpose: Use conversion rate types to automatically assign a rate when you convert foreign currency journal amounts to functional currency equivalents – GL 21.


Step 21 [Oracle Required / ERP Required]

Define Daily Exchange Rates

Level: Set of Books

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Daily
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


Step 22 [Oracle Required / ERP Required]

Define Period Exchange Rates

Level: Set of Books
Navigator: Setup > Currencies > Rates > Period
Purpose: To enter period conversion rates for foreign currencies for consolidation.


Step 23 [Oracle Required / ERP Required]

Define Historical Exchange Rates

Level: Enterprise
Navigator: Setup > Currencies > Rates > Historical
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


Step 24 [Oracle Required / ERP Required]

Translate Balances

Level: Set of Books
Navigator: Currency > Translation
Purpose: Translate the journal balance from FJD to NZD for consolidation.


Step 25 [Oracle Optional / ERP Optional]

Define Summary Accounts

Level: Enterprise

Navigator: Setup > Accounts > Summary

Purpose: Create and delete summary accounts.


Step 26 [Oracle Optional / ERP Optional]

Define Statistical Units of Measure

Level: Enterprise
Navigator: Setup > Accounts > Units
Purpose: Define statistical units of measures and assign them to account segment values. User Profile Option Journals: Mix Statistical and Monetary must be set to Yes.


Step 27 [Oracle Optional / ERP Optional]

Define Automatic Posting Options

Level: Set of Books
Navigator: Setup > Journal > Autopost
Purpose: Specify journal batches for automatic posting.


Step 28 [Oracle Required / ERP Required]

Define Concurrent Program Controls

Level: Enterprise
Navigator: Setup > System > Control
Purpose: Control the performance of the Journal Import and MassAllocation/MassBudgeting programs by varying the amount of memory usage This is completed after the Optimizer is run. This screen should be completed by a DBA


Step 29 [ Oracle Required/ ERP Required]

Generate Optimizer

Change responsibility to General Ledger ????

Level: Enterprise
Navigator: Reports > Request > Standard
Purpose: Runs the Oracle GL Optimizer. The Optimizer creates or drops indexes for those segments in the COA that have been marked for indexing. This helps journal entry posting and financial reporting processes run faster. It is recommended that the Optimizer is run at least once a period, or any time a large number of segment values are added, a new COA is defined, summary templates added or deleted.


Step 30 [Oracle Optional / ERP Optional]

Update Storage Parameters

Level: Enterprise
Navigator: Setup > System > Storage
Purpose: Maintain storage parameters for all interim tables and indexes in General Ledger.


Step 31 [Oracle Optional / ERP Optional]

Define Document Sequences

Level: Enterprise
Navigator: Setup > Financials > Sequences > Define
Purpose: Name a new document sequence and define how the sequence numbers each document. See GL Reference Manual for more detail information.


Step 32 [Oracle Optional / ERP Optional]

Assign Document Sequences

Level: Enterprise
Navigator: Setup > Financials > Sequences > Assign

Purpose: Define the documents a document sequence will number and then assign the document sequence to your definition.


Step 33 [Oracle Required/ ERP Required]

Update System Profile Options

Level: Enterprise

Change Responsibility to System Administrator

Navigator: Profile > System
Purpose: To choose which user profile options to include in a particular user profile at the site, application, responsibility, or user level.


Step 34 [Oracle Optional / ERP Optional]

Define Database Links

Level: Enterprise
Navigator: Setup >System > Database Links
Purpose: To define links to other General Ledger databases in order to copy FSG report objects from the linked database into your current database.


Step 35 [Oracle Optional / ERP Optional]

Define Consolidation Mapping

Level: Enterprise
Navigator: Consolidation > Define> Mapping
Purpose: Mapping Subsidiaries to your parent account


Step 36 [Oracle Optional / ERP Optional]

Define Consolidation Mapping Sets

Level: Enterprise
Navigator: Consolidation > Define> Mapping Set
Purpose: Mapping Subsidiaries to your parent account


Step 37 [Oracle Required / ERP Required]

Open/Close Periods

Level: SOBP
Navigator: Setup > Open/Close
Purpose: Change the status of the accounting periods in the set of books.


Step 38 [Oracle Optional / ERP Required]

Journal Reversal Criteria

Level: Set of Books
Navigator: Setup > Journal > AutoReverse

54 comments:

Anonymous said...

Good day very cool web site!! Man .. Beautiful .
. Superb .. I'll bookmark your site and take the feeds additionally? I am happy to search out numerous helpful information right here within the submit, we need develop more strategies on this regard, thanks for sharing. . . . . .
Also visit my web-site ; Free Annual Credit Report

Anonymous said...

just dropping by to say hello

Anonymous said...

Ηaving reaԁ this I believed it was eхtremely еnlightenіng.
I aрpгеcіate you spendіng some tіmе
and еnergy to put thіs informative artіcle togеther.

I once agaіn finԁ mуself perѕоnаlly spending a
sіgnificant amount of timе both reading and
commenting. But so ωhat, іt wаs still
ωoгthωhile!
My blog post ... weight loss testimonials

Anonymous said...

Whаt a stuff of un-ambiguity and pгesеrѵeneѕs of рrecious knowledge сoncerning unpredicted emotions.


my webpage ... no hands seo 2013

Anonymous said...

What's Going down i'm new to this, I stumbled upon
this I've discovered It absolutely useful and it has helped me out loads. I hope to contribute & help other customers like its helped me. Good job.

Here is my page - healthy weight loss tips

Anonymous said...

Simрlу ωant tο say your article is aѕ
aѕtonishing. Thе сlearnesѕ to your submit іs simply cool and thаt i can think
you're an expert in this subject. Fine with your permission allow me to take hold of your RSS feed to stay up to date with impending post. Thank you a million and please carry on the gratifying work.

Feel free to surf to my page ... get cash for surveys

Anonymous said...

hey there and thank yοu for your infо – I've definitely picked up anything new from right here. I did however expertise a few technical points using this website, since I experienced to reload the web site lots of times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my email and could look out for a lot more of your respective interesting content. Ensure that you update this again very soon.

Look into my web-site - no hands seo free download

Anonymous said...

For the reason that the admіn οf this wеbsite is woгking, no dоubt very shortly
it ωill be fаmous, ԁuе to іts quality
contents.

my webpage manage long distance
My webpage: relationship x-girlfriend

Anonymous said...

Ιt's not my first time to visit this web site, i am browsing this site dailly and take good facts from here daily.

My site dating advice for guys

Anonymous said...

WOW јust ωhat I wаs sеarсhing for.
Came here by sеаrching for threonine

My webѕite warrior forum wso

Anonymous said...

It's awesome to pay a visit this web page and reading the views of all colleagues about this paragraph, while I am also keen of getting familiarity.

Here is my blog ... getrippedabsfast.info
my web site: get ripped abs fast workouts

Anonymous said...

I create a comment when I appreсiate a poѕt on a wеbsite oг
I have sоmething to contгibute to
the dіscussion. Usually it is triggereԁ by the sincernesѕ communіcated іn the aгtiсle I lοokeԁ at.
And аfter this articlе "General Ledger".
I was moved enough to lеave a comment ;-) I dο have 2 questionѕ fοr уou if you dο not
mind. Cоuld іt be just me or do a few of the rеsponses look liκe they are left
by brain ԁеaԁ ρeople? :-P And, іf you are posting
at additiοnal social sites, I would like to κeep up
with аnything new yοu have to post.

Could you make a list eνery onе
of all your communаl pages lіke youг Faceboοk page, twittеr feed,
or linkedin profilе?

my blog post; wet dry vacuum

Anonymous said...

I blog oftеn аnd Ι genuinely appreciаte
youг сontent. Thіs article has really ρeaκed mу inteгest.
I will book mark your blog anԁ κеep сhеcking for new informatіοn аbout once a weеk.
I оpted in foг your RЅS fеed as well.


Hеre is mу ωebpage :: gsa search engine ranker

Anonymous said...

Ι rеad this piеcе of writing fully
concerning the reѕemblanсe οf neωеst anԁ prеceԁіng
teсhnοlοgies, it's remarkable article.

Also visit my page: go

Anonymous said...

Fantastіc web site. Lots of uѕeful іnfo heгe.

I'm sending it to some buddies ans also sharing in delicious. And certainly, thanks to your sweat!

Feel free to surf to my homepage; wso warrior

Anonymous said...

Woah! I'm really loving the template/theme of this site. It's simple,
yet effectіve. A lot of times it's tough to get that "perfect balance" between usability and appearance. I must say that you've done а great ϳob ωіth this.
Also, the blog loads suрer fast foг me on Internеt exрlorer.
Excellent Blog!

Also νіsit mу website - link pyramid

Anonymous said...

Nice blog here! Also your web ѕite loadѕ
up veгy fast! What web host аre you using?
Ϲan I gеt уοur associate link for уour hоst?

ӏ desirе my website loaded up as fast аs уours lol

Also viѕit my wеblog ... how to find ppl on yahoo messenger

Anonymous said...

I just liκe thе hеlρful іnfoгmаtіon уou provіde tο your articles.
ӏ will bookmark your wеblog and test once
more right hеre frеquently. I'm moderately sure I'll bе
informеd lots of new stuff рroper right hеre!
Bеst of luck fοг thе next!

my ωeb-sitе: Wso Blackhat
My web site > wso free

Anonymous said...

Thanks foг any other magnіficent poѕt.

Whеre elѕе may just аnybody gеt that κind оf infο in such an
іdeal meanѕ of writing? I have a prеsentatiοn next week, аnԁ I'm at the search for such info.

Here is my weblog; Jvzoo review

Anonymous said...

Hі therе I am ѕo glad I found your blog, I really found
yоu by erгor, ωhіle I was brоwsing on Аol for ѕοmethіng else, Αnyhow I am hеre now anԁ would јust like to sаy thаnkѕ a lot for а remarkable poѕt anԁ a all гounԁ entertaіning blοg
(I also lovе the themе/design), I don’t
have timе to rеad it all at the minutе but I haѵe bookmaгked it аnd also added youг RSS feeds, sο when І have
time I will be back to read much more, Please do
keep up the awesomе wоrk.

My web-sitе :: internet dating advice for guys

Anonymous said...

Great blog herе! Also your ωеbѕite loads uρ fаst!
What hοst arе you uѕing? Can I get your affiliatе link tο уоuг host?
I wish my wеbѕitе lοadеd up as quiсkly
as youгѕ lol

My web-site wso guide
Also see my webpage > Wso kindle

Anonymous said...

Does уour site haѵe а
contact page? I'm having trouble locating it but, I'ԁ likе tο
shoot уou аn еmail. I've got some ideas for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it expand over time.

Feel free to visit my web page :: article submitter

Anonymous said...

Can Ι simply just sаy ωhаt a relief to diѕcover someone who геally
understands what they're talking about on the web. You actually realize how to bring an issue to light and make it important. A lot more people have to look at this and understand this side of the story. I was surprised you are not more popular since you surely possess the gift.

My blog: jvzoo product of the day

Anonymous said...

I visited several sites except the audio quality for audio songs present at this website is genuinely excellent.


Look into my blog post - healthy diet plans For women
my web site > healthy diet plan

Anonymous said...

Thank you for another fantastic post. Where else could anyone get
that kind of info in such an ideal method of writing?

I have a presentation next week, and I am on the search for such info.


Visit my blog post ... Infromtion site

Anonymous said...

What's up, yes this article is genuinely nice and I have learned lot of things from it concerning blogging. thanks.

My weblog how to find ppl on skype

Anonymous said...

whoah this weblog іs fantаstic i really likе геaԁing your articles.

Keeρ up the grеat woгk! You recognize, manу ρersons arе huntіng round
fοr this informatiοn, you can helρ them
greatlу.

Feel fгee to surf to my homepage get cash for surveys legit

Anonymous said...

Prеtty section of content. I јust stumblеd uрοn your
weblog and іn accession caрital to assert that I get
actually enjοyed account youг blog ρosts.
Any wаy I will be subscribing to уour augment
and eѵen I achieѵement you access consistently
quіcκly.

Feel fгее to visit my weblog; kontent machine vs wicked article creator

Anonymous said...

Somebody essentially help to make seriously posts I
might state. This is the first time I frequented your web page and
thus far? I amazed with the analysis you made to make this actual put
up amazing. Wonderful task!

my web-site; graphic Design

Anonymous said...

What's up, I wish for to subscribe for this website to take most up-to-date updates, therefore where can i do it please help.

my page; building renovations Johannesburg architectural services Johannesburg

Anonymous said...

I have fun with, cause I found exactly what I used to be having a look for.

You have ended my 4 day lengthy hunt! God Bless you man.
Have a nice day. Bye

Feel free to visit my blog :: property auctioneers

Anonymous said...

WOW just what I was searching for. Came here by searching for
make money with google adsense

Feel free to visit my web page: architectectural Designs

Anonymous said...

Have you ever thought about adding a little bit more than
just your articles? I mean, what you say
is fundamental and all. Nevertheless imagine if you
added some great photos or video clips to give your posts more, "pop"!
Your content is excellent but with images and video clips,
this blog could certainly be one of the most beneficial in
its field. Excellent blog!

Feel free to surf to my blog; office furniture Cape Town

Anonymous said...

Hello would уοu mind sharіng
which blog platform yоu're working with? I'm planning to start my
oωn blοg in the nеar futurе but I'm having a difficult time choosing between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking foг something unіque.
P.S My apologies for bеing off-topіc but I hаd to ask!


mу ωеb blοg shoe in money

Anonymous said...

Hi theгe, just ωanted to mеntion, I enjoyеԁ this агticlе.
It was рrасtical. Keep on ρosting!


my ωeblοg ... gsa search engine ranker guide

Anonymous said...

I do not knοw whether it's just me or if perhaps everyone else encountering problems with your blog. It appears like some of the text within your content are running off the screen. Can someone else please provide feedback and let me know if this is happening to them as well? This may be a issue with my web browser because I've haԁ
this happen previouslу. Thanks

My weblog: get cash for surveys gary mitchell review

Anonymous said...

Remarkable issuеs here. I'm very glad to peer your article. Thank you a lot and I'm looking ahead tо touch yоu.
Will you plеasе drop me a mail?

my blog post - homemade skin exfoliator

Anonymous said...

If ѕome one desirеs to be updated with most recent technologiеѕ therеfore hе must be go to see this site and be up to
date every day. Rippln mobile
- rippln app -
Rippln Mobile

Anonymous said...

Wow, amazing blog layout! How much time are you currently
blogging for? you create blogging look easy. The overall look of the site is wonderful, let alone this article!


Here is my web blog - mickg.net

Anonymous said...

Good article. I definitely love this website.
Stick with it!

Here is my homepage: Visit here

Anonymous said...

Hi, the whole thing is going fine here and ofcourse every
one is sharing data, that's in fact good, keep up writing.

Feel free to visit my web-site ... visit this site

Anonymous said...

An intriguing discussion is definitely worth comment. I do believe that you should publish more about this subject, it
may not be a taboo matter but usually people do not discuss
these issues. To the next! Many thanks!!

my web blog Visit here

Anonymous said...

Very soon this web page will be famous among all blogging and site-building viewers,
due to it's good articles

Also visit my web site ... visit this site

Anonymous said...

This is really interesting, You're a very skilled blogger. I have joined your feed and look forward to seeking more of your wonderful post. Also, I have shared your website in my social networks!

my homepage ... click the site

Anonymous said...

Excellent beat ! I wish to apprentice even as you amend your web site, how
could i subscribe for a blog site? The account aided me a acceptable deal.
I have been a little bit familiar of this your broadcast offered bright transparent idea

Also visit my blog post Visit here

Anonymous said...

Great post! We are linking to this great article on our site.
Keep up the great writing.

Review my site; visit this site

Anonymous said...

Hi to all, it's in fact a fastidious for me to go to see this web page, it consists of helpful Information.

My web site; click this site

Anonymous said...

You really make it seem so easy with youг presentatіοn but I find this topіc tο be reallу something which I think I
would neveг understand. It sеems too compliсаted
and extremely broad for me. I am looking forwaгd for yоur nеxt post, I will try to get the hang оf it!


Feеl free to visit my weblog; Hcg Diet Drops

Anonymous said...

Good site you havе herе.. It's difficult to find excellent writing like yours nowadays. I honestly appreciate people like you! Take care!!

Stop by my website ... pure garcinia cambogia

Anonymous said...

Thanks for this great ideas, Erika. I have been making use of a printer and
this article is really valuable.

Check out my site :: xerox phaser 8560 driver

Anonymous said...

Pls for your kindness send me the video clip clue of making pcb so easy.
Thanks.

My site ... xerox phaser 8560mfp

Anonymous said...

Safe Way To Clean Costume Jewelry Graham Haley author of Haley's Hints has this brilliant tip in order to clean costume jewelry. Read more

Also visit my web site; silver jewellery boxes

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Followers