Oracle SQL :Interview questions

1) Which of the following is a valid reason for deciding to create a subprogram as a function rather than as a procedure?  A. It must ...

Oracle APPS Technical ::How Org Context works

Oracle has introduced session specific global temporary table MO_GLOB_ORG_ACCESS_TMP to hold operating units available for user session/res...

Oracle EBS : Inventory/Purchasing Periods

Receiving is controlled by Inventory/Purchasing periods ? Yes : Purchasing and inventory will need to be open. The related GL period will...

Oracle EBS :BI publisher reports :Hiding a row

How to hide complete row having zero values?    Different amount fields in the  rtf template.If  all amount fields has zeros in a single ...

Oracle APPS : How to Face Interviews?

                                                     Oracle APPS : Interview Preparation Normally when we are giving interviews ,we hav...

Oracle EBS : FND_STANDARD.SET_WHO is not working

Q) Unable to see record history? What is the reason? Resolution: Though we set fnd_standard.set_who  in  PRE-INSERT,PRE-UPDATE una...

Oracle eBusiness Suite: Payables R12 upgrade

            Oracle eBusiness Suite: Payables R12 upgrade Suppliers New R12 tables  -> Old 11i Tables AP_SUPPLIERS - replaces PO_...

Oracle SQL : Latest Interview Questions

Oracle SQL Interview Questions 1. How will you a activate/deactivate integrity constraints ?   The  integrity constraints can be e...

Oracle SQL : Interview Questions New Series

Oracle SQL Interview Questions   1. What are the types of SQL Statement ?   Data  Definition  Language  :  CREATE,ALTER,DROP,TRUNC...

Oracle eBusiness Suite : Inventory Interfaces

Oracle eBusiness Suite : Inventory Interfaces Interface Name Data Flow Direction Details / Concurrent Program ...

Oracle :SQL*Loader Issues

Oracle Applications :SQL Loader How to resolve SQL Loader skipping records and it says the column is too long? P lease specify ...

Oracle Applications : Query Find window

Oracle Apps Forms Query Find window 1.create a table in particular module. 2.grant the table to apps. 3.create synonym for the table....