BI Publisher
Discussion List
-
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?Summary: I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting Ref…User_2025-02-12-15-34-52-841 21 views 2 comments 0 points Most recent by User_2025-02-12-15-34-52-841 Subledger Accounting & Accounting Hub -
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can i create course due learning reminder notification.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H…MandeepGupta 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
what are the standard VAT reports available for UK?Summary what are the standard VAT reports available for UK?Content Hi Experts, Can you please provide me the list of standard vat reports available for UK? Thanks, Pradv… -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 155 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f…
-
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 32 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP -
BIP - Talent RatingsSummary: Hello, Good day! I'm running a report in BIP but facing performance issue when I'm trying to create multiple data sets. One data set for employee details and on…Hazel De Castro 31 views 0 comments 0 points Started by Hazel De Castro Reporting and Analytics for HCM -
Consolidated List of OTBI and BI Publisher Reports Posted (10 August 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 15 June and 10 August 2015: * Address Changes After Date * Marital St…Julian Challenger-Oracle 346 views 5 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 384 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 160 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
OTBI Training, Documentation, FAQs and moreContent Just a reminder that there is a knowledge article on My Oracle Support that provides a wealth of information on HCM Cloud OTBI (and also some on BI Publisher). Y…Julian Challenger-Oracle 539 views 6 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM -
Table which stores the descr (or Meaning) of ASSIGNMENT_TYPE AND PERIOD_TYPE field valueSummary: Hi All, I see the Per_all_assignment_M have the assignment_type as one/two letter words. Which table I can able to see the descr? Same of the PERIOD_type in Per…Prabhu Krishnamoorthy 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
"Total Amount" column in OTBI from Paysheet - ICMSummary: Anyone who knows the exact column name of "Total Amount" in OTBI? This is a field from Paysheets in Incentive Compensation. Tried other existing columns in the …User0901 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Not able to fetch resultsHi, When I run the OTBI report it keeps spinning but not able to view the report and this is happening suddenly any idea what could be the reason and how to fix itMohammed Rafi 31 views 5 comments 5 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)… -
How to include attendees on the business meals seeded Expense Report template ?Summary: How to include attendees on the business meals seeded Expense Report template ? Content (required): Hello Although the user captured the attendees on the busine… -
The BIP Catalog pageSummary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 21 views 1 comment 0 points Most recent by Dharmendra Shukla Revenue Management -
BIP Report - Performance & Potential RatingSummary: Hello, Does anyone know how can I create report out of this sample data by means of using BIP? Best Regards, Content (required): Hello, Does anyone know how can…Hazel De Castro 51 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 363 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…Gerardo Peluso 43 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to run a customised seeded bip report from the Report and Analytics folder/catalog folder.Summary: Greetings, Team — Is there a way to make the 'Open' hyperlink button enabled for a customised BIP Report? We customised the PO PDF Report for two different clie…User_2025-10-24-00-15-43-324 1 view 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM