BI Publisher
Discussion List
-
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su… -
Query to get Approver Details of Ad-hoc payment in Cash managementSummary: Need Query or Joins to get Approver Details of Ad-hoc payments in Cash Management Content (please ensure you mask any confidential information): Hello Experts, …Nalsoft Pvt Ltd 165 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management -
Edit Print Receivables Transactions ESS Job parameterSummary: Edit Print Receivables Transactions ESS Job parameter Content (required): I would like to be able to edit the Default 'Invoice Template Name' in the 'Print Rece… -
A HCM BI Report is giving extra duplicate pages but the output is valid (the o/p is 1 page gives 2)Summary: A HCM BI Report is giving extra duplicate pages but the output is valid. If the output is 1 page it gives 2 pages of same data only in production environment. I…Chandan M-Oracle 1 view 0 comments 0 points Started by Chandan M-Oracle Reporting and Analytics for HCM -
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationSummary: One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target serve…JEngalan 191 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 RA_CUSTOMER_TRX_ALL from SubscriptionSummary: Need help in understanding how DFF Fields INTERFACE_HEADER_ATTRIBUTE2 to INTERFACE_HEADER_ATTRIBUTE6 in RA_CUSTOMER_TRX_ALL Table populated for transactions hav… -
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, …Jessica L. 161 views 3 comments 0 points Most recent by Jennifer-Leung Reporting and Analytics for ERP -
Payslip with custom attachment nameHi All, We are trying to change the payslip attachment name to a different format (emp_name.effective_date.pdf or emp_name.effective_date.pdf). Please let me know if tha…GopalS 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI) -
How can we get attachment to a BI report to be send through e-mail?Summary: Send attachment which is on invoice as part of email with the BI report over email through schedule Report Content (please ensure you mask any confidential info… -
jg_zz_vat_trx_gt load from JG_IT_TAX_REPORTING_PKGSummary: for extend a standard report in saas I need to know how load semantically the fields of the temporary table Content (required): I would like to know how that pa… -
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 94 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 41 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. 22 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 33 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 161 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 4.6K 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 31 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 723 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM