1)
Inventory (INV)
a.
What
is the use of the Item Attributes?
ANS:Item
attributes are fields in the item table used to store specific characteristics
of the item such as item status,unit of measure,revision control etc.
Attributes
can be controlled at either the master
or the organization level.
It will
store the structure name of the DDF only we can fill/store one structure.
b.
Which
table holds the Master Vs child Organization Details?
ANS:mtl_parameters
c. What is the difference between
ORG_ORGANIZATION_DEFINITIONS and
MTL_PARAMETERS?
ANS:in org_organization_definitions
we can know all the organization names But we cant differentiate what is
master&child organization
But from mtl_parameters we can
differ this.
d. If Master Organization doesn’t have
any child organizations, this will be stored in
MTL_PARAMETERS or not?
ANS:yes,it will be stored one record
child organization will be as a master organization
e.What is the Item Template? Name some
Predefined Templates?
Ans: We can define the properties
of the Item automatically. Predefine Templates of Item is
·
Inventory
Item
·
Stockable
·
Tansactable
·
Purchasable
·
Purchased Purchasing Tab
·
Allow
description updates
·
Reservable
f. What is meant by Lot and Serial
controlled item?
Ans:
Serial Number
It is the unique representation of
quantity for an Item.
Lot Number:-
It will group the item
quantities.
g. How you can generate the Serial
Numbers?’
Ans: In Inventory tab give
Generation : at receipt
Starting Prefix : S
Starting Number: 1
It will
store mtl_serial_numbers
h. What are the different Transaction
Types you know? What is the use of Transaction type?
Ans :
Types:-
·
Miscellaneous
Issue (RG update)
·
Miscellaneous
Receipt (RG update)
·
Miscellaneous
Issue
·
Miscellaneous
Receipt
By using transaction types we can
increase / decrease the item quantity
In which table I can see the
transaction types?
Ans:MTL_MATERIAL_TRANSACTIONS
i. What are the KFFs in Inventory
Module?
1.
Account
Aliases
2.
Item
Catalogs
3.
Item
Categories
4.
Sales
Order
5.
Stock
location
6.
System
Items
j. What is the difference between
MTL_SYSTEM_ITEMS_B and
MTL_SYSTEM_ITEMS_KFV?
Ans:
In MTL_SYSTEM_ITEMS_B the segment stored in segment but MTL_SYSTEM_ITEMS_KFV concate
all the segments and stores in to segment. It (KFV) mainly used in
GL_code_combination for charge_account_id because the charge_account_id stored
in different segments. If we use the KFV it concate all the segments and stores
into the one segment.
k. What is the Item Category? What is
the use of it?
Ans: By using Item Categories we can
group the items which have similar properties.
Use :
·
Define
the struction for category
·
Create
category
·
Create
category sets
·
Define
the item and assign the item to category.
l. What is the Item Revision?
Ans: It represents the upgradation of
item.
m. How I can get the default price in
the PO form?
Ans: We can give the list price in
purchasing tab. Then we can get the default price.
n. Which attributes need to be checked
in order to get the item in PO form?
Ans:
Purchasing Tab
·
Purchasable
·
Purchased
·
Allow description updates
n (1). What
is the DFF in Item Screen?
Ans:
·
Late demands penalty :
·
Invoice UOM :
·
Graphical Link for web reqs:
·
Material over-capacity penalty:
·
Context:
Bills Of Materials
(BOM)
o. What is the BOM? What you can do in
BOM Module?
Ans: BOM means Bill of Materials. It
is used to plan a manufacturing item.
p. What is the Bills and Routings?
Ans: Bills list the components which
are used to manufacture the assembly items.
Routings list the departments and
resourses which are used to manufacture the assembly item.
q. What is Intended Bill?
Ans: It shows the complete structure
of an item.
r. Explain the Steps how to create the
Bill and Routings with one example?
Ans :
1.
Create
the items CPU, RAM, Processor and HD
2.
Define
the cost for items. RAM-100, HD-100, Processor – 50
3.
Define
bills CPU->RAM,HD, Processor
4.
Define
resources S1, A1, P1 with costs
5.
Define
Departments and assign resources to departments.
Sold dept : S1, S2, S3……………………Sn
Assm dept: A1, A2, A3……………………An
Pack dept : P1, P2 P3…………………….Pn
6.
Define
Routings
CPU sold dept S1 1Hr
Assm dept A1 1Hr
Pack dept P1 1Hr
s. What are the setups required in
order to create the Routings for the Assembly Item?
Ans: Same as above.
t. What are different types of BOMs we
have? Explain?
Ans:
There are 5 types of BOMs.
1.
Standard
– List mandatory components
2.
Option
– List the components so that the customer choose the components.
3.
Model
– List the components the customer can configure the items as per his
requirement.
4.
Planning
5.
Product
family.
u. What is the difference between ATO
and PTO configuration?
Ans : ATO : Customer is giving order
and we start manufacturing.
In PTO : We will check whether the
configuration is available as per customer requirement. If available pick the
item and ship to customer.
ATO -> Available to order
PTO-> Pick to Order
v. What is the Mutually Exclusive in
BOM? When we can use it?
Ans : If we check mutually exclusive
check box we can select only one item. Ie., either 2 GB RAM or 4 GB RAM
If it is unchecked we can select (or)
default it will add all the items.
w. What is the Planned and Family
Product BOM?
Ans: Planned is used for only forecasting
purpose.
In product family we can group the
items which have similarities in manufacturing an processing.
Planned and Product family both are
only for our internal purpose only.
Purchasing (PO)
x. What is the P2P cycle? Explain in
details along with tables?
Ans:P2P cycle means Procure to pay
cycle in this cycle we will perform following steps
1)creating the requisition
2)creating RFQ’s
3)Creation Of Quotations
4)creation of purchase Order
5)creating Of Receipts
6)creation Of invoice
7)making payments
y. Have you got any error while
opening the PO form?
Ans:yes,your not set up as
worker to access this form you need to be a worker.
z. What are the setups required in
order to raise the PO?
Ans :create requisition and approve
and make employee as buyer.
a. What is the difference between
Preparer and Requestor in the Requisition form?
Ans :preparer:
Who is authorized to create
requisition
Requester:who is requesting for making requisition.
Prepairer has rides to create
requisition but requester does’t have any rides to create reuesition.in this
case requester request the prepairer to create the requisition.
b. How can I get the item price
automatically in the Requisition or PO forms?
Ans:By entering the list price in
purchasing tab when item is created.
c. What attributes need to set in
order to get the Item in Purchasing Module?
Ans:purchased , purchasable and allow description updates.
d. RFQs, Quotations and POs are stored
in the same tables PO_HEADERS_ALL,
PO_LINES_ALL and
PO_LINE_LOCATIONS_ALL.How you can differentiate these
documents?
Ans :
e. Give the query to extract the
‘Catalog’ RFQs details?
Ans :select*from po_headers_all where
type_looup_code=’RFQ’ and quote_type_lookup_code=’Catalog’
f. What is the
difference between PO_LINES_ALL and PO_LINE_LOCATIONS_ALL?
Ans :po_lines_all table
g. What is the Difference Between
Standard and Planned PO? Explain with one example?
Ans :standard it is used for one time
purchasing here we know item name ,price and qty shift location and shipment Id
Plannedpo it is also similar to standard po but it
is used for future reservations here there will be agreement unlease (frelease
will acts like actual order)
h. Explain one scenario when you will
choose Blanket and Contract PO?
Ans :Blanket Po is choosed when we
know item name and price while releasing we will mention qty shift location
shipment date
Contract:in case
of contract po we know only
agreement amount here we can purchase any item from supplier.
i. After creating Planned PO, can I
create the receipt? If not then when I can create the
receipt?
Ans :No,first we need to approve the
planned po and release the po then only we can create receipt.
j. What are the tables effected after
creating Blanket and Standard PO?
Ans :standard:po_headers_all,po_lines_all,po_line_locations_all,po_distributions_all
Blanket: po_headers_all,po_lines_all,po_line_locations_all
k. What is the difference between
Agreements and Releases?
Ans :
l. Explain the Process how you can release the
Contract PO?
Ans :we an release the contact po
througt standard po
Navigation:poàpoàtype=’standard
po’,supplier=’3M health care’ enter supplier and site as in contact po
Click on reference document then enter line details and approve.
m. Why you can’t release the Contract
PO through the Releases?
Ans :In release mentioning the line
number mandiatory but contract po does’t have lines.
n. Can I change the PO details once it
is approved?
Ans :yes by querrying po number we can
change the details, but we need re approve the po.
o. How can I know that how many times
a PO is changed after approved?
Ans.
p. Planned Agreement and Releases
location details will be stored in the same table
PO_LINE_LOCATIONS_ALL. Then how you
can differentiate Agreement and
Releases?
And :by using release_id,if release id is null it is agreement po ,if it
contain value it is release.
q. Which table will holds the details
of the PO approver?
Ans:PO_CONTROLL_GROUPS_ALL and
PO_CONTROL_ROLES
r. What is significance of the PO_ACTION_HISTORY
table?
Ans :
Select*from po_headers_all where
segment1=’6025’
Select*from po_action_history where
object_id=110306 and object type_code=’PO’
And Obect_sub_tgype_code=’STANDARD’
s. What is the Match approvals and how
many types are there?
Ans :By using this we can meake sure that invoice is generated
for the goods we have ordered.
We have 3 types of Match Approvals
1)2Way:
Qty Billed<=po Qty
Invoice Bill<=Po amount.
2)3Way: Qty Billed<=po Qty
Qty Bill<=Received Qty
Invoice Bill<=Po amount
3)4Way: Qty Billed<=po Qty
Qty Bill<=Received Qty
Qty Bill<=accepted Qty
Invoice Bill<=Po amount
t. What are different types of
Receipts?
Ans : we have 3 types of receipts
1)direct delivery
2)standard receipt
3)inspection required.
u. What are the Receipt tables?
Ans :RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES,
RCV_SHIPMENT_TRANSACTIONS
v. What is the transaction type in
RCV_TRANSACTIONS?
Ans :receive,delever,accept,reject
w. I have created PO (#123) in
‘Hyderabad’ Operating Unit?5 mouses have to be shipped
to ‘Pune’ Organizations,10 Mouse have
to be shipped to ‘Noida’ organization? Explain
how you can create the Receipt?
Ans : change organization name go to
purchasing go to noida
x. What is the Receipt tolerance level?
Ans :go to receivingcontrols-à
we will find tolerance tab
y. Can I change the ship-to location
while creating Receipt?
Ans : yes we can change.
z. How can I forward the PO
document to others in order to approve?
Ans:
a. Explain about Approval Hierarchy in
PO with example?
Ans :to approve the po we need to
create approval groups and approval
assignments
1)create the employee
2)create the job and position
3)assign job and position to employee
4)create approval group
5)create approval manager.
b. What is the Approval Group?
Ans :by using approval group we can
knows which type of document and how much amt we
canapprove .
c. How you can find which Approval
Hierarchy you are using?
Ans :by using this tables
PER_POSITION_STRUCUTRES
PER_POSITION_STRUCUTRES
PER_POS_STRUCTURE_ELEMENTS
d. What is the Approval Manager?
Ans:by using Approval Manager we can know how much amt we
can approve
e. Explain the tables of Approval
Hierarchy?
Ans :PER_POSITION_STRUCUTRES
PER_POS_STRUCTURE_ELEMENTS
f. What is the Auto Create?
Ans : by using this we can create po
directly by using requisition number.
Account Payables (AP)
g. What are the different types of
Invoices?
Ans: we have following types of
invoices in ap
1.stadard,2.credit memo,3.debit
memo,4.expence report,5.prepayments,6.retaiage release,7.transponrtation
inv,8.with hold taxes,9.mixed.
h. What is the difference between
Credit Memo and Debit Memo.Explain the Process with example when you can use
this?
Ans:In credit memo supplier will
create negative amt invoice.
In Debit memo invoice customer will create negative amount invoice.
Suppose customer order 10 items but
suppiers sent 8 items and created invoice for 10 items in this setuation if suppier creates negative invoice it is called credit memo
invoice.
If supplier creates negative amount
invoice then it is debit memo invoice.
i. What is the PO Default?
j. Explain the Process how you can
create the Invoice against the Purchase Order?
Ans:craete the po and copy the po
number
Sw r to payable vision operations
Navigate to invoices the in lines
enter type,po number inv date ,inv no,amount etc.
k. What is the
Recurring invoice and when we can use this?
Ans :
l. Why you are
doing ‘Create Accounting’?
m. What is the
difference between Charge and Liability?
n. What are the Invoices Tables?
Ans:
AP_INVOICES_ALL,AP_INVOICE_LINES_ALL,AP_INVOICE_DISTRIBUTIONS_ALL
o. Which table holds the
Invoice Accounting information?
Ans:AP_INVOICE_PAYMENTS_ALL
p. Which table gives the
information about how much money we have paid for the
Invoice?
Ans:AP_CHECKS_ALL
q. What is the importance of the
PAYMENT_STATUS_FLAG in AP_INVOICES_ALL
table?
Ans :By using payment_staus_flag we
can know wheather the payment is paid by
customer or not.
r. What is the hold? Which table
contains the hold details?
Ans : hold is used to stop the next
process
AP_HOLDS_ALL
s. Explain some scenarios
when you have encountered the holds?
t. Where you can see the hold Details
in front-end?
Ans : To view the hold details go to
actions button click on action and
select hold name then ok then click on holds tab then we can view the hoilds
details.
u. How you can release the holds?
Ans :To release holds go to action
button gthe select release hold with proper reason and click on release.then
hold will be released.
v. Can we release all type
of holds?
Ans :no
w. What are the payment Tables?
Ans :AP_INVOICED_PAYMENTS_ALL
AP_CHECKS_ALL
x. What is the Payment Terms? Which
table holds these details?
Ans:by using payment terms we can
know how much amount will be paid with
the particular period
Table:AP_TERMS_TL
AP_TERMS_LINES
y. What is the Distribution Set? Which
table holds these details? Explain when we can
use it?
Ans: By using Distribution set we can
devide the amount into different accounts automatically
Tables:
AP_DISTRIBUTION_SETS_ALL
AP_DISTRIBUTION_SETS_LINES_ALL
Automatically amounts will be splitted
into specified accounts.
Order Management (OM)
z. What is the Order Type? In which
table I can see these details?
Ans:order type says that which type of
order we are generating.
Table:OE_ORDER_HEADERS_ALL
a). What is the Price list? What is
the Relation between price list and OM?
Ans :by using price list we can sell
the same item for different prices.
If we want to get default price for
the item in OM wde need to define price
list.
b. How can I can get the Item Price in
the OM form? Can I override this price?
Ans:by definning price list yes u can
over ride.
c. In which columns I can see the
price list price and over ride price for particular sales
Ans: oe_order_lines_all. unit_price
Order Line?
d. While writing the query how you can
get the line number?
Ans :select
oola.line_number||’.’||oola.shipment_number
e. Explain the O2C cycle?
Ans: 1 Entered(entering the item
details raughly)
2 Avaiting Shipping(Booked)(Agreement
will be started)
3 Picked(Reserving Item,Qty not
decreased)
4 Shipped(Item Shifted,Qty decreased)
5 Closed(Order closed)
6 Create the Invoice(Work flow back
ground program will tranfor the records from
OM to AR interface table, Run
Auto invoice Import Program to move from AR interface to base table).
7 Receive money
f. What are the basic setups you have
done in order to create the Sales Order?
Ans:In ordere to create sales order we
have to done following steps
1 Booking the order
2 Picking the order
3 Shippig bthe Order
4 Closing the order
g. What are the different statuses you
got?
Ans: While creating sales order we
come across the following statuses
1 entered
2 avaiting shipping
3 picked
4 shipped
5 closed
h. What is the difference between
Picked and shipped?
Ans: After picking Qty of item won’t
be redused as just we are reserving the item but
After shipped the Qty of item will be
redused.
i. Name the Programs will be submitted
after each and every stage? Ex: Picked and
shipped etc.
Ans: For Picking:
1 Pick selection list generation
2 Pick slip report
3 shipping exception report
For Shipping:
1 Bill of landing
2 Packing Slip Report
3 Commercial invoice
4 Vehicle load sheet details
5 Interface trip stop
j. What is significance of
the Bill of Landing Program?
k. If I pick the item what are the
tables will be effected. Give more than 7 tables?
Ans: while picking the order the
following 7 tables will be effected
WSH_DELIVERY_DETAILS
WSH_DELIVERY_ASSIGNMENTS
WSH_PICKING_BATCHES
MTL_MATERIAL_TRANSACTIONS
MTL_RESERVATIONS
MTL_TXN_REQUEST_HEADERS
MTL_TXN_RQUEST_LINES
l. What is the Transaction Type for
Picking and shipping?
Ans : For Pickling:
Transaction Type= Sales Order Pick
For Shipping
Transaction Type = Sales Order Isuue.
m. How you can send
the data from OM to AR?
Ans :Work flow back ground program
will tranfor the records from OM to AR
interface table, Run Auto invoice Import
Program to move from AR interface to base table.
n. What are the
Interface tables and Standard Program for AR?
Ans
:RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_AL
Stadard Prog: Auto
Invoice Import Program.
o. What is the relation between OM and
AR?
Ans:In Om after closing sales order
,in AR supplier will create the invoice and send to customer so that customer
can pay amount and supplier will receive payments.
p. What are the delivery tables?
Ans: WSH_DELIVERY_DETAILS
WSH_DELIVERY_ASSIGNMENTS
WSH_PICKING_BATCHES
q. Explain the situation when we can
go for Drop Shipment and Back to Back Order?
Ans: When supplier is not having item
to delever to customer in this setuation supplier will go for drop shipment or
back to back order.
r. What is the Drop shipment? How you
can make one Sales order line as a Drop
shipment? Explain
the Process and tables in each and every stage?
Ans:customer orders items to
supplier,but supplier doesn’t have the item to delever to the customer ,so
supplier will contact third party this is drop shipment.
By giving column sourse type External
s. What is the Back to Back
order? How you can make one Sales order line as a B2B
Ans:
Order? Explain the Process and tables
in each and every stage?
t. What are the advantages and
dis-advantages of Drop shipment?
Ans :adv:
No need of inventory
Shipping time is less.
Shipping price is less.
Wide range of items can be delevered.
Dis Adv:
After no of times interactions between
customer and third party third party can
make direct contract with customer.Here supplier have achance to loose the
contract
u. What is the Back Ordered?
v. If Items are not
available while picking the Items then what will happen to Sales Order
Line?
w. Can I create one Normal
line, one Drop shipment line and B2B line in one Order?
x. Can customer return the
good? How you can do this one in OM?
y. What is RMA?
z. What will happen if I apply the
holds?
Ans : Hold is used to stop the process
due to some reasons
Ex: customer not paid money regularly
a. What is the difference
between applying the holds between headers and lines?
Ans : If we apply holds on headers it
will be applicable to lines also but if we apply hold to a line it will
applicable particular line only.
b. Which table contains the holds
Details?
Ans:AP_HOLDS_ALL
c.
Explain
the Process how to apply and release the holds?
Ans:applying the hold:
We can apply the hold in headers as well as lines also to
apply the hold go to shipping tab click
on action button select hold name from drolp down list
And enter hold comments the click on
ok.
Releasing the hold:
Click on actions button select release
hold and enter proper reason and click on release then hold will be released.
d. What is the use of ‘Configurator’
button in OM screen?
Ans :customer can configer the item
Ex: if the customer wants to select
cpu of 4gb(out of 2gb,4gb) then we are using cofiguratot.
e)Explain the Process of
Internal Sales Order?
Ans : internal sales order means normal
sales order in OM
Account Receivables
(AR):
f. What are the different types of
invoices (Transactions) we have?
Ans :we have following types of invoices
in AR
1. invoice,2.credit memo,
3.Deposite,4.guarentee, and Charge back.
g. What are the Transaction (Invoice)
Tables?
Ans :RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_LINE_GL_DIST_ALL
RA_CUSt_TRX_LINE_SALESREPS_ALL
h. What is the difference between
Deposit and Guarantee?
Ans in case of deposite:it is used to
give some money in advance to the customer.
For Guarentee: Guarentee is also like
a deposite that original amount
Won’t be redused from guarantee amount
but in case of deposite original amount will be redused from deposite amount.
i. What is the Chargeback? When you
can use it?
Ans :Charge back is used to cancel the amount.
j. Can I create or credit memo and debit memo against one invoice? If so
explain how I
can create?
k. What is the applied and unapplied
amount in Receipts?
Ans :
l. What are the Receipt Tables?
Ans :Cash Recipts:
AR_CASH_RECEIPTS_ALL
m. What is the Auto-lock
Box? Explain the Process?
Work in Process (WIP)
n. What is WIP.What is the use of this
module?
Ans:WIP stands for Work In Process. In
this module we can manufacture the items. Manufacturing of Items takes place in
two ways in Oracle Apps.
1.
Discrete
Manufacturing
2.
Process
Manufacturing
1. Discrete
Manufacturing :
It uses Bills of Materials for
manufacturing the items. We can de-assemble the Items which are prepared
through DM.
Ex: CPU, Laptop.
2.Process
Manufacturing :
It uses formulas for manufacturing the
components.
We cannot de-assemble the items which
are prepared through PM.
Eg: Food products.
Apps will support DM through WIP
module.
Apps will support PM through Oracle
Process Management (OPM) Module
o. What are the different Job statuses
we have?
Ans:
We have 5 types of Job Statuses, ie., Unreleased, Released, Complete,
Cancelled, Onhold.
p. Explain the Process how you can
manufacture the item in WIP?
Ans:
1.
Create
the job : Here the status will be unreleased
2.
Change
the status from unreleased to released manually
3.
Now
perform the inter operation steps : here now the jobs status will be completed.
4.
Close
the job.
q. How many types of jobs we have?
Ans : We have 2 types of Jobs ie.,
Standard and Non Standard Jobs.
r. What is the difference between
Standard and Non Standard Jobs?
Ans : Standard Jobs is used for
manufacturing a new item (based on BOM) whereas Non Standard Job is used for
reparing, deassembling, etc.,
s. What is the use of Supply types?
Ans : By using Supply types we can
state that when material has to be consumed from sub inventory.
t. What are the different supply types
we have?
Ans : We have 6 types of supply types.
Assembly Pull, Operation Pull, Push,
Supplier, Bulk and Based on Bill.
u. What is the different between
Assembly Pull and Operation Pull?
Ans: In Assembly Pull material will be
consumed from sub inventory after completion
of operation only.
In Operation pull material will be
consumed from sub inventory once the operation is started.
v. What is the ‘push’ Supply Type?
Ans : In Push Supply type we need to
supply the material manually before starting the process.
w. What are the different
Intra-operation Steps we have? Explain each and every one?
Ans:
1.
Queue
2.
Run
3.
To
Move
4.
Receipt
5.
Scrap
1.Queue:
Assemblies at this step are waiting
for you to perform an action.
2.Run
Assemblies at this step are being run
ie., work is going on.
3.
To move
Assemblies at this step are completed
and waiting for the next operation if available
4.
Receipt:
Assemblies
at this step are rejected and waiting for repair.
5.
Scrap
Assemblies
are this step are useless (We cant use them at all, they should be thrown away)
x. What are the basic setups required
to create the job?
Ans: We require two steps to create a
job.
1.
Defining Parameters:
Here we
are mentioning the supply sub inventories from which material has to be taken
to manufacture the item and what kind of inter operations steps to
perform,etc.,
2.
Defining WIP accounting class:
Here we
are capturing details in different accounts like material, material over head,
resource etc.,
y. Name the tables and use of it you came across in WIP
Module?
Ans:
WIP_Paramaters : To check from which sub inventory
material has been consumed.
WIP_accounting_classes:
To capture the operation details in different accounts.
WIP_operations : To view what department are used in
manufacturing the item.
WIP_requirement_operations : To view what components used
to manufacture the items.
WIP_operation_resources : To view what resources used to
manufacture the item.
z. Explain the process how you can man
SQL* Loader
What
are the different options we have?
Ans :
What are the different types of
files ?Explain?
Ans:e have 5 types files in
sql*loader
1)flat file:It is data file it
can be text or xls format.
2)CTL File(Control file): In
this file we will write the logic to tranfor the records into to table
3)LogFile:It will show
statestic like (how many records processed, inserted,rejected)
4)Bad File:It contains The
Records Which are rejected by sql*loder(rejected by syntax errors)
5)Discard File:It Contains the
records which are rejected by our own logic(Ctl file )or which are rejected by
when clause.
What is the difference between
Bad and Discard File?
Ans :Bad File contains the records which are rejected by sql*
loder(pogram) example:data type mismatch etc
Discard File:It Contains the
records which are rejected by our own logic(Ctl file )or which are rejected by
when clause.
How
you can generate bad and discard file?
Ans :They are auto matically generated
What
are the different loading methods? Explain?
Ans :
Can I use functions in CTL file?
Ans : Yes ,we can use functions
in CTL file
Ex:deleting spaces trailing
nullcols(RNAME LTRIM(RTRIM(:RNAME)),
RNO LTRIM(RTRIM(:RNO)),
RGROUP LTRIM(RTRIM(:RGROUP)))
If date
is not mentioned then I need to insert sysdate how can I achieve?
Ans:
If we
insert the data into table using sqlloader for last column value ‘|’ symbol
will be concatenated. How can I
Delete
this?
How can I load multiple files
into multiple tables?
Ans :By using position numbers
Reports 10g
Explain the registration steps
to register the report in applications?
Ans :1)Design your report
2)generate executable file of the report.
3)move the executable as well as source
file to the appropriate products folder.
4)register the report as concurrent
executable.
5)defile the concurrent program for
executable registered.
6)add the concurrent program to request
group of the responsibility
Do I require any setups to do
in order to register the report in applications? If I require when I require?
Ans :yes we need to do all the
above steps,when we want to register the report in the application.
To which folder will you move
the rdf? How you will move?
Ans :we will move our rdf to on custom top custom folder(Client given)
How can you decide which
application name have to give while creating Executable and Concurrent Program?
Ans : according to the client
requested responsibility we will take that responsibility related application name.
While Registering the report in
applications have you created Responsibility?
Ans :no already
responsibilities created by system admin requested by the client.
What is
P_CONC_REQUEST_ID?
Ans : P_CONC_REQUEST_ID is user parameter
Why you are using user exists
while registering the report in applications? Is it mandatory?
Ans :we have to use user
exist whenever we use profile options,no these are not
mandiatorry.
How you can match your report
parameters with application parameters?
Ans :By using token we can match your report parameters with
application parameters
Profile Options
What is the profile option.
Explain where exactly you have used it?
Ans :It is just like a PL/sql
varriable which will takes the values dynamically from oracle applications.If
we wnt to change vision operation
organization to vision swedan as a default org we have used profile options.
What are the different levels
in profile options?
Ans :We have 4 levels
1)site level
2)application level
3)Responsibility level
4)User level
Name some of the profile
options which you have used?
Ans :Mo operatring unit,Hr
operating unit,Qa inspection required,Hr Business group,hr security profile.
I have assigned operating unit
‘vision operations’ at responsibility level and ‘vision Sweden’ at user level.
Which operating unit I can get
and why?
Ans :we will get ‘ vision
Sweden’ operating unit because user
level will override remaining all levels
I want to disable the
responsibility level how I can do?
Ans :sysadmin--àapplicationàprofileàquery with user profile
name (MO operating unitg)àuncheck
Responsibility access level.
Flex Fields
What is the flexfield.?
Ans :Flex Fields means Flexible
fields By using Flexible fields,we can
divide one field into different fields.
What are the different type of
flex fields we have.
Ans :we have two types of
flexfields
1)key Flex Field:used to capture
the codes ex:Accounting Flexfield,which are stored in segments
2)Descriptive flexFields:To add
extra information to the form which are stored in attributes.
Explain the process how we can
implement DFF sand KFFs.
Ans :DFF:
Name some of the KFFS.
Ans :Accounting flexfield,
Why we need KFFS. Explain with
one example?
Ans :
What is
attribute Category?
Ans :
What is the Context Field?
Ans :
Multi Org Access Control (MOAC)
What is MOAC?
Ans :By using MOAC same user can perform multiple task across
operating unit without changing responsibilies
MOAC feature in R12 retains the
data security aspect between organizations and users
What is difference between MO
and MOAC?
Ans :In MO we have only one
operating unit but in MOAC we have more than one operating unit and we can
access
All operating units
What are the different levels
and give the tables of all levels?
Ans :1)Business Group
PER_BUSINESS_GROPS
2)Ledger:GL_LEDGERS
3)Legal Entity:HR_LEGAL_ENTITIES
4)OperatingUnit:HR_OPERATING_UNITS
5)INVENTORY:ORG_ORGANIZATION_DEFINITIONS
What is Multi org view and
Multi Org Table?
Ans :Multi Org table stores all
the operating Unit transactions and it contains org_id
àmulti
Org View is created based on multi org table
with the condition org_id=clent_info
What is difference between
po_headers and po_headers_all?
Ans :Po_headers_all is a multi org table and po_header is a view
I have
created vendor (Ap_Suppliers) and vendor sites (Ap_Supplier_Sites_all) in
‘vision Operation’ Operating Unit.
If I change my operating unit to
‘vision Swedon’ Can I see vendors or vendor sites or both.
Ans :Yes,
How you can decide whether your
client is multi org or not?
Ans :
Name
the operating unit names of your client?
Ans:
if I write ‘select * from
po_headers’ can I get the data. If not what is the reason and how I can get the
data?
Ans :we don’t get any data because it is aview,in order to get data copy
po_headers and paste it on toad put cursor on it and press f4 them we can get
the table.
If we go to the forms
help->record history it will show the view ‘po_headers’ instead of
‘po_headers_all’ why.
Ans :Because form info will be
stored in views by joining so many tables ,the id’s only will be
stored in base table.
What is the difference between
organization_id and org_id?
Ans :organization_id refers to
unique id of inventory organization,org_id refers a operating unit
Name some modules which are
organized at operating unit and organization level.
Ans :BUSINESS LEVEL:HRMS
LEDGER:GL
LEGAL ENTITY:CASH MGT(CM)
OPERATING UNIT:PO,AP,OM,AR
How you get particular
operating unit?
Ans :MO:OPERatingUnit(Profile
Option):we will get particular operating unit.
In
R12 I want to use MO instead of MOAC ?
How can I achieve?
Ans :
AIM Methodology
What is AIM Methodology?
Explain what are the documents
you have followed in your project.
Name few sections in the MD50
and MD70 document.
What is the difference between
MD50 and MD70.
Explain about the test cases
you have prepared in your interface/Reports.
No comments:
Post a Comment