BI Publisher
Discussion List
-
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
What are the control reports to be run on the fresh instanceSummary: We are going to start testing and want to run the control reports in the fresh instance. Could you let me know what are the control reports to be run. The modul…Lal11 33 views 3 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 155 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …SSS Song 102 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec…
-
how to change the hyperlink text in the workflow checklist tasks notificationSummary: I am trying to change the "More details" hyperlink to "Click Here". attached is the data model, xml output and rtf template screenshots any idea ? Content (plea…Shlomo Elnekave 11 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
hi all, by any chance can you point me to the join between per_person_names_f and CMP_PLANS_BSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 31 views 2 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 81 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
how to give user access to view invoices image from receivables UISummary: Business users are not able to see invoice image from receivables UI. But IF BI Administrator role is provided, then users are able to view image. We can't assi…
-
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area?
-
Create Accounting Execution Report Same as Accounting Automation?Summary: Our Accounting Automation report runs each night at 11:10pm and I am one of three who receive the email notification with the summary and the Automation Errors.…
-
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 167 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 55 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
BI publisher PDF corrupted error after upgrading to Chrome browser to 119.0.6045.106Summary Content (please ensure you mask any confidential information): After upgrading the chrome browser, we encountered PDF corrupted error for BI publisher reports. W…Maria Inocentes 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Questions about Maintain Chart of Accounts Hierarchies processWe recently discovered we had an issue with a custom BIP report that was built for us by our implementation consultants. Long story short, we discovered that any new com…MDeming 43 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Not able to include file type attachments in Invoice Account Coding Email NotificationSummary: Trying to customize Invoice Account Coding Email Notification to include all invoice attachments hyperlinks in the notification, but we are not able to get hype…Chowdari Malapati Monika 43 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Trying to customize Receivables Aging by General Ledger Account ReportSummary: We want customized report output in excel format, where sheet1 should contain the parameters passed, sheet2 with detailed info in tabular format with customer a…Chowdari Malapati Monika 33 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Report for Changes OnlySummary: We are currently not able to pull out a report with the last change done for a person in the system. Content (required): We have multiple reports in Oracle base…
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
Provide code for XLA_ACCT_ANALYSIS_RPT_PKG used in Global SLA Account Analysis Report in fusionSummary: Hi, We are working on Global SLA Account Analysis Report, and we want to know the tables and joines used in the data model. And also requesting you to share the…
-
Table for Job Profile ReportContent Hi, How do I get the Job Profile name attached to the job? Which table contains the same and what is the relation to Job table? Kindle help. Regards, Nivya Versi…Nivya Mathire 166 views 9 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 41 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
unable to get all the column values in Excel output in BIP reportSummary: Hi, When I run the BIP report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few col…Satish123 71 views 10 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 62 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM
-
ESS Job - "Print Receivables Transaction" enable UCM BurstingSummary ESS Job - "Print Receivables Transaction" enable UCM BurstingContent Hi Team, We have a requirement to send Print Receivable Transaction: Invoice pdf report outp…