Oracle Application Interview Qs?

How to disable prompting the password for diagnostics/examine/personalization for forms

To disable prompting the apps password for diagnostics and examine/personalizations at form level Set the value as Yes to the profile option "Utilities: Diagnostics" at any level

 

What is the difference between Supplier and Vendor...

Supplier -> Can provide the material as per indent.
Vendor -> Can produce & supply the material to the customer.

Supplier - Supplier are those which provide  some material to the company but they have not any contract to the company
Vendor - They also provide the material to the company but they have contract to the company

Your responsibilities will include:
* Buy a product, sell it to your customer and you still responsible for its maintenance

Suppose you are a supplier: Your responsibilities will include:

* You buy products, keep them. You can sell it. You are no more responsible for its future
maintenance.

What is the difference between Supplier and Vendor?

vendor - An organization that sells something. In this publication, vendor refers to both manufacturers and distributors as long as they sell products to the general public.
supplier - someone whose business is to supply a particular service or commodity

RE: What is the difference between Supplier and Vendor?

When a company needs a product, it places an offer to vendor(s). The vendor(s) on the other hand will place bits (amounts based on quality), this is evaluated by the company and a final vendor selected. At this stage the vendor is considered a prospective supplier yet no contract exist (acceptance is still pending)
A supplier is a vendor who's bit has been accepted hence an offer and an acceptance exist between the two parties as well as other components of a contract are established e.g terms and conditions, a consideration etc.

What is the use of cursors in PL/SQL ? What is REF...

If you have not used REF cursor, then when you need to open cursors multiple time, it will throw an error. Because in a procedure there is a limitation availe for maximum number of cursors to be open at any point of time.

Cursor is used to process multiple rows in PL/SQL.
Ref cursor is dynamic cursor and reusable. Ref cursor allows global declaration of a cursor.

Re: What is the use of cursors in PL/SQL ? What is REF Cursor ?

Generally we use cursor to get multiple Result. and Specify a particular name of storage area . by cursor we know that active set. where is position of cursor.

What is segment qualifier?

Segment qualifiers hold extra information about individual segments such as if the account is an Asset, Liability or Expense, if you can post to the account and more.

When we define a segment value in the Segment Values window, we must also assign qualifiers which determine the account type (asset, liability, or expense), whether budgeting is allowed, whether posting is allowed and other information specific to the segment value.

Allow Budgeting, Allow Posting, Account Type, Control Account, Reconciliation Flag. 

What is segment qualifier?

-          segment qualifier are used to identify a particular segement within key flexfield

Qualifier means that behavior segment qualifier means that it tells us abt behaviour of a segment qualifiers are for company ---   Balancing segmentDepartment   --- cost centers segment
Accounts ---- Natural Account segment

accounting qulifiers are Allow Budgetting
Allow posting
Account type
Control Account
Reconsilliation flag

 

What is the difference between data conversion and data migration  

Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA), validating it and converting it to ur our the target module using the standard import program.

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 the dropship subinventory>> Verify the SO lines should be shipped by now>>> Run workflow and Autoinvoice.

It is process where in customer location is the ship-to-location. Suppliers directly unload the material in customer's customer location.

Drop Shipment is a process where the customer places a purchase order on a company and this company instructs its supplier to directly ship the items to the customer.

Drop Shipment – Process Steps

Create a Sales Order with line where the line source is External
Book and Schedule the Sales Order
Run Requisition Import Process
Now the line status will be in Awaiting Receipt
Login to the Receiving Organization (Purchasing) who has been setup as an Approver
Run Requisition Import
Create Purchase Order from the Requisition
Approve the PO
Receive the full quantity
Run Auto Invoice
Verify Invoice in Sales Order

Oracle Order Management uses purchase orders to outside suppliers that are automatically generated from sales orders for goods supplied directly from the supplier. The “external ” supplier ships the goods directly to the 3rd Party customer and confirms the shipment through the use of an Advanced Shipment Notice (ASN).