-
Oracle BI | Receive error message after 10 minutes when opening the report
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
-
WLF_ASSIGNMENT_TASKS_F LAST_UPDATED_BY
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
-
OBIA Future Support Timelines & OAS Moving to FMW 14c
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
-
SQL Filter Issue - INSTR Function Causing Report Filters to Disappear for Specific Users
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
-
OAS 2025 (EBS 12.2.12): Anyone has built "Project to GL Cost Reconciliation" Report
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
-
Download reports xml using command line Catalog Manager and online mode
Hi, Is it possible to download all XML reports from a specific folder using Catalog Manager in command-line and online mode? Regards Szymon
-
From where we can download Informatica 10.5.9 at Oracle portal
Hello Team, It seems Oracle is providing Informatica license at Oracle portal/eDelivery. But we are unable to find Informatica version 10.5.9 software at Oracle eDelivery. We need to upgrade Informatica to latest version. We do use OBIEE and BIP as well. Whom should we reach out for help? Sales or licensing team at Oracle?…
-
How to fetch the fetch the CONTENT ID based on ESS Job request ?
I need to fetch the Content Id (Output file)based on my ESS Job request Id, Join or table query also fine. Key Tables for Content IDs:- REVISIONS , FND_DOCUMENTS_TL and FND_ATTACHED_DOCUMENTS. I am failed to get the link between these… Please help. Thanks, Prasad.
-
How to replace "No results. The specified criteria (...) any data." with a customized tile?
Hi, I have a dashboard with 2 prompts filtering by asset state and location in one section and multiple small analysis in another section that show different type of models. Here below a dummy example with 4 tiles (each tile is one analysis and they all are in one section): 280 15 170 95 Notebook Large Notebook Large…
-
During Intall of Oracle Analytics toolkit got INST-07551
Found reference Knowledge Article regarding patch 37351880. The solution is to use OPatch 13.9.4.2.18 version so is this my solution and if so how do I get this version?
-
Brazil ECD report -BIP report , output in pipe delimeted text
Team, Do we have any standard Brazil ECD BIP report , pipe delimeted text output. This report is to declare GL entries , balances to Brazil Govt. This is mandatory for any company having business in Brazil. I am looking for the standard report which can we customize, if needed.
-
In FDI using a custom subject area, how to perform detail calculations at a record level?
In FDI using a custom subject area, how do I perform detail calculations at a record level before doing aggregation? We have customer shipments data; one line per shipment where the status of the shipment line can indicate that the item was shipped or the item was returned. Based on shipment line status and shipment date…
-
How can we relate DOO_headers or with fulfill table with requisition/po/with receipt for BIP report
i need to find some connection. scm_supply_headers table is not there in the system,, What other tables i can use for connectivity. also source_document_id is not there in doo_fulfill_lines table to connect with po_header.
-
DAC services are going down with below error.
Shutting down the server.... DAC Repository connection lost. Shutting down the server.
-
Is there any we can increment the parameters of scheduled FRS report
We have an FRS (Financial Reporting Studio) report that needs to be scheduled. For each scheduled run, the Accounting Period parameter should automatically increment to the next period. Is there a way to achieve this functionality?
-
Power BI connector
Hi, We have semantic layer created in OAS that we want to use in Power BI with the help of a Power BI connector. We are not in cloud and cannot use the Power BI connector (Preview). Does anyone has any tips, workaround, or know when Power BI connector is available for OAS. Thanks Tasmeia
-
Need more info | Oracle Critical Patch Update for October 2025
Can you please review and let me know on below queries : 1.Is it applicable to only ERP or is it applicable to OTMGTM,Middleware,OIC and other areas as well, if all other areas please share the list of affected where we need to apply patches. 2. Do we need any downtime or it is online patching where no downtime is needed?…
-
Internal Server Error while calling /biacm/rest/meta/export API
We are encountering an Internal Server Error (500) while trying to get a response from the API endpoint /biacm/rest/meta/export. Has anyone faced a similar issue or know what might be causing this error? Are there any specific configurations or prerequisites needed for this API to work correctly?
-
For 'Humanoid Avatar + AI Agent' (to replace Call Center Operator), what kind of security required?
Now many parties are developing the 'Humanoid Avatar + AI Agent' in order to replace Call Center Operators. In this case, the Security issue will be a large concern. How can we protect our system?
-
How to fetch project source template details for a particular project in Oracle Projects module.
How to fetch project source template details for a particular project in Oracle Projects module in BI reporting. Not able to get the project and its template details using the 'pjf_projects_all_vl', 'pjf_projects_all_tl' or 'pjf_projects_all_b' tables.
-
Does anyone have and can share a presentation (ppt) for 8.2 OAS DV version new feature added?
Does anyone have and can share a presentation (ppt) for 8.2 OAS DV version new feature added comparing it with old version with screen shots whether it is login screen or navigation or outer join inclusion?
-
Is OAS 2023 certified with OBIA 11.1.1.10.3 PS4? I was told only 2024 & 2025 were certified.
-
How to display data for a month other than the current one in the calendar type
Hello everyone. I did some scheduling work and used the calendar type, and every month a different schedule is created. When I need to view a schedule from a past month, the calendar always opens to the current month, and I have to keep clicking to scroll back to the month and year I want to view. I saw and used this…
-
Maps in OBIEE 12.2.1.4
Hi community, I would like to use maps in OBIEE 12.2.1.4, and I have a few questions first of all if there's any guide or tutorial to work with maps, is stricktly required to get aSpatial Provider like NAVTEQ, is there any other option? Thanks
-
OAC Calculations
I’m building a pivot table in Oracle Analytics Cloud with Month on columns and Category on rows, showing three measures under each month: YTD Previous Year, YTD Current Year, and Evolution. For YTD Previous Year, I’m using the formula Filter(PERIODROLLING(SO Value, -24, -12, Month) using Year(Date) =…
-
How to check list of scheduled or standard notification jobs scheduled in oracle fusion for each mod
Hi Team, We need to see the list of all schefuled ess jobs mainly of those standard notifications getting triggered in Quality management module. How do we check the. We can srach for report jobs scheduled but need the ESS jobs/ standard oracle notifications triggerred for any of actions in Quality Actions/Issues.
-
Hello, I am trying to find the table that holds the selected educational institution in the employee
Hello, I am trying to find the table that holds the selected educational institution in the employee admission.
-
How to transfer report files in csv format via ESS job to SFTP SERVER.
We need to transfer a report output as a single file to the SFTP server using an ESS JOB, so we're using a bursting query to specify the server name, path, and location. The bursting query requires a key column, so we've added a dummy column, resulting in a single output file. However, we need the output in CSV format, and…
-
How to create Custom BICC PVO Creation in Fusion
Can someone share details on if it's possible to create Custom PVOs for the tables for which the standard PVOs are not available? If yes, please share the steps to create it.
-
Oracle Cloud Bursting
Hi Team, We are currently working on Oracle Cloud bursting queries. We successfully triggered a bursting report and compressed the data. We are triggering the job using the ScheduleService WSDL SOAP API. Is it possible to encrypt the data before uploading it to UCM? If we create a custom UCM instance with encryption with…
