Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Benefits Extract Custom Data Rule Issue - No Data — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Benefits Extract Custom Data Rule Issue - No Data

Received Response
13
Views
1
Comments
edited Sep 18, 2020 10:56PM in Benefits 1 comment

Summary

The Value is always 0 and No of records in Extract are decreases

Content

The seeded Benefit Extract for FSA data is not fetching the Coverage amount, SO I have written a Fast formula to get the amount. But when the extract is run the Value is always 0 and no of the records fetched is decreased. Not all records are coming. I have attached the formula, could anyone review and let me know what is the issue is.

Thanks!!

Version

20B

Code Snippet

DEFAULT FOR BEN_PRV_ANN_RT_VAL IS -1
L_DEFAULT_DATE      = TO_DATE('1951/01/01', 'YYYY/MM/DD')
L_PERSON_ID         = TO_TEXT(GET_CONTEXT(PERSON_ID, 0))
	
	/*EFFECTIVE_DATE,HR_ASSIGNMENT_ID,BUSINESS_GROUP_ID,LER_ID,OPT_ID,ACTY_BASE_RT_ID,PL_ID,BENEFIT_RELATION_ID*/
	
	L_BUSINESS_GROUP_ID	   = GET_CONTEXT(BUSINESS_GROUP_ID,1)	
	L_HR_ASSIGNMENT_ID 	   = GET_CONTEXT(HR_ASSIGNMENT_ID,1)
	L_PL_ID 			   = GET_CONTEXT(PL_ID,1)
	L_LER_ID			   = GET_CONTEXT(LER_ID,1)
	L_OPT_ID			   = GET_CONTEXT(OPT_ID,1)
	L_BENEFIT_RELATION_ID  = GET_CONTEXT(BENEFIT_RELATION_ID,1)
	L_ACTY_BASE_RT_ID      = GET_CONTEXT(ACTY_BASE_RT_ID,1)
	L_EFF_DATE 			   = GET_CONTEXT(EFFECTIVE_DATE, TO_DATE('1951/01/01 00:00:00')) 
	
	CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = L_HR_ASSIGNMENT_ID,PL_ID = L_PL_ID,OPT_ID = L_OPT_ID,BENEFIT_RELATION_ID=L_BENEFIT_RELATION_ID,ACTY_BASE_RT_ID=L_ACTY_BASE_RT_ID,EFFECTIVE_DATE =L_EFF_DATE,BUSINESS_GROUP_ID=L_BUSINESS_GROUP_ID,LER_ID=L_LER_ID )
		(
			L_BEN_AMT = BEN_PRV_ANN_RT_VAL
		)
		
		RETURN L_BEN_AMT
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!