BI Publisher
Discussion List
-
How to customize the data model to include disputed transactions for Strategy based dunning letters?How to customize the data model to include disputed transactions for Strategy based dunning letters? What data fields are required to be added for including the disputed…Kratika Sharma 31 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
How to include disputed transactions in score based dunning letters?I am using the seeded data model for Collections Dunning Letter template. But it does not display the disputed transactions in the list of delinquent transactions. How c…Kratika Sharma 31 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
province tag is missing in Payee/Address/ level in Payment xml though value exists in setupSummary: In Oracle Cloud, Not able to see Province tag in Payee/Address/ in the Disbursement Payment File Format standard xml output even though value exists in the supp…Chowdari Malapati Monika 32 views 5 comments 0 points Most recent by Chowdari Malapati Monika Payables, Payments & Cash Management -
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…Gian Luca Triglia 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 32 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 31 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Requires to have a Cash Flow Report?Hi, We require to have a cash flow report, appreciate if you can provide any existing reports or subject areas which can be used in creating the report, and any inputs y…Janitha Perera 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Value set retrieving lookup meaningSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve by value set the CMP_CWB_CUST_COL_46_LIST lookup meaning entered…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean… -
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu… -
Compensation Components amount, date and plan name BI TablesSummary: Content (please ensure you mask any confidential information): Hello experts, we cannot find Compensation Plan Components amounts, effective dates and plan name…Valerio Curzi 21 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM -
Is there a way to report on "Withdraw Learners" > Comments section?Summary: Is there a way to report on "Withdraw Learners" > Comments section? Content (please ensure you mask any confidential information): Hi, I'm looking for a way to … -
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha… -
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…Pradnya_Pampatwar 521 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo… -
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 51 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP -
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 1 view 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM -
Apprenticeship ReportingSummary Can we report on Apprenticeships?Content Hi all - we have been asked to report on Apprenticeships that are listed within the Talent Profile. I cannot find anywhe…Prudence K 72 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
How to add column in training supplier page?Summary: Hello experts, I need to view the description field as a column when searching a training supplier. How can I make this column visible since there is no default… -
Receivables Aging by General Ledger Account ReportSummary: We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund pro…Shadaab Ahmed 22 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections -
BI Publisher reports folder security in HCM FusionSummary: Hello, I need help in BI Publisher reports folder security in HCM Fusion. I need to know if we can achieve a functionality on BIP reports where a developer can … -
How to insert logo dynamically in RTF template headerSummary: We have a RTF template in that we are showing logos in header and same will be different for different Business units. now we have a base 64 encoded format of i…Hari krishna 1.2K views 2 comments 0 points Most recent by Hari krishna Reporting & Analytics for Sales -
How do I convert salaries currency to euro in BI Publisher report?Summary: How do I convert salaries currency to euro in BI Publisher report? Content (required): Hello, My client requires that the salaries in a custom BI Publisher repo…Alice Gouzy 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
eText Replacement Characters command not effectiveSummary: Content (please ensure you mask any confidential information): I am trying to remove problematic characters from the resulting file via eText command but it's … -
How can I create a custom job Role in BI Publisher?Summary: I can view the Roles and Permission under the Security Center using the /xmlpserver/. However, I cannot create a custom Role as there is no way for me to see th…Cristelle Rose Sampang 11 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…Ayesha Iroshani 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM