Thursday, May 24, 2012

Add a new report to responsability


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