Responsability:Application Devevoper.
Function:(Concurrent|Executable).
Fill this fields:
-Choose Oracle Report in Execution Method. In otherwise you can choose procedure.
-Executable:Name of report
-Application is the name of oracle module, i.e, Order Management, Inventory,etc.
- Execution file name is filled with .rdf file name.
Next step is define output style of report:
Responsability:Application Devevoper.
Function:(Concurrent|Program).
Program: User name.
General Name: the same that executable name(filled before)
Application:
Executable Name:the same that executable name(filled before)
Format: text,pdf
Style:A4,A3.
Now, we are ready for define Parameters pressing Parameter button:
Sql Examples for dates:
- P_ANYO:select to_char(sysdate,'RRRR') FROM DUAL
- P_MES:elect to_char(sysdate,'MON') FROM DUAL
So at this moment new report is accesible. Finally we need assign the report to user or responsability.
Responsability:System Administrator.
Function:(Security|Responsability|define).
Copy name of Request Group: OM Concurrent Program and go to (Security|Responsability|request) then find with request name copy and add new line below with the program user name.
No comments:
Post a Comment