-
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…
-
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…
-
Unable to find BICC PVO Names for tables OSS_ENT_PLAN_ESTIMATES , OSS_ENTITLEMENT_PLANS
Hello Everyone, I am currently working on a data extraction using Business Intelligence Cloud Connector (BICC) in Oracle Fusion. I need to extract data from the following tables: OSS_ENT_PLAN_ESTIMATES OSS_ENTITLEMENT_PLANS However, I am unable to find the corresponding Public View Objects (PVOs) for these tables in the…
-
BI Publisher Report from design from the Letter head word document
HI, Customer has shared word document letter head which contains company logo and content. when i designed the rtf with that word doc and load data in standalone BIP plugin the images and content is not getting displayed in pdf format. Thanks, Srinivas B.
-
Query to get the history information from the Product Data Hub
Hi, I am looking for a query or related tables to identify the columns for a BIP report to get the item's related - user-related details, attribute details, additional object identifier details etc. (Highlighted columns in the image)
-
First Question (not the correct forum) regarding Constrained Plan and how it is implemented.
The issue is we have several plants and we are implementing a Constrained Plan at a plant in Oregon. The plant in Oregon uses Standard Delays in the process, but I also assist for a group in Alabama that uses resource offsets (or activity offsets) in their planning. According to the person who is the implementer of the…
-
Convert Date Field to "YYYY-Qx" Format
Summary Need to convert a date field from MM/DD/YYYY to "YYYY-Qx" format. Content Hi, I’m trying to convert a date field from the standard MM/DD/YYYY format into a "YYYY-Qx" format (e.g., "2020-Q1"). I’ve tried using Calendar functions in formulas. While they help extract the year and quarter separately—one column for the…
-
How to enable SSL for OAS?
Hello, does any one know how to implement/enable SSL for OAS on windows platform? we currently use http but need to implement https instead. Thanks,
-
OACS - Need Logic to exclude a Subject Areas from Analysis based on Prompt Values
My analysis uses multiple unions of Subject Areas (Criteria) e.g. Subject_Area_1 Union Subject_Area_2 Each Subject Area is quite data heavy and the query takes a lot a time. Would be great to know if there is a way to guide OAC engine to exclude a Subject Area based on a Prompt Value?
-
Oracle Data Transforms - Inbuilt options to trigger email alert
We are using Oracle Data Transforms - 2024.06.20.01.00 from Market Place and not finding any release notes in the Oracle sites and though we have latest 2025.03.14.00 ,there are no proper documentation in the bug fixed with proper release notes. Email Trigger: Also, unlike other ELT tool ODI ,we dont see an inbuilt email…
-
BICC PVO files are blank
BICC, Subledger Application and Subledger Transaction Entities PVO files are blank. Till a day before the same extract files were getting created with the relevant data. But suddenly, without any known changes to the configurations, the PVO files generated are blank.
-
Could you please tell me where to find the 'type' field within the Payment Module
Please let us know the Oracle table that contains the 'type' field from the Payment Module
-
Is Dynamic Filter supported based on Dates for BICC PVO extract
Hello Gurus, The use case is to be able to extract data from a specific PVO based on a Filter which gets data for the current month or data between specific months. Is there support to create Filter based on Dates which accepts system values like system date function?
-
can we add reset button in BIP report
-
Unable to bring up BI after change the AD user password for "oracle.bi.system" in AD and em console
Hello, we are not able to bring up BI (11.1.19) application after change the AD user password for "oracle.bi.system" in AD and em console, now even we switch to use "local user" BISystemUser, but get the same error in bi managed server logs: INFO: SAW Config read through…
-
How to display logo dynamically in FDI ?
Hello, We need to develop custom reports based on our needs. In this implementation, we have multiple locations, each with its own logo. We therefore need to make the logo display dynamic in the reports, depending on the logged-in user's location. If user1 runs the report, LOGO1 will appear. And if user2 runs the report,…
-
How to do email bursting without sending an attachment
I am writing the bursting logic to send a text file . I dont want the text file to be attached in the email. Logic: (select 'DATA' KEY ,'Billing' TEMPLATE ,'eText' TEMPLATE_FORMAT ,'en-US' LOCALE ,'TEXT' OUTPUT_FORMAT, 'EMAIL' DEL_CHANNEL, 'abc'||:P_MODE||'_'||TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') OUTPUT_NAME, 'xx@abc.com'…
-
Currently in Oracle BPM approval workflows, "Information_Requested" task has no reminders
Currently in Oracle BPM approval workflows, "Information_Requested" task has no reminders. Can this be improved? We have users forgetting to act on this because they don't get reminders and this causes approval delay and more admin effort to remind folks to submit information.
-
Need table and column information to get User account status & Locked status under security console.
I have a requirement to get user account status whether account is active or inactive and user locked status, whether account is locked or unlocked. Need table information to get this information. Is there any tables to store these information. TIA.
-
Setup BICC to extract files to External Storage (Azure Blob Storage)
Our client has requirements to extract BICC PVOs incrementally into their Data Lakehouse (Azure-based solution, not OAC). Can we configure External Storage to extract files from Oracle Fusion Cloud to Azure Blob Storage? (Our client does not have OCI so there is no Object Storage). Additionally, are there REST API or SOAP…
-
OBIEE12C Unable to Login to Analytics
Hi Team, Unable to login to OBIEE Analytics on our existing OBIEE12c with Admin as well, we are getting below issue: Issue1: Error[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error…
-
Oracle ERP Cloud - Customize seeded Report - xdmz file not being recognized
I followed several links posted by the community in understanding how to customize a seeded BI Publisher report under shared folder catatlog. However, when i try to re-upload back the xdmz file after I added my changes into the query its not recognizing this file to be used by the report. Here are few screenshots that I…
-
Tips on how to best troubleshoot BIP report performance
We have a custom BIP report that was created by our SI back when we implemented, that we are having some performance issues as of late. The code is a bit complex and we are joining data from multiple places (balances, journal entries, SLA, etc), so we know the nature of the report itself is not ideal by any stretch of the…
-
Daily Balances Columns missing in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyBalanceExtractPVO
We are observing that not all columns in GL_DAILY_BALANCES table are being extracts as part of FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyBalanceExtractPVO. Why is there a diffrence and how can we get those additional columns?
-
Need SQL Logic to get data from last bip report scheduled date
We have requirement to get report output from sysdate to last report scheduled date. for example, if report is first scheduled on Jan 1st 2025 and later schedule date is Jan 15th 2025. I need data from 1 Jan 2025 to 15 Jan 2025. So, is there any SQL logic to get that data.
-
Installation of OAS with Existing OFSAA
Dear Team, We are planning to install Oracle Application Server (OAS) in our environment, where OFSAA is already installed. Before proceeding, we have the following clarifications: What is the compatible version of OAS with OFSAA 8124? If we install OAS on the existing application server, do we need to install Oracle…
-
A column with a moving number of working days OBIEE 12c
Hello, I would like to create a column with a moving number of working days. The working days will be calculated based on the selected period time from the Dashboard Prompt. For example from 2025week03 to 2025week40 or from 2025/01/01 to 2025/03/14. It is possible? Number of working days will be part of the formula. Best…
-
Oracle OLAP on the Brink: Let’s Unite to Preserve Its Powerful Modeling Capabilities
We are a service company that designs and develops software in the field of management control and decision-making tools related to payroll and workforce management in large organizations. Our software suite is built on Oracle technology, leveraging Oracle’s OLAP option, which allows the description of multidimensional…
