testoag

Oracle Apps Technical Interview Questions  1. What is the difference between Function and Procedure? 2. What are the various restrictions in functions to use in SQL statement? 3. Can we use out parameter in function if we do this then what is the drawback? 4. Select * from 1+null+9 from dual; What is the output? 5. Select count (*) from tab1; and there is no data in tab1 then what will be the output? 6. How to return values in procedure? 7. Create or replace function f1 as N number; Begin Return1; Reture2; Return3; End; what will be the output? 8. If there are two columns in a table t1 [a char(10), b varchar2(10)] And we want to fetch all those records in which in which a=b the write the SQL query? 9. Syntax of collections and cursor? 10. I want to fetch the last name from ‘Oracle_Apps_Guide’. Write the query? 11. How to count commas (,) in the string (a, b, c, d). Write the query? 12. How to replace ‘a’ to null in ‘Anand’? 13. What is the difference between trunk and round? 14. What t

Script to insert on hand  quantity   into MTL_TRANSACTIONS_INTERFACE To insert on hand  quantity    into  MTL_TRANSACTIONS_INTERFACE INSERT INTO MTL_TRANSACTIONS_INTERFACE                             (     TRANSACTION_INTERFACE_ID,                    SOURCE_CODE,                             SOURCE_LINE_ID,                             SOURCE_HEADER_ID,                             PROCESS_FLAG,                             VALIDATION_REQUIRED,                             TRANSACTION_MODE,                             LOCK_FLAG,                             LAST_UPDATE_DATE,                             LAST_UPDATED_BY,                             CREATION_DATE,                             CREATED_BY,                             INVENTORY_ITEM_ID,                             ORGANIZATION_ID,                             TRANSACTION_QUANTITY ,                        TRANSACTION_UOM,                             TRANSACTION_DATE,                             SUBINVENTORY_CODE,    locator_i

How to release REC EXCEPTION [Receiving Exception] hold on invoices in R12 Follow given steps to implement the solution in your instance follow the below steps: 1-: Go to Purchasing Application 2-: Receipts and query the Receipt [which is created against the PO] 3-: Now Check Receiving Exception check box is unchecked. [It should be unchecked] Note -: if Receiving Exception check box is not available then do the Show Field and choose Receiving Exception then check. 4-: Now revalidate the invoice to release the hold. Solution For -: How to release REC EXCEPTION [Receiving Exception] hold on invoices Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1] For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

How can create a User in Oracle Apps R12  or  How Can Assign a Responsibility to a User  1) Go to " System Administrator" > Security  > User > Define  2) Username -: As per User Number      Password - : Fill the password and press Enter then type again same password .     Responsibility-: Select Responsibility from LOV whatever you want to Assign to user .   Note-: If you will Assign System Administrator Responsibility to the User then a Indirect Responsibility Application Diagnostic  will assign automatically to user . 3) Now Save the form . Now your User Created . 4) Go to User Login form of Oracle Apps ERP 5) Login with your User Credential. 6) Change Your Current Password  Note -: It will ask to change the password at the time of first login . Save the New Password  Select Responsibility    Click on Any form and check   Now Your User are ready to do our Responsibility .  For More Information Visit on www.OracleAppsGuide.com  Or Subscribe your email-id on O

ERROR: Localization setup does not exist for this Location The following error occurs. India Localization "SUBINVENTORY" setup is defined only with organization and location is null. When attempting to run India Receiving Transaction processor, Please follow the following steps:- 1. Go into the responsibility: India Local Inventory. 2. Navigate to India Local Inventory-->Setup -->Sub inventories. 3. Create Setup with organization and location combination. 4. Now check the issue. 5. Migrate the solution as appropriate to other environments. For More Information Visit on www.OracleAppsGuide.com  Or Subscribe your email-id on OracleAppsGuide