My Oracle Support Banner

Fusion Global Human Resources : Need To Print Position Id And Organization Id (Doc ID 2851167.1)

Last updated on APRIL 02, 2022

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.21.10.0 version, Global Human Resources

need to print position id and organization id

How to fetch Position id, Organization id, job id, grade id in one of the oracle function in the seeded report.

select per_bipntf_flex.GETATTRIBUTE('AssignmentMDVORow',VALUE(RowType),'PositionId','OldValue') as "CurrentPosition",
   per_bipntf_flex.GETATTRIBUTE('AssignmentMDVORow',VALUE(RowType),'PositionId','NewValue') as "ProposedPosition"
from TABLE (per_bipntf_utility.extractXMLSequenceForVO(:transId,'AssignmentMDVO')) RowType
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.