BI Publisher
Discussion List
-
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 151 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 382 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 203 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 11 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 41 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 224 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 274 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 61 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 11 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 101 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 122 views 3 comments 0 points Most recent by User_Sathishkumar Sundaresan Reporting and Analytics for HCM
-
Effort for In Progress Offerings/ActivitiesSummary BIP Table for Effort in In Progress Offerings/ActivitiesContent Hello! I am searching for Effort hours in In Progress Offerings. The TOTAL_ACTUAL_EFFORT column i…
-
Actual Effort Attempts ReportSummary Tracking report on self paced activities with the actual training effort for every attemptContent Hello there, We need a tracking report on self paced activities…
-
Add invoice tax lines on the separate remittance adviceSummary: Unable to find data model to customize separate remittance advice report Content (required): We need to add invoice tax lines on the separate remittance advice …
-
Is there standard report for movement transaction Purchase requisition until invoice and paymentSummary: the standard report for transaction since PR until payment in one report Content (required): Purchase requisition, Purchase order, Receiving, Invoice and Paymen…MihirS 11 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Has anyone got any tips and tricks on how to align the completion certificate properly?I have the logos, the graphics and it all looks good in Word. But uploaded onto BI and then downloaded as the certifcate results in all the graphics and fields being com… -
Implementing Fusion Security in SQL-based BI Publisher Data Models for custom objectSummary: We need to implement Fusion Security for custom object SQL query Content (required): We have a custom object and we need to achieve same security applied by CSA…Rana Alwohaibi-Oracle 81 views 4 comments 0 points Most recent by Rana Alwohaibi-Oracle Reporting & Analytics for Sales
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Is there standard report temporary prepayment and PermanentSummary: Any standard report to list down the temporary prepayment and permanent prepayment Content (required): list temporary prepayment, list permanent prepayment Vers…MihirS 11 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
How to add Cash Management application under "Map Reports to Work Area" taskSummary: How to add Cash Management application under "Map Reports to Work Area" task Content (required): We have requirement to create new OTBI dashboard for Cash Manag…SuryaRaju 31 views 2 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Limitations on number of Invoice lines that can be printed / generatedSummary: Business has a requirement to print Aggregated Invoice via ESS Scheduled Process/ Reports Business wanted to know if there would be a technical limitation on th…John Angelo Galang 12 views 0 comments 1 point Started by John Angelo Galang Reporting and Analytics for ERP
-
tables for state tax and local tax setup in hcm cloudSummary: looking the tax class,tax_type,max_gross based on the tax class Content (required): Version (include the version you are using, if applicable): Code Snippet (ad…