Reports
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 19 comments 22 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.4K views 30 comments 31 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP
-
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow…Rebecca_Edwards 2 views 0 comments 0 points Started by Rebecca_Edwards Reporting and Analytics for HCM -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 251 views 16 comments 0 points Most recent by Archana Prasad Reporting and Analytics for HCM -
Export out list of reports/book from FR and ReportSummary: how would we export out the list of reports/book from reports and from finance reporting? Content (please ensure you mask any confidential information): Version… -
How to invoke a REST OIC integration from BIP by a data source where OIC is in Fusion domainSummary: We are invoking a REST integration from BIP by a data source using Basic auth which is working fine in our Dev environment. But In our Test environment oic is c…Pasad Elugoyi-Oracle 52 views 1 comment 0 points Most recent by Ahmed-Hisham Identity and Access Management
-
Administrator and role report from Oracle Cloud InfrastructureSummary: I am required to provide my InfoSec team with a report of Administrator users and their role in Oracle Cloud. Please advise how best to achieve this Content (pl…David Boudreau 21 views 3 comments 0 points Most recent by Ahmed-Hisham Identity and Access Management
-
In Bursting How to get email bounce back if email address is incorrectDeveloped email bursting functionality for users. However, when an email address is invalid, we need to capture the bounce-back. In the current design, emails are trigge…
-
Link learning evaluation questionnaire to learning assignment in Bi publisherHello, I have a requirement in BI Publisher in wich I need to extract the answer of a specific question from the offering evaluation (in learning) My base is that, howev…Sara Suleiman 11 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tablesSummary: Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tables. Content (please ensure you mask any confidential information): We have established a link betwe…ViswanadhK 23 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS…
-
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…Mallikarjun Sheshagani 12 views 1 comment 0 points Most recent by John Lyndon Amemita Reporting and Analytics for ERP
-
It is possible to add shared reports in report packages?How can we add shared reports from Planning PBCS in Report packages embebbed content (Narrative Reporting)? We don't want to make copies every time we update reports in …
-
Fusion Data Intelligence - Data inconsistent across delivered workbooksSummary: After converting workers, I tried running the delivered workbooks. I am getting different data in them. The Team composition overview shows a total headcount of…JaspreetKapoor 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.8K views 7 comments 2 points Most recent by Shubham Kadam Reporting and Analytics for HCM -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 43 views 3 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
OTBI HCM Workforce Profiles and Counts (counts returning O's only)I thought this would be simple OTBI report, but am stuck on getting an accurate count (returns only zeroes). It should output active Profiles, their associated Job Codes…
-
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Reference Variable in text column of a reportSummary: So, creating some reference variables in excel variable sheet that do not exist in EPM. Can I reference these in text rows / columns using text formula in a rep…
-
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 41 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Time out setting in Data ExchangeHi team! We have a situation that it was timed-out in Data Exchange but the report job is still running in Oracle GL. The data load rule runs a out-of-box report in Orac…GaryYip-Asc 11 views 2 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 11 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 2.7K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Set last year as default value on BIP parameterSummary: Content (please ensure you mask any confidential information): I have a BIP report with parameters. One of parameters is year. I know that last day of last year…Stefano_Mazzocca 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Specific user assigned with Payroll Administrator cannot view the Reports tab in UI Dashboard.Hi Experts, Does anyone have experienced that there is a specific user which was assigned by Payroll Administrator role but cannot view the Reports tab when clicking the…