BI Publisher
Discussion List
-
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 7 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 43 views 7 comments 0 points Most recent by Larissa Meid Payables, Payments & Cash Management -
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…
-
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…Kimberly Showman 11 views 1 comment 0 points Most recent by UchihaItachi Reporting and Analytics for ERP
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C…KabirB 375 views 7 comments 0 points Most recent by Koteswara Rao Kandula Payables, Payments & Cash Management -
Bill management portal link custom template not workingSummary: The welcome email has a portal link, we have customised this to pick the value from a profile variable but the custom template is not being picked. Content (ple…
-
Blank line at the end of etext template output fileBlank line at the end of etext template output file.BASWANTH 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Learning report(Specilization,course,offering and activity details - data issue)Hi Team, Please find the attached report columns. https://us.v-cdn.net/6034893/uploads/BUBHSV0DMANA/specilization-report-columns.txt Could you please review them and let…
-
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…Nidhi Chhajed 51 views 5 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2K views 10 comments 0 points Most recent by User_QRDCE Reporting and Analytics for HCM -
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 951 views 12 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 251 views 5 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
is there a way to restrict the use of commas in receivables transaction line descriptionHi We are using Fusion Receivables , is there a way to restrict the use of commas in receivables transaction line description. Since the extract of transactions are sent…
-
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…Aseef Babujan-Oracle 11 views 4 comments 0 points Most recent by UchihaItachi Reporting and Analytics for ERP
-
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 71 views 2 comments 1 point Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled …
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 202 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM
-
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 111 views 4 comments 0 points Most recent by Koteswara Rao Kandula Payables, Payments & Cash Management -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 31 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 62 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…
-
cancel scheduled BIP jobs for inactive users in Oracle FusionSummary: We have users who are no longer active but have their scheduled jobs (including BIP) running. Is there any process to abort these scheduled jobs? Content (pleas…Chetan Banglorewala 1 view 5 comments 0 points Most recent by Chetan Banglorewala General Ledger & Intercompany