Sunday 22 April 2012

BOM Routings Query



SELECT MSI.SEGMENT1 ITEM_NAME,
MSI.DESCRIPTION,
MSI.primary_uom_code uom,
MIRB.REVISION,
BOR.CREATION_DATE START_DATE,
-------------------------
----------------------------
 bos.operation_seq_num,
  bd.department_code,
  DECODE (bos.count_point_type, 1, 1, 2) count_point_flag
FROM BOM_OPERATIONAL_ROUTINGS BOR,
MTL_SYSTEM_ITEMS MSI,
MTL_ITEM_REVISIONS_B MIRB,
----------------------
 bom_operation_sequences bos,
  bom_departments bd
WHERE BOR.ASSEMBLY_ITEM_ID='222955'
AND bor.assembly_item_id = MSI.inventory_item_id
AND bor.organization_id = MSI.organization_id
-----------------------------------------------
AND BOR.ASSEMBLY_ITEM_ID=MIRB.INVENTORY_ITEM_ID
AND BOR.ORGANIZATION_ID=MIRB.ORGANIZATION_ID
-----------------------------------------
AND BOR.ROUTING_SEQUENCE_ID=BOS.ROUTING_SEQUENCE_ID
AND bos.department_id = bd.department_id

AR invoice query


SELECT
RCTA.TRX_NUMBER INVOICE_NO,
HP.PARTY_NAME CUST_NAME,
HCA.ACCOUNT_NUMBER,
RCTA.TRX_DATE INVOICE_DATE,
--------SHIP TO
HP1.PARTY_NAME SHIP_CUST_NAME,
HCS.LOCATION SHIP_TO_LOC,
HL.ADDRESS1 SHIP_TO_ADDR1,
DECODE (HL.CITY,NULL, NULL,HL.CITY || ', ')||
DECODE (HL.STATE,NULL, HL.PROVINCE || ', ',HL.STATE || ', ')||
DECODE (HL.POSTAL_CODE, NULL, NULL, HL.POSTAL_CODE || ', ')||
DECODE (HL.COUNTRY, NULL, NULL, HL.COUNTRY) SHIP_TO_ADDR5,
----------BILL TO
HP.PARTY_NAME BILL_CUST_NAME,
HCS1.LOCATION BILL_TO_LOC,
HL1.ADDRESS1 BILL_TO_ADDR1,
DECODE (HL1.CITY,NULL, NULL, HL1.CITY || ', ')||
DECODE (HL1.STATE, NULL, HL1.PROVINCE || ', ',HL1.STATE || ', ')||
DECODE (HL1.POSTAL_CODE, NULL, NULL,HL1.POSTAL_CODE || ', ' ) ||
DECODE (HL1.COUNTRY, NULL, NULL, HL1.COUNTRY) BILL_TO_ADDR5,
----------REMIT TO
HP.PARTY_NAME REMIT_CUST_NAME,
HCS2.LOCATION REMIT_TO_LOC,
HL2.ADDRESS1 REMIT_TO_ADDR1,
DECODE (HL2.CITY,NULL, NULL, HL1.CITY || ', ')||
DECODE (HL2.STATE, NULL, HL1.PROVINCE || ', ',HL1.STATE || ', ')||
DECODE (HL2.POSTAL_CODE, NULL, NULL,HL1.POSTAL_CODE || ', ' ) ||
DECODE (HL2.COUNTRY, NULL, NULL, HL1.COUNTRY) REMIT_TO_ADDR5,
-------LINES
   RCTL.LINE_NUMBER,
   MSIB.SEGMENT1 ITEM_NAME,
   RCTL.UOM_CODE,
   RCTL.QUANTITY_INVOICED,
   RCTL.UNIT_SELLING_PRICE,
   RCTL.LINE_TYPE,
   (RCTL.QUANTITY_INVOICED*RCTL.UNIT_SELLING_PRICE)LINE_PRICE,
   DECODE(RCTL.QUANTITY_INVOICED*RCTL.UNIT_SELLING_PRICE,NULL,RCTL.EXTENDED_AMOUNT,
   RCTL.QUANTITY_INVOICED*RCTL.UNIT_SELLING_PRICE)TOTAMT
FROM
RA_CUSTOMER_TRX_ALL RCTA,
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS HCA,
HZ_CUST_SITE_USES_ALL HCS,
HZ_CUST_ACCT_SITES_ALL HCAS,
HZ_LOCATIONS HL,
HZ_PARTY_SITES HPS,
--------------------
HZ_CUST_SITE_USES_ALL HCS1,
HZ_CUST_ACCT_SITES_ALL HCAS1,
HZ_LOCATIONS HL1,
HZ_PARTY_SITES HPS1,
---------------------------
RA_CUSTOMER_TRX_LINES_ALL RCTL,
MTL_SYSTEM_ITEMS_B MSIB,
HZ_CUST_SITE_USES_ALL HCS2,
HZ_CUST_ACCT_SITES_ALL HCAS2,
HZ_LOCATIONS HL2,
HZ_PARTY_SITES HPS2,
---------------------
HZ_PARTIES HP1,
HZ_CUST_ACCOUNTS HCA1,
-------------------------
HZ_PARTIES HP2,
HZ_CUST_ACCOUNTS HCA2
--------------------------
WHERE RCTA.TRX_NUMBER = '12024'
AND RCTA.SOLD_TO_CUSTOMER_ID=HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID=HP.PARTY_ID
----------------------------------------------
AND RCTA.SHIP_TO_CUSTOMER_ID=HCA1.CUST_ACCOUNT_ID
AND HCA1.PARTY_ID=HP1.PARTY_ID
AND RCTA.SHIP_TO_SITE_USE_ID=HCS.SITE_USE_ID
AND HCS.CUST_ACCT_SITE_ID=HCAS.CUST_ACCT_SITE_ID
------------------------------------------------
AND RCTA.SHIP_TO_SITE_USE_ID=HCS.SITE_USE_ID
AND HCS.CUST_ACCT_SITE_ID=HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID=HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID=HL.LOCATION_ID
---------------------------------
AND RCTA.BILL_TO_CUSTOMER_ID=HCA2.CUST_ACCOUNT_ID
AND HCA2.PARTY_ID=HP2.PARTY_ID
AND RCTA.BILL_TO_SITE_USE_ID=HCS1.SITE_USE_ID
AND HCS1.CUST_ACCT_SITE_ID=HCAS1.CUST_ACCT_SITE_ID
----------------------------------------------
AND RCTA.BILL_TO_SITE_USE_ID=HCS1.SITE_USE_ID
AND HCS1.CUST_ACCT_SITE_ID=HCAS1.CUST_ACCT_SITE_ID
AND HCAS1.PARTY_SITE_ID=HPS1.PARTY_SITE_ID
AND HPS1.LOCATION_ID=HL1.LOCATION_ID
----------------------------------------
AND RCTA.REMIT_TO_ADDRESS_ID=HCS2.SITE_USE_ID
AND HCS2.CUST_ACCT_SITE_ID=HCAS2.CUST_ACCT_SITE_ID
AND HCAS2.PARTY_SITE_ID=HPS2.PARTY_SITE_ID
AND HPS2.LOCATION_ID=HL2.LOCATION_ID
-----------------------------------------
AND RCTL.CUSTOMER_TRX_ID=RCTA.CUSTOMER_TRX_ID
--------------------------------------
AND RCTL.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID(+)
AND RCTL.ORG_ID=MSIB.ORGANIZATION_ID(+)

bom bill query



SELECT
MSIB.SEGMENT1,
MSIB.DESCRIPTION,
DECODE(MSIB.REVISION_QTY_CONTROL_CODE,1,'A',2,'B',MSIB.REVISION_QTY_CONTROL_CODE)REVISION,
bom.creation_date,
MSIB.PRIMARY_UOM_CODE UOM,
---------LINES DETAILS
bic.item_num,
bic.operation_seq_num,
MSI.CONCATENATED_SEGMENTS,
 msit.description,
 MSI.PRIMARY_UOM_CODE,
 DECODE(NVL (bic.basis_type, 1),1,'ITEM',2,'LOT',NVL (bic.basis_type, 1))BASIS,
 MIRB.REVISION,
 bic.component_quantity,
 ---COMPONENT DETAILS
 fcl.meaning item_type,
  msi.inventory_item_status_code,
  ----MATERIAL CONTROL
  ml.meaning supply_type
