BI Publisher
Discussion List
-
Need the exact table in Fusion for the column "STAGE" in the Manage Payment Process Requests screenHi Everyone's I am having difficulty finding the 'Stage' column in the Fusion tables under the navigation: Payables → Payments → Manage Payment Process Requests → Stage …lkarthik-Oracle 32 views 3 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management -
Program "Print Receivables Transactions" is completing with errorWe have a requirement to deliver the consolidated output to customer if he has multiple invoices which are eligible to print. We have changed the bursting key to achieve…ramesh.daniyala.mcd 178 views 2 comments 0 points Most recent by ramesh.daniyala.mcd Receivables & Collections -
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the… -
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract… -
fixed assets transaction tab amount details in fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Can customers report on Signer's IP Address for electronically signed documents within Oracle HCM?Summary: We have a need to report on all of the various components of electronically signed documents/forms within Oracle HCM Onboarding Journeys. These data items shoul…Marnetta Griffin 12 views 1 comment 1 point Most recent by Claudiu Postolache-Support-Oracle Journeys -
Query to get customer contacts by siteSummary: Query to get customer contacts by site Content (please ensure you mask any confidential information): Hi, I am trying to fetch AR Customer contact information w…Cesar Tepetla Corte 4.9K views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales -
Restrict Control Account within SubledgerContent We have a requirement to restrict entering control account in AR & AP Transactions. We managed to achieve this partially via Customer/Supplier Control Option und…Rihan Jameel 30 views 5 comments 0 points Most recent by Gifty V Subledger Accounting & Accounting Hub -
Alert statistics and execution details ReportHi, We've a requirement to list how the OLC alerts are executed everyday and how many associates are getting notifications etc. Can you please suggest if it can be achie… -
How to get IDR details for a Payable invoiceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nepal Bhumireddy 11 views 3 comments 0 points Most recent by Nepal Bhumireddy Payables, Payments & Cash Management -
Date Format not convertedSummary: I am trying to get date in the format of 'Monday, 1st of January, 2020' using the query below in data model: select TO_CHAR(SYSDATE, 'Day, DDth "of" Month, YYYY… -
Print receivables program does not pick specific credit memo template?Summary: We have multiple Credit memo templates specific to each BU, the Print receivables program does not pick specific credit memo template. eg. Germany has a custom … -
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 738 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to JOIN AP_CHECKS_ALL table with per_all_people_f or per_all_assignments_m table in Oracle HCM ?Summary: Hi All, I was preparing a report which required all the check payment of US employee. In order to complete this I have to join a table which contains the check …abhjkum-Oracle 72 views 1 comment 0 points Most recent by Kishore S Payables, Payments & Cash Management -
How to display the output of a BIP Report in multiple excel sheetsSummary: How to display the output of a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we created a BIP Report, w…Barile Alberto 451 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Setup required to transmit Positive Pay File for payments/checks created via Quick PaymentSummary: Could someone please provide assistance on how to transmit a Positive Pay file to our bank's SFTP if the check payment is made via Quick Payment? Content (pleas…Christian Roxas 174 views 6 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management -
BI Output file name along with current dateContent Hi, Can someone help me how to add date in the output file name of BI report while downloading directly from BI catalog? ex: Employee Detailed Report_yyyymmdd.xl…Nivya Mathire 628 views 8 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Oracle cloud HCM sql queries to fetch details of employees who left the organization(ex-employee)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Srujana Reddy 61 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Does it mandatory to configure the mail server for dunning letter?Hi All, Does it mandatory to configure the mail server for dunning letter? Can we not use the oracle.com server, It works for invoice print and customers statement. Than…Gotham 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections -
Is it possible to retrieve deleted technical talent profile competencies in HCM extracts?Hi if we are deleted technical competencies for particular person in talent profile, Is it possible to retrieve deleted technical talent profile competencies in HCM extr… -
When attempting to print expense report with pdf receipt, the page goes to error messageSummary: Certain users are unable to print their expense reports from expenses application because when they do, the page spins for a while trying to load and then goes … -
How to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header?Summary: We want to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header since our invoice approvals are based on this field and mos…AkashAgarwal 31 views 2 comments 0 points Most recent by Harsh Masharu Payables, Payments & Cash Management -
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'… -
I need sql query to get employee timezone like employee working timezoneI need sql query to get employee timezone like employee working timezoneLakshmiVanarasi 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to remove the 'price' field from the overview of the course details?Hi everyone, I need to remove the 'price' field from the overview of the course details because the employee should not be able to see it (see the attachment). It is pos… -
What is the table name of evaluation comment during "Share and Release" phase?Summary: What is the table name of evaluation comment during "Share and Release" phase? Content (please ensure you mask any confidential information): During performance…Stefano_Mazzocca 62 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
Report course. where we receive reports without information about who made them?Summary: Content (please ensure you mask any confidential information): regarding the reporting functionality in courses, where we receive reports without information ab…
-
How to run Generate Prenote File report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report Generate Prenote File report of payroll module of HCM. But I don't know how to run this report. Thanks Content (…VAIBHAV L 52 views 6 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)