To debug value sets, create a BI report with the following query as a data model to return the required data: SELECT pay_ff_functions.gvs ('SAMPLE_GET_ASG_NUM','|=PERSON_ID=100000012092216') value FROM dual
Tuesday 25 February 2020
Context PAYROLL_ASSIGNMENT_ID wasn't set when used at line ABC of formula XYZ_PRESTAT_DEDN_CALCULATOR.
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Context PAYROLL_ASSIGNMENT_ID wasn't set when used at line ABC of formula XYZ_PRESTAT_DEDN_CALCULATOR.)
I faced this error when using DBI ASG_HR_ASG_ID in the fast formula (in this particular case, a oracle payroll formula was written on pre stat deduction element).
The above error is got during payroll execution. This error is got because the element, on which this formula is tagged to, is defined at payroll relationship level and not at assignment level.
This DBI is using the context payroll_assignment_id but this context is not available at the payroll relationship level (the element is setup to be processed at payroll relationship level). So this cannot be used in a fast formula of an element which is defined at payroll relationship level.
Refer Doc ID 2542604.1 for more information.
I faced this error when using DBI ASG_HR_ASG_ID in the fast formula (in this particular case, a oracle payroll formula was written on pre stat deduction element).
The above error is got during payroll execution. This error is got because the element, on which this formula is tagged to, is defined at payroll relationship level and not at assignment level.
This DBI is using the context payroll_assignment_id but this context is not available at the payroll relationship level (the element is setup to be processed at payroll relationship level). So this cannot be used in a fast formula of an element which is defined at payroll relationship level.
Refer Doc ID 2542604.1 for more information.
Friday 21 February 2020
Null value check in Fast formula in cloud
if isnull(VALUE_SET_VALUE) = 'N' then
(
VALUE_SET_VALUE = 0
)
However, it does the exact opposite of what its name suggests: it returns 'Y' if the value is not null, and it returns 'N' if the value is null.
However, it does the exact opposite of what its name suggests: it returns 'Y' if the value is not null, and it returns 'N' if the value is null.
Manage Payroll Process Configuration task navigation
With the 19A release the "Manage Payroll Process Configuration task has moved to a different location:
1. Start on the landing page and click on the “You have a new home page!”
2. Click on “My Client Groups”
3. On the left, click on “Show More”
4. Scroll down to the section titled ‘Payroll’ and you will see “Manage Payroll Process Configuration”
a. Refer to the below knowledge document for step by step instructions.
b. https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=467288969587748&id=2503131.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=6ba0z82ik_114#FIX
5. By design only user's account with person ID attached is able to access Payroll Process Configuration Task.
1. Start on the landing page and click on the “You have a new home page!”
2. Click on “My Client Groups”
3. On the left, click on “Show More”
4. Scroll down to the section titled ‘Payroll’ and you will see “Manage Payroll Process Configuration”
a. Refer to the below knowledge document for step by step instructions.
b. https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=467288969587748&id=2503131.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=6ba0z82ik_114#FIX
5. By design only user's account with person ID attached is able to access Payroll Process Configuration Task.
Subscribe to:
Posts (Atom)