Archive for December 2014

Top 50 Oracle Apps Technical Interview Questions

08:46 0 Comments A+ a-

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 the difference is between ceil and floor?

15. Can we use lookup in concurrent program?

16. How to register an XML report with and without RDF?

17. If I want to print a message on bottom most “No Data Found” if there is no data in the report then what we need to code in XML as well as RDF report?

18. What are the different ways to create an XML Report without RDF?

19. How many types of frames are there in Oracle report?

20. What is conditional trigger?

21. How to create concurrent program for RDF?

22. What are the various execution methods you have used?

23. Why we use tokens in oracle reports only?

24. How to submit a concurrent program from backend?

25. What is the difference between substr and instr?

26. How to use these functions in data template?

27. How to use select statement in data template?

28. How to call report trigger and parameters in data template?

29. How to join to queries in data template?

30. How to link the concurrent program to data template?

31. What is incompatibility explain with scenario.

32. Name the FND tables you have used?

33. If we are calling fnd_request.submit_request from backend but it is not showing in SRS window then what’s the reason for the same?

34. How to call a request in a trigger?

35. Have you done any customization in any workflow? Explain.

36. Tell me the type and steps to use Alerts?

37. How to perform DML in Alert?

38. Explain PA costing and billing cycle?

39. What are the tables used in Project Accounting?

40. How to map AR with PA tell me the setup required for this?

41. What is AME?

42. What are retcode and errbuf and its values? What is the use of retcode and errbuf in interface?

43. What are the interfaces you have worked?

44. If we want to complete our oracle report program with warning status what we need to do?

45. What is the flow to get any task in your current project?

46. What you have in Form personalization explain the different scenario?

47. What are the different triggers in Form personalization?

48. What are the report triggers?

49. What are the interfaces have designed?

50. Do you know about utl_file?





TOP 50 Oracle Apps Technical Interview Questions  




For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide

Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

08:25 0 Comments A+ a-

Script to insert on hand quantity  in to MTL_TRANSACTIONS_INTERFACE

To insert on hand quantity  in to 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_id,
                            DISTRIBUTION_ACCOUNT_ID,
                            TRANSACTION_TYPE_ID ,
   flow_schedule,
   scheduled_flag
                            )
                 VALUES(
                            MTL_MATERIAL_TRANSACTIONS_S.nextval ,--TRANSACTION_INTERFACE_ID,
                   'ORATECH_LEGACY',--SOURCE_CODE,
                            1,--SOURCE_LINE_ID,
                            1,--SOURCE_HEADER_ID,
                            1,--PROCESS_FLAG,
                            1, --VALIDATION_REQUIRED,
                            3,--TRANSACTION_MODE,
                            2,--LOCK_FLAG,
                            sysdate,--LAST_UPDATE_DATE,
                            1318,--LAST_UPDATED_BY,
                            sysdate,--CREATION_DATE,
                            1318,--CREATED_BY,
                            6068,--INVENTORY_ITEM_ID,
                            204,--ORGANIZATION_ID,
                            15,--TRANSACTION_QUANTITY ,
                       'EA',--TRANSACTION_UOM,
                            to_date('25-11-2007','DD-MM-YYYY'),--TRANSACTIOn_DATE
                            'AWC_MS',--SUBINVENTORY_CODE,
   2034,--locator_id,
                            13401,--DISTRIBUTION_ACCOUNT_ID,
                            42,--TRANSACTION_TYPE_ID ,
   'Y',--flow_schedule
   2--scheduled_flag)
)





Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide

How to release REC EXCEPTION [Receiving Exception] hold on invoices in r12

11:27 0 Comments A+ a-

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.comOr Subscribe your email-id on OracleAppsGuide

How can create a User in Oracle Apps R12 or How Can Assign a Responsibility to a User

12:25 0 Comments A+ a-

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 OracleAppsGuide

ERROR: Localization setup does not exist for this Location

10:20 0 Comments A+ a-

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
Subscribe to: Posts (Atom)