Request for an Optimized Oracle Method to Extract YTD GL-Level Data for Cash and PSP Groups

Summary:

We would like to explore more efficient options within Oracle for extracting the required data for the Cash and PSP groups. Specifically, we need to obtain GL‑level details for the year‑to‑date (YTD) amounts across ERP and FCCS entities for these groups.

Content (please ensure you mask any confidential information):

Hi All,

We are loading periodic view data into FCCS through ERP and file integration. For all entities, we need a report that shows the A‑Cash and A‑PSP account details along with their total balances at a specific point in time. Since these groups are mapped from many ERP accounts into a single FCCS account, we need visibility into the detailed source mappings.