Publishing Forecasts to mulitple EBS instances
We are trying to publish Demantra Forecast scenarios to mutliple Oracle EBS instances. But we notice the forecast is only available in one instance. We found code when the ' forecast publishing' instance id was assigned which looks at the msc_apps_instance table:
select min(instance_id) from msc_apps_instance table where instance_type <> 3 and validation_org_id is not null. Since it was looking for minimum value, it was assigning only one instance_id to the data and we cannot publish to the other instance_id.
Is this expected functionality?
Thanks