OTBI
Discussion List
-
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add… -
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
OTBI Workforce Management - Person Real Time - Person Work Permit "Checked By"Summary: Adding "Checked By" to a work permit report severely degrades performance. Though the report will run when prompted on a single department, it times out when ru…Stephen Jones 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Update permission of report with custom roleSummary: We want to limit the visibility of some reports only to specific user roles. We tried to add permission but we are not able to see the custom roles. We can add …
-
Which Subject Area is used to access Relationships on Items or ChangesSummary: I am trying to build an Analysis that pulls the relationships of an item or a change. Content (please ensure you mask any confidential information): I am using …
-
Area of Responsibility subject area does not return latest changeSummary: We created a simple analysis to return AOR but do not get the latest change. Does the subject area return the same values as what's seen in the UI Content (plea…David Boudreau 2 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
Not able to run Transaction register for the duation of one monthSummary: We have 300K transactions per month and OTBI transaction register is not able to pull the data when we execute the report for one month. We are able to get the …Subbareddy Kandala 41 views 4 comments 0 points Most recent by Jill Stanton Receivables & Collections -
Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPASummary Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPAContent We have to give demo to your client on basic understanding o…User_2025-02-10-05-51-05-868 102 views 5 comments 0 points Most recent by Velmurugan Palanisamy Sourcing -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 805 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Merging Multiple PDF Attachments as Additional Pages in a Single PDF Output BIP ReportI am working on a BI Publisher report in Oracle Fusion and would like to understand whether the following requirement is technically feasible. For an AP Invoice, there m…User_HRWJI 22 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Query dropship and receiptsSummary: Query dropship and receipts Content (please ensure you mask any confidential information): Hello everyone, I need a query to associate sales order lines with th…
-
OTBI dashboard row count limitSummary: I have a dashboard in OTBI that, depending on the user input prompts, may produce more than 500 lines of data. There seems to be a row limit of 500 that I canno…
-
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
How to create OTBI Custom Subject AreaSummary: While creating OTBI custom Subject Area, how to know which primary object is for the specific table? Content (please ensure you mask any confidential informatio…
-
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo… -
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
Restrict line manager access to report on direct reports DOB and Address InformationSummary: Hello, We don't want our line managers to report on their direct reports DOB and Address information. We tried to use data security profiles to restrict access …
-
Parent and Child Assets Appearing on OTBI ReportAn OTBI query was created for Fixed Assets and it's not pulling in newly created assets (parent and child) as long as fields, Asset Book or Major Category, are on the qu…
-
Candidate Extensible Flexfields recruiting for Job Application specific candidate profileSummary: Hello - 26A release the ability to report off Candidate Extensible Flexfields in OTBI subject area - Recruiting - Recruiting Real Time under the Candidate > Can…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Trade Reference Letter aka Credit Reference Letter - Available?Does Oracle have functionality to generate a trade reference letter aka credit reference letter? If so, from which module? I am not asking about a letter of credit but i…