is there a way to generate a list of reports and their path available in custom folder?
Hi @Sohel.IN-Oracle -
You will be able to find the information using below tables.
gl_frc_reports_b
gl_frc_reports_tl
Thanks,
Abhilash
Hello @Abhilash K - Deloitte USI,
I tried with gl_frc_reports_b but I am getting blank output as I don't have general ledger implemented in the application.
Sohel
https://docs.oracle.com/en/cloud/saas/financials/23b/oedmf/glfrcreportsb-7712.html#glfrcreportsb-7712
I would not trust the accuracy of the data in this table if you are looking for a report on the actual date times the report was created in the OTBI folders.
As an example, for a DM I created in 2022, from the OTBI folders the creation date is - 30/Sep/2022 15:23:49
However, from the table GL_FRC_REPORTS_B, the date is showing as - 11/Dec/2023 16:04:44
This is clearly not correct.
I suspect this is linked to the way the table is populated; from this SR.
----
How To Query Details Of ALL BIP, OTBI and FRC Reports (Doc ID 2722120.1)
<excerpt from Bug: 31996857>:
The description is correct and it takes care of 3 types of reports namely BIP, OTBI and Financial Report.
The report information will not be inserted into the table GL_FRC_REPORTS_B immediately after creating the new report and catalog in Custom folder.
For getting the entry into this table you need to do the following steps after creating the report in the Custom folder.
1. Login to the environment home page : https://<pod....com>/
2. Navigate to the following location:
Others >> Financial Reporting Centre
3. Upon clicking "Financial Reporting Centre" and navigating to this FRC page the new custom report entry will be created in the GL_FRC_REPORTS_B table.
I suspect the dates in the table are when the the FRC page was accessed, not when the Reports were created.
So, @Sohel.IN-Oracle , if you navigate to FRC (which I believe is available without implantation of GL) I would guess a list of reports will be available for you to look at. Please do try and let us know.
I do not know of an accurate way to list this information. If anyone does please do post an update.
Thanks
StuJM
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how theseā¦
Hi,š I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able toā¦
hi Oracle team, Have a scenario: Country = A, then page 1 should have a notification for that country with no header/footer however page 2 onwards, the existing content with header/footer. but if Country != A then no notification and has to display existing one with the header/footer. Tried option A: Native word optionā¦
Hi Oracle Community, I have a requirement in Oracle Fusion HCM Performance Management and would like to understand the recommended approach for BI Publisher. The business flow is as follows: A Manager logs into Oracle Fusion using their manager account. The manager can see the performance documents of their direct reports.ā¦
I have Windows 64-Bit in my system and I have downloaded Oracle BI Publisher Desktop 64-bit. when trying to install Oracle BI Publisher in my system, I get error like "Set Word2007 flg failed" or "Please uninstall the current version using Add or Remove Program from the control Panel" But there is no program for Oracle BIā¦
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ā¦
