BI Publisher
Discussion List
-
Query For External Record Learning Experience(Non Catalog Learning)Summary: I am unable to find below two fields to fetch a data from 'Record External Learning Experience' screen. Field1: URL Field2: Start Date (Under Completion Detail)… -
Print Receivable Transactions custom template is not showing for Credit MemosSummary: Print Receivable Transactions custom template is not showing for Credit Memos Content (please ensure you mask any confidential information): Hi All, We customiz…
-
-
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…Sushant95-Oracle 11 views 2 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 23 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
My goal is to generate hyperlinks within BIP report outcomes, linking them to attachments related toSummary: I intend to create hyperlinks within BIP report results that correspond to attachments for AP Invoices. Clicking on these hyperlinks should lead to the display …bhavana.sudanagunta 202 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 118 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…Hazel De Castro 61 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Error while running Receivables Aging by General Ledger Account Report; permission: 16578Summary: We created a custom role for users to view Receivables transactions and run various AR reports. When the user attempts to run the Receivables Aging by General L…hannah_barry 133 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
Payables Open interface rejects all records....The Transaction business category code isnt validSummary: We are uploading Bulk AP Invoices using FBDI, Payables Open interface rejects all records....saying ..The Transaction business category code isnt valid on the t…Raoof Ahmed 133 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas…BeachDreamer 281 views 4 comments 1 point Most recent by BeachDreamer Reporting and Analytics for HCM -
Is it possible to change image while loading the analytic?Is it possible to change image while loading the analytic?Alfredo 31 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…Tom John Bontoyan 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
Xml Tag names for "supplier email address" and "invoice line amount" fieldsSummary: XML Tag names for "supplier email address" and "invoice line amount" fields Content (please ensure you mask any confidential information): We are customizing th…bandaru mohanrao 41 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec… -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 138 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are …
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
Generate CSV file output with column names from BI publisherSummary: Is there a way to exclude column names from printing on a csv file output using BI publisher? I created the DM and report and the csv output has the required da…Aaron Asher 142 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Query for Sales Order Contact at header and line levelSummary Query for Sales Order Contact at header and line levelContent Can you please share the query to get the customer Bill_to and Ship_to contact details at header an…AnishRV 24 views 2 comments 0 points Most recent by Kishore J-Oracle Reporting and Analytics for SCM
-
Customised Create Customer Statements for multiple templatesSummary: Customised AR Customer Statements for multiple templates Content (required): The requirement is for the Customer Statement to print the correct logo based upon …
-
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
The void has to be printed at the end after the payment total for all overflows.Bulk invoices are to be paid via check and the invoices are extended beyond one page, there is an obvious overflow. The expectation on payments is that it records the me…AaronJai 51 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Need to know Table names to get the offerings/Learning Initiative details from Learning Module in OrContent Hello All, I am developing a Report from Learning Module in Oracle Fusion HCM. I want to know the below details ,Please guide : 1) In OTBI Report: - i am using W…kanchana venkatasubramanian 1.6K views 3 comments 0 points Most recent by Kiran-HCM-Oracle Taleo Learn
-
Total row should have same color according to the stage respectivelySummary: Total row should have same color based on the stage. Kindly check the screenshot. Content (please ensure you mask any confidential information): Version (includ…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How/where can I get a glossary/dictionary of language pack translations for all UI text?Hi We are in process of implementing HCM & Learning cloud for 5 countries in Europe. As part of the implementation, we have a couple of custom reports (BIP) to be genera…Jayant Ankur Kujur 61 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Run report privilege not found after creating a job definitionSummary: I created a job definition to run a report by schedule process however, I am not able to find the privilege to assign to users in order to grant them access to …