BI Publisher
Discussion List
-
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia… -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
The value of the attribute Bank Name isn't valid.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…Pazhanivel 112 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to use nvl function in excel templateSummary: Using NVL function in excel template for Extracts Content (please ensure you mask any confidential information): Hi All - We have a requirement to fetch the req…
-
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…Saurabh_Mharolkar 52 views 2 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Tax Box Return Preparation ReportSummary: catalog location specified is: /Financials/Transaction Tax But it is not visible. Business need to customize Content (please ensure you mask any confidential in… -
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 31 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 186 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 11 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 5.1K 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 12 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 761 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 73 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 464 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 202 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 631 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 63 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…
-
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 14 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM