1. Administering Oracle Payroll Interface
  2. Configure Dynamic File Names for Global Payroll Interface

Configure Dynamic File Names for Global Payroll Interface

Global Payroll Interface generates the output file names dynamically.

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:

Note: Don't specify the LDG while creating the fast formula, so that the formula is available across LDGs.

Formula Parameter

Value

Formula name

GPI_OUT_FILENAME_FORMULA

Description

Formula to consolidate various file name components and return the final output file name dynamically.

Formula text

 
------Formula starts-------------------------------------------------------------------------------------------- 
DEFAULT FOR RULE_VALUE IS ' '
l_instance_name=GET_PARAMETER_VALUE('INSTANCE_NAME')
l_date=GET_VALUE_SET('System_Time_Stamp')
l_leg_id = GET_PARAMETER_VALUE_NUMBER('LEGISLATIVE_DATA_GROUP_ID')
l_leg_id_param = to_char(l_leg_id)
l_final_value='ORC_'+l_instance_name+'_'+l_date+'_'+l_leg_id_param+'GPI'+'_'+'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.

Update Extract Structure

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 Global Payroll Interface.

  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 GPI_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

Configure a FTP Server to post the files in through BI Publisher.

To configure a secured FTP server for automatic file delivery, follow the instructions provided in How to setup SFTP Server for BI Publisher (Doc ID 1526505.1).

Add Delivery Option

Add a new delivery option to generate the files with configured file names.

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/Global Payroll Interface.xdo

    • Template Name: Global Payroll Interface Template

    • Output Name: %de

    • Delivery Option: FTP

  3. In Additional Details section enter this detail

    Run Time File Name: Search for and select the Attribute you created in the Update Extract Structure section.

  4. If 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 server name as entered in BIP

    • Run Time File Name: Search for and select the attribute you created in the Update Extract Structure

    • Click Save and Close