BI Publisher
Discussion List
-
How to Include Supplier Site-Level Details in Payment XML generated by Oracle FusionWe are working with Oracle Fusion Payments and have a requirement to include supplier site-level information in the payment XML (Seeded XML generated by Fusion) and the …mauryapradhyumn420 82 views 2 comments 0 points Most recent by mauryapradhyumn420 Payables, Payments & Cash Management -
In Oracle fusion HCM learning module , Setup configure details are stores in which table ?Summary: Navigation: My client groups —> Learning—>setup—>Configure Catalog Defaults Example: would like to know Configure Catalog Defaults Page Show Enrollment Question…
-
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 21 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…Hazel De Castro 721 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM
-
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
Returing null while executing fnd_global.get_session_attribute('JOB_REQUEST_ID')Summary: select fnd_global.get_session_attribute('JOB_REQUEST_ID') from dual is returning null. Can you please how we can get the current job request idTejas Deshpande 23 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Addition of columns to U.S 1099 Payment reportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 1 view 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
Disable FYI Notification for LearningAssignmentCompletionApproval taskSummary: We have a requirement to disable the FYI Notification for the Creator (learner) in the LearningAssignmentCompletionApproval task. Any suggestions would be great… -
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
Where is Source Reference stored in the Review Completed Txns screen?Summary: In the Review Completed Transactions screen we have a ‘Source Reference’ column. I am unable to understand where this is stored in the sql base tables. Content …
-
AgingbyGeneralLedgerAccount_Understanding the Receivables Aging by GL Account ReportAgingbyGeneralLedgerAccount_The following three questions are asked about the Receivables Aging by GL Account report: ・There are 546 items when outputting CSV, but I wo…Yuma Suzuki-Oracle 1 view 0 comments 0 points Started by Yuma Suzuki-Oracle Receivables & Collections
-
what is the difference between SQL bind and Post SQL bind.Summary: Hi all, I have a requirement where I have to make a dependent parameter in HCM extract. I used refine extract and now need to decide what to use SQL bind or Pos… -
Is it possible to insert a Deep Link for a custom BIP Report for the View Transcript Button?Summary: Is it possible to insert a Deep Link for a custom BIP Report for the View Transcript Button? Content (please ensure you mask any confidential information): Hi T…
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
Unwanted Linefeed characters getting returned in eText outputSummary: Linefeed characters getting returned in eText output Content (please ensure you mask any confidential information): I am having an issue where there is both Lin…
-
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …Gurvinder Singh Gill 148 views 3 comments 2 points Most recent by Sai Sunkara Reporting and Analytics for ERP
-
Enabling SMS alert and mobile push notification is LearnSummary: Customer has requested to enable SMS alerts and push notifications for various conditions such as course expiry, reminder to take action and enroll, learner ass…
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 224 views 4 comments 1 point Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS p[erformanceSummary: Performance issue in AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS pkg Content (please ensure you mask any confidential information): Hi, I am using SELECT distin…azodpe 232 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle Payables, Payments & Cash Management
-
Is it possible to implement a parameter refresh function when the parameter is in date format at BIPSummary: Is it possible to implement a parameter refresh function when the parameter is in date format, like a text parameter? Content: Hi, In the SQL for the parameter …M Watanabe 11 views 1 comment 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
Unable to fetch asset financial detailsWe need to fetch Current Cost, Original Cost, Net Book Value, Depreciation Reserve, YTD Depreciation, In Service Date from Asset Inquiry > Details > Financial screen. Un… -
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 21 views 3 comments 6 points Most recent by Harikaran Ravikumar Reporting and Analytics for HCM
-
Need help : Looking for table with 'Alternate Account Owner Name'Hello, I'm currently working on a report related to customer bank accounts, and I would appreciate your support. Does anyone know which table and column store the "Alter…
-
Need to pull FND attacements in BI Report- ERP CloudContent Hi Team, In Oracle Subscription Management (OSM) module, where while creating a subscription the user will attach a file(excel/word/….) with certain information(…Vikas Tiwari 423 views 9 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP
-
How to incorporate count of payment numbers in rtf template Positive pay file in fusionHow to incorporate count of payment numbers in rtf template Positive pay file in fusionKavitha Nanjundaiah-Oracle 1 view 1 comment 0 points Most recent by Kavitha Nanjundaiah-Oracle Payables, Payments & Cash Management -
Why does the logo for our Separate Remittance Advice ends up as attachment via emailSummary: Our Separate Remittance Advice is customized and our client wants to have a logo on the SRA. When the delivery method is via Email with .pdf as attachment, the …Christian Roxas 41 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 41 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Group similar columns together in bip report either through report editor or rtf templateSummary: We have a requirement to build a performance report in BIP to bring all the similar worker and manager comments in single row instead of the rows being repeated…
-
Please advise how to create a scheduled report of all administrators of the oracle application?Summary: IT would like a monthly report of all administrators of the oracle fusion application. The Scheduled Process report, User Role Membership Report, contains data …
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 250 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting and Analytics for HCM