Fusion Global Payroll (CA) : How to Convert Province ID to Province Code (AB, ON, QC etc.) in Fast Formula CA_GET_PROVINCE (Doc ID 2187532.1)

Last updated on OCTOBER 14, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Global Payroll - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

The fast formula CA_GET_PROVINCE returns the Province ID for Canada.

How to convert this province ID to Province Code such as (AB, ON, QC etc.) ?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms