Configure Dynamic File Names for ADP Global View

Lookup Type

Configure a new lookup type to hold implementation-specific values for few components in the dynamic file name. For example, the Client Number might vary between different customers. Create a lookup type to use it in a file name.

Here's how you can create a lookup type:

1. On the Home page, click the Lookups quick action under the My Client Groups tab.

2. On the Manage Common Lookups page, click New.

3. Enter these values:

   Parameter	Value
   Lookup Type	ADP_GPY_OUT_FILE NAME_COMP
   Meaning	File name component values
   Description	Holds values for components in the ADP Global Payroll Interface output file name.
   Module	Oracle Fusion Middleware Extensions for Applications

4. In the Lookup Codes section, click New.

5. Enter these values:

   Parameter	Value 1	Value 2
   Lookup Code	ADP_GPY_SYSTEM_NUMBER	ADP_SAP_CLIENT_NUMBER
   Enabled	Yes	Yes
   Meaning	Actual value	Actual value
   Description	ADP Global View System Number	ADP Global View Client Number

6. Click Save.

Value Sets

Use value sets to extract various values required to form the dynamic output file name.

This table shows how to define new value sets:

Fast Formula

A fast formula combines the various file name components in the correct sequence and returns the final file name.

This table shows how to create fast formula of type Extract Rule:

------Formula starts-------------------------------------------------------------------------------------------- 
DEFAULT FOR RULE_VALUE IS ' '
l_instance_name=GET_PARAMETER_VALUE('INSTANCE_NAME')
l_param ='|=LOOKUP_CODE=''ADP_GPY_SYSTEM_NUMBER'''
l_system_id = GET_VALUE_SET('ADP_GPY_OUT_FILENAME_COMP',l_param)
l_date=GET_VALUE_SET('System_Time_Stamp')
l_leg_id = GET_PARAMETER_VALUE_NUMBER('LEGISLATIVE_DATA_GROUP_ID')
l_leg_id_param ='|=LEGISLATIVE_DATA_GROUP_ID='+to_char(l_leg_id)
l_leg_code = GET_VALUE_SET('ADP_Legislation_Code',l_leg_id_param)
l_final_value='ORC_P'+l_instance_name+l_system_id+'_'+l_date+'_'+l_leg_code+'OGPI'+'_'+'HRMD'+'01'+'_'+'D'+'UT8'+'G2I'+'.XML'+'.pgp'
RULE_VALUE = l_final_value
RETURN RULE_VALUE
-------Formula ends------------------------------------------------------------------------------------------ 

Ensure that the formula returns the value through variable RULE_VALUE.

Save and compile this formula.

Configurations on Extract Definition

An additional attribute called ADP Global Payroll File Name has been delivered to address dynamic file name requirements. You can map additional delivery options you create with this attribute to generate files with the filename returned by the formula ADP_GPY_OUT_FILENAME_FORMULA.

The application uses the attribute in the delivery options to generate the file with the dynamic file name.

1. On the Home page, click the Extract Definitions quick action under the My Client Groups tab.

2. Search for the extract definition specifying Name as Payroll Interface for ADP Global Payroll V2.

3. Create additional delivery options corresponding to every additional delivery type you need.

4. In the Runtime File Name attribute search for ADP Global Payroll File Name and map it to the delivery option.

5. Submit the changes and ensure that the validations are successful.

If you are using Payroll Interface for ADP Global Payroll to integrate with ADP Global View:

Save the generated file name in one of the attributes in the extract. The application uses the attribute in the delivery options to generate the file with the dynamic file name.

1. On the Home page, click the Extract Definitions quick action under the My Client Groups tab.

2. Search for the extract definition specifying Name as Payroll Interface for ADP Global Payroll.

3. Create a record in the extract.

4. Add an attribute of type Rule to this record and attach the rule formula that you created earlier.

   Note: The best approach is that you create the record under Root Block, like Payroll Group Data.

5. Specify Type as Rule and Rule as ADP_GPY_OUT_FILENAME_FORMULA..

6. Select the attribute created in Step 4 as the Run Time File Name for the delivery option you are creating.

7. Submit the changes and ensure that the validations are successful.

Configure a FTP Server

To configure ADP's secured FTP server for automatic file delivery, follow the instructions provided in How to set up SFTP Server for BI Publisher (Doc ID 1526505.1).

Adding Delivery Option

If you are using Payroll Interface for ADP Global Payroll V2 perform these steps to add a new delivery option,

1. Click Extract Delivery Options and add a new extract delivery option.

2. Enter these details:

   • Delivery Option Name: Any name

   • Output Type: XML

   • Report: /Human Capital Management/Payroll Interface/ADP Global Payroll Interface.xdo

   • Template Name: Override Template

   • Output Name: %de

   • Delivery Type: Select as needed

3. In the Additional Details section enter this detail:

   • Run Time File Name: Search for and select the attribute ADP Global Payroll File Name.

4. If the Delivery Type is FTP, , ensure that you have already configured the FTP server as mentioned in the Configure a FTP Server section. Add the server details in the Additional Details section as mentioned in the next steps.

   • Secure FTP: True.

   • Remote Directory: SFTP Destination Folder Name.

   • Server Name: SFTP servername as entered in BIP.

   • Run Time File Name: Search for the attribute ADP Global Payroll File Name.

5. Click Submit.