Aug 1, 2011

Concurrent Report


Report Parmaeters Default type Value sets Report standards

1)How will you develop the Report?
  8 steps

2)What is Custom Top?

3)What is the diff between APPS Schema and PO Schema?

4) Can we create Table in Apps Schema?
   Yes But we are not suppose to create

5)What is concurrent Program?
   Executable  Parameters , Incompatible Programs

6)What is Request group?
   Collection of Concurent Programs and Reports

7)how to schedule concurrent Program?
  At SRS window by selecting Schedule button

8)What are the Standards we will follow for Oracle reports in Application?
          1)P_CONC_REQUEST_ID
          2)srw.user_exit('FND SRWINIT');
          3)srw.user_exit('FND SRWEXIT');

9)What is User Exit?
  Program which will transfer the control from Report builder to some other 3GL

10)Types of user Exists? 5

    FND SRWINIT            
    FND SRWEXIT
    FND FORMATCURRENCY
    FND FLEXSQL
    FND FLWXIDVAL

11)what is Token?
    Maping between Concurrent Program Parameter and Report Bind Variable

12)What is the Mandatory parameter in Reports?
    P_CONC_REQUEST_ID

13) Can we define parameter without Token?
     No

14)What are the Default types we have?
    SEGMENT CONSTANCE SQL Statement Profile

15)What is Range option?
    Will be used to maintain the Condition Between Two parameters like Low and High

16)What is value set?
    List of values with Validations

17)What are the different value sets we have?
   8

18)What is Table value set?
    Displaying the values from db Table column

19)Can we delete value set?
    Yes, we can delete IF Value set is not used by any concurrent Program in application

19)Can we delete Concurrent Program?
    No, we can disable by Unchecking Enabled Check Box

20)What are the things we need to add for responsibility?
    Menu , Request Group , Data Group

21)What is SRS Window?
    Will be used to submit Request and To schedule Requests.

22)How to get Request ID into the report Output?
    By using P_CONC_REQUEST_ID Bind Variable

23)Can we delete Concurrent Parameter?
    Yes, we can delete

24)Can we delete User name from the Application?
   NO, We can disable by giving End date

25)While creating Executable -->we will give the Application Name
     While creating Concurrent programe--> we will give the Application Name what is the diff between these two?

Ans)Executable Application is nothing but Where Exactly .rdf File is Located
      Concurrent Program Application Name is nothing but From which application we can submit Program
                                                           we can define in Multple Application if we required

26)Can we create Two concurrent Programs with same short name and application name in Apps?
    NO















No comments:

Post a Comment