My Oracle Support Banner

ANSI 834 is Returning pl_id Instead of Plan Name for Some Business Groups (Doc ID 2415757.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.


The 834 extract is not returning the plan name for all business groups.

Customer first tried Decoding the Plan Name. They discovered it was returning the PL_ID instead of the Plan Name from Business Group-<Business Group Name B>, so they tried using the Short Name.

The Short Name came across for Employees but not for Dependents. The Decode would work if the Plan Name instead of the PL_ID were returned from Business Group-<Business Group Name B>.

Customer included an HD record field with the Data Element Type of Field and the field set to 'Enrollment Plan Name'. This Data Element confirms the Plan Name from <Business Group Name B> is returned to the 834 Extract run in Business Group-<Business Group Name A>.

It looks like the Decode logic has some issue that causes this Data Element Type to return the PL_ID instead of the Plan Name.

Customer has configured the following fields with the below Plan and Option names (example of possible names):

AST- CT-HD06 Enrollment Plan Name Verification: PPO Low Dental
AST- CT-HD07 Enrollment Option Name Verification: EE plus 2 or more

Customer used these two fields to confirm that the extract was returning Plan and Options names for both enrolled and cover individuals.

The Short Names are Short names on these Plan and Option configurations. Does this mean that it will return the Plan and Option names for both enrolled and covered individuals, but not the Short Names?

Customer choose using the Short Names because appeared to Decode correctly. Previously, they were using the Plan and Options Names. Even though we can see the Plan and Option names returned in the Data Element Fields, the Decode Data Element fails.

Customer needs the Plan and Option Names to decode correctly, or the Short Names to work.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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