Results 1 to 2 of 2

Thread: Registering reports in oracle back end

  1. #1
    Junior Member
    Join Date
    Jun 2007
    Answers
    1

    Registering reports in oracle back end

    How to register the oracle report from backend?We should not go through the normal procedure like how we register report from front end in oracle apps,same prodecure should be done from backend.


  2. #2

    Re: Registering reports in oracle back end

    Hi Fazeena,

    U should prepare a sql script for Report Registration...
    STEP 1: Declare the variables for parameters, executable name, application name, description name, valuesetname,etc.....

    STEP 2: Validate the Application Name,
    Determine if Concurrent Program already exists.. If YES then drop it by
    FND_PROGRAM.DELETE_PROGRAM
    Determine if Concurrent Executable already exists.. If YES then drop it by
    FND_PROGRAM.DELETE_EXECUTABLE
    Drop the Parameter if they exists..
    FND_PROGRAM.DELETE_PARAMETER

    STEP 3: Create the Value sets by API fnd_flex_val_api

    STEP 4: Create concurrent program executable
    FND_PROGRAM.EXECUTABLE

    STEP 5: Create concurrent program
    FND_PROGRAM.REGISTER

    STEP 6: Add the Parameters (If present else skip this)
    FND_PROGRAM.PARAMETER

    STEP 7: Add the Conc, Program to the Group

    U try this and tell me if there are any difficulties at siddharth DOT shah AT atosorigin DOT com

    Cheers,
    Siddharth


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact