OTBI
Discussion List
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 51 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Ability to Drill down from OTBI to edit journal passing data access set on general accountingSummary: Deeplink on a column in order to edit the journal , also if the user is set on general accounting on a ledger different from the report row ledger Content (plea…GNCC33 283 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Date Paid is Current Date (the date the report runs)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The report is scheduled to run every 14 days which is also the Date Paid. How can I set…
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Actual Goal Names are not reflecting in the Analysis ReportSummary: We are trying to build OTBI Analysis Report with the following attributes from Two Subject areas: Person Number, Name, Position Name, Unit, Department Name, Man…sayeed_ahmed 41 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
ARGENTINA - SICORE. REPORTING OF WITHHOLDINGS IN ACCOUNTS PAYABLESummary: what is the structure that this report should handle according to your country reg Content (required): Argentina SICORE, what is the structure that this report …
-
deletedelete -
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 41 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 40 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Calculations with Sum Distinct for Pivot TableSummary: Hi! I am hoping for some guidance regarding a report I am making to predict retirement in my company. I built a formula to estimate the likelihood of retirement…
-
BI Report for Invoice in Receivables Manage Transaction PageHi Experts, Kindly if anyone knows from where in BI publisher we are able to see the template and data model used to view the invoice in Manage transaction page in Recei…Yuvraj S-Oracle 31 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Learning Records Subject Area - Fields missing dataSummary: A couple of questions - both relate to the Learning Records Subject area Content (required): 1) Assignment Start Date vs Enrolled on Date (Active Details folder… -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I Need a report showing pension contribution by employees and employersSummary: Does anyone know which subject areas I should use to get the pension contribution from employees and employers? Content (please ensure you mask any confidential…Isabela Radivoi 167 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 41 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
issues with customized OTBI report in HR Help DeskSummary: we are customizing an OTBI report for the hr help desk module but we are unable to extract the following info: - Which employees (which person ID) did a search …Gianfranco Fariello 41 views 2 comments 1 point Most recent by KMChris-Oracle Reporting and Analytics for HCM
-
general ledger - Balance real time subject area not showing hierarchy values for balancing segmentsSummary: In General ledger - Balance Real time Subject area - Balancing segment - There is no value coming in hierarchy (22nd level of hierarchy for balancing segment) t…Shreeya Jain 32 views 1 comment 0 points Most recent by Madhavi.Godbole General Ledger & Intercompany
-
I have a requirment to upload PDf file on released work order at header level using Rest API.Summary: I have a requirment to upload PDf file on released work order at header level using Rest API. I can find get attachment rest APIs but not able to find any API f…
-
How to check "Note to buyer" before submitting of Negotiation in OTBI ReportSummary: After submitting a "Purchase Reauisition" and before creating a "Supplier Negotiation", I would like to display "Note to buyer" using OTBI Report. Content (plea…
-
Can we report on deleted OTBI agents?Hi all, We seem to be unable to find a very important OTBI agent - at this point having gone through each folder we can only conclude somebody deleted it. Is there any w…Cora_Stanciu 11 views 2 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…
-
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t…
-
Which Subject Area does Default Maintenance Work Order type and Subtype from Asset page can be foundWhich Subject Area does Default Maintenance Work Order type and Subtype from Maintenance Assets page can be found?
-
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…Veera_CPS 111 views 4 comments 1 point Most recent by Veera_CPS Payables, Payments & Cash Management
-
sql query to extract standard cost details in FBDISummary: I need to extract item standard cost details for a particular valuation unit in the same format as FBDI templates for item standard cost and then upload it to a…
-
Manager only saves ratings (no submit) and then the OTBI report is run, are saved ratings fetched?Summary: Hi Peers, Our client has a requirement relating to an already live Performance Evaluation. They want to calibrate the rating (as an afterthought) Instead of add…S Shree 12 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM