BI Publisher
Discussion List
-
Can we write PLSQL in BI Data Model ?Summary Is PLSQL supported in ERP Cloud ?Content Good people, Can we use PLSQL in BI Data Model ? If so is there any documentation on the same ? Thanks, SoumyaSoumya Prakash Parhi 108 views 4 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Do we have any Report giving the details of miscellaneous receipts in Oracle Fusion?What is the name of the BIP report giving providing details of the miscellaneous receipts in Oracle Fusion?KanikaGupta 41 views 2 comments 0 points Most recent by Vivek Mandowara-Oracle Receivables & Collections -
XML tag in RTF TemplateSummary: Team, We have developed one extract. The data is getting appeared in XML. But in the output file, its not getting appeared. Any idea, how can we get Business Un…
-
table which stores the value of "Automatically assign payment method to all payees" under Usage rulePallavi S 191 views 10 comments 0 points Most recent by Lori K-Oracle Payables, Payments & Cash Management
-
Unable to view xml tags in RTF templateSummary: Content (required): Hello all, I'm facing difficulty in editing old custom reports and seeded reports since the XML tags are not visible as they should be. For …Sushan Peiris 333 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
HELP: SQL Query from Fusion AR Transactions and Tax detailsSummary: Hi gurus! I need a query to extract the detailed data of the Transaction and the details of the Taxes calculated in the respective invoice type FUSION AR transa…Marcos G Soares 5.9K views 4 comments 0 points Most recent by Marcos G Soares Receivables & Collections -
Lookback through HDL after getting dat file as result of hcm extractSummary: We are creating probation automation in that we are linking bip report to hcm extract and output of that hcm extract will be hdl file and we want to trigger hdl… -
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…Cesar Saveedra 61 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Need recommendation for Printer Model for Label Printing for a Manufacturing ClientSummary: Hi Team, we are trying to find recommendation for Printer Model for Label Printing for a Manufacturing Client. Any help you can provide would be really helpful.…Abhilash K - Deloitte USI 11 views 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Benefits Report Etext template question?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Extract Comment after Hiring Transaction or other transactionSummary: Extract comments after hiring transaction Content (required): Extract comments after hiring transaction as show in the image Version (include the version you ar…teresa.marciano 1 view 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM
-
How to identify auto completions on Courses/OfferingsSummary: Finding a way to identify autocompletions on Courses/Offerings from db tables and UI. Content (required): Hello experts, Is there any way to identify autocomple…User_2025-10-24-00-19-49-011 42 views 1 comment 0 points Most recent by Pavalean Silviu-Oracle Learning
-
Need to fetch 'To Be Created' status tasks for strategy in CollectionsSummary: Can anyone help me in fetching the tasks data which are having 'To be Created' Status for a given strategy in Oracle fusion Collections.Ramya_30395 31 views 0 comments 0 points Started by Ramya_30395 Payables, Payments & Cash Management
-
OTBI - Need Specific Assignment History along with complete salary historySummary: Hi , Client wants specific assignment history like Job Change, Dept. Change, Status change along with complete salary history. Able to get it but the salary his…
-
Would anyone with experience with OTBI be willing to serve on a panel with OATUG ERP CLoud SIG?Summary: I am the VP of the OATUG ERP Cloud SIG who is hosting a panel in September called " ERP / HCM Cloud: OTBI, Third Party – lessons learned / improvement opportuni…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Started by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Performance Management Eligibility ProfilesContent Hi All, I am unable to find the table names for "Manage Eligibility Profiles" and "Profile Criteria". Please finds the attached screen shots for your reference a…
-
How to display multiple values in seperate columnsWe're creating a report with employee data and part of the report are e.g. e-mailaddresses. When e-mail type is part of the report, the result is multiple lines, but we …Wouter.Schaap 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 936 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
BI Publisher Date parameterSummary: How can I format a date parameter to a TZ string? Content (required): Which variable should I use to populate a date parameter with 2023-03-10T00:00:00.000+05:0…
-
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 262 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the…
-
How to attached Invoices to Payments Remittance Advice Notification via EmailSummary: The accounting team is requesting to attach the invoices to the Payments Remittance Advice Notifications sent via Email Content (required): We have a custom pay…Patricia Gonzalez 71 views 3 comments 0 points Most recent by Patricia Gonzalez Payables, Payments & Cash Management -
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 41 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 376 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Error after adding another subject area to an analysisSummary: I built an analysis based on Workforce Management - Worker Assignment Real Time. Now I need to add a column from Worker Management - Person Real time. When I di…
-
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ…
-
how to report on job offers that are pending for approvals using workflow tablesSummary: we need to cover and track all job offers that are pending for approvals and who is the next approvers! I need to create a report covering this topic.. for the …Ayoub AFRASS 101 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 326 views 3 comments 0 points Most recent by Catherine Myrand Reporting and Analytics for ERP