FROM
bom_bill_of_materials bom,
MTL_SYSTEM_ITEMS_B MSIB,
-----------------------
bom_inventory_components bic,
 mtl_system_items_b_kfv msi,
 mtl_system_items_tl msit,
 ------------------------
 MTL_ITEM_REVISIONS_B MIRB,
 fnd_common_lookups fcl,
 -------------------
   mfg_lookups ml
WHERE
ASSEMBLY_ITEM_ID='222955'
AND BOM.ASSEMBLY_ITEM_ID=MSIB.INVENTORY_ITEM_ID
AND BOM.ORGANIZATION_ID=MSIB.ORGANIZATION_ID
--------------------------------------------
AND bic.bill_sequence_id = bom.bill_sequence_id
AND bic.component_item_id = msi.inventory_item_id
------------------------------------------------------
AND bic.component_item_id = msi.inventory_item_id
AND bom.organization_id = msi.organization_id
AND msi.inventory_item_id = msit.inventory_item_id
AND msi.organization_id = msit.organization_id
AND msit.LANGUAGE = USERENV ('LANG')
-----------------------------------------
AND bic.component_item_id = miRB.inventory_item_id
AND bom.organization_id = miRB.organization_id
AND msi.inventory_item_id = msit.inventory_item_id
-----------------------------------------------
AND fcl.lookup_type(+) = 'ITEM_TYPE'
AND fcl.lookup_code(+) = msi.item_type
------------------------------------------
AND ml.lookup_code(+) = bic.wip_supply_type
AND ml.lookup_type(+) = 'WIP_SUPPLY'



WIP discrete jobs Query



SELECT WE.WIP_ENTITY_NAME,
 DECODE(wdj.job_type,1,'STANDARD',2,'NON_STANDARD',wdj.job_type)JOB_TYPE,
 MSIB.SEGMENT1 ASSEMBLY_ITEM_NAME,
 MSIB.DESCRIPTION,
 wdj.class_code,
 lu1.meaning status,
 MMT.TRANSACTION_UOM UOM,
 wdj.scheduled_start_date SCHEDULE_START_DATE,
 wdj.scheduled_completion_date SCHEDULE_END_DATE ,
 wdj.start_quantity,
 wdj.net_quantity,
 ----BILL TAB-------------------------
 lu2.meaning wip_supply_type,
 ----------ROUTING TAB----------------
    wdj.completion_subinventory,
    -------COMPONENTS
    msik.concatenated_segments,
    --DEPARTMENTS---------
    bd.department_code
    ---RESOURCES-----------
     --br.resource_code
FROM WIP_ENTITIES WE,
wip_discrete_jobs wdj,        
MTL_SYSTEM_ITEMS_B MSIB ,
mfg_lookups lu1,
mfg_lookups lu2,
MTL_MATERIAL_TRANSACTIONS MMT,
--------------------------
 mtl_system_items_vl msik,
       wip_requirement_operations wro,
       --------------------------
        wip_operations wo,
      bom_departments bd,
       --------------------
        bom_resources br,
        wip_operation_resources wor
WHERE WE.WIP_ENTITY_NAME='246412'
AND we.wip_entity_id = wdj.wip_entity_id
AND WE.PRIMARY_ITEM_ID=MSIB.INVENTORY_ITEM_ID
AND lu1.lookup_type = 'WIP_JOB_STATUS'
AND lu1.lookup_code = wdj.status_type
AND lu2.lookup_type = 'WIP_SUPPLY'
AND lu2.lookup_code = wdj.wip_supply_type
AND WE.PRIMARY_ITEM_ID=MMT.INVENTORY_ITEM_ID
---------------------------------------
AND WE.WIP_ENTITY_ID=WRO.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WRO.ORGANIZATION_ID
AND  msik.inventory_item_id = wro.inventory_item_id
AND msik.organization_id = wro.organization_id
----------------------------------------------
AND bd.department_id = wo.department_id
AND WE.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WO.ORGANIZATION_ID
 --------------------------------------
 AND br.resource_id = wor.resource_id
 AND WOR.WIP_ENTITY_ID=WE.WIP_ENTITY_ID
 AND WOR.ORGANIZATION_ID=WE.ORGANIZATION_ID

Wednesday 18 April 2012

apps details


BOM,WIP,INV,PO,AP,AR,MOAC


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_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.