Need BIP report SQL query to get GL Balances by Posting Date
Maybe these will help you what you're looking for
https://www.enginatics.com/reports/gl-trial-balance-detail/
https://erp-integrations.com/2017/01/23/query-to-check-gl-period-begining-balances-with-previous-period-ending-balancecompare-period1_end_balance-with-period2_begin_balance/
https://rpforacle.blogspot.com/2020/07/ytd-balance-query-in-oracle-apps.html
Brendan gave a number of options to explore.
It would be nice if you could write a proper question, with some context, and at least what product you are using.
I imagine you aren't using FDI, but building a report on Fusion. In that case, this is not the right forum: Fusion data questions should be posted in https://community.oracle.com/customerconnect
@Kalyani-Oracle , please use this specific forum General Ledger & Intercompany — Cloud Customer Connect to ask your question. You can search also for already answered questions, and it might help you get the answer for your question.
Hope it helps!
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
