Mass Update of Dental Care Option Canada T4 program using API
Hi there - I just built a database procedure to import Dental Care Data (Reporting Year, Dental Care Option) from a flat file for Canada employees. No matter what value I pass to the parameter pei_information12 for the API call HR_PERSON_EXTRA_INFO_API.CREATE_PERSON_EXTRA_INFO, I get the following error - ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, 2023/01/01 00:00:00, N, SEGMENT, Reporting Year, N, VALUESET, PAY_CA_EOY_MAG_YEAR.
Alternatively, from the forms when I select the exact same values and save the entry, it works fine. I'm passing the exact same values that I see in the database after saving from the forms and in the same format to the API but it fails. I'm following coding guidelines for this particular import from Oracle DocID -