Hi Nathan, When I created a report within OTBI it would only pull default expense accounts for employees who have submitted expense reports. I now see you were referring to the query. Sorry about that. And thank you for the additional information! Thanks, Trent

Hi Nathan, I am aware that exists. However, that only pulls the default expense account for employees who have submitted expense reports. Employees who have not submitted expense reports will not show up in that field. For this particular project, I needed the default expense account for all employees regardless if they…

Thank you Bhaskar! That's exactly what I needed. I really appreciate all your help with this! Thanks again, Trent

Hi Bhaskar, Thanks, this was a huge help! Just one more question. Is there a parameter we can input in the query above so it only pulls active employees? I noticed this particular query is pulling our inactive employees and I would like those excluded. Thanks! Trent

Hi Bhaskar, Curious as to if a query like the one I described above exists? Thanks, Trent

Hi Bhaskar, We are getting closer to what I need. The one issue I'm noticing is that the query pulls in a code combination ID, which I assume refers to a specific user. Is there something that will pull in the user name instead? And then also within this query, it is only pulling in distinct default expense accounts which…

Hi Bhaskar, It appears I would need to run this query with a specific person number. I need the default expense account for multiple users so running this by each person number would be very time-consuming. Is there a way we can run a query by a specific company number (segment 1)? Thanks, Trent

Thank you Sovi. That worked great. Appreciate your help with this! Trent

Hi Sovi, Thank you. I do have one question. How do I add that analysis column on the report? Segments 1 & 2 will always be lengths of 3. Thanks, Trent

Yes, segment 2 would be 100 in the example above. Thanks, Trent

I have a sample data set here. Is it possible to extract segment 2 from COA? Thanks, Trent Sample Expense Data.xlsx

Thank you Sovitendu! This will be a good workaround to use for now. Appreciate your help! Regards, Trent