Saturday, 5 August 2017

How to check online FND_USERS - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/08/how-to-check-online-fndusers-in-oracle.html

How to check online FND_USERS

SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != ‘Y’
AND icx.pseudo_flag = ‘N’
AND ( last_connect
+ DECODE (fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’),
NULL, limit_time,
0, limit_time,
fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’) / 60
)
/ 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id

Wednesday, 19 July 2017

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-make-your-user-and-sysadmin-to.html

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests

Suggested you enable those standard grants for fnd_concurrent_requests and create a new role and then assign to your USER and SYSADMIN. Please check below steps for details.


Using the Functional Developer Responsibility, type Code as "FND_CONCURRENT_REQUESTS"

1. End_dating the following grants

DEFAULT_ACCESS_VIEWREQ
ECO Implementation Concurrent Request Grant
XDO Concurrent Request Security
IPM System Administration Concurrent Requests Grant

2. Create a new roles and assign to your USER and SYSADMIN

1. As SYSADMIN user with “Functional Developer” responsibility, update object "Concurrent Requests".

Search for object Concurrent Requests.
Click on Concurrent Requests.
Click on Object Instance Sets tab.
Click on Create Instance Set button.
Enter Name, Code and Description for new instance set.
- Enter the following for predicate:
1=1


2.As the SYSADMIN user with “User Management”, go to Roles and Role Inheritance tab.

Click Create Role button
Input value for the following column
Application,Role Code.Display Name,Description
Click Apply button

then query the role you created just now,,click update icon.
click Create Grant button,Input value for the following column
Name,Description

For the Data Security Object enter “Concurrent Requests”.
Click Next and provide the Data Content Type of “Instance Set”.
for Instance Set choose instance set created in step #1
Click Next
The permission Set is “Request Operations”.
Click next and finish button

3. As the SYSADMIN user with “User Management”, go to Users

Under Search region,query user name your USER
click update icon,click Assign Roles button
Query the role which you created in step 2
click apply

Same steps for user SYSADMIN

4.Wait some mins (10-15mins) to make workflow Angent listener to proceed it
then retest your issue.

Monday, 10 July 2017

How to stop users to see specific Requests of any other user - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-stop-users-to-see-specific.html

How to stop users to see specific Requests of any other user

Navigation: View>Requests>Find>Find Requests>Specific Requests> (Now here I can see any user Request. How can I stop User to access this)

--------------------------------------------------------------------------------------------------------

1- Login as sysadmin ->functional developer.
2- Search for object Concurrent Requests.
3- Click on Concurrent Requests (link in the left cell)
4- Select the grants tab, click update.
5- Select the grants tab (again)
6- Update the "valid to " with the same date of the "valid from" for all records.
7- Click apply and retest the issue.

--------------------------------------------------------------------------------------------------------

For My Case:

1. Login as functional administrator.
2. Search for object Concurrent Requests.
3. For both XDO Concurrent Request Security click on Update and in Grantee Type select Specific User and select one user you want to allow to see all Users Requests (for my case it was Administrator User). one should be given access to view all requests of Users.

Sunday, 21 May 2017

How to Disable Close Other Forms Function from any Responsibility - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2017/05/how-to-disable-close-other-forms.html

How to Disable Close Other Forms Function from any Responsibility

Navigate to Menu of the Responsibility and add in Function "Navigator: Disable Multiform".

If Menu is Shared to Multiple Users then add in Menu Exclusions of that Responsibility to Enable it for that Particular Responsibility

Tuesday, 31 January 2017

How to insert image in RTF Template - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2017/01/how-to-insert-image-in-rtf-template.html

How to insert image in RTF Template

Image Must be in .gif Format

Make a table of single row and Column and insert image in it through insert>Pictures in RTF Template.