BI Publisher
Discussion List
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 331 views 10 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM -
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 121 views 2 comments 0 points Most recent by User_DXIFI Reporting & Analytics for Sales -
Link to Linkedin CourseHi, we need to send the Oracle Course Catalog to an external system, for Linkedin Courses we want that users of external system will access direclty to Linkedin wihout p… -
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementHello, we need to create an SQL query where we have ChRM Program details, Accrual and Journal Batch Transaction Details: Debit/Credit from Accounting Hub. Can you please…Raluca Balan-Oracle 1 view 0 comments 0 points Started by Raluca Balan-Oracle Reporting and Analytics for SCM -
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 472 views 12 comments 2 points Most recent by S Akhtar Payables, Payments & Cash Management -
Error from SQL type DFF in applied receipt to get information from DFF in the applied transactionI want to transfer information for a DFF in receivable transaction to the receipt when applying it So i have created a DFF type SQL at AR_RECEIVABLE_APPLICATIONS, and en… -
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…Mamdouh Ahmed 21 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP -
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 259 views 8 comments 3 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 545 views 11 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 61 views 6 comments 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode)Summary: In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode) must be correctly aligned with the corresponding rows that contain the rel… -
We are building a custom report based on the Standard Uninvoiced Receipt Accrual ReportSummary: We are building a custom report based on the Standard Uninvoiced Receipt Accrual Report, and we need to include additional receipt‑related fields such as Receip… -
Restrict sending attachment in email burstingSummary: We have a requirement that client does not want email attachment to go to the end user and should not be part of the mail body as well. We created a deeplink fo…Abhilash K - Deloitte USI 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Table : Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloudSummary: Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloud Content (please ensure you mask any confidential information): Version (i… -
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o…Abhilash K - Deloitte USI 3 views 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Suppress Outputs from showing under Output & Delivery after burstingSummary: We have a BI report that needs to be scheduled to run. The report will send multiple emails, and it also generates one output which contains summarized detail o…SarthakRohilla 12 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for ERP -
Clarification on Future Support for External Data Sources in BI Publisher for SaaS to OICIntegrationDear Oracle Community, We have a requirement to utilize the external data source configuration feature in Oracle Fusion Applications BI Publisher to establish connectivi…ReddyBashaShaik 34 views 0 comments 0 points Started by ReddyBashaShaik Reporting and Analytics for SCM -
SQL query to get Manage Withholding Tax Classifications setup dataSummary: Hi Team, We need a table where the information of Manage Withholding Tax Classifications setup data. The table ZX_ID_TCC_MAPPING_ALL have the classification cod… -
Need sql query to fetch Collection strategy driving follow-up actions for overdue invoices.Summary: Need sql query to fetch Collection strategy driving follow-up actions for overdue invoices. Content (please ensure you mask any confidential information): Versi… -
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …Opkey PA 12 views 2 comments 0 points Most recent by Keerthana-Support-Oracle Recruiting, Opportunity Marketplace -
In an rtf template the single cell containing image is stretching to next pageSummary: In an rtf template, the single cell containing image is stretching to next page as it is not having any image to display. Whenever , the xml is generating image… -
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…Malak 109 views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 9.6K views 12 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 970 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 51 views 2 comments 0 points Most recent by Jason Lobo Deloitte Reporting and Analytics for HCM -
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…Arkaprabha Pal 1 view 0 comments 0 points Most recent by Arkaprabha Pal Reporting and Analytics for ERP -
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 1 view 0 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 586 views 19 comments 2 points Most recent by cylim Reporting and Analytics for ERP