Period and Year extracted from Oracle database in columns - not working in FCCS Data Management

Summary:

Period and Year extracted from Oracle database in columns - not working in FCCS Data Management

Content (please ensure you mask any confidential information):

We have a requirement to pull actuals from Oracle Database where current period and current year also exists in the column. However, when I try to import and export the data, no matter which period and year it shows in the workbench, the data is loaded to the period selected in the dataload rule.

Customer's requirement is to automate and not select start and end period and it has to load to the period and year extracted from the columns.