BI Publisher
Discussion List
-
Payment Process Request Status RTF Templatein Payment Process Request Status RTF Template, Get_Variable working directly without declaring Set_Variable. Anybody experienced same in RTF? If I use Set_Variable syst…KISHAN BUSSA 3 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version …Diego Zegarra 31 views 1 comment 7 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany -
Tables for Audit Report Page Details that are under Tools Tab in UI PageSummary: We need to build a BI report that extracts the Audit Report Details under Tools tab as Shown in below image. Could anyone please suggest the tables that have th…Chandana Priya-Oracle 31 views 5 comments 0 points Most recent by Melissa Goodrich Reporting and Analytics for SCM -
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen…
-
OTBI report to pull purchase order issued from each punchout and catalogSummary: OTBI report to pull purchase order issued from each punchout and catalog Content (please ensure you mask any confidential information): Hi Team, We have require…Nidhi Chhajed 11 views 2 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 24 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed…
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…
-
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …SarthakRohilla 11 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for HCM
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does Oracle Fusion support Microsoft Unified Printer ServerSummary: Does Oracle Fusion support Microsoft Unified Print Server, Can we connect to a printer which is exposed on Microsoft Unified Server. As the client specifically …
-
Creating ESS job set's to parameterSummary: Hi Everyone, I hope all doing well out there! I have a BIP report, using which team is extracting output for 9 countries. now user is asking to automate it to a…VasanthaFusion90 21 views 4 comments 0 points Most recent by VasanthaFusion90 General Ledger & Intercompany
-
How to prevent approval or validation of invoices whose BUs are different between line and headerSummary: I would like to know how I could create a rule to prevent the approval or validation (preferably) of invoices whose Business Unit is different between the Invoi…FilipeFerreira_ 11 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
FYI notification needed for any approval or escalationSummary: FYI notification needed for any approval or escalation (T&E, PO, GL) that goes to A. Notification should be sent to B. Note: Team(B) needs to be informed only i…
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En…
-
Is it still available to use the ORA_ASSN_REC_COMPLETE_PENDING - LOOKUP CODE from HR_LOOKUPS table?Summary: Content (please ensure you mask any confidential information): I am working one report and i need to know all sub status for one learner. I used the following q…ClaudiaManea 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to Increase CSV Export Limit from AnalyticsHi, we have created some analyses and the related dashboards. We then made the analytics available in the Analytics section (the dashboards are very simple—for example, …Martina Di Battista 16 views 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Sales
-
Change Only HCM extract for Recruiting/Job RequisitionSummary: Hi Team, We have a requirement to send the Job Requisitions changes using the HCM extract to the third Party system. Kindly share the code pack if anyone had co… -
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 962 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss https://commu… -
How to enable horizontal scroll while creating/editing a xpt reportSummary: How to enable horizontal scroll while creating/editing a xpt report Content (required): Create a xpt report using data model having many columns, while trying t…Bhavna-Civeo 11 views 2 comments 0 points Most recent by PadmanabhamP Reporting and Analytics for HCM
-
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…Karthik Adiga-Oracle 1 view 1 comment 1 point Most recent by Sivasekar Narayanan-Oracle Reporting and Analytics for HCM
-
Need sql query to join between subledger and fixed asset and asset invoicesSummary: We are pulling the general and sub-ledgers for fixed assets and asset invoices in order to create a custom BI report for fixed asset reconciliation. Since we ar…
-
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 1 view 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Is there any way to send notification for the upcoming expiry courseSummary: Is there any way to send notification for the course which user has already completed and about to get expire course (60 days before expiry date) but that notif…