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.
Printable View
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.
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 [B]fnd_flex_val_api[/B]
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