03-15-2023
02:22 PM
- last edited on
03-16-2023
07:00 AM
by
JackLacava
Hello,
We have our PLP Workflow step set to "Workspace, Import, Validate, Load". When we click the "Complete" button the Import, Validate and Load step are executed.
We have forecast scenarios with settings for "Number of No Input Periods Workflow Unit".
In the OTB Connector "PeoplePlanning" we have a complex expression on Time.
Dim iScenarioID As Integer = api.CurrentDataClusterKey.ScenarioID
Dim noInput As Integer = BRApi.Finance.Scenario.GetWorkflowNumNoInputTimePeriods(si, iScenarioID)
If args.Value <= noInput
globals.Bypass=True
Else
Return args.Value
End If
This works great if we have a separate Import, Validate and Load step in the WFP.
The "Complete" button appears to use a different connector even though we assigned PeoplePlanning as the Data Source Name in the WFP step.
Any suggestions on updating the connector used by the "Complete" button. I looked at the PLP_SolutionHelper and narrowed it down to the line
Dim impProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, _
wfChildClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, _
SourceDataOriginTypes.FromDirectConnection, True)
Any suggestions?
Solved! Go to Solution.
03-16-2023 02:04 PM
Just an update..embarassingly it's my fault. There was leftover data in the Staging table for the 'closed' periods.
I cleared it and (knock on wood), it issue is resolved.
03-15-2023 11:42 PM
This is the line running the import and validate:
Dim valTranProcessInfo As ValidationTransformationProcessInfo = BRApi.Import.Process.ValidateTransformation(si, wfChildClusterPk, True)
03-16-2023 02:04 PM
Just an update..embarassingly it's my fault. There was leftover data in the Staging table for the 'closed' periods.
I cleared it and (knock on wood), it issue is resolved.