PAYROLL_USER_INTERFACE_CONFIGURATION Fast Formula Not Working As Expected (Doc ID 2558526.1)

Last updated on JULY 02, 2019

Applies to:

Goal

We have a requirement to prevent employees in certain countries from editing their personal payment method. We have created a Fast Formula (see attached) with type Payroll User Interface Configuration and followed the steps in Global Payroll Implementation 19B document (Chapter 12) by linking the formula to Prevent Edit Personal Payment Method Value in Manage User Defined Tables.

When logging in as an employee from Philippines (used LEGISLATIVE_GROUP_ID in formula to limit this to Philippines LDG, the Delete, Save and Cancel buttons are still available).


We used the sample formula below provided in the 18b implementation manual: https://docs.oracle.com/en/cloud/saas/applications-common/18b/oapff/formulas-for-payroll.html#OAPFF1903646

/**************************************************************************************
FORMULA NAME: Prevent Edit Personal Payment Method
FORMULA TYPE: Payroll User Interface Configuration
Expected Behavior : If value returned is N, no change in functionality
  If value returned is Y, Save/Submit buttons will be disabled in edit flow to prevent the edit of personal payment method.
  The Delete buttons will also be disabled for the personal payment methods

Sample Input File Format:
User Interface|Legislative Data Group|Effective Date|Payroll Relationship|Payment Type
***************************************************************************************/

/* inputs */

INPUTS ARE PAGE_NAME (text), LEGISLATIVE_DATA_GROUP_ID (text), PAYROLL_RELATIONSHIP_ID (text), EFFECTIVE_DATE(text), PERSONAL_PAYMENT_METHOD_NAME (text), ORGANIZATION_PAYMENT_METHOD_NAME (text), PAYMENT_TYPE_NAME (text), CURRENCY_CODE (text),PAYMENT_AMOUNT_TYPE (text),PERCENTAGE (text),AMOUNT (text),PRIORITY (text),BANK_NAME (text),BRANCH_NAME (text),BANK_ACCOUNT_NUMBER (text), BANK_ACCOUNT_TYPE (text)

/* Configuration */

IF ORGANIZATION_PAYMENT_METHOD_NAME='Check' THEN
(
OUTPUT_VALUE = 'Y'
)
ELSE
(
OUTPUT_VALUE = 'N'
)

RETU
 

Solution

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