BI Publisher
Discussion List
-
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
SCM INT Process Work Order Details (ASN) Oracle to Third PartySummary: outbound integration report from Oracle to Third Party Content (please ensure you mask any confidential information): Hi Team, Need information on creating outb… -
In Job Details need Travel Required fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 21 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management -
Deep Link for payment view in oracle fusionSummary: Please provide the deep Link for payment view in oracle fusion. Content (please ensure you mask any confidential information): Version (include the version you …User_B1ZBU 5 views 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Issues with Decoding Large XML in adhocschedule Column for ESS Jobs inFUSION_ORA_ESS.REQUEST_HISTORYIssues with decoding large XML in the adhocschedule column for ESS jobs in FUSION_ORA_ESS.REQUEST_HISTORY. We have created a SR with Oracle. They recommended creating a …Rajesh Kumar Gunda 85 views 7 comments 5 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Send Separate Remittance Advice RTF CustomizationSummary: We have customized RTF template for sending remittance information to the Supplier. We are pulling PO number from the invoice line level along with payment info…Rajesh Kumar Gunda 12 views 1 comment 0 points Most recent by Rajesh Kumar Gunda Payables, Payments & Cash Management -
How to add oracle cloud url in RTF templateSummary: Am trying to add login url( oracle cloud url) from ask_deployed_domains table. when we click on link it is throwing error. {COLUMN_NAME} using this in address o… -
Need to display UTR number in supplier payment page against each payment Num from cash management.After importing MT940 into oracle fusion, The UTR number populated in additional information in cash management. Now we need to display the UTR number in invoice payment…Kolikonda 35 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Request for Solution & Documentation on Oracle Fusion ERP Integration with ZATCA for AR invoicesSummary: We are currently working on implementing e-Invoicing compliance for Saudi Arabia (KSA) and need to integrate Oracle Fusion ERP with the ZATCA portal in accordan… -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 100 views 2 comments 0 points Most recent by Eric-Oracle Reporting and Analytics for HCM -
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 553 views 10 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject… -
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…Nirosha Yelicherla 153 views 4 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
How to translate amount into wordsSummary: (1) In Fusion BIP Report, how to translate the USD amount into English words? for example, 0.11 needs to translated as 'Zero and eleven USD'. I have tried tried… -
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma… -
How to Remove Blank Spaces Appearing from Hidden Conditional Tables in RTF TemplateI have an RTF template with 3 separate tables that display conditionally based on a parameter (ITEM, ASSET, WorkOrder). When one table is selected, the other two are hid…Voladri Saikiran 49 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot… -
Download bulk Attachments or documents by using HCM extract or BICCHi, Can someone please help us on below. Download bulk Attachments or documents by using HCM extract or BICC in Fusion Cloud Applications. -
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 506 views 11 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP -
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …Praneeth Nalluri 858 views 2 comments 0 points Most recent by Sandeep Marka Reporting and Analytics for ERP -
Receivables Aging by General Ledger Account Report Completed with error for as on date of 12/28/2024Summary: Use has submitted report : Receivables Aging by General Ledger Account Report with a ledger and as on date as 12/28/2024 and it is completed with Error and log … -
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…Opkey PA 1.2K views 5 comments 0 points Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP -
Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assiHi Everyone, Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assigned to a user and when? Or Any suggestion for seeded re…