Oracle Apps Interview Preparation Guide

Download PDF

both, master and org. Google it.

In UOM Two Conversions One Is
Inter UOM
Intra UOM
Inter:
The Conversion Rate will Be Changed To An item With in
Different UOM Class..
Eg:Gn oil Kg=0.961 Lt..
Intra :
The Conversion Rate Will Be Changed To The Different
Items With in the Same UOM Class.
Eg:1 Case Bottles=12 Each
1 Case Bottles=24 Each

Transaction Register
Material Distribution Detail Report
Material Distribution Summary Report

Workday calendar is simply use for transactional purposes.
For example in treasury in counting of money placements with
the define workday calendar you define working days is 5
days only excluding week ends, and this is the same AP
wherein you defined in aging of payables it will count due
date after you have set terms date, and so fourth in for AR.

While, the accounting calendar this is the financial period.
In defining it we will just simply refer to calendar 12
month and or 13 month including the adjustment period. This
is where the start and end of every financial periods and
cut off of reporting period in the financial statements.

Under Costing tab, if u unchecked "inventory asset value"
attribute it becomes expense item and if checked it becomes
asset type item.

We can change item's UOM in Item master responsibility..

if the Item Code is already transacted then we can't change the UOM .
if the item code is not transacted then we can chaenge the UOM.

Its all depends upon the item kff and the value sets.
Dont use special char like #,@,%,&
Some char like %,_,# have special meaning while perfoming query by form

Keep it balnk for the same. It will allow to select all
invoices

Accounting Convention which is nothing but subledger
accounting. It is the additional feature introduced in R12

For Eg. If the company in India is primary company and it
has branch at US which we can treat as secondary or subsidary,

1) In us its functional currency is USD which differs with
Primary country functional currency,
2) In US Calander is from 01-jan to 31-dec and in Primary
company Calander is 01-APR TO 31-MAR
3)BASED ON PRIMARY COMPANY REQUIREMENT ACCOUNTS ARE CREATED
AND SAME WAY SECONDARY COMPANY ALSO HAVING ITS OWN ACCOUNTS
KEY FLEXI FIELDS

Global temporary tables are temporary table for perticular session.
Global temporary tables are two types,
1.Transaction wise temporary table
2.Session wise temporary tables.
In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.
In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.

format trigger : when we want hide or display the objects in
in layout model dynamically we can use format trigger

action trigger : when a button selectd procedure executed
new report open

format trigger we can write in item level

1-HR:Security Profile __because join between business Group
and Responsibility
2-MO:OPERATING UNIT TO deFine organization with GL & AP
3-HR:USER TYPE TO CREAT EMPLOYERS

ZERO_DIVISOR,
INVALID_CURSOR,
CURSOR_ALREADY_OPEN

This segment will be paired with the balancing segment when
generating account balances for the Retained Earnings
account, Unrealized Gains or Losses accounts, and the
Cumulative Translation Adjustment account.

Yes, you could run translation for Multiple Currencies.

You need to run Translation for the SOB or Ledger with GBP
Currency. The Translation should be from GBP to USD for
given periods.

Not possible

Yes, Auto Accounting determines the general ledger accounts
for transactions that are entered manually or import using
Autoinvoice.

1. natutal account while creating Ap invoice should be
Asset clearing account
2. Enable track as asset in AP invoice line distributions
3. The Invoice should be validated, accounted and transfered
to GL.

Note- mass additions will work only if transfer to run
program is run and ap invoice is transfered to GL.

Automatic Offsets, Payables automatically balances invoice
and payment distributions that cross balancing segments by
creating offsetting entries for each balancing segment.

Create new code combination at General Ledger Super User -
Settup - Accounts - Combinations