BI Publisher
Discussion List
-
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t… -
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 16 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …
-
Bill management portal link custom template not workingSummary: The welcome email has a portal link, we have customised this to pick the value from a profile variable but the custom template is not being picked. Content (ple…
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 655 views 8 comments 0 points Most recent by PiyasaMandal1 Payables, Payments & Cash Management
-
4-Bucket parameter is not showing for Receivables Aging by General Ledger Account ReportSummary: 4-Bucket parameter is not showing for Receivables Aging by General Ledger Account Report Content (please ensure you mask any confidential information): Run Repo… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
Learning report(Specilization,course,offering and activity details - data issue)Hi Team, Please find the attached report columns. https://us.v-cdn.net/6034893/uploads/BUBHSV0DMANA/specilization-report-columns.txt Could you please review them and let…
-
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c…
-
Download Excel template BIP Report using SOAP Web ServicesThere was an error rendering this rich post. -
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 8 views 1 comment 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
Download Attachment File from Oracle REST API (HCM/SCM) without MiddlewareI was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downl…
-
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…tejaswi kilaru 8 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Standard oracle functionality is not working when one custom button added in the Edit Journal Page.Summary: I have created one custom button in the Edit journal page name 'Validate' for a business requirement in my project. That custom button itself is working as expe…Arkaprabha Pal 9 views 1 comment 1 point Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled …
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 75 views 10 comments 0 points Most recent by RajuKumarOracle-Oracle Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 22 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
New assignment alertSummary: We are using Seeded Alert for New assignment, whereas for Event its showing "Null" can some one help? Content (please ensure you mask any confidential informati…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 764 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM
-
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …Sherie Ross 23 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Project field is blank for below querySummary: WITH hours_data AS ( SELECT prr.payroll_assignment_id, prr.run_result_id, TRUNC(prr.ora_part_key) AS trx_date, SUM(TO_NUMBER(prrv.result_value)) AS hours FROM p…Rajeswari Thanubuddi 6 views 0 comments 0 points Started by Rajeswari Thanubuddi Reporting and Analytics for ERP
-
Report Name Change ImpactsSummary: We have some reports in OTBI & BI which have a prefix of a Company and the name is changed - just a letter - XYZ to XY1 - so can anyone advice on the below Do w…Sailajad 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How Payables gets the Remittance Email for Customer Refunds?Summary: How Payables gets the Remittance Email for Customer Refunds? Content (required): We are creating CM in AR and issuing refunds in payables. We need to send remit…
-
Is there a scheduled process (or other way) that we can update a payment type change to flow throughOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): MTB Description (Required): Is there …Ajay Kumar Kotha 5 views 0 comments 1 point Started by Ajay Kumar Kotha Payables, Payments & Cash Management