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.



Wednesday, May 2, 2012

User cannot shipping


When a registered user cannot shipping is because he hasn't an adecuate permission or ROL.
For add permission  to user , use Commercial responsability,then  go Roles and permissions definitions | Permissions
In Shippping execution permisions form you can add or modify row with  username and appropiates permissions.
See screen below for more details:



User cannot retrieve OPM inventory information

When a registered user cannot view OPM inventoty is because he doesn't OPM organization permission. 
For changing it , use OPM System Administrador responsability and  go Setup System | User Organization.
You have to give organization permission for each user as you see below: