Archive for 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

Functional Security In ORACLE APPS

10:44 0 Comments A+ a-

Functional Security In ORACLE APPS









































User
End user, using the application front end interface.
Responsibility
Privileges to the user.
Menu
Hierarchal arrangement of Sub Menus and Functions.
Sub Menu
Hierarchal arrangement of functions.
Functions
A Function calls a form.
Form
A Form is a GUI (Graphical User Interface).


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

Lookup Customization Levels ,Lookup Type and difference between "LOOKUP"

10:02 0 Comments A+ a-

Lookup Customization Levels ,Lookup Type and difference between "LOOKUP"
Or
What is "LOOKUP"


User

Ø  Insertion of new codes is allowed
Ø  Updating of start date, end date, and enabled fields is allowed
Ø  Deletion of codes is allowed
Ø  Updating of tag is allowed

Extensible

Ø  Deletion of lookup type is not allowed
Ø  Insertion of new codes is allowed
Ø  Updating of start date, end date, enabled fields, and tag is allowed only if the code is not 'seed data'
Ø  Deletion of codes is allowed only if the code is not 'seed data'
Ø  Updating of module is not allowed

System

Ø  Deletion of lookup type is not allowed
Ø  Insertion of new codes is not allowed
Ø  Updating of start date, end date, and enabled fields is not allowed
Ø  Deletion of codes is not allowed
Ø  Updating of tag is not allowed
Ø  Updating of module is not allowed




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

    APP-PO-14624: Source organization is missing or invalid

    09:47 0 Comments A+ a-

    APP-PO-14624: Source organization is missing or invalid.






    At the time of creating an internal requisition with Source name Inventory and entering the Organization name that time this error occurs.

    Firstly check whether used Item should be ‘Transactable’, ‘Stockable’ & ‘Internal order enabled’ at both level Source and destination Organizations.

    Go to
    Inventory > Items > Master Items > Find the Item.

    Now go to Inventory tab and check attribute ‘Stockable’ and ‘Transactable’ are checked or not (It should be).And In Order Management tab, check ‘Internal Orders enabled’ attribute is available.


    Careful –: If Item attribute ‘Internal ordered’ is enabled then we cannot enable “Internal Orders enabled” attribute. Unless all the above three attributes are enabled we cannot Proceed with the Internal Requisition.

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

    How can Create Document Sequence in r12 for Order Management Transaction Type like "Mixed"

    00:20 0 Comments A+ a-

    Document Sequence

    Go to 

    Order management Responsibility < Orders, Returns < Sales Order 





    Make a sales Order for Check the Sales Order Number for Mixedtransaction type.










    Now Sales Order Number Series are 1000. And we want to start sales order number with 1.




    Now Go to

    Setup < Documents < Define

    Define sequence with the name “Doc_Seq_Mixed” And create a sequence with initial value ‘1’.

    Note -: You can manage it accordingly and if you want to make it manual then select TYPE Manual.














    Now Save it.




    Go to

    Setup < Documents < Assign







    Select Categories Mixedfor Transaction Type “MIXED”.







    Select Ledger name “Vision Operation (USA)”.







    Now Go to Assignment tab .







    Assigned Define sequence “Doc_Seq_Mixed”.








    Note -: If there are any existing Sequence for the particular time period then firstly fill end date for that sequence.

    Now Again Create the Sales Order and check the Series number for transaction type “MIXED”.














    Thus we can change the sequence number for any transaction type in order management and another application also.

    Now enjoy your Successful development.


    For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide
    Subscribe to: Posts (Atom)