Need BIP report SQL query to get GL Balances by Posting Date in oracle Fusion

Summary:

Customer is looking for following columns in the report
-Ledger
-Period

-Posting Date
-Account

-beginning balance

-period activity

-ending balance

tried to join GL Balances and Je headers and Lines table however facing challenges with the aggregation and not getting correct results.

Please advise.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):