+917330907991 (Online) | +917330907992 (Classroom) info@rcptec.com

Oracle Financials Training in Hyderabad

Oracle Financials Training in Hyderabad Ameerpet

Classroom and Online courses are mainly defined to create an expert out of you while using Oracle financial structure. These are mostly provided by us with the main aim to build financial management solutions. These courses form our sides are primarily related to risk, operations and performance management strata in any form of the enterprise be it small or big. All you need to do is just focus on our Oracle financial courses, as provided by reliable professionals only.

More about Oracle base

Oracle is considered to be only software, which comprises of complete financial management solutions, meant for performance management. You can also try and get acquainted with risk and finance operation services. The major functionalities of an economic structure comprise of receiving activities, processing transactions and also some additional accounting entries. Therefore, it is mainly stated as the global intercompany system. Through our Oracle Financials training in Hyderabad, people are likely to explain various modules, along with the overview of the outlined roles and additional responsibilities. It also helps in building financial models and ways to get access to different transactional types.

The training courses cover the topics from introductory note to the available commitment management systems. Moreover, you will get to know more about iBudgets service, ledger, and internet procurement. Students are likely to availability to affectivity implement some promising analytical skills. Finally, it helps in creating a dynamically designed financial model. Only well experienced and trained professionals are appointed for such job profiles and with so many years of working in IT professionals. Depending on the various modes and flexible mindset of people, we have separate packages for them to opt for.

Course curriculum available for you

Depending on flexible mindset, there are various forms of curriculum to be related to Oracle Financials training, which can be availed for your needs. All you need to do is just get acquainted with our courses from the start till end, and our professionals are all set to help you. Go through the packages, which you are likely to come across and check out the contents, which these courses have in store for you.

General ledger services:

  • Description of flex field and key flex fields
  • Designer account of char
  • Value sets, segments, calendar, currency and ledger
  • Close or open periods, journal source and category
  • Journal batch, reverse and suspense journals
  • Auto posting, recurring journals and auto reversal
  • Mass allocation; intercompany and statistical journal
  • Approval procedure of a journal, tax journals, and sequential numbering
  • Rollup groups, budgets, translation and summary temples
  • Reporting currency, evaluation and secondary ledger
  • Financial statement generator and consolidation
  • Security rules cross validation rules, code combinations
  • Data access set, account alias and definition access set

Purchasing module:

  • Overview of the process to the pay process of Oracle Financial training in Hyderabad
  • Purchasing options, financial options, buyers and also approval assignments
  • Approval groups, requisitions and document types
  • Auto creates RFQs
  • Auto creation quotations and other quotations
  • Quote analysis and auto quote analysis
  • Auto creates purchasing order, purchase order, and receiving
  • Delivery, inspection and returning to supplier
  • Matching options and some receipt routing methodology

Inventory services for you:

  • Receiving options, flex fields and setup item category values
  • Defining master item and assign items to firms
  • Setup system values and defining item category codes
  • Maintaining inventory periods and copy attributes
  • Defining hazard classes and UN numbers
  • Miscellaneous issues in inventory services and view item on hands quality
  • Miscellaneous receipt in the inventory

Accounts payable services:

  • Payable options, financial options and payable system setups of Oracle Apps Financials online training
  • Payment terms, special calendars and distribution sets
  • Accounting periods with validation application on accounting definition
  • Bank creation, payment format, and bank branches creation
  • Credit memo, standard invoice, debit memo and prepayment invoice
  • Interest invoice, retainage invoice and recurring invoice
  • Payment batch, pay group, invoice batch and auto create invoice
  • Invoice as created against the PO values and with invoice receipt creation
  • Employee expense reports and third party payments
  • Manual holds, AP or AR netting, and system hold
  • Multi-organizational service with proficient access control

Accounts receivable services:

  • Sales location, key flex fields, and system options
  • Running the available validation service with accounting definition
  • Payment terms, funding letters and statement cycle
  • MOAC setup for auto cash rule, AP, and collector
  • Customer profile and bank creation
  • Memo lines, transaction sources, and types
  • Auto accounting, debit memo invoice and transaction or sales invoice
  • Credit memo, deposit invoice and other forms of accounting rules
  • Receivable activities, invoice tiles and receipt class
  • Receipt reversal and with remittance receipts
  • Balanced forward billing cycle and with receipt write-off adjustments

