The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Data Adapter showing Invalid object for ReconItem table
Hello,
We've recently upgraded to OFC 8.4 and after this upgrade, underlying RCM table names have been updated.
For ex - XFW_RCM_ReconItems is now updated as ReconItem.
Earlier on OFC 8.2 , we were able to query this table using a data adapter as well as in Business rule (DBConnInfoApp) . But now it's not working anymore. Same issue is occurring for all other RCM related tables.
It does work for other tables not related to OFC/RCM (for ex - Member).
Are there any restrictions in OneStream to query certain application tables? Is there any workaround for this?
Regards,
Gaurav
Table showing in Application Database:
Giving error while querying from data adapter:
Found the workaround from onestream support, it is an existing Platform bug that impacts OFC tables.
To query this in data adapter, you will have to include rcm. or txm. before the table name.
ex - RCM.ReconItem
Thanks,
1 Reply
Found the workaround from onestream support, it is an existing Platform bug that impacts OFC tables.
To query this in data adapter, you will have to include rcm. or txm. before the table name.
ex - RCM.ReconItem
Thanks,