2 weeks ago
- last edited
2 weeks ago
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.
2 weeks ago
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.
2 weeks ago
This is the line running the import and validate:
Dim valTranProcessInfo As ValidationTransformationProcessInfo = BRApi.Import.Process.ValidateTransformation(si, wfChildClusterPk, True)
2 weeks ago
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.