Fixed assets as next step:

  • Asset category, flex fields and asset location
  • Asset key, financial year calendar and system controls and values
  • Depreciation flats and methods table and calculated
  • Depreciation calendar and with prorating convention
  • Formula, production, asset categories, and book controls
  • Asset additions and with CIP addition process
  • Inquiry and depreciation financial information
  • Corporate book, asset books and tax books
  • Single and with mass transfer, asset transfer
  • Revaluation, changes and mass and single evaluation
  • Mass and single reinstatement and reclassification
  • Retirement, mass and single retirement
  • Create accounting and mass additions
  • Mass and single reinstatement and reinstatement

Other points associated with cash management

There are some major platforms, looking for your use when dealing with cash management. For the primary, system parameters and bank statement as some of the other values, meant for your use. You can even try and look for reconciliation service and with in-reconciliation structure. Forecasting and with bank transfer are some of the major categories, to deal with. We would also like to help you with banks charges as some additional values.

Instant help right near your hand

With us, you will get to see more about Oracle Apps Financial Online training services, without making a fuss. Some of our programs are available in different packages, and the services are too good to avoid. Apart from the courses, which we have already mentioned, our professionals are also likely to help you with human resources services and e-business tax service. Some of the other value-added services are user management and sub ledger accounting structure.

 

Oracle Financial Notes:

Business process

P2P/O2C: –

O2C —–>order to cash

P2P —–>procedure to pay

 

P2P: – (Procedure to pay)

—–>This process is going to be initiated by inventory module

—–> Can implement planning methods, count

Pic1: –

——>These are taken care by purchase – department and they submit the program (Req – Import – program)

—–>Req – import – program will pick the data from the Req – interface table and create requisitions.

—–>Requisitions are two types

1.    Internal

2.    External

—–>Based on the source it will be created as internal or external

—->once you approve these requisition (Create an internal – orders) program are submitted for internal – requisitions

—–>It will transfer to order management and creates an internal order

—->For external requisitions will send it for approvals

—->These approvals are handled by workflows

—->These workflows are having EMP hierarchy for the approvals (by – step – by step) process

—->And these workflows are handled by position hierarchy also

—->The organization can be used only one of the hierarchies (EMP or positional hierarchies)

—->There external requisitions are created with item1, item2, and item3

Pic2: –

These are sending to suppliers

Pic3: –

—–>After the Approving the Quotations will create a PO and send to the supplier

Structure of POL: –

PO – headers (s1, supplier, sites, Bill to, ship to, Buyer)

——>Po – lines (Line1, line type, Quantity, price, Amount)

—–>PO – shipments (Item, org, Qty, need by date)

—–>PO – Distributions (Item1 —– 25 sales, —- 25 —>Finance dept)

—->For each line we have multiple shipments

—–>For each shipment will have distributions

Sum                 sum            Sum                  po

Total       =      total    =     Line            =  order

Dist                  ship          Quantity         Amount

—–>Supplier will deliver goods to different suppliers

Pic4: –

—–>Here you will be receiving an invoice from supplier

—–>Match invoice to PO (for checking)

—–>for serviceable item => not receiving (service) anything

——>Here GRN will not come

Pic5: –

Self-billing suppliers: – (Directly payments based on the delivered goods)

[Pay – on – Receipt – auto – invoice] —->Program will not for self-billing supplier and these program transfer data to [AP – invoices – interface] table. And runs the program called [payables – open interface import] this automatically creates an invoice

 

Payments ————–>check

Electronic

Wire

ECSC learning

—–>These payments are classified into

1.    Manual payments (individual payments)

2.    Quick payments (calculations)

3.    Refund payments (coming from supplier)

4.    Netting payments (agreements)

—–>The liabilities are nullifying by the receivables

5.    Future dated payments or post-dated payments => maturity date override

6.    Oracle payments (AP)

PIC6: –

—–>Payments are transferred to cash management module

—->Internal Banks will provide the bank statements and these compared to the payments in cash managements

—->cash management is used for Bank transfers

Cash pooling: – (Reserving the cash)

—->Create accounting for payments and invoices

—->the entries are created in sub ledger. er accounting

Pic7: –

—->Here event classes are debit memo, credit memo, and prepayments

