Thursday, March 26, 2020

How to run a user login report in P6.

https://docs.oracle.com/cd/F25599_01/English/Admin/p6_eppm_reporting/helpmain.htm?toc.htm?98014.htm


Description

Provides a list of users logged into P6 EPPM within the period specified in the Time interval to store user login information setting in Application Settings. Shows the user ID, user name, login date and time, logout date and time, the total time the user was logged in, the application the user logged into, and the server for that application.

Location
Click Reports.
On the Report page:
Click the Reports tab.
Expand the P6Reports folder.
Expand the Administrative folder.
Click User Login Report.

Thursday, March 12, 2020

Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired".

Applies to: Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 and later. Information in this document applies to any platform.

Symptoms: When attempting to log into P6 Professional, the following error occurs.

Error: Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired".

Cause: A bug in the GET_SAFETY_DATE PACKAGE causes error
"Exception Exception in module PM.EXE at 000000000118614B. GET_SAFETY_DATE -54: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" to occur.

Solution

This issue has been resolved, and the fix has been included as part of the following patch sets:
  • Primavera P6 Project and Portfolio Management (EPPM and PPM) release 19.12.2
  • Primavera P6 Project and Portfolio Management (EPPM and PPM) release 20.3 (Cloud-hosted customers)
To review and download the latest patchset, please refer to the following document:
To implement the solution, please execute the following steps:
  1. Download and review the README documentation and pre-requisites for the Patch Set.
  2. Ensure that you have taken a backup of your system before applying the recommended Patch Set.
  3. Apply the Patch Set in a test environment.
  4. Re-test the issue.
  5. Implement the solution as appropriate in other environments.
Cloud-hosted Customers
  1. Enter an SR for the appropriate Solution and reference this KM as a solution to the issue.
  2. Work with Support to apply the workaround (or patch when available).
  3. Approve closure of SR when the fix has been applied and verified.
Workaround available:
This workaround is appropriate for other releases of P6 or when it is not yet possible to apply the patchset.
  1. Download script (adjusted2.sql) from this article.
  2. Run adjusted.sql script as the "admuser" (Oracle database) to re-create the package..
Oracle database:
  • Use SQLPLUS or SQLDeveloper
  • Connect as the admuser.
  • Run the adjusted2.sql script.

Working offline in P6

https://docs.oracle.com/cd/F25600_01/client_help/en_US/helpmain.htm?toc.htm?99219.htm



Monday, March 9, 2020

Administration Identity Management Administration Guide Version 20


All users are added by the Administrator via the Global Admin app. All users are assigned a global permission set when added. The default permission set is View Only, but you can create a permission set to assign as the default later.

Columns with a red star are required to be filled. You can’t save the record until all required fields have been completed. Make sure to click the other tabs at the top.

Only Users who are associated with the Primary Company can become Application Admin.
Application admin have full access to see License Usage, User Usage, Consent Notice, Integrations, Configure Labels, View User Profiles and Global Permission Sets.



Adding companies (teams/contractor companies) in Oracle Primavera Cloud


To create a new user, first add the Company name if not added already and enter the new Company information.  Once the Company is added, select the Company name in which you want to add the user to. You can download an import template to import from excel.
Columns with a red star are required to be filled. You can’t save the record until all required fields have been completed. Make sure to click the other tabs at the top.