BI Publisher
Discussion List
-
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F… -
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Is there any way to print an Expense Report programmatically (not manually from Expense Report page)Summary: Steps for Standard Functionality: -------------------------------------- 1. Go to Navigator > Me > Expenses 2. Select the menu for any report, click on Print 3.…
-
Font mismatch between RTF template and PDF outputSummary: Font mismatch between RTF template and PDF output Content (required): Hi Experts, We developed a custom template for the PO PDF report. We found font mismatchin…Venkatesan 231 views 9 comments 0 points Most recent by Rajesh Singh Reporting and Analytics for ERP
-
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Get rid of white space at the top of a tabular reportSummary: Has anyone experienced a large white space at the top of a tabular report. Please see attached screenshot. Content (required): Has anyone experienced a large wh…
-
Select All columns from multiple tablesHi All, How to select all columns from multiple tables in the BI Data model. select a.*, b.* from table1 a,table2 b I cannot execute above sql statement when both the ta…
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy…Julian Challenger-Oracle 319 views 8 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 334 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Is there a way to pull comments section off Requisitions and Offers into reports?Summary: Pull the Comments field from Job Requisitions and Offers into reports Content (required): Looking to be able to pull the Comments field from Job Requisitions an…
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…Kalyan Reddy 45 views 3 comments 0 points Most recent by Fabiana De Arruda Reporting and Analytics for SCM
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 161 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Primary Email in Oracle TablesSummary: Hello. Could you please advise which table contains Primary Email? I'm building a BIP data model using query below. There are email type and email address inclu… -
Passing parameters from a UI page to html opening BIP Report doesn't work anymoreSummary: Passing parameters from a UI page to html opening BIP Report doesn't work anymore Content (required): Hello Experts, I'm facing an issue when passing a paramete…Dario_DiFranceschi 51 views 4 comments 0 points Most recent by Dario_DiFranceschi Reporting and Analytics for HCM
-
Looking to update the Invoice Approval Notification template and need help finding the infoSummary: Looking to update the Invoice Approval Notification template and need help finding the information in Oracle Fusion. Our Finance Dept. wants to add the multi-pe… -
Where can I find the Manager Dashboard that Oracle demos?Summary Oracle consistently demonstrates a MSS dashboard during OLC sales material; is that BI object available to customers?Content Customers are consistently exposed t… -
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
Email-Bursting Without Split-ByWe have a requirement to send an email with details. The email body should have the details with table format. The query has more than one record and it should be printe…
-
Where to find employee W2 Box 1 and Box 5 Data?Summary: I have a report request for employee's W2 box 1 and box 5 values. Content (required): W2 Data in Oracle Fusion HCM Version (include the version you are using, i…
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
How to determine timing delay how long does it take for data to be committed to the audit tables?Summary: We receive ad hoc tasks from business every time there's a compensation refresh happening. This process contains updates in the Assignment and Salary Section of…
-
Oracle Cloud IP'sSummary: We need to SFTP a file to our vendor using BIP report. Vendor needs us to provide the IP's to whitelist on their end. Can you please advise where to find Oracle…Haritha Avuthu 51 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to change the "subject line" or "from address" details for Accounting Automation emailsSummary: Content (required): We have enabled GL accounting automation process in all our PODs. The issue we are facing is, all the emails from all the PODs are coming wi…
-
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…Manivannan V-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Overlapping timing of learnersSummary: Hi Team, Do anyone has some sample of report to allow Learning Specialist to see if the the same engagement of the same people at the same time ? I understand t… -
How the performance will be affected if multiple user run a BIP report at the same time?Summary: How the performance will be affected if multiple user run a BIP report at the same time? Content (required): If multiple users run the same BIP report at the sa…
-
How to align 63 Report Fields in RTF Report TemplateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 101 views 7 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales