Oracle Projects Security

In this article we will be looking at various levels of security in Oracle Projects module. In Oracle Projects, we can restrict the access to certain functions of a project based on Project Role an employee plays in that project. This is additional level of control imposed on top of the standard responsibility level security. […]

Read More

Oracle Projects Migration/ Data Conversion

In this article I will be explaining the general steps involved in any Conversion/Data Migration of Oracle Projects module. At the end of this article, you would have learned: Stages in Oracle Projects Conversion. How to setup the Oracle Projects module for the conversion/Data Migration. Options for the Load (flat file, csv, or direct Loads). […]

Read More

Import legacy Timesheets to Oracle

This article gives you a brief understanding and sample code snippet of how to import legacy timesheets into oracle projects. Steps: 1. Populate the transaction interface table pa_transaction_interface_all. 2. Run the PRC: Transaction Import process for the Transaction Source/ batch name. 3. Run the Distribute Labor Costs process if the transactions are not costed. Populating […]

Read More

Cost Collector Troubleshooting

In case the transactions are not interfaced from Project Inventory to Oracle Projects. You need to make sure the following setups. 1. Check the Project references box.When you check this box, the organization is Project References enabled. Project number and, optionally, task numbers can be associated with the transactions. 2. Select a Common Project. Selecting […]

Read More