BI Publisher
Discussion List
-
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…User_GFPRZ 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
FBDI Fails to import Data containing Double Quotes(")Summary: FBDI Fails to import Data containing Double Quotes("). We are loading Items through "ItemImportTemplate" FBDI template. In item description we have data like WO…Lucky Sharma 221 views 8 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Auditing changes of VAT codes between PO and AP PO InvoiceSummary: Report of differences of VAT codes between Invoice lines and matched PO. Content (required): I am trying to create a report of any invoices that have a differen…User_2025-02-10-15-12-48-631 21 views 1 comment 0 points Most recent by Simona Ipate-Oracle Payables, Payments & Cash Management -
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?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 References. …User_2025-02-12-15-34-52-841 21 views 2 comments 1 point Most recent by User_2025-02-12-15-34-52-841 Reporting and Analytics for ERP
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv…Aloka Bhattacharya 568 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod InstancesSummary: Please suggest, After 22A upgrade we are not able to delete BI email server from Oracle Cloud Non-Prod Instances Content (required): After 22A upgrade completed…User_J7H19 32 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
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 12 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 160 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 31 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 344 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 373 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 163 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 538 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…