BI Publisher
Discussion List
-
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real… -
How to query return transaction id from AP invoice tables?Summary: How to query return transaction id from AP invoice tables? Content (required): We have the requirement to get return transaction id of debit memo. But the AP in…Lucy.liu 521 views 1 comment 0 points Most recent by Cesar Tepetla Corte Payables, Payments & Cash Management -
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 71 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 946 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …
-
Table details for Setup: Payment process ProfileSummary: Table details for Setup: Payment process Profile Content (required): We need table details, which stores Default Payment Document for Payment Process Profile Cr…Nishanth B Jain 71 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
requirement to restrict the parameter display for BIP report.Summary: For an e.g for role ABC logged in user we want to display one parameter and the user with role XYZ we don't want to display the parameter. Is it possible to ach…Sayali Pawar-Oracle 41 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Is it feasible to restrict the folders using custom roles in reports and analyticsHi Team, I have the requirement that only a few sets of employees will be able to see some folders on the reports and analytics page. Ex: our requirement is only custom …Haritha 41 views 3 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 223 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 434 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Track IP AddressContent Hi All, Is there any way to track IP Address of the user who has made changes and accessing fusion system? Thanks, Visu
-
EEO - Recruiting ReportSummary: Hello, I am hoping our community can share an HCM BI Publisher report that lists all applicant data for requisitions that had a hire within the past year. It mu…
-
White paper to load an HDL through BIP reportSummary: Please let me know if there is a white paper indicating the configuration for creating an HDL file and further load it through HDL through a payroll flow. I am …
-
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to query for this attributes from which table we can get these attributesSummary: Content (required): We want to fetch blended instructor led and self paced from bip query Versio n (include the version you are using, if applicable): Code Snip…
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
How to join xcc_tr_headers and xcc_tr_linesSummary: How to join xcc_tr_headers and xcc_tr_lines Content (required): I have joined xcc_tr_lines and xcc_tr_headers by header_num however the details in UI doesnt mat…
-
What is MRC compliant in Fusion Reporting?Summary: How to check if the reports built is MRC compliant or not Content (required): Version (include the version you are using, if applicable): Code Snippet (add any …Priyanka_Ghosh 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Tool to extract query from CatalogSummary: Do we have any tool or any libraries which can be used to extract the Dataset (queries) from the DM catalog? or option to create DM programmatically based on th…sailesh_cloudare 31 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file …
-
Add Report to Manage Invoice Screen and have it be dynamicSummary: We are looking to add a report to the Manage Invoices screen and have the results of the report be specific to the invoice we are on. Content (required): We hav…Jennifer Tavino 101 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Audit Report using BIP and shadow tables for Assignment ChangesSummary: Looking for a custom BIP report query for Audit purpose using shadow tables. Content (required): We enabled the Audit for multiple products using the task 'Mana…
-
Facing issue in performance goal dashboard reportsSummary: Facing issue in performance goal dashboard reports Content (required): Hi All, We are facing the issue in performance goal dashboard report. Even employee has e…Venkatesan 21 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Dynamic page orientation change from portrait to landscape in a single RTF templateSummary: Dynamic page orientation change from portrait to landscape in a single RTF template Content (required): Requirement is to change the Page orientation conditiona…Lakshmi Bandlamudi 161 views 2 comments 0 points Most recent by Lakshmi Bandlamudi Reporting and Analytics for ERP
-
How to know recipients of bursting report that is not job history?Hi, we have many scheduled BI Publisher reports leveraging Bursting functionality to send emails to many recipients. Our client has the requirement to report on those pe…Fabio_Testa 124 views 9 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Report is taking 17 minutes for 1M record using burstingSummary: Report is taking 17 minutes for 1M record using bursting Content (required): Hi Expert, We have build a report to extract ledger balance and the report is havin…
-
Why are SOAP webservices reading sample data of a BI report with Excel layout?Summary: SOAP services - reading data from a BI report, with Excel data: date fields are taken from the sample data (report excel layout) and not from the report output …