Monday, January 29, 2024

Error INVALID_ETYPE_SYSLINK PRC: Transaction Import Errors

 Error INVALID_ETYPE_SYSLINK is due to Expenditure Type or Expenditure Class not matching

you need to ensure Expenditure Type is associated to the right expenditure type class


1. Check Expenditure Type setup with Expenditure Type Class

2. Verify in Transaction Import table

select EXPENDITURE_TYPE_ID , EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, START_DATE_ACTIVE, END_DATE_ACTIVE
from PA_EXPENDITURE_TYPES
where EXPENDITURE_TYPE = :EXPENDITURE_TYPE

3. Verify the system linkage between Expenditure Type and Expenditure Class linkage

select SYSTEM_LINKAGE_FUNCTION, EXPENDITURE_TYPE , START_DATE_ACTIVE, END_DATE_ACTIVE
from PA_EXPEND_TYP_SYS_LINKS
where expenditure_type = From above step
and system_linkage_function = from transaction interface

4. Make sure setups and data in the Interface table should match, if not will receive error 
5. update the interface table with correct set of data either exp type or class
6. Import the data

Thursday, January 25, 2024

Oracle Cloud Project Portfolio Management Overview

 



Oracle Project Management offers a single project cloud solution, designed to help you gain a complete picture of your organization's project finances and operations - seamlessly integrated across the enterprise with the Oracle Fusion Cloud ERP, HCM and SCM applications. The solution supports a diverse array of projects including service-centric, product innovation and lifecycle management focused, project supply chain driven, and award funded initiatives. The result is a fully streamlined and automated solution, designed to improve the way project-centric organizations work, from the project executive and business stakeholder to the program manager, project manager, resource manager and project team member. Program managers and executives can manage the collective efforts of diverse business functions through programs to deliver strategic business transformation; or increase profitability for customer engagements by centralizing analysis while still managing specific deliverables at project level.





Oracle Fusion Project Costing

Oracle Project Costing provides a completely integrated cost management solution for all projects and activities across your enterprise, with the ability to cross currency and organizational boundaries

Oracle Project costing is linked with AP, PO,INV and OTL to accumulate the total cost incurred on the Project.




Other topics in detail will be posted in other notes for the below topics

Billing

Project Management ( Task, Financial, Resource)

Project Cost Processing

Performance Reporting