OTBI
Discussion List
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se… -
How to Reprice the Sales Orders after Pick ReleaseSummary: How to Reprice the Sales Orders after Pick Release Content (please ensure you mask any confidential information): We have a requirement to reprice the Sales Ord…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
Any OTBI Report/table to get Multiperiod Accounting Transactions AHCSDo we have any tables or oracle Reports BI or OTBI to get the list of Multiperiod transactions posted and future transactions other than table XLA_MPA_DISTRIBUTIONS.Chetan007 1 view 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 63 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 31 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 235 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 262 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 114 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…Prakash Maram 11 views 0 comments 0 points Most recent by Prakash Maram Reporting and Analytics for HCM
-
OTBI Report is working very slow when fetching the Assessment DetailsSummary: Hi Team, I am currently working on developing reports in OTBI, but I am encountering significant performance issues. The reports are taking an unusually long ti…
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 191 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
Need to calculate month on month attrition percentageWe need to calculate month on month attrition percentage on the basis of formula = (Attrition count of that month *100)/(Average of (Headcount as of first day of month a…Shaarif_Hussain 31 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 44 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 21 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
How to identify a requisition lines if negotiated flag is checkedSummary: Content (please ensure you mask any confidential information): We have some requisition where users checked 'Negotiated' which they shouldn't. This has created … -
I want to Extract in OTBI the 'Enable time limit' and 'Enable Score' Cols from the Assessment Page.Summary: Hi Team, I have requirement to built the OTBI Report to capture the below details in the OTBI Report. Below mentioned columns are check box enabled fields. Can …
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb… -
How to check Budget Reserved/Consumed against a Particular Purchase Order including its PRs/InvoicesSummary: Need to check the Budget reserved/consumed against a particular Purchase order, including its complete cycle which is PR, PO and Invoice. Using standard reports…
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Marketing - CRM B2B Customers Subject AreaSummary: Marketing - CRM B2B Customers Subject Area Content (please ensure you mask any confidential information): Hi Team, I am looking for details on "Marketing - CRM …Nidhi Chhajed 11 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…