CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
ONT Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM ORACLE INTERVIEW QUESTIONS ONT INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

ONT Interview Questions & Answers - Learning Mode

Oracle Technology Network provides services and resources to help developers, DBAs, and architects build, deploy, manage, and optimize applications. It is the world's largest community of developers, admins, and architects using industry-standard technologies in combination with Oracle products.

Try ONT Interview Questions & Answers - Exam Mode

1

Sort By : Latest First | Oldest First | By Rating

ONT Interview Questions & Answers - Learning Mode
Try ONT Interview Questions & Answers - Exam Mode
Question: Can anyone Explain Order Management Flow in detail






Answer: 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 Source: CoolInterview.com
Question: What is the difference between a Purchase Order (PO) and Sales Order?

Answer: Sales order is which customer want or list of item's that customer want. It can be billable or non-billable

Purchase order is order used for fufilled requisitions. i.e Get item's from supplier. Source: CoolInterview.com
Question: I would like to know the shipping process along with some screen shots?

Answer: Shipping date / ship confirm date is stored in the table oe_order_lines_all.actual_ship_date Once the material is shipped and after running the interface trip stop SRS the above field get updated with the ship confirm date. Source: CoolInterview.com
Question: What are the APIs used in Order Management?

Answer: 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 delive Source: CoolInterview.com
Question: Explain the setup involved in Drop Shipment Process?

Answer: 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& Source: CoolInterview.com
Question: Can any one tell me what is ONT stands for, as OE stands for Order Entry?

Answer: ONT is the application short name for Order Management. Source: CoolInterview.com
Question: What is ORDER_TO_CASH cycle?

Answer: We perform the following steps in O2C cycle
Enter and Book Sales Order
Schedule the Order
Pick Release the Order
Ship confirm the Order
Auto Invoice to the Receivables for the customer invoicing
Receipts
Bank Reconciliation Source: CoolInterview.com
Question: Can any body please tell me what is PTO and ATO? Their functionality . How can we differentiate between them.



Answer: PTO and ATO or Different Ordering Environments,

PTO is Pick To Order: where it is assumed that

availability of stock is plenty , just pick and relese and ship for an order.

ATO is Assemble to Order : it is assuemed that,

availble of option class, all included/standard items/ and depending up on the Order the Assemblies are carried and shipped.

where it is expected that an order is booked for a predefined model item,

Source: CoolInterview.com
Question: What are the interface programs done in Order Management?

Answer: The following interface programs are involved in Order Management process..

1. Interface Trip Stop.
2. Inventory Interface
3. Order Management Interface
4. Workflow Background Engine. Source: CoolInterview.com
Question: What should be done when sales order lines are closed but header is still in Booked status?

Answer: Verify the Sales order header workflow. It should be waiting at sales order line close.
now navigate to Sysadmin>>workflow>>administer workflow>>status monitor
on the new webpage enter the item type as OEOH and item key as the header workflow ID and find.
Now click activity history and select the wait function and retry>>submit>>Okay

Now again go to the sales order header and verify the header status it should be complete.

In case the order is Source: CoolInterview.com
Question: 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.


Answer: oe_order_headers_all oe_order_lines_all oe_order_holds_all oe_transaction_types_tl cs_customer_product_statuses cs_customer_products_all wsh_delevery_details

For Deemed Products:-

MTL_UNIT_TRANSACTIONS MTL_MATERIAL_TRANSACTIONS Source: CoolInterview.com
Question: How is conversion of holds done using API? What are the tables affected?what are the fields to be passed & to which base tables?

Answer: 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. Source: CoolInterview.com

1



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.016113 Seconds