BI Publisher
Discussion List
-
BIP email's font appear diffrent within gmail than outlookSummary: Customized email's fonts appears diffrent Content (required): I'm designing a BIP template with the kind of rtf format. I'm designing one of the journeys OOB re…Peleg Puzaylov-Oracle 21 views 5 comments 0 points Most recent by Peleg Puzaylov-Oracle Reporting and Analytics for HCM -
can we create one certificate for course and specialization with same DM?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 226 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to hide parameters in csv output and change data formatHi All, I'd like to create a report which output type is csv. After the output file was generated, I found the parameters of report are included in the output file and o… -
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 23 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Why bursting from BI Publisher sends emails to 1 domain and not the other?Summary: Why bursting from BI Publisher sends emails to one domain and not the other? Content (required): I created a BI Publisher report having bursting object on it. I…Stefano_Mazzocca 51 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Source Table for Manage Common Options for Payables and Procurement:Summary: Need Help on Source Table for Manage Common Options for Payables and Procurement: Pls see below screenshot of the screen.. Content (required): Given the Busines…JSalarza 378 views 1 comment 0 points Most recent by Danieleeeeee-Oracle Reporting and Analytics for ERP
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_…Ankit_Bhadja 1.1K views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Oracle functions to calculate third quartileSummary: Content (required): Hello experts, we need to calculate THIRD QUARTILE for a set of employee salary amounts. The calculation should work in this way: For employ…Valerio Curzi 153 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…Nicola Petri 383 views 10 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 204 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
How to create a log file of invoices that were sent by email ?Summary: How to create a log file of invoices that would be sent by email ? Content (required): Hello I was wondering If you can share with me an SQL of the invoices tha…
-
Question related to Knowledge base ArticleSummary: We have a subject area "Article Summary Historical Subject Area" in that we are looking at a attribute "Article View" where it related to the number of times us…
-
How to initialize session based on username in Oracle cloud BIP reportsSummary: How to initialize session based on username in Oracle cloud BIP reports. If a Service user is running a report and has to initialize the report based on a parti…
-
Need to Convert PDF from word and merging more than one PDF documentsHi, we are planning to use BI Publisher of Oracle analytics cloud to print customer invoice out of a custom tool being developed in VBCS. we have a requirement where the…
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 11 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Is it possible to build custom reports retrieving data in more active workforce plans?Summary: Content (required): Hello experts, we need to build custom reports retrieving compensation components values and making analysis based on data loaded in several…Valerio Curzi 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to preserve the single space character in the report?Summary: In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the re…Maria Femia Bianzon 42 views 10 comments 0 points Most recent by Maria Femia Bianzon Reporting and Analytics for ERP -
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…Donald 220 views 4 comments 0 points Most recent by Chandra Kiran Ushakoela Reporting and Analytics for ERP
-
Application Composer tableHow to query custom objects in database - currently hitting HZ_REF_ENTITIES table which seems to store some of the record data, however not finding what table to join to…Michael A. Marthe 271 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Need information of HCM table which store multiple choice answers for any questioners?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Praveen D 62 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoicedSummary: Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue. Content (required): select p…Rudraksha Vishnu 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Can we change the attachment file name of Dunning letter . Default attachment showing as Output.pdfSummary: Can we change the attachment file name of Dunning letter . Default attachment showing as Output.pdf. Instead of Output.pdf we want to send filename as Reminder.…BibhuMishra 112 views 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 123 views 3 comments 0 points Most recent by User_Sathishkumar Sundaresan Reporting and Analytics for HCM