-
I have enabled descriptive flexfield for expenses based on expense type selection
I have enabled descriptive flexfield for expenses based on expense type selection for 2 expense types to display the same value set(free text) to capture values captured in another system. I am seeing 2 values for the same field in the subject work area of expense transactions realtime report. . If I add 1 field, i can…
-
Dunning letters seeded report questions on SendDunningBatchProcess report
I am new to Fusion and trying to modify the report and/or data model for the Dunning process. I see 3 issues so far: Account Number column is blank even though when I set up a separate query from one of the data sets, it is not missing (q_payment_history). The grouping/repeating section is on Location - which at least in…
-
Sign In Sign Out Audit report in Oracle Fusion
Summary: Hello, We have requirement to extract User Sign In, Sign Out and IP Address details through Oracle BIP/OTBI reports. Is there any Seeded report available in Oracle fusion for this purpose or are these data being stored in any of the tables? We got a REST API from Oracle for this but our business users need a…
-
Hide Subject area and catalog folders which are not needed
Hi All, Can we hide the subject area while creating any new analysis in OTBI which are not relevant or client has not bought the license for that module ? Similarly , can we hide the catalog folder too which are not needed . Regards Ankur
-
Budgetary Control Results Report by Transaction
What are the tables that contain transactional information pertaining to budget control data? Could we have query of "Budgetary Control Results Report by Transaction" report?? We need all the transactions related to a project in a budget.
-
Oracle Fusion Budgetary Control Transaction Subject Areas.
Hi, I use the budgetary control transaction subject area to show a transaction with purchase order transaction type. I want to display the item number of the purchase order transaction but I cannot find the column in the budgetary control transaction, so I want to get the item number from purchase order subject areas. But…
-
OTBI Fields translation spreadsheet to BI Fields
Hello! I have an outdated version (19C) of an excel spreadsheet of OTBI Subject Areas where you can find the column name/table in BI Publisher. Cover Page tab is titled Oracle HCM Cloud View HCM Subject Area-to-Database Mappings Release 13 (19C). Does anyone know where there is an updated version? thank you! Lauren
-
Where to find Taxable Benefit, Associations, Tax Reporting Unit, Effective Start date
Hi, I'm attempting to extract the Effective Date of the Tax Reporting Unit in Associations for a Taxable Benefit in OTBI. I'm using Subject Area Payroll - Calculation Cards Real Time and have selected virtually every Effective Start Date and Start Date field but nothing is returning my specific date for a chosen employee.…
-
OTBI: How to categorize Front Loaded Accrual Balance and get the employee Headcount
I have a requirement to get Headcount of the employees based on Annual Leave Accrual Balance where it should be categorized like 0-5 and 6-10 and 11-15 and 16-20 and >20. Like how many employees have the accrual balance between 0 to 5 and how many employees have the accrual balance between 6 to 10 and how many employees…
-
Disable auto run in OTBI analysis
Hi Team, OTBI analysis report running automatically without giving parameters and getting results which creates confusion to business/user. So could you please try to help, is there any option to disable auto run which means don't run reports automatically on initial page entry. Thanks, Uday
-
OTBI Dashboard Prompt Timestampadd Formula for Default End Date Covering through EOD 11:59:59pm
I needed to default the begin and end date dashboard prompt for First Day of Previous Month through Last Day of Previous month using the following timestamp formulas respectively: First Day of Previous Month: TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))…
-
How to get the Take-Home Pay (Net Pay) of EMP in Oracle HCM
I am working on generating reports related to Take-Home Pay (Net Pay) in Oracle HCM, which is the net amount of income a worker receives after deductions (such as taxes, benefits, and other contributions). Could someone guide me on the best way to retrieve this net pay amount ?
-
Why is the modified date changing on the seeded OTBI reports?
Hi, I have noticed that modified dates on the seeded OTBI reports are changing. I do know that whenever there is a patch applied to the instance the modified dates may change, but apart from patch dates I am seeing different dates as modified dates on the OTBI seeded reports. I am pretty sure no one is going in and…
-
"sensitive data access audit real time" subject area does not show results
We are recently searching for audit information and found the subject area "sensitive data access audit real time", however, no results are shown.I searched the documentation and the required role is IT auditor, the users who are trying to use the subject area have that role assigned.Has anyone managed to use that subject…
-
conditional formatting in RTF for duplicate
Summary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any confidential information): Say we have a report where supplier number 123 is present in two different rows. We'd like to highlight both rows with yellow…
-
Data Model with single parameter not returning sql query results
i am trying to create a very, very simple data model, to turn into a bip report, that contains one parameter. the data model query works independently of the parameter (when the parameter is not defined and is not part of the sql query), but does not work when the parameter is added. thank you.
-
Replace function is not working in OTBI Dashboard Prompt
Hi Team , we have created dashboard prompt where we have two parameters . Parent department and Child Department. Parent department is sql result type and have presentation variable defined as R1. Parent department is multiple choice enabled. Now child department is dependent on R1 input so here is query we are trying to…
-
BI FTP Server setup screen missing Test connection button
I am trying to 'Add Server' under Manage Publisher > FTP. The screen allows me to input all the details but 'Test Connection' and 'Apply' buttons are missing. I have employee and BI Administrator roles assigned to my user. What could be missing? TIA
-
Report 2x - 5xing values when using the hierarchical tiers
I'm having issues trying to get the right data when using the object 'Level 22 Value' in Natural Account Segment under the General Ledger - Transactional Balances Real Time subject area. If I use the Natural Account Segment - Value object, the amounts DO NOT get duplicated, but Natural Account Segment - Level 22 Value DOES…
-
Display of Total Row Cell at the Top of the Data Table
Is it possible to display the Total Row Cell at the top of the table instead of last row in the data table. Currently, there are only 2 options displayed when hovering on the Show tab (one without any Total, and one with Total Row at the bottom). I am looking to see if this can be moved to the top in any way? We're trying…
-
Oracle Procurement Cloud BIP Report - Does trigger require parameters unique to the trigger SQL?
Summary: Trigger SQL returned no data when sharing the same parameter with the report logic. Content (please ensure you mask any confidential information): We are using a trigger for a scheduled BI Publisher report to skip the report run when no data is returned by the trigger SQL. We have 2 parameters that are used by…
-
How to use multiple aggregates In OTBI
Hello, I am brand new to OTBI, and am having a little bit of difficulty providing the analysis that my business is requesting of me. The end result should look like this: I am using the Workforce Management - Assignment Real Time Subject Area for the Vertical (the top level ADMIN), as well as the Department (next level in)…
-
Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)
Dear experts, I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to results table in analysis, not able to proceed further.. Please suggest. Error details: (Error during query plrocessing (SQLExecDirectW).) Attached the…
-
Where can i find incumbent details dates allocated in position through Subject Area OTBI?
We created BI using the subject area” Workforce Management – Position Real Time” , but don’t find the “Position Entry Date” and “Position Exit Date”
-
Workforce Management - Worker Assignment Real Time: pulling Active and inactive assignment statuses
How to get the current assignment status of worker using "Workforce Management - Worker Assignment Real Time" , it is showing both inactive and active assignment statuses of active worker as of today(especially in case of global transfer).. attached cataglog and excel with sample data..…
-
OTBI - Exported XML Data Model is not show in lower case
Hello When exporting a report in XML format through BI, the XML tags are in upper case and not lower case. Please could you confirm if this behavour system?
-
How do you add department name to the new Redwood ChangeSalaryReport RTF template?
With the new 24D redwood update, the Change Assignment, Change Position, etc. transaction rtf has the department list in the notification. However, for the Change Salary/Administer Salary transaction notification, the department name field is not in the data set or in the RTF. How do we update the rtf and data set to…
-
Need to get referrer Job Title and Referrer assignment status in OTBI
We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker person number and worker person name etc.. and now the customer wanted pull other two columns referrer Job Title and Referrer assignment status to this report. Would…
-
Data Limit/size when we use BIP Report by calling SOAP Web Service in Fusion OIC layer
We are planning to Use BIP query to get the data from Fusion Order Management and Receivables by Sales order within OIC integration. We are storing batch number in ATTRIBUT4 column of Invoice line table, for example 2000 AR lines will have the same batch number and If we pass Batch number from OIC so we are expecting…
-
Banner on Reports & Analytics page
Hi , We have noticed a new yellow banner at the top of the 'Home' page in all our environments on Reports & Analytics page since it got upgraded to 24D stating "The Marketing Segmentation and Scorecard features are deprecated and will be removed in a future release." Can anyone help with the impact it has and how it…
