BI Publisher
Discussion List
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS… -
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…Mallikarjun Sheshagani 14 views 1 comment 0 points Most recent by John Lyndon Amemita Reporting and Analytics for ERP -
Apply Format Currency in RTF within a calculation TagSummary: Hello, Is there a way to apply a format currency () for this tag in an RTF template: Thanks Content (please ensure you mask any confidential information): Vers…Guillaume SAVALL 91 views 1 comment 0 points Most recent by User_8M22K Reporting and Analytics for ERP -
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid… -
BI Publisher Preview Options not enabledSummary: BI Publisher Preview Options are not enabled. Content (please ensure you mask any confidential information): We are trying to update our RTF template and the Pr… -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 42 views 3 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 61 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management -
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 411 views 6 comments 0 points Most recent by Raunak Kumar Singh Reporting and Analytics for ERP
-
Requirement for HR users to modify copies of reports for their useSummary: We have a client requirement for HR users with certain roles to be able to copy existing reports and then modify them for their own use cases. Content (please e…Alona Aronov-Oracle 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Getting Blank Data When Combining Multiple Subject Areas in ReportSummary: Hi everyone, I’m trying to create a report by combining fields from three or more subject areas. However, whenever I add columns from different subject areas in…Vaibhav Shingare 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…essdee 5 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser… -
BI Publisher prompt on date to refresh other parametersHello, I built a BI Publisher report with a prompt on 'as of date' which I want to reflect on other prompts so they refresh the available values. I read that it's not ye…Alice Gouzy 32 views 2 comments 1 point Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 49 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Procedures in AP_INVOICES_PKGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Consultant2025 1 view 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management -
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 15 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP -
Print Receivables Transactions completes with errorSummary: When attempting to run the "Print Receivables Transactions" process for a single invoice, we are getting below error: The bill-to customer email address for tra… -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 2.6K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records … -
Set last year as default value on BIP parameterSummary: Content (please ensure you mask any confidential information): I have a BIP report with parameters. One of parameters is year. I know that last day of last year…Stefano_Mazzocca 13 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Specific user assigned with Payroll Administrator cannot view the Reports tab in UI Dashboard.Hi Experts, Does anyone have experienced that there is a specific user which was assigned by Payroll Administrator role but cannot view the Reports tab when clicking the… -
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…ManishaPatil 31 views 5 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP -
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…Sridhar Gupta Yerram-Oracle 11 views 2 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP -
Is it possible to restrict the users to create the AR invoice with a particular source ?Summary: Hi Team, Is it possible to restrict the users to create the AR invoice with a particular source which has type as Manual. Content (required): Is it possible to …Ayyappa-Oracle 51 views 3 comments 0 points Most recent by Himanshu Mahajan Receivables & Collections -
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 265 views 6 comments 0 points Most recent by Dairy Land Reporting and Analytics for ERP