—->event types are invoice validated, invoice canceled, invoice adjusted

Pic8: –

Order to cash

—->This process starts with order management

Pic9: –

—->Defining the customers in TCA (Trading community architecture)

—–>Items information should be there in inventory then only items can be processed and organizations are defined in HRMS

PIC10: –

Price list is maintained in advance price list or processing sales persons are defined in sales

[OM] —->Sales order

 

Structure of sales order: –

Pic11: –

—->In inventory for items to be booked they open order organizer form and this shows list of the orders and these generate pick release and this pick release will generate pick slip report

—–>pick slip report will be generated based on picking rules (It differ from item to item)

—–>And these goods are delivered to staging and everything is correct to perform action called

[Pick confirm] —->Here deliveries are closed in this stage

 

—->And after pick confirm we perform action called [ship confirm]

Communication invoice —->Item cost

Sales invoices —->all taxes, miscellaneous + Item cost

—>After ship confirm

Pic12: –

Multi-org

—–> Multi – org is a feature used to stores the data of multiple organizations in single database by partitioning the data of human resources, financials, sales purchases, and inventory

Design org – structure

Pic13: –

—->Main components of multi-org

1.    Business group

—–>Is the highest level in the organization structure at this level we secure human resources information like?

Business group (HRMS) —->this is configured in HRMS module

1)    Manual/auto for EMP no

2)    Applicant no —->manual/auto

3)    Job flex field —->2 fields —>job id, job name

4)    Position flex field —->2 fields

5)    Min age — 18

6)    Max age —– 60

Security and user access: –

MG – HRMS —->HR – Security profile – MG

—->HR – User – type – HR

Ledger: – (A ledger is used to secure journals and ledger balances of the company)

—–>A ledger is a collection of currency, calendar, and chat of accounts and conventions of accounting

—–>currency —>INR

—->Calendar —->1 – Apr – 2010 to 31 – Mar – 2011 —->periods

—->Apr

—->May

—->June

—->July

—–>Aug —>open

—–>Sep —– etc

—>Chat of accounts —->2 segments —> (company —-> accounts)

—->cash accounts

—->Bank accounts

—->Salary accounts

—->SLA —->Cash                                     MGGL —–>GL Ledger name

—–>Actual

—->Defined date access set of sub ledger, in the security and user access

—->Define legal entities – is a legal business at this level we secure financial information and tax reports

Operating units: -are divisions of the legal entities at this level we secure sales purchases information

—->order management can be implemented at the operating unit level

Inventory organizations: –

Pic14: –

—->cash receipt is generated and sent for clearing

Calendars [General ledger]

—->Calendar are classified into two types

1)    Accounting calendar

2)    Transaction Calendars

—–>Accounting calendars are used to determine periods in this we maintain accounting entries and ledger – balances

—->Transaction calendar are used to determine the list of holidays in this transactions are not allowed

—->this transaction calendar are used to calculate the average balances which are generally used in the banking sectors

Accounting calendar

Setup: –

Define 1) period type (A period type is used to determine the number of periods required for a financial year)

Period type: –

1)    Name — x — pt

2)    No of periods per year

3)    Year type —->calendar/fiscal

—->In Oracle applications year type is used to determine the suffix for our period names

—->If the year type is calendar, the period names are suffixed with last two digits of the from date

—->If the year type is fiscal, the period names are suffixed with last two digits of the year

2) Accounting calendar: –

Accounting calendar —–>Name – x – cal

We are going to divide the calendar into periods

Periods (defining the period details)

Period – prefix —->Apr

Period type —->xpt

Year (financial year) —–>2010

Qtr —->1

Period num —->1

From date —-> 1 – Apr – 2010

To date —–> 30 – Apr – 2010

Name of the period —>Apr – 10

May             Xpt                      2010              1          2       01-May-2010       31 – May – 2010

May – 10

June           Xpt                       2010                1          3      01 – Jun – 2010        30 – Jun – 2010

June – 10

July           Xpt                 2010                  2           4

Aug          Xpt                  2010                 2            5

Sept         Xpt                 2010                 2             6

Det         Xpt                  2010                 3             7

Nov         Xpt                  2010                 3            8

Dec         Xpt                  2010                 3            9

 

