What is flex field? What are different
types of flex field?
Flex field is used to capture the
information in organization these are two types i.e. KFF and DFF.
Difference between key flexfield and
Descriptive flexfield?
KFF is unique identifier, stored in segment column but
DFF is used to capture additional information, stored in attribute column.
How many KFF are in GL, AP, and AR?
In GL module KFF, GL Accounting flexfield, AP no KFF
and AR Sales tax flex field, Territory flex field.
What is structure of KFF in the
Accounting Flexfields?
In accounting flexfield company, department, account,
future.
What are the flexfield qualifiers?
Flexfield qualifiers are used to identify the
segments. These are various types i.e. balancing segment qualifiers, Cost
center qualifier, Natural account segment qualifier, Inter company qualifier, Secondary
tracking qualifier, Management segment qualifier.
What are different types of Currency?
These are Functional currency, Foreign currency.
What are different types of Calendars?
These are Fiscal and Accounting.
How many types of open/close periods?
These are five types i.e. 1. Open, 2. Close, 3. Never
open, 4. Permanently closed, Future.
How many journal approvals in GL?
They are two i.e. Journal Source (it is origin of the
journal), Journal Category (it is identifying the journal).
What is a Journal?
Journals are used day to day business transactions. So
journals are contain debit and credit transactions so it is always equal to
both i.e. debit and credit these are two types i.e. Manual , Import.
What is Reverse Journal?
It is used to reverse the error journals
they are two types of journal method i.e. Switch Dr/Cr (it is used to new
journal created and change the debit to credit and credit to debit), Change
Sign (it is used just change the +tive amount is to -tive).
What is batch journal?
It is used to group the journal based on certain
parameters.
What Suspense Journal?
It is used to post the unbalanced journal entries when
we posted unbalance journals suspense account will be added by the system.
What is Recurring Journal?
Which accounting is repeating every month or time i.e.
is called Recurring journal these are three types i.e. Standard, Skeleton, And
Formula.
What is Auto Posting?
This is used post journals automatically by the
system.
What is Mass allocation?
It is used to distribute the particular amount various
expenses heads using simple formula i.e.
Mass
allocation = Cost fool amount * Usage factor
=
Target amount
Total usage factor
What is aliases?
It is used to define the short name for account code
combination it will wok at structure level.
What Inter company?
Transaction which is used two companies is called
inter company these are two types 1. Inter company and Intra Company
Inter Company: Transactions which is
tacking place between two legal entities is called Inter Company.
Intra Company: Transactions which taking
with in the legal entity is called Intra Company.
What is Journal Approval?
It is Security feature it is used to define the
authorization limits for journal approval.
What is Budget?
Budget are using better planning fund controls
feature. These are two types i.e. Planing, Funding.
Planing: it is used to plan expense and
revenue but it not along with controlling exp and revenue.
Funding:
it is used to plan expense and revenue but it along with controlling exp and
revenue.
What is Rollup group?
It is used to group the parent value.
What is Summary template?
This is used to calculation purpose that who will
associate roll up group with the summary template
What is Translation?
Translation is used to convert the accounting balances
from functional currency to foreign currency
What is revaluation?
It
is used to reflect the changes in the exchange rate.
What is consolidation?
Multiple sub ledgers into parent ledger are called
Consolidation.
What is a Security rule?
These are used to restrict the user from entering the
segment values it will work at responsibility level.
What is Cross validation rules?
These are used to restrict the users from entering the
code combination, it will work at chart of accounts level.
What is definition access set?
It is used to provide using, view and
modified access to the various users it will work at responsibility level.
What is secondary ledger?
It is represent to the primary ledger accounting data
when the following things are different i.e. chart of account, currency,
calendar, conversion method, accounting option.
What is FSG (Financial Statement
Generator)?
It is standard report tool which is used to customize
the required reports. They are five components. I.e. Row set, Column set,
Content set, Row order, Display set.
What is MOS (Multi Org Structure)?
It is used to capture the multiple organizations in a
single data base.
What is Business group?
It is highest level in multi level it is used to
secure the human recourses details.
What is Ledger?
It’s a reporting entity which we record the day to day
organization transactions and determine Four ‘C’ i.e. Chart of Accounts,
Calendar, Currency, Accounting method.
What is
Legal entity?
Legal entity nothing but a tax authority, ledger
contain multiple legal entities but legal entity associate with one ledger
What is Operating unit?
It’s a Major business division, one legal entity
contain multiple operating units but one operating unit associate with one
legal entity.
What is inventory organization?
Its
nothing but where house or plant, one operating unit contains multiple
inventory but one inventory associate with one operating unit.
What is Sub-Inventory?
It’s a part of the inventory organization, one
inventory contains multiple sub inventories but one sub inventory associate one
inventory.
What is MOAC (Multiple Org Access
Control)?
It is used to access the multiple operating unit information from single
responsibility to access multiple operating we need to say Mo Security profile
option.
How to use Purchasing?
All the purchasing related activity
information will be declared in purchasing these are two cycles in PO i.e.
Procure 2 Pay, Order 2 Cash.
Procure 2 Pay Cycle.
This cycle start with Requisition and
end with Reconciliation i.e.
RequisitionàRFQàQuotationàQuotation analysisà PurchasingàReceivingàInvoice
àPaymentàReconciliation.
The Accounting entries in P2P cycle when we
receive the goods
1.
When we receive the goods
Receiving Inventory A/c Dr
To
Inventory AP Accrual A/c Cr
2.
When we transfer the goods
Inventory A/c Dr
To
Receiving Inventory A/c Cr
3.
When we create Invoice
Inventory AP Accrual A/c Dr
To
Liability A/c Cr
4.
(a) When
we make payment and follows Reconciliation
Liability A/c Dr
To Cash
Clearing A/c Cr
(b) When
Payment is cleared
Cash
Clearing A/c Dr
To
Cash A/c Cr
5.
When we make the payment and we are not following
Reconciliation
Liability A/c Dr
To Cash
A/c Cr
6.
Final entry is
Inventory A/c Dr
To Cash
A/c Cr.
What is option how many options in PO?
Options are nothing but a controlling future at the
operating unit level. In PO these are three types’ i.e. financial options,
Purchasing options, Receiving Options.
Who is Employee?
A person who is worked in organization or company is called employee.
Who is Supplier?
Either person or organization who is supplying goods
or services is called supplier. They are two levels of data in supplier i.e.
Supplier header, Supplier site.
Supplier
header (Head office): This information is global specific
Supplier
site (Branch office): This
information is operating unit specific.
What is Item?
Item will be defined in either inventory or purchasing
application so it is used inventory key flexfield to define the item. These are
seven key flexfield in inventory applications.
Category Codes: Category cods are used to categories the item
Category Set: It is used to group the values categories.
Why are used Document types?
It will determine the futures of various purchasing
documents
Why are used Approval groups?
This are used to define the authorized limit for
various job.
Why are used Approval assignments?
It is used to assign approval goods to the jobs.
Who is Buyer?
A person who is buying goods or services behalf of
organization is called a buyer.
What is Requisition?
Requisition is first steps in PO, it means requirement
specification, and specifies the requirement, quantity, expected date etc.
These are two types i.e. Internal requisition,
Purchase requisitions.
Internal requisitions: it is created by employee and send to the where
house to adjust items internally.
Purchase requisition: it is also created by employee and send to the
purchasing department to accrue goods from external sources.
What is RFQ and Who will create?
Require the goods information at the time buyer
created RFQ and send to the supplier to quotation.
These are three types Catalog, Standard,
Bid.
What is Quotation?
Quotations are received from the supplier and enter in
to Oracle PO it contains all item segments details
These are three types Catalog, Standard,
Bid.
Quotation are created by two ways i.e.
Manual, Auto Create.
What is Purchase order and who will
create?
It’s a legal document which will be crated by
organization and send to the supplier to buy the goods or services
These are four types i.e. Standard, Plan,
Blanket, Contract.
What is Receiving and how many types of
Receiving methods.
Entering the delivery information in the system is
called receiving
These
are three types i.e. Direct delivery, Standard, Inspection.
What is use of Accounts Payables in
Oracle?
Any types of payments will record in the account
payables
How many options in account payables?
These are three types options i.e. financial, payable,
payable system setup.
What is Standard invoice?
A trade invoice which will receive from
the supplier and entered in Oracle AP.
What is Credit Memo?
It’s a negative amount invoice which will be received
from the supplier and enter in to AP to record the credit for the purchases
goods or services.
What is Debit Memo?
It’s a negative amount invoice which will be created
by organization and send to the supplier to record for feature debit items.
What is Prepayment?
It’s a Advance payment made to the supplier by
organization later it will applying against feature debit items.
These are two types i.e. Permanent,
Temporary.
What is Interest invoice?
An invoice which created by automatically system to
pay interest on over due invoices
What is Recurring invoice?
Which invoice repeating each accounting period is
called a recurring invoice.
What is Retain age?
Holding the portion of percentage the invoice in
organization is called retain age.
What is With Holding Tax?
An invoice which is created automatically by system to
pay tax amount to the tax authority
What is Pay on receipt?
Under this feature invoice will be created by system
automatically in AP when receive the goods in the AP.
Order cash cycle.
Sales orderàpick orderàshippingàreceiptsàreconciliationàcash management
How many flexfield in Account
Receivable?
They are two types i.e. Sales tax location flexfield,
Territory flexfield.
What is sales tax location flexfield and
what is territory flexfield?
It is mandatory flexfield which is used to calculate
the tax based on the location. When we define up to 10 segments under this location.
It is optional flexfield which is used
to identify where sales is taking place, to identify profit for each sales
territory.
What are payment terms?
Payments terms are used to determine the payment
schedule for the various invoices.
What use of Statement Cycle?
This cycle will determine the when to sent statement
to the customer.
Who is Collectors?
The person who is collecting the money from the
customers is called collectors.
What is Remit to Address?
An address where customer to send receipt information.
What is Application Rule Set?
This is used how to apply receipt amount against the
invoice component, the invoice components are line, tax, fright and finance
charges.
What is Customer Profile class and How
many types?
This are used to classify the customer based on
certain parameters. Generally these are three types i.e. good, average, below
average.
Who is customer?
Either person or organizations who are selling goods
or services is called a customer.
What is Transaction?
Transaction can be created by org and send to the
customer they are three levels of information i.e. header, lines, distribution
Transaction can be created in two ways
i.e. Manual, Auto Invoice.
What is Transaction Source?
This source will determine numbering for single
transaction and batch transaction and also it will be determine transaction
type for various transactions, these are two types Manual, Imported.
What is Receipt class?
At the time defining receipt class we have define
Creation method + Remittance method + Clearance method
They are two types i.e. Manual,
Automatic
What is receipt source?
At the time of receipt source we have to assign
Receipt Class + Payment method + Bank Accounts.
They are two types i.e. Manual,
Automatic.
What is Debit Memo in Account
Receivable?
When customer is under charged debit memo will be
created by organization and send to the customer.
What is Credit Memo in Account
Receivable?
When customer is over charged credit memo will be
created by organization and send to the customer.
What is Deposit?
It’s an advance amount which is received from the
customer later it will be adjusted against the invoice it will come under
commitment transaction
What is
Guarantee?
It is assurance from the customer to buy the good or
services it will come under commitment transactions
What is Charge back?
Charge back nothing but closing old transaction and
create a new transaction.
What are Invoice rules and Accounting
rules?
Invoice rules will be determine the accounting period
in which receivable amount will be recognized. These are two types i.e. Bills
in Advance, Bill in Arrears
Accounting rules will be determine
accounting period in use recognize the amount. They are four types i.e. fixed
schedule, variable schedule, daily revenue rate all periods, daily revenue rate
partial periods
What is Reconciliation?
Matching either payment or receipt with the book
statement is called reconciliation.
These are two types i.e. Manual, Auto
Reconciliation.
Difference between 11i and R12
|
11i
|
R12
|
|
Set of book i.e. Primary,
Reporting
|
Ledger i.e. Primary,
Secondary, reporting
|
|
SOB is collections of 3’c’
and Defined of sub ledger level (accounting method)
|
Ledger is collections of
4’c’ and defined at main ledger level
|
|
Forms on screen i.e. D2K,
Tabs
|
JSP/HTML pages i.e. ledger
options & Hyper lines
|
|
Key flexfields i.e.
Accounting Flexfields, Reporting Attributes
|
Accounting Flex field i.e.
Reporting Attributes, General ledger
|
|
Can see one Structure
|
Two Structure
|
|
Flex field qualifiers are
five i.e. Balancing segment, Natural A/C segment, Cost center, Inter company
transactions, Secondary tracking segments
|
Flex field qualifiers are
six i.e. Balancing segment, Natural A/C segment, Cost center, Inter company
transactions, Secondary tracking segments, Management segment
|
|
Legal entity define in HRMS
|
Legal entity define in GL
|
|
Primary and Reporting
COA can be same/ different
Calendar can be Same/
different
Currency would be
difference
|
Primary and Reporting
COA can be same /
difference
Calendar can be same /
difference
Currency can be difference
A/C method can be Same /
Difference
|
|
Profile options: GL set of
books names to assign SOB to Responsibility
|
Profile options: GL ledger
name to assign to Responsibility
|
In R12 introduced MOAC (Multi Org Access Control) so
this features are
- To Access different operating unit from the same responsibility selecting that particular responsibility
- We can do the steps for multiple operating units and SOB
- We can run report for multiple operating units from single responsibility
- MOAC features can be used only for Multi Org Environment.
- To access MOAC features in R12 we have define “Security Profile” in HRMS while defining security profile select one branch group.
11i and R12 differences in Account Payables.
|
Invoice forms in 11i,
header and distribution
|
Invoice forms in R12
header, distribution, line
|
|
|
Invoice types are added in
R12 i.e. Transaction invoice, Retain age
|
|
AP/AR netting is available
in 11i Indirect
|
This concept AP/AR netting
is introduced in as Direct Functionality,
In AP module the menu
“Contra Charge Menu” attaching to the responsibility AP/AR netting will be
available.
|
|
Supplier and Customer are
called separate
|
Supplier and Customer will
be commonly called “Trading Partner”
|
|
If we define Supplier in PO
& AP we can use Supplier in these two modules only
|
If we want same Supplier
information in other modules we have to define again we can use TCA (Trading
Community Architecture)
|
|
Only Customer & Legal
Entity are Global
|
In R12 Customer, Legal
entity, Supplier, Bank, Branch also Global.
|
|
We cont use bank, branch,
bank a/c information of one operating unit to other operating unit
|
Here ledger entity is the
owner of bank account so we can use one bank a/c to different operating units
which are under same legal entity.
|
|
Here transfer AP to GL in
two ways i.e. Payable Accounting Process Program and By Transaction Data.
|
In R12 only one transfer to
GL any Module i.e. Creating Accounting.
|
|
SLA (Sub ledger accounting)
move in 11i i.e. AP transactionàGL interfaceàGL
|
SLA (Sub ledger accounting)
move in R12 i.e. AP transactionàSLA Accounting àGL
|
No comments:
Post a Comment