BI Publisher
Discussion List
-
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 91 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the … -
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…RenzelkeithCoquia 96 views 6 comments 0 points Most recent by makarandamondikar Reporting and Analytics for HCM
-
Calendar year is not populated in 1099 ReportSummary: Calendar year is not populated in 1099 report output Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code …Surya01 121 views 4 comments 1 point Most recent by Jeff Rich-Terillium Payables, Payments & Cash Management -
SQL query statement to get all unaccounted transaction in AR with full GL StringSummary: Require query to extract all unaccounted transaction in AR with full GL String to review all incomplete Invoices (transactions), credit memos, and on-account cr…Rajesh_BR 2.8K views 1 comment 1 point Most recent by Veronica Stefan-Oracle Receivables & Collections
-
PO Change order History TableSummary SQL/Table to fetch Purchase order change historyContent Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was…Sahil_Makhiza 1.5K views 7 comments 0 points Most recent by Anjana Das-Oracle Reporting and Analytics for SCM
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 41 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 632 views 7 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 41 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
BI Publisher - Filter Action NameSummary: I have a SQL query that was created by our vendor. I am still a beginner in using SQL so I am seeking assistance in how to filter the report to pull certain act…
-
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 71 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on QuestionsSummary: Hi Experts, Can we built a report on questions available in Learning Assessment subscriber to indicate who has changed questions and date/time of change ? Conte… -
Hi, I hope everyone is doing well. I need help to pull every column from Oracle HCM (BI Query) .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Karthi 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI?User_2025-01-25-03-18-49-935 97 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
Manage IBAN with REST APISummary: Content (required): Hello everyone, We are having issues using the REST API to add an IBAN for a waiting employee/worker. In particular, we have developed a cal…
-
Creation of HCM Learning BIP data model - missing fieldSummary: Un able to locate colleague details when building BIP data model Content (required): We are about to go live with Learning Observation Checklists and we have no…
-
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 333 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
How start with Triggers with BI reportsSummary How start with Triggers with BI reportsContent Hi Team, Can someone advise how can use Triggers function in BI reports. Any white paper or Video training to use …User_2025-02-01-03-43-13-079 56 views 2 comments 0 points Most recent by Raghavan p-Oracle Taleo Learn
-
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require…
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…Venkatesan 41 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP