BI Publisher
Discussion List
-
How to customize email body and subject and split it by invoice number/customer name?Summary:Hi team, We request some support in modifying the SJG Dunning letter (Reminder emails for unpaid invoices). The email notification to customers/clients only rece…Somnagho_in-Oracle 131 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections -
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any …Abhilash G S 478 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…sunny.k.singh 113 views 1 comment 1 point Most recent by NJ.Mazumder Reporting and Analytics for ERP
-
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…User_2025-10-31-00-42-31-597 285 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Printing Count Field in RA_CUSTOMER_TRX_ALLSummary: Hi All, We are trying to use the Printing Count field in the RA_CUSTOMER_TRX_ALL table. The requirement is as follows: For the first three prints, the invoice s…
-
"Go Noto" Font Used in PDF OutputRegarding the default "Go Noto" font used in PDF reports generated by BI Publisher or OTBI, could you please let me know whether the font available for download from the…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 577 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 854 views 9 comments 0 points Most recent by Adnan Saleem Reporting and Analytics for ERP
-
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 79 views 11 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
SQL to fetch Amount Type in Review Budgetary Control BalancesHi All, We would need guidance in identifying the table where the amount type is stored, we could find the amount type in table 'FND_LOOKUP_VALUES_VL' for the lookup typ…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…Vinay Gharge 146 views 5 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP -
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Default Multiple Value for Multiple Selection ParameterSummary: Is anyone know how to pass the multiple default value in multiple selection parameter. Content (please ensure you mask any confidential information): N/A Versio…Yeung Shing Keith 11 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP
-
Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_valuesHello Hope everyone is doing well! I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below quer…Gaurav Bhardwaj 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Custom ESS Job submit window is not opening in Schedule New Process ScreenHi Team, We have encountered an issue with the custom ESS Job. When attempting to submit the job via the Scheduled Process Screen in our lower environment, the parameter…Vigneswaran Ck 41 views 5 comments 0 points Most recent by Mahmoud Adel Payables, Payments & Cash Management
-
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 151 views 2 comments 1 point Most recent by Showstopper09 Human Capital Management
-
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…
-
Expense approval report is turning into ADF page while doing customizationSummary: We are currently customizing the Expense Approval Report BPM notifications. When submitting expense approvals for Non-sponsored, Sponsored, or Cost Share projec…
-
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact…G. Class-Peters 11 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
Please help us understand if we can use 'JPMPOSITIVEPAY.xsl' file for generating XML output for BankAfter designating JPMPOSITIVEPAY.xsl (Standard Oracle Template) as the default template for the "Disbursement Positive Payment File" XDO, we are unable to generate the X…
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 655 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Need SQL Query to fetch Course and Course CommunitySummary I need to create one BIP Report where i need to fetch Courses and the Course communityContent I need to create one BIP Report where i need to fetch Courses and t…
-
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…Yeung Shing Keith 11 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for HCM
-
Issue with "Take Again" Button VisibilitySummary: We have encountered an issue in our Oracle Learning implementation where the "Take Again" button continues to be visible to learners, even though the profile op…
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 7.1K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 151 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM
-
QR Code Redirect Not Differentiating Learner Offering Pages – Always Redirects to Same URLSummary: We have developed a custom report that generates a QR code link for learners. When scanned, it should redirect each learner to their specific offering enrollmen…