BI Publisher
Discussion List
-
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to… -
Fetch balance values from Fast FormulasI have a requirement to fetch balance values based on input balance names passed to Fast Formula. I am using Balance Specific DBI's to fetch their values. When I hardcod… -
Record Limit in Payables Invoice RegisterSummary: What is the limit (Max number of Invoices can be pulled in) of Payables Invoice Register? Content (required): Client want's to know what is the maximum number o…Prateek Bajpai 54 views 2 comments 0 points Most recent by Kratika Sharma Payables, Payments & Cash Management
-
Lookup Type that stores raw completion status and previous event statusSummary: Hello, I need the lookup_type and lookup_code for the raw_completion_status and previous_event_status in WLF_EVENT_ATTEMPT_INTERACTIONS table. Content (please e…
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 303 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…RupaliGahalot 112 views 3 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Build reports for questionnaire templatesSummary: We have built evaluation, pre-enrolment forms. We can view individual learner response. How do I build a report to show this. I've never built a report before, …
-
Context sensitive DFF in LookupSummary: Actually i have done all the setup and Before i'm able to see the DFF value in lookup. My system got cloned from Prod. After performing all the steps as before …
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter… -
Expense Authorization along with expense report matched in Expense module reportSummary: Expense Authorization along with expense report matched in Expense module report Content (required): Expense Authorization along with expense report matched in … -
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 11 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …Brian W 54 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 32 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 58 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Regarding invoice approvalSummary: hi , for one supplier invoices before 2021 approval workflow is not trigerred . after 2021 approval workflow is trigerred . Could you tell reason behind that . …Eleti Mahender 21 views 3 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Unable to access BI report using REST serviceHi, When I try to access BI report from postman it returns as 400 Bad Request Thanks -
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 836 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue with converting UTC time to BRT timeSummary: When I run below SQL to convert time from UTC to BRT (America/Sao_Paulo), output is not correct. There is a difference of 1 hour in the output. I read somewhere… -
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 370 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
Table(s) contain POD Version and Last Refreshed DateContent Hi... I am looking for a SQL query to derive the last refresh date for a POD and latest patch level (ie 12A, 12C, etc). Thanks in advance for any tips. JRJoe Roberts-Oracle 887 views 15 comments 1 point Most recent by DhirajRathi Reporting and Analytics for HCM
-
MSC_BOMs_VSummary: When queried it results no data and when the code is viewed it says "undefine" Content (please ensure you mask any confidential information): Is this a bug that…Mike.Myers.CDIPRODUCTS.COM 11 views 2 comments 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for SCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Can we call external application from BIP ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Dunnings - How to exclude the invoices which have not yet passed the due date from the dunning letteContent Hi, In Oracle Fusion - How to exclude the invoices which have not yet passed the due date from the dunning letters for a customer? Thanks, Kanika Version 21CKanika Mahajan 96 views 2 comments 0 points Most recent by Lavanyaa Damodaran Receivables & Collections
-
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…Kirtee Jeetah-Naran 31 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Reporting and Analytics for ERP
-
Need to allow holds resolution routing for system invoice Hold codeSummary Need to allow holds resolution routing for system invoice Hold codeContent Hi, For our user case, we need to allow holds resolution routing for system invoice Ho…Mohamed jouini 254 views 4 comments 1 point Most recent by AmitGoel Payables, Payments & Cash Management