Total Pageviews

June 14, 2015

6/14/2015 09:16:00 PM
1. How can you retrieve system date from database? Which API having the same functionality in Oracle Apps?
2. Can you invoke web browser through any API’s? If so  Which API can do this?
3. What is the use of FND_UTILITIES.PARAM_EXISTS API?
4. FND_FILE support maximum buffer line size _____KB.
5. Shall we use FND_FILE.PUT_NAME & FND_FILE.CLOSE in concurrent programs? If not Why ?
6. What is the difference between FND_FILE.PUT & FND_FILE.PUT_LINE?
7. What are the two types of files we can deliver with the help of FND_FILE Package?
8. How can you see the status of the concurrent program through backend?
9. What is the use of FND_CONCURRENT.WAIT_FOR_REQUEST API?
10. What is the usage of FND_PROGRAM package?
11. What is the usage of FND_CURRENCY Package?
12. Is it possible to Delete Executable through FND_PROGRAM API’s?
13. What is the usage of FND_PROGRAM.ENABLE_PROGRAM API?
14. Can you submit the request from Backend triggers? Which API helps to do that?
15. How can you submit a request from Backend?
16. Why we have to register the tables & columns in AOL?
17. How can you register a table in AOL?
18. How can you launch a workflow through backend?
19. What are the two default parameters you have to give when you create stored procedures & functions as a concurrent program?


Answers:

1) SELECT sysdate FROM DUAL used to find the system date in Oracle Database. FND_STANDARD.SYSTEM_DATE API having the similar functionality.

2) Yes, you can invoke web browser through API. FND_UTILITIES.OPER_URL API can do this.

3) FND_UTILITIES.PARAM_EXISTS API is used to check the given parameter is Exist in the Open Oracle Form or not . If exists it will return True other wise it will return False.

4) FND_FILE support maximum buffer line size    32    KB.

5) We should not use FND_FILE.PUT_NAME & FND_FILE.CLOSE in concurrent programs. Because these two operations are automatically done by Oracle Apps we should not override this default operations.

6)
FND_FILE.PUT API is used to write text to a file (without a new line character). Multiple calls to FND_FILE.PUT will produce concatenated text.
FND_FILE.PUT_LINE API is used to write a line of text to a file (followed by a new line character).


7) FND_FILE.OUT – Oracle Apps Output  File.
       FND_FILE.LOG – Oracle Apps Log File.

8) With the help of FND_CONCURRENT.GET_REQUEST_STATUS API we can see the status of the concurrent program through backend.

9) FND_CONCURRENT.WAIT_FOR_REQUEST API is used to implement the parent-child concurrent programs. Waits for request completion, then returns the request phase/status and completion message to the caller. Goes to sleep between checks for request completion.

10) FND_PROGRAM package Usage:

The FND_PROGRAM package includes procedures for creating concurrent program executables, concurrent programs with parameters and incompatibility rules, request sets, and request groups.
The FND_PROGRAM package also contains functions you can use to check for the existence of concurrent programs, executables, parameters, and incompatibility rules.

11) FND_CURRENCY Package Usage :

This package is used to format the currency . We can use it in Client side as well as Server Side .

12) Yes , It is Possible to delete executable through FND_PROGRAM.DELETE_EXECUTABLE if it is not attached to the Concurrent program Otherwise not possible to delete.

13) FND_PROGRAM.ENABLE_PROGRAM API Usage:

      Use this procedure to enable or disable a concurrent program.
Syntax is:

Procedure FND_PROGRAM.ENABLE_PROGRAM
(Short name IN VARCHAR2,
Application IN VARCHAR2,
ENABLED IN VARCHAR2)
14) Yes, You can summit the request with in the backend triggers. Before submitting the request you have to use the FND_REQUEST.SET_MODE API to set the mode. With out using FND_REQUEST.SET_MODE we can’t submit the request from Database Triggers.

15) With the help of FND_REQUEST.SUBMIT_REQUEST API we can submit the request in Backend.

16) You have to register the table & columns in AOL before you create new flex field or alert on a table. Otherwise not possible to create flex field or alert on it .

17) With the help of AD_DD.REGISTER_TABLE API we can register the table in Application Object Library.

18) With the help of WF_ENGINE.STARTPROCESS we can launch the workflow from backend .

19) errbuf  - VARCHAR2

retcode – NUMBER  - 0 for success
                                     1 for success with warning
                                     2 for error