OTBI
Discussion List
-
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… -
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 9 views 2 comments 0 points Most recent by David Boudreau Reporting and Analytics for HCM -
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 21 views 7 comments 0 points Most recent by Jill Stanton Reporting and Analytics for ERP
-
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 …
-
AP invoice specialist cannot access to OTBI analysisSummary: Hi Guru, We have following two roles for our AP users, The users who is assigned specialist role where not able to see any record from our AP analysis report 1)…
-
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). …Victoire Bizieau 12 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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" …
-
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 5 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 42 views 4 comments 0 points Most recent by Jill Stanton Receivables & Collections -
OTBI report for Bank Account TransfersHi, I want to create an OTBI report for Bank Account Transfers - External Cash Transactions. I used the Cash Management - External Cash Transaction subject area, and I a…Abeshek VP 2 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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 91 views 5 comments 0 points Most recent by Velmurugan Palanisamy Sourcing -
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 …
-
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 760 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 12 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 32 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…
-
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…Shahid Qureshi 01 20 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM