Compensation and Benefits - EBS (MOSC)

MOSC Banner

Mass update of Benefit Balances (Wellness Points)

edited Feb 5, 2020 9:37AM in Compensation and Benefits - EBS (MOSC) 7 commentsAnswered ✓

Good Morning All! 

I am using the following API to update the benefits balance for a person and I cannot seem to get past some conversion errors.  I have tried many things with no success.  Many thanks in advance.  G

declare

v_object_version_number number;

v_employee_number varchar(10);

v_effective_start_date date := '01-JAN-2020';

v_effective_end_date date :=  '31-DEC-4712';

v_person_id number;

v_per_bnfts_bal_id number;

v_bnfts_bal_id number;

v_benefit_balance varchar(5);

--v_effective_date date; -- := '01-JAN-2020';

v_temp_tabspace number;

data_line varchar2(100) := null;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center