Oracle Basic Interview Questions and Answers

1 :: Explain what are the setups involved in Drop Shipment Process?

Drop Shipment is done when your customer has ordered an item that you dont manufacture. In this case you purchase the same product from another company and the ship to location will the customers address. In Oracle the steps that are followed are as follows:

Enter the order with a Dropship item >> Book >> Workflow Background Process is run>>
Then Purchase release is run>> now in PO super user>> run Requisition import>> it will create the requisition>> Autocreate the requisition to a PO>> receive the PO into thedropship subinventory>> Verify the SO lines should be shipped by now>>> Run workflow and Autoinvoice.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

2 :: Explain Order Management Flow in detail?

Create Sale order >

in the Header Level - enter customer name whos should be having both Bill to and Sit to Address> enter Payment Terms> enter the pricing > enter the transaction Type of that sale, then go to Line item and pick the invenotiable ( or ono inventoribale item) items from item master from the Sub Inventroy Orginsation, then attch this line to a particular sales man or collection agent.

Save the data, ( Line statius is 'Entered') then book the order ( shows the line status as " line is awating shippment" ( order status will be 'booked' > release the sales order > ( Line status will be " Picked") and ship the Materail which eventually show the line status as 'closed'.

this shows the inventroy is credited with inventory Cost and COGS is Debited

The next face is interfacing to AR ( Autoinvoicing Rule) - Customer is Debited and Sales is Credited.

enter the order:
---------------
oe-order-headers-all
oe-order-lines-all(flow_status_code = entered)
book the order:
--------------
oe_order_headers_all
oe_order_lines_all(flow_status_code = booked)
wsh_new_deliveries(status_code =open)
wsh_delivery_details(releases_status = R 'ready to release)
pick release:
---------------
which items on sales order we need to take out from inventory.
normally pick release SRS program run from backend once this over.
oe_order_lines_all(flow_status_code=picked)
wsh_delivery_detalis(release_status = S 'submitted for release)

pick confirm:
-------------
items are transfered from salable to staging sub inventory.
mtl_material_transaction
mtl_transaction_accounts
wsh_delivery_details(released_status = Y 'released')
wsh_delivery_assignments

ship confirm:
-------------
here ship confirm program run from backend and data removed from wsh_new_deliveries.
oe_order_lines_all ( flow_status_code =shipped)
wsh_delivery_details (released_status = shipped)
mtl_transaction_interface
mtl_material_transactions (linked through source_header_id)
data deleted from mtl_demand & mtl_reservations
item deducted from mtl_onhand_quantities.

Enter invoice:
--------------
this is also called recivables interface,that mean information moved to accounting area for invoicing
details.
invoicing workflow activity transfers shipped item info to recevables.
ra_interface_lines_all
then auto-invoice program imports data from this.
then effected tables : ra_customer_trx_all (trx_number is the invoice number)
ra_customer_trx_lines_all (line_attribute 1 & 6 ) linked to header_id
and lined_id for orders....

complete line:
-------------
order line level table get updated with flow status & open flag.
oe_ordr_lines_all ( flow_status_code = shipped & open flag = N)

close order:
------------
once we close the order oe_order_lines_all table get updated with flow_status_code as closed.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

3 :: What is ONT stands for, as OE stands for Order Entry?

ONT is the application short name for Order Management in Oracle.

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

4 :: Explain What are the APIs used in Order Management?

OE_ORDER_PUB is the main API in OM. Using this API all data manipulation (Inserts updates deletes can be performed on a Sales Order and it's attributes. Besides these certain other action requests such as applying holds attachments booking etc. can also be processed using the Sales Order API. After this in Shipping we have WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERIES
for creating and updating deliveries for picked
lines WSH_DELIVERIES_PUB.DELIVERY_ACTION
for actions on created deliveries like PICK_RELEASE SHIP_CONFIRM

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

5 :: Explain the conversion of holds done using API? What are the tables affected? what are the fields to be passed and to which base tables?

The tables effected are

oe_hold_definitions (contains hold name would be defined as apart of setup)
oe_hold_sources (hold applied info would be saved in this)
oe_order_holds (contins the hold info in this as well)


Data to be passed sales order header id order line id hold id (type of hold) hold code like OEOH means hold at the header level OEOL hold at the line level.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No