BI Publisher
Discussion List
-
AR Print Receivables should send invoice pdf file and attachments seperately to SFTPOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte USI Description (Required): … -
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…TestUser35 1K views 4 comments 0 points Most recent by L.G.M Manikanta Reporting and Analytics for HCM
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
How do we split the invoice and supporting attachments into separate files in Print ReceivablesCurrent State : Invoice and supporting attachments are sent as one file to the customer from the client when they run the Print Receivables Job in Oracle Fusion Requirem…
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Add parameter to Seeded report- Statement Generation data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 1 view 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
what is the relevant table for ap_batches_all table in oracle fusionwe have AP_BATCHES_ALL table in oracle fusion, but we don't see any data in table . Is there any relevant table for ap batchesHarshitha S Motagi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 721 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP
-
Equivalent FUNCTION (per_bipntf_utility) for XPATH QuerySummary In Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE) and advised to replace XPATH …Sandeep19rm 1.5K views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM -
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
The selected analysis object doesn't contain a list of people to assign the learningSummary: I have created a very simple BI Report, which includes person_id, Display Name and Job Name. I have applied a filter on the Job Name field to limit the data ret… -
what is the XML Field for file modifier in payment file ACH formatwhat is the XML Field for file ID modifier in payment file ACH format for Bank of America. Attached is the bank specifications.Harshitha S Motagi 11 views 0 comments 0 points Started by Harshitha S Motagi Payables, Payments & Cash Management
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…Swati Rana2805 11 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 14 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to center align a custom bip notification with an rtf templateHello, Can anyone tell if there is a possible solution to center align a custom bip notification in the user's end. We are using an RTF template. While viewing it on the…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 258 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM -
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is Reginal information for Mexico field stored in GL_INTERFACE Table?Summary: We have a requirement to upload journal lines under Reginal information for Mexico with UUID but we are unable find the exact column from GL interface, Is there…Sreenivasulu Donka 81 views 2 comments 0 points Most recent by User_CWYF6 General Ledger & Intercompany
-
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi
-
Receivables Billing History Extract - Unable to add custom parameter in BIP Data modelHello Experts, We have a requirement to add an extra parameter (Customer class) to the seeded report - Billing History Report. Data Model Path - /Shared Folders/Financia…Yugesh Keluskar 43 views 2 comments 0 points Most recent by Yugesh Keluskar Receivables & Collections
-
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
I need a sql query to fetch number of performance document types usedSummary: I need a sql query to fetch number of performance document types used in the organization in talent management Content (please ensure you mask any confidential …
-
RTF Pivot Table Repeating GroupSummary: I'm developing a report where I would need duplicate pivot table based on country and put the data into different spreadsheets in excel. My problem is that Im n…Martin Smid-Oracle 11 views 0 comments 0 points Started by Martin Smid-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, https://us.v-cdn.net/6034893/uploads/DY6GVHKZ7OXI/ess-job-parameter-issue.docx I’m facing an issue when scheduling the ESS job — as soon as I select the paramet…Ashish1Soni 68 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP