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 and later
Information in this document applies to any platform.


On : 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


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

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