I am trying to load CellText using the Memo field in FDM to export to CellText in HFM. I have followed the previous post and instructions and taken this method for CellText loading: https://forums.oracle.com/thread/2412887.

The application I am working on requires CellText loading to group level Account members. For these specific accounts, I have loaded a value of "0" in the amount field and textual data in a Cell Text field to be loaded in to the Memo field. The script that maps the CellText to memo field works fine, and the validation stage displays no errors. However, upon export to HFM there are kick-outs stating; "Error: Data cannot be input for group level Account members."

Is there any way that the Memo fields can be loaded to group level Account members without loading the amount data?

If you just want to load cell texts but not data you can follow some different approaches. One of this could be to disable "Enable Cell Text Loading" and adjust your EXPORT action so the .DAT file generated contains only !Descriptions sections with your cell text information and not !DATA section. You can get cell texts in the same way it´s done in LOADB Action script.

This should be working. If !DATA section is required you can add dummy record to be loaded.

Thank you for your reply.In our case, our import file will contain both rows of data that need to be loaded, and also rows of data with only CellText but with no numerical amount needed ("0" input in the amount field).

Could you please go in to more detail of how dummy records can be loaded? Will this mean that I will be able to point to the CellText only data rows in the EXPORT action and edit the !DATA specifically for those rows?

I will investigate your suggestions above regarding EXPORT section tomorrow and get back to you, thanks for your help!

It seems that on export we get the error message; "Error: Stream Failed, Invalid file path provided!". However the data and CellText is successfully passed through to HFM. Would you know how we would be able to resolve the error?