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
Automating BAI uploads in Workflow
Hello OneStream Community,
Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application.
1. BAI Parser &...
As for transaction data, did you map the BAI fields (FH,GH,AH,TH,AT,GT,FT fields) to attribute fields on your BAI data source? I did get transaction data for 95% of my initial test file. There was a small percentage not loading transaction level BAI data, but my source system for BAI files is still working their file formatting, so I chalked it up to that for now. When my source system starts sending me finalized BAI files I was going to recheck. But since you seem to be having that same issue it might be an OS issue.
As for amounts and the decimal place, yes the decimal was missing for me as well. So that might be an OS issue. This is a first for me dealing with bank BAI files, so I was not sure if that was a normal BAI format. Like amount lines all coming in positive with DR/CR indicator.
Because I can't get finalized BAI files from my source system I have stopped my BAI Parser effort at this time, but I'd still like to hear how your effort goes. And happy to provide help if I can.
We mapped all the BAI fields that our business's use. It's parsing the data but appears to be missing some of the data. We can look at the BAI file and see the transactions detail that it should be pulling in but is not. We can also tell by the type codes in OneStream. The decimal place issue is just strange. I do have a ticket open with OneStream support to look into this and see if they can provide any more information about configuring the BAI Parser. I will reply back once I hear something from them.
As for missing decimals... BAI bank data will not have decimals. On your Data Source use the 'Factor Value' to apply your needed decimal position (0.01 factor).
As for missing BAI data... All the transaction detail level data is flowing through the parser, but I am missing "higher" level data rows for example AH_TypeCode rows of value 010 which is the Closing Ledger balance. I have opened a ticket with OneStream.
I've been working on a BR to replicate the BAI Preview Upload/Import into Workflow delivered functionality. I've somewhat reverse engineered BAI Preview to see what it's doing and code it's calling. It's proving pretty difficult to replicate that same functionality in a custom BR.
Have you had any success with a custom BR to replicate BAI Preview?