-
Last Updated By column show 'anonymous' in Supplier site level data in Supplier audit report.
Why does the 'Last Updated By' column show 'anonymous' in Supplier site-level data in the Supplier audit report? It should show who is making the change request Supplier Bank Accounts last_updated_by with"Anonymous" user (Doc ID 3017051.1): We have done an improvement to our hashing algorithm in 24A to ensure Bank Accounts…
-
Additional Person Info - History data should be available from OTBI
Hi, We are opening this idea because now, when we try to extract data about Additional Person Info (Subject area: Workforce Management - Person Real Time), we only get current data and not historical data. As mentioned in this…
-
Employment contract Real Time - Historical data should be available from OTBI
Hi, We are opening this idea because now, when we try to extract data about Employment contracts - (Subject area: Employment contract real time), we only get current data and not historical data. As mentioned in this…
-
Enable Cycle Count Header dff for Inventory - Inventory Cycle Count Real Time OTBI subject area
Client captures information on Cycle Count in the dff on the cycle count header (INV_CYCLE_COUNT_HEADERS). And enabled it for OTBI. But it is not showing up in the Inventory - Inventory Cycle Count Real Time subject area?! Expected to find it under the section Cycle Count Header Details. But it does not populate. See below…
-
BIP Reports built on Excel Template needs to support Report Output Format Option as xlsx
Currently BIP Reports built on Excel Template, supports Report Output Format Options as .xls and this can hold data of only 65K records per worksheet/tab in Excel and the remaining data is split across tabs. As we are currently having data in millions, even if need to export this data for 1 month or 1 quarter for analysis;…
-
Requisition Subject Areas - Missing Messages information
Hello, We would like to request to add Message Information from Job application screen to Job Application folder structure under requisition subject areas. This information is currently missing. We would like to see messages and it's statuses along with dates. Thank you
-
Employee Previous Assignment Information -
Hello, Our HR partners, always required to have previous assignment information in report and flag out what changes has gone through. For example, if employee to different department or location or grade etc. So we can get all changes through Assignment event subject area but it is hard to get previous values for each…
-
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…
-
BIP Report output downloaded name to change dynamically based on the parameter selected (PO Number)
The PO print BIP report is getting generated based on the PO selected in the parameters. When the output is generated and downloaded, the file is getting downloaded with the default name 'Output_Document'. Requirement is that the name of the downloaded file should pick the PO number selected in the parameters dynamically,…
-
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…
-
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.
-
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.
-
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…
-
"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…
-
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…
-
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…
-
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.
-
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…
-
Add support to enable BI Broker Mode in create/update BICC job Rest API
All the jobs created via BICC Rest API always have BI Broker Mode option set as disabled and there is no option to set the extract mode in the API right now. Add support to enable Bi Broker Mode via API. Ref -…
-
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.
-
General Ledger - Journals Real Time issues with filters on Journal Source & Journal Category
When you create an OTBI analysis filter using Journal Source or Journal Category, the OTBI analysis XML hard-codes the IDOF key value. Therefore, when archiving and unarchiving reports for deployment into higher level instances, the reports break. Request that functionality be incorporated so this does not occur, and…
-
Can we send any Taleo Analytics reporting output file to any FTP location
Can we send any Taleo Analytics reporting output file to any FTP location. There is no FTP in delivery option. Taleo reporting URL: https://reporting********taleo.net/analytics/saw.dll?bieehome&startPage=1
-
Adding Additional DFF information at expenses level to OTBI Reports
We have enabled a DFF at the expense line level to capture additional information. We have a a requirement of adding the descriptive flexfield value to expenses transactions real time report. Please let us know if it is do-able.
-
Issue with Exporting "Bank Check" Report for Printing on Specific Printer
I am experiencing an issue while trying to export the "Bank Check" report to be printed on a specific printer. The issue lies in the sizing of the report, which does not appear to be compatible with the check format used by our bank or the printer specifications. Steps to Reproduce: Open the "Bank Check" report. Attempt to…
-
Make flexfield information for DOO_FULFILL_LINES_ALL available in BICC
Hello! I would like to be able to use BICC to export flexfield information from DOO_FULFILL_LINES_ALL. Currently I can only export this information using BIP.