BI Publisher
Discussion List
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh… -
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…Ripendra Kumar-Oracle 1.6K views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Looking for a table which gives the activity type from the review budgetary control transactionsSummary: Looking for a table which gives the activity type from the review budgetary control transactions UI Content (required): Version (include the version you are usi…
-
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
How to Zip BIP output containing multiple output filesSummary: Content (required):We are trying to download zip file(containing all output files for particular schedule) using Compress output prior to delivery. Version (inc…
-
Personalized Workflow notifications based on approvalContent Hello, we would like to have different messages sent when a user requests a non catalog learning item depending on the status of approval. As of now, the notific…
-
BIP Report LOV becomes read-only when the number of characters increasesSummary: Content (required): I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV t…Akash Kiran Jana 71 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to send the BIP report output to dynamic email address based on the report resultsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Shlomo Elnekave 583 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t…Richard Nagle 551 views 1 comment 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n…Murthy Kodavati 21 views 2 comments 1 point Most recent by Murthy Kodavati Reporting and Analytics for ERP -
How to use Starts With or Contains function in BI Report SQL QuerySummary: Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how? Content (required): Is it possible to use Starts With or Contains fun…Richard Nagle 291 views 2 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP
-
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…VinodKumar 658 views 6 comments 0 points Most recent by Stephan Steup - ITUP Reporting and Analytics for HCM
-
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 21 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 128 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
I see only few terminated PPRs in the iby_pay_service_requests tableSummary: When I check in the application, there are around 15 terminated PPRs available. But when I query , I see only 7 in iby_pay_service_requests table Content (requi…Lakshmi Bandlamudi 41 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 322 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …Guillaume SAVALL 31 views 2 comments 1 point Most recent by Guillaume SAVALL Reporting and Analytics for ERP
-
Conversion RatesSummary: Conversion Rates Content (required): We have "MY IFRS Primary" Primary ledger ledger currency for this Primary ledger is "MYR" as we are creating a custom repor… -
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
Is there a plan to lengthen the BIP audit log data of 90-day retention period to, say, 180 daysSummary: We would like to ask if Oracle Product Team has planned to lengthen the 90-day retention period for BIP audit log data. Content (required): Audit Log Version (i…
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 271 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 934 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
Expense Approval Notification Template not picking the Locale templateSummary: We have a requirement to show Expense approval notification template both in English and French based on the Preferences set at the user level. Expense approval…
-
Print Receivables Transactions request to run by transaction and/or customerSummary:Hi we had an issue recently where someone ran the above request and did not narrow their request by transaction number or customer. The result was that thousands…