BI Publisher
Discussion List
-
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. 173 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 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 44 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 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 181 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 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 759 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 80 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 462 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 204 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 625 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