-
Audit Report/Functionality Needed for tracking Report Run History
In current system we don't have audit on who had run a particular report . If we want to track the usage of report that how many users running daily we dont have that logging available . It will be good if we have a report with date parameter for detail log as to when this report is run . This report should not hang or…
-
Need status filter in OTBI subject area Under dimension.
Customer account number shows 1 relationship (1 billing account) in Oracle Account Receivables but in Customer Validation Report shows 2 relationship (2 billing accounts) for same one account where one account is in inactive status and the other one is active. we want the report should show only one account which is active…
-
BICC PVO Containing Data for Fusion Tables "AR_CMGT_CASE_FOLDERS" and "AR_CMGT_CF_DTLS"
There is currently a requirement to capture data through the Fusion PVO on the following Fusion DB tables and columns: Fusion Table1: AR_CMGT_CASE_FOLDERS Fusion Table1 Columns: CASE_FOLDER_ID, CASE_FOLDER_NUMBER, DESCRIPTION, REVIEW_TYPE_CODE, STATUS_CODE, CUSTOMER_NAME, PARTY_ID, CUST_ACCOUNT_ID, CREDIT_ANALYST_ID,…
-
How to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard
Hi Team, We are building a custom OTBI analysis in Fusion, need to know how to have Drill Down option on Aggregated column/field in OTBI Analysis/Dashboard. Please share any info. if anyone worked on the same requirement. ------------------------------------------------------- My requirement was to show supplier wise count…
-
Return page variable in a deeplink
Hello, I use this deeplink (for example) : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHeaderId=300000425217318 It redirects me to a new page (in a new tab) "purchase order" with the detail of the purchase order as wished. When I click on the "Done" button, it redirects me to the "Invoices" page. I…
-
Need the values of attribute group to be displayed in One-Row format in OTBI
Description We have some EFF as attribute group. When we run OTBI analysis, it shows one record per row for attribute group. It causes the report shows few parts. For example, we have Countries field (it is attribute group style), if one part has 250 countries, the report will shows 250 rows for country value. The…
-
Ways to restrict users from moving folders in Reports and Analytics to a different location
Hi All, Navigation: Tools --> Reports and Analytics -->Click on Browse Catalog at top right corner --> Shared Folders We have encountered numerous issues as business users mistakenly move folders in Reports and Analytics to a different location. As a result, lot of report jobs/HCM Extracts tend to fail. At times, while…
-
OBI Folders Move Warning Message
Description Would be very helpful if we have warning message when developers move the OBI folders accidently Use Case and Business Need During development of OBI analysis/dashboards, developers were moving folders accidently. This has happened couple of times and even though this was not the intention of developer. Would…
-
SR 3-32543631091 : CCC - Unable View other project Managers detailed info in OTBI Subject Area
Problem Summary --------------------------------------------------- Unable View other project Managers detailed information in OTBI Subject Area Problem Description --------------------------------------------------- Unable View other project Managers detailed information in OTBI Subject Area "Project Costing - Actual Cost…
-
Attempting to create a lookup table, getting syntax error
I am attempting to use SQL to create a report that determines whether a procurement was completed late or not depending on a number of factors. Due to the many conditions that need to be defined, I am attempting to use a lookup table to make it more efficient. However, I am encountering a number of errors when i try to…
-
Allow Developers to write SQL and preview data on the same screen
When creating an SQL Data Model, I have to write my SQL in the "Diagram" tab, close the window go into the "Data" tab to see a preview of the results. Realize the changes i need to make, go back to the "Diagram" tab adjust my SQL, back to the "Data" tab to review results again, and so on and so forth. If this could be on…
-
Want to set default by ALL for 'Show Task by creation date' In Worklist
In Worklist, Notifications and Approvals Show Tasks by Created date set as All by default. So that by opening tasks by default it will show all.
-
Dashboard page export to PDF
We created a dashboard in OTBI that contains three reports. We have the dashboard set to allow exporting the entire dashboard page to PDF and Excel (without having to export each report as separate files). We present the dashboard to managers via a link in the HCM user interface (via Page Composer>Add Content>Select…
-
Not able to reference columns from multiple SA's within a Case statement.
Hi, Getting below error while referencing columns from multiple subject areas within a Case statement. Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000.…
-
Subject area to be able to report on candidate drop offs before job application submission using OTB
Organization Name Associated Banc-Corp Description Need the subject area to be introduced to be able to report on candidate drop offs using OTBI or BIP(Feature for tracking candidate activities is currently not reportable in OTBI or BI Publisher)Use Case and Business Need We are trying to report on the progress of an…
-
Need expanded OTBI areas or selection across Awards / Projects / Contracts / Accounts Receivables
Need expanded areas for selection across Awards / Projects / Contracts / Accounts Receivables when creating reports (OTBI, PVOs) Available OTBI data / subject areas do not currently suffice for providing data that CCF Research has in the custom reports that OCS has developed and used BIP instead.
-
Improve the search function when adding new permissions
This idea relates to adding additional permissions to reports in OTBI, by clicking on More, then Permissions and '+'. We are then presented with the Add Application Roles and Users window. In the search box (when Application Roles is selected from the drop down), only the exact name of the application role is recognized.…
-
Date Parameter should show Hijri calendar instead of Gregorian calendar
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): AAIS Global Description (Required): For KSA region when need the date parameters to show Hijri calendar as currently it shows Gregorian calendar Use Case and Business Need (Required): In KSA…
-
Incremental date logic for ESS job scheduling
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): TrueBlue India Inc., Description (Required): Incremental date logic data required through ESS job scheduling Use Case and Business Need (Required): Business need this to burst the report on…
-
Access purchase workflow approvals in OTBI
Hello, We are trying to build a procurement dashboard, and one of the key elements is the ability to see on who is the requisition/purchase order pending to be approved. However, there is no way to obtain this information as it belongs to the workflow approvals, and it is not part of the procurement data models available…
-
Retaining OTBI Parameters in OTBI Output
Description (Required): Parameters in OTBI are lost once we run the OTBI Report. We enter the values in parameters in OTBI Report and click on Submit. After submit, we see the output but the parameters are not visible. Therefore we need the parameters on top of the report output so that we can update the parameters again…
-
new subject area to provide payroll costing data to users that don't have access to HCM forms
Organization Name Portsmouth City Council Description We would like the ability to provide payroll costing reports & analytics to users that do not have access to the HCM forms e.g. my client groups. Use Case and Business Need currently this is not possible as to give this access to users you would also need to provide…
-
Password for SQL Server connectivity limit
Currently, it appears the database user password to connect Oracle Analytics Server to a SQL Server database is limited to 16 characters. Within our organization, we have a standard that all passwords be no less than 30 characters. Please consider adding this feature/enhancement to future versions of AOS. Thanks.
-
OBI Agent - Ability to customize/filter when Dashboard is Delivery Content
Description Current state, you cannot filter/customize the delivered content when using Dashboard with OBI. Recommend change to allow this, similar to use of Analysis with agent. Use Case and Business Need In current state, we have the technical ability to "customize" the content auto delivered via an Agent only if the…
-
OTBI - ability to create report include requisition "use" field
Per SR 3-33678849671 it's not currently possible to report on the requisition "use" field yet (see screen shot below). This is important to clients as it identifies path used when req is being created and can help in troubleshooting req approval issues (if they arise). Please review and vote up if you are aligned. Thank…
-
How to get the list of details from outstanding credit card transactions per employee?
How to get the list of details from outstanding credit card transactions per employee?
-
Hide ApplicationDB_HCM data source in BI data model creation
Description HI Team, With the elite roles like Application Implementation Consultant, BI Admin, we can query any table using BI Data model and see sensitive data like salary. We are looking to restrict this to unauthorized people even though they have access to write data model and allow only to authorized people based on…
-
OTBI - "Transaction Administration Real Time" should include Approver related fields (email, person
Organization Name Aperam Description Add "approver" name / person number / email address in this subject area so we send an automatique reminder to the HR who did not approve yet a transaction in the system Use Case and Business Need We want to send automatically a reminder to the HR who still need to approve a transaction…
-
OTBI Reporting - ability to save the parameters for a report
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): ASB Bank Ltd Description (Required): It would be great to be able to save the parameters entered when running custom OTBI reports Use Case and Business Need (Required): We have a number of…
-
Reporting on Commitments for History and Auditing
Need to be able to report on historical commitments (including internal/external and requisitions) at any point in time. Per research the PJC_COMMITMENT_TXNS is a transitory table and does not keep commitment information once the commitment has been lifted. Need to find subject area(s) and/or tables can be used to create…
