OTBI
Discussion List
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says … -
Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi…
-
Set different hyperlinks for different languages with Page ComposerContent Hi all, we have the following problem: We have customized the "Request noncatalog item"-page. Therefor, among other things, we have insterted a hyperlink that re… -
How to move reports under project modulesSummary: I can find some reports in the project management function of the project management module, but I want to move them to the cost function under the project mana…
-
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
V3 Seniority date pulling old assignment detailsSummary: We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Per…Sreeraj Kavallore Sujith 11 views 2 comments 0 points Most recent by Sreeraj Kavallore Sujith Reporting and Analytics for HCM
-
Help Finding Training "Start Date" Field or Table in Oracle DBWe’re trying to report learner states as Not Started, In Progress, Completed, and Past Due. Currently, we can only show Not Completed, Completed and Past Due reliably. T…
-
Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time"Summary: Incorrect Invoice Amount when using OTBI "Payables Invoices - Transactions Real Time" Content (please ensure you mask any confidential information): Hi - has an…
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 161 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
How to Add Menu to run custom report in Action>Create document of Manage order in fusion sales orderRequirement : Need to Run Custom Sales order report by adding extra menu to Manage order —> Create Document. Attaching screenshot for reference.
-
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl…Gail Langendorf-Oracle 389 views 15 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 33 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not …Rajib_Samanta 311 views 20 comments 0 points Most recent by Jacqueline Mellonas Reporting and Analytics for HCM -
Help finding the audit product id for middleware applicationsIn order to call the API endpoint /fscmRestApi/fndAuditRESTService/audittrail/getaudithistory you have to pass "product". The products for regular fusion modules are eas…
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
what is the expected behaviour in total balance of a parent, if hierarchy is changedSummary: We have a scenario of Hierarchy change. and we need to know what balance should show in the parent level before hierarchy change and after the change Content (p…
-
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 1.8K views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 21 views 8 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
How too identify actual hours spent by each employee on each Work Order Operations from OTL/PayrollHow too identify actual hours spent by each employee on each Work Order Operations (WIP). Where to get what employee is charged how many hours on what elements (Payroll … -
Scheduling OTBI report to store report output daily in sharepoint locationSummary: Scheduling OTBI report to store report output daily in sharepoint location where user can access directly instead of downloading it seperately from report Conte…
-
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 41 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany -
OTBI report with export where it shows only 2 Lakh 50 thousand records in export at maximumCX Sales: In OTBI Analytics, there is currently a record extraction limit of 250,000 records. This restriction is not meeting our reporting requirements in certain cases…Rohan Bhadani 22 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales