BI Publisher
Discussion List
-
How to find out the name of "Analysis Report Criteria" used during Initiative creation?Content Hi, I assigned a Course to learners through Learning Initiative and I have used "Analysis Report Criteria" when creating the Initiative. I want to know the table… -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I…User_2025-01-30-03-28-08-030 41 views 9 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 91 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM -
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…JimCC 81 views 5 comments 0 points Most recent by Shanmugaraja_Karunamoorthy Reporting and Analytics for ERP -
AP Invoice Account Coding initiation dateSummary: which fusion table will have information of AP invoice Accounting Code, Initiation Date to write a SQL query Content (required): AP Invoice Account Coding initi…Harish Pati 171 views 2 comments 0 points Most recent by James Canaber Payables, Payments & Cash Management -
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…Jie Shen 171 views 3 comments 0 points Most recent by Madhavi.Godbole Reporting and Analytics for ERP -
RTF Payment File Output - How Can I add invoice/payment approvals to it?Hi Guys I need to add the list of creation details/approvers for each invoice listed on a payment file output which is built using an RTF file. So for two invoices I mig… -
Generate file name at runtime with respect to parametersSummary: I want to get Report's output where i want to generate name of output report with respect to User Input Parameters against the same Bi Publisher rtf Report. Con… -
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In…Naveen Jayaraman-48236 80 views 5 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Is there a table or view that contains goal names before approval?Summary: Is there a table or view that contains goal names before approval? It seems that HRG_GOALS contains the information such as GOAL_NAME, SUCCESS_CRITERIA_TEXT, LO…S.Watanabe0110-Oracle 61 views 5 comments 0 points Most recent by S.Watanabe0110-Oracle Reporting and Analytics for HCM -
Can we control Embedded report display properties?Summary: We have embedded a report to Account object. But it is not displaying in full screen, can we control such properties for BIP report to display it as user wants.…Abhishek Nirgudkar 11 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
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 31 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 32 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 31 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 519 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