[Jan          Xpt           2010           4          10           01 – Jan – 2011         31 – Jan – 2011        Jan]

Feb          Xpt           2010            4          11           01 – Feb – 2011        28 – Feb – 2011       Feb – 11

Mar         Xpt            2010            4          12           01 – Mar – 2011       31 – Mar – 2011      Mar – 11

[URL: HTTP/org fin1. Oracle/ 8000/] —–>For R12 instance

 

—->You get a login page

User name —–>operations

Password —->welcome click on login

—–>Select one of the responsibility —->General Ledger vision operations

Journals —>Entry —-> (close it)

Navigation to define period type

[Setup —->financials —>calendar —>type]

Period types             periods/year                  Year type

Birla – PT                        12                         calendar and save

[Setup – financials —->calendar —->Accounting] —–>Navigation to define the calendar

 

Calendar ——->BIRLA CAL

Periods

Prefix             type              year                num             from                           To                         Name

Apr              Birla – pt        2010        1        1            01 – Apr – 2010        30 – Apr – 2010       Apr – 10

May            Birla – pt         2010       1         2           01 – May – 2010        31 – May – 2010     may – 10

Jun             Birla – pt          2010       1         3           01 – Jun – 2010          30 – Jun – 2010        Jun – 10

Jul              Birla – pt          2010       2         4                                                                                     Jul – 10

Aug           Birla – pt          2010       2         5                                                                                     Aug – 10

Sep           Birla – pt          2010       2         6                                                                                     Sep – 10

Oct           Birla – pt          2010      3         7                                                                                      Oct – 10

Nov          Birla – pt          2010      3         8                                                                                      Nov – 10

Dec           Birla – pt         2010      3         9                                                                                      Dec – 10

 

Jan         Birla – pt          2010      4          10             01 – Jan – 2011                 31 – Jan – 2011             Jan – 11

Feb         Birla – pt         2010      4          11                                                                                                   Feb – 11

Mar        Birla – pt        2010      4           12                                                                                                   Mar – 11

 

1)    Period type

2)    Accounting calendar

3)    Submit calendar validation report

Primary ledger                                               secondary ledger

Calendar 1                                                         calendar 2

Apr                                                                           Jan

–                                                                                Feb

–                                                                                Mar

Apr

Jan                                                                     May

Feb   —–>2009                                                 Jun

Mar                                                                      Jul

Aug

Apr-Sep

May                                                                Oct

June                                                                Nov

July                                                                 Dec

Aug       ——>2010

Sep

Mar

—->In the mid of the financial year. If the client wanted to change the specification of the calendar then we recommended the client go with secondary ledger with a new calendar from “Jan to Dec.” In which we have to introduce secondary ledgers system which will take care of transversing the data from primary ledger to secondary ledger till the end of financial year.

—->to move data from the previous periods we need to reconsolidation process

—->But in the consolidation process will also transfer closing entries If any, so must we reverse the closing entries in the secondary ledger so that it generate financial statements only for the transactions created between the first and last

Period of the calendar

Adjustment period calendar: –

Adj1            Rash             PTL               2010              1         1           01 – Apr – 2010                   30 – Apr – 2010

Apr              Rash                                  2010              1         2           01 – Apr – 2010                   30 – Apr – 2010

May            Rash                                   2010              1        3            01 – May – 2010                 31 – May – 2010

June           Rash                                   2010               1        4            01 – Jun – 2010                  30 – June – 2010

July           Rash                                    2010               2        5            01 – Jul – 2010                    31 – July – 2010

Aug           Rash                                     2010               2        6            01 – Aug – 2010                  31 – Aug – 2010

Jan               Rash             2010              4             11            01 Jan 2011             31 Jan 2011

Feb              Rash             2010              4              12           01 Feb 2011            28 Feb 2011

Mar             Rash             2010              4              13           01 Mar 2011            31 Mar 2011

Adj2            Rash             2010              4               14          01 Mar 2011            31 Mar 2011

Save

 

COA (Chat of accounting)

Pic15: –

Company and accounting are mandatory and rest of the segments varies from one organization

Flex fields: – (Using this object we can capture business requirements)

—–>Key flex fields (mandatory business requirements)

—->Descriptive flex fields (Additional business requirements)

—->Key flex fields are 41

—->Accounting

—->Asset category

—–>Asset location

—–>Job

—–>position etc

Key flex fields: –

—->It is a collection of structures. The structure is a collection of segments. Value set is collection of values

Pic16: –

We can restrict the invalid combination by cross validation rules

01.0.0.0.3 —->Rents at company level

01.0.0.1.3 —–>Sales at company level

01.0.1.1.3 —>Location at company level

Qualifier: –

—->Are the properties which are used to determine the behavior of segments and their values?

—->Qualifiers are o two types

a)    Flex field qualifiers

b)    Segment Qualifiers

—->Flex field qualifiers are used to set the properties to the segment columns

—–>segment qualifiers are used to set the properties to the value of the segment

—->segment qualifiers depend upon the flex field qualifier

—->flex field qualifiers are going vary from one KFF to another KFF

—->One of the qualifiers is balancing segment. It is a unique and mandatory

—->To which segment we associate this property the application balances the journals on that segment value

—>Which segment is enabled as balancing segment application calculates and creates journal entries to account for retained earning account, unrealized gain and loss account and cumulative translation adjustment account while performing the closing operations in a financial year

Ledger

—->calendar

—->Apr

—>Mar

—->closing balances of this year are carried out to next year

—>Retained earning account is not distributed to the stakeholders

—->Secondary tracking segments

—->This is unique and optional

—->To which segment we associate this property application accounts for retained earning accounting, unrealized, gain and loss and cumulative translation adjustment accounting

Natural account segment: –

—->This is unique and mandatory

—>To which segment we associate this property application enables a segment qualifier as account type

—->The values of this [Account types] are —->segment qualifier of the natural account

1.    Asset

2.    Liability

3.    Expense

4.    Receive

5.    Retained earnings accounts

—>cost center

—->Intercompany        —-> these are optional

—->management

Navigation

[Setup —->financials —>key —->segments]

Press Ctrl – F11

—>Flex field title —->Accounting % and ctrl – F11 take the cursor to structure block and new structure

 

Code                           title                   description               view name

MM Group               MM Group                                optional

Now click on segments button

Number              name            window prompt                    column             value set

1             company           company               segment             MM Comp

2               Division              Division                segment2          MM divisions

3                Location             Location               segment 3           MM Loc

4                 Dept                    Dept                     segment 4            MM Dept

5               Account               Account                segment 5             MMA accounts

And save it

Click on value set

Value set name —->MM Comp

Max size —-> 2

Format type —–>char

*numbers only

*right justify and zero – fill numbers

Value validation

Validation type —->Independent

Value set name —->MM Div

Max size —-> 2

MM Dept —->value set name

—->max size —>2

MM Accounts —->value set name

Security type —->no security

Max size = 4

Click on flex field qualifiers enable balancing segment *

*enabled * allow dynamic inserts and compile

—>Define values to the segments of our chat of accounts

Navigation

[Setup —->financials —>flex fields —>key —>valued]

Application —->General ledger

Title —>Accounting flex field

Structure —->MM Group

Segment —->company

Value      translated value           description

01                          01                              Mahindra motors       in qualifiers

Allow B —> Y

Allow P —> Y

—–>There is a hidden flex field qualifier as GL – Global by default this is associated with all the segments of our chart of accounts

GL – Global

—->Allow budgeting

—->Allow posting

—->Allow budgeting —->this property is used to specify whether the budgets are allowed on a specific segment value or not

—>It has two values yes/no

—->Allow posting —->this property is to used to determine whether posting is allowed or not —>Yes/no

—->these two are set to each and every value

02                 02                  Tech Mahindra                                 yes, yes

03                 03                   Mahindra auto finance                   yes, yes

04                 04                    Mahindra General finance             yes, yes

Click —-> ok

Accounting translated

Value             value                   description                     qualifiers

0001             0001                     Retained earnings          yes, yes

1000             1000                            cash                            yes, yes, Asset, no, no

1050             1050                          receivables                     yes, yes, Asset, no, no

1100             1100                      short-term investments    yes, yes, Asset, no, no

1500             1500                            machinery                       yes, yes, Asset, no, no

1550             1550                             Furniture                        Yes, yes, Asset, no, no

1600             1600                           equipment                        yes, yes, asset, no, no

2000            2000                            Rents paid                          yes, yes, expense, no, no

2050           2050                             salary                                   yes, yes, expense, no, no

2100           2100                            comm paid                          yes, yes, expense, no, no

3000          3000                             payables                               yes, yes, liability, no, no

3050         3050                               Loans                                    yes, yes, revenue, no, no

4000         4000                               sales                                      yes, yes, Revenue, no, no

4050         4050                         Rents received                           yes, yes, revenue, no, no

4100         4100                         Interest from Bank                     yes, yes, revenue, no, no

Currency: –

Navigation to define currency

Setup —>currency —>Define

Ctrl – 11 —>we get all standard currency

Code                 name                    description             issuing tentony               symbol           precision

EUR                   pound                  pound steeling                                                                                 2

Accounting setups: –

—->These are the common setups required for general ledger and all the sub ledgers to secure the transactions and reporting

Accounting setups: –

1.    Create legal entity

2.    Define ledger

3.    Define accounting options

4.    Add legal entities to ledger

5.    Assign balancing segment value to legal entities

Navigation to define accounting set – ups: –

Setup —->financials —->accounting setup manager —>accounting setups

Click on create accounting

—->create legal entities (number of companies can be equal to No of legal entities)

Click on create legal entity

Territory —->India

Legal entity name —->Mahindra motors

Organization name —->Mahindra motors

Legal entity identifier —->Mahindra motors

Pan —>APK44JPM

Foreign <— IEC/EIC —->

1.    Create new address

Location —–>India

Address1 —–>India

Addr2 —–>AP

City —–>Hyd

Place of registration —->Hyd

Inception date —–>optional

Business activity —->sales, purchasing

Type of company —->

Share capital —->1000000

Currency —->INR

Click on apply (Repeating the process)

—>Create another legal entity

Territory —–>India

Legal entity name —->Tech Mahindra

Organization name —->Tech Mahindra

Click on next

Primary ledger

Name           COA                    Accounting — calendar              currency

MAHPL      MM Group                    Mahindra                                INR

Click on next

Read the information and click on finish and save

Accounting options: –

1.    First ever opens period

2.    Number of future periods

3.    Retained earnings account

4.    CTA Account (currency translation options)

5.    Budgeting controls

6.    Suspense accounting

7.    Inter-company

8.    Journal reconciliations

—->Click on accounting options

Setup step                      description                       last up date

Ledger                            defines and update the

Option                             journal processing options of your ledger

First ever opened period —–>AD1 – 2010

Click on next

Retained earnings account:

Company    01

Division      00

Location     000

Account     001

Click on create

—->At any ledger we can map retained earning account code combinations for any one company

—->But when we are performing closing operations system automatically generate retained earnings code combination for each balancing segment identifying the remaining segment values from ledger

—>click on – next – next —–>finish

—->The status of the ledger is status —->

—>click on add legal entity —->Add legal entity to ledgers

Search by [legal entity]   [Math]

Click on select and apply

—->click on update balancing segment value click on add balancing segment value

Select auto finance and general finance and give start date and end date

Click on [apply]

And

Click on [complete]

Click on [yes]

Security and user access (System administrator)

Define responsibility: –

A responsibility is a role authorized to access specific forms and programs of a particular module

—>A responsibility is a collection of menu, request group, and data group

—->Menu is a collection of forms, request group is a collection of reports and process and data group is a collection of modules

—->standard menu for GL is GL – Super – user

Request group —->GL – concurrent program – group

—->Request group is different for the modules

—->Data group —->standard

Define the responsibility

System administrator —>click on

Navigation is

Security —–>responsibility —->Define

Responsibility name —->MAH1 GL

Application —->General ledger

Responsibility key —->MAH1 GL

Date group

Name —–>standard

Appli —->GL

Menu —–>GL – Superuser

Request group: –

Name: GL – concurrent program group

Appli: GL

—->Assign ledger to the responsibility using GL – ledger name profile option

Profile options: –

—->They are used to determine the behavior of oracle applications, forms and programs

—>there are also 7000+ profile options which are going to come with the package

—>each profile option can be set at core level site, applications, responsibilities and user provided site is an instance at this level we can implement one or more modules

—->A site is a collection of module

—->When we set the profile option at site level this is going to affect all the forms and programs of all the modules

 

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

ENQUIRE US NOW