-
Fusion Tables with Metadata for All Catalog Objects for Oracle Cloud users.
Dear Oracle, Objective: Acquire Metadata - Author, Owner, Creation Date, Modification date. I am seeking META data for all objects located in Catalog directories from a FUSION table. During my research, I identified the following tables listed below. However, these do not contain meta data (author, owner); instead, they…
-
Need to Schedule FRS reports in Excel Format through Batch scheduler
Organization Name Jade Global Inc. Description We need to Schedule FRS- Financial reports in Excel format as currently we see there is only PDF and HTML output option in batch scheduler. Functionality Needed:- Need to schedule in Excel format to see clear balance and GL's. Currently it supports only PDF and HTML Use Case…
-
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment
Organization Name Tesco Description Hi Experts, I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data. But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not…
-
Update the Permissions setting so that Unarchive and create Data Models or Reports can be separated
USE CASE AND BUSINESS NEED: Currently, we provide the access to Unarchive from Administration > Manage Privileges, in the BI Catalog and if the Permission is defined as “Write” for a folder, for the particular user or a particular role that is assigned to the user, then the user gets access to unarchive under the same…
-
While scheduling a report, added message text to come along with the HTML output in email body
There is a business need to keep the output type as HTML of a Oracle fusion BIP report. Also, when this report is run through scheduling, there is an additional message that user inserts by going to the Output Tab → Add destination (As shown in the screenshot). The message marked in yellow is not part of the message body…
-
Learning Records Real Time - Adding Common Dimensions
Hello, I've found by trying to join Workforce Leaning - Learning Records Real time to Workforce Management - Worker Assignment Real Time and it doesn't join very well. Through oracle support I've learned that it will connect to the following dimensions Worker Job Location Time I think it would be best if we could connect…
-
Proposed start date in My Activities Centre
Client wants to have the option of including proposed start date in My Activities Centre for pending workers. We want an option to do this in VBStudio.
-
‘Transfer Out’ Measure in Worker Assignment Real Time
Organization Name Vanderbilt University Description In the 'Workforce Management - Worker Assignment Event Real Time' subject area, there are measures for Hires, Terminations, and Transfers In. To get a full picture of the movement of workers within an organization, a ‘Transfer Out’ measure is needed. For example, when…
-
Field level security needed for OTBI subject area analysis reporting
Organization Name Clayton Homes Inc. Description When creating an analysis using a Subject area in OTBI reporting, there are fields that may contain PII data that need to be secure. If someone has access to the entire Subject area, they can pull any data associated to that area regardless of whether they should have access…
-
Include support for Amazon S3 as a BICC Extract Delivery Location
Organization Name Twilio Inc. Description Currently, BICC supports delivery to * Cloud Object Storage * UCM As a user, I would like to be able to automate data delivery from the scheduled BICC jobs to other delivery locations, specifically an Amazon S3 server. Use Case and Business Need BICC extracts are used to feed data…
-
Please enable datastores in BICC for ap_invoice_lines_interface, ap_invoices_interface, ap_interface
Please enable datastores in BICC for ap_invoice_lines_interface, ap_invoices_interface, ap_interface_rejections tables. Data from these tables need to be exposed to third party reporting tool to analyze and implement business requirement which is highly dependent on data from BICC.
-
BICC does not display all the seeded PVOs
Fivetran is a cloud-based platform that automates the process of moving data from various sources to a desired destination It is connecting Oracle Fusion Cloud and extracting the list of available BICC objects. Fivetran is able to list objects that are not standard in the list of available BICC objects. Client is expecting…
-
"Created by" in "Workforce Succession Management - Plan Candidates Real Time" OTBI subject area
At the moment it is possible to report on when a candidate was added to the plan ("Workforce Succession Management - Plan Candidates Real Time"."Candidate Details"."Candidate Since New") but information about who added a candidate to the plan is missing in Candidate Details dimension. Succession plans can have multiple…
-
Data flow from AP to PA
In AP, when invoices are created, those expenses have their FA major minor codes and locations tagged to the transaction. When this invoice has been processed for payment, this information of FA major minor codes and location is not interfaced into project module. Under Project module, as the data is not received from the…
-
Data join type of OTBI subject areas should be able to manage
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Johnson Controls Description (Required): For now, when create OTBI report need join data cross subject areas, the join type is inner join, and it's not allow user to change the join type. That…
-
Track BPM rule changes performed through SOA composer in Audit Reports
We have an audit requirement where we have to track all the changes made in BPM rules. At present we can only capture changes made manually in BPM but changes done through SOA composer are not getting captured. As confirmed on SR 4-0000367631, at present this functionality is not available in fusion application. It will be…
-
HCM Group Override Field
Hello, I had been tasked with creating a reporting with hinged on the values within the field "HRM Group Override" which is found in the Person Management area within Oracle Fusion, Using Reports and Analytics, this field cannot be found in any of the subject areas (Including Flex fields). I referred to the spreadsheets…
-
Allow Selection of Multiple Values from an LOV into a single parameter
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): The MathWorks, Inc. Description (Required): In development of a custom Data Model and Report the user can create a "menu" based parameter that allows them to select multiple values to pass…
-
How to exract SQL statements applied to BIP reports
At our organization, we would like to execute various scans on the SQL statements applied to BIP reports, for style, defect-checking, security, and more. The SQL is embedded in BIP report packages are in a binary format. We are looking for recommendations on how to extract the SQL statement code, which we can then send as…
-
URL for Chooser Login page
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Tata Trusts Description (Required): We were using the Chooser Login page till recently and we have enabled the SSO just a few weeks back. I need to ensure that the Chooser login page does not…
-
Contact Date of Death
Add Person Contact Date of Death to the Person Contact Relationship folder in 'Workforce Management - Person Real Time' and 'Benefits - Person Information Real Time' subject areas. Person Contact Date of Death does not exist in any Person Real Time subject area in OTBI. Benefit analysts often request reports that include…
-
Need to update file name $ORACLE_HOME/oracle_common/modules/thirdparty/log4j-2.11.1.jar
We need to update $ORACLE_HOME/oracle_common/modules/thirdparty/log4j-2.11.1.jar with correct version of log4j inside the manifest file which is 2.17.1 to avoid any confusion for security scanning application.
-
Ability to access Schedule process names using a Table in OTBI Report.
Organization Name Apps Associates Description We have a requirement to show all the scheduled job in an OTBI report. We are not able to access Schedule process name as it is stored in XML format in FUSION_ORA_ESS.REQUEST_METADATA table in MDS repository which is not accessible in SAAS. Need ability to…
-
HCM Rest API Usage Details
We need the Rest API usage details for HCM SaaS model. Kindly let us know how we can get the usage details on user basis.
-
Ability to automate backup/deploy of analytics and reports on Oracle Cloud HCM BI
Description Currently no tools are available to allow for automated backup and deploy of analytics and reports. There is no clear way to version our objects. We should also have the ability to store BI objects as code/text instead of binary. The binary objects can fail if you try to import across different versions of…
-
Audit trails for specific page in HCM Fusion
Hi, Does anyone know how we can retrieve audit trails/activity trails from fusion(using HCM query) for a set of user if he has performed any action over an specific page like employment, performance page etc? I have checked the Audit report tool where we can check only for one user at a time for one Business Object type at…
-
When the employee open a report we need to send one email to same employee
DescriptionWhenever the employee open a report we need to send one email to the same employee. Once the employee select all the perameters and click on apply button automatically one email should be trigger. Use Case and Business NeedWe have lot of use cases are there for this functionality. Example, we are created some of…
-
Enable version control to Fusion OTBI Reports
Enable version control over OTBI reports in Fusion SaaS to connect data model queries with a Git repository. In the same way, there should exist a method to allow moving reports developed in the Dev/Test environment to the Prod environment through a pipeline in DevOps OCI services.
-
Need Person level data- add Worker Dimension to Payroll-Payroll Costing Setup details Real Time SA
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Hillsborough County Description (Required): Currently the Employee Level information for Payroll costing is not accurate when we try to join with any other SA. This is because there is no…
-
BI permissions and custom folder privileges should not be affected during upgr
Organization Name Keurig Green Mountain, Inc Description Currently, upgrades wipes off any custom permissions or folder level privileges in BI, forcing us to apply them back every time after an upgrade. Is there a way to keep them intact? Already have an ER going through the following SR: SR 3-22463462591 : How to preserve…
