BI Publisher
Discussion List
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…Barile Alberto 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to debug BIP report that has dataset based on Procedure as a SQL type?Summary: I have an issue with a BIP report that use a complex plsql code as a dataset. I am looking for suggestion to debug procedure used in dataset. The data set confi…Vijayaragavan Ramasamy 12 views 0 comments 0 points Started by Vijayaragavan Ramasamy Reporting and Analytics for ERP
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Manage Delegations ReportSummary: Is there a seeded report that would list all the active employees that are able to create expense reports for employees? There is not a way to download to excel…
-
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 387 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 42 views 2 comments 0 points Most recent by User_W53WG Payables, Payments & Cash Management
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 139 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
How can I add custom columns and layout to a seeded report in Oracle Fusion?Hi everyone, I’m working with a seeded report (Funds Capture Authorization and Settlement Formats) in Oracle Fusion Receivables, and I need to add custom columns to the …
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 74 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 141 views 5 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to disable "Import Payable Invoices Report" generating for every Import Payables ESS Job run?Our client uses another system to process their AP Invoices. They validate the invoices triggering the web service for Invoice Import (7.5-10k per day). This process is …Camilo Botín-Oracle 51 views 1 comment 0 points Most recent by dwalia-Oracle Payables, Payments & Cash Management -
Where to find the client channel data (i.e., the payment initiation method) in ERPHi, The requirement is to identify where the client channel data (i.e., the payment initiation method, such as H2H or J.P. Morgan Access) is stored in Oracle Fusion, and…Keerthana Sekar 11 views 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 44 views 2 comments 0 points Most recent by Rama Krishna T Payables, Payments & Cash Management
-
Setup PrinterHi, I need to print a receivables report directly to a printer in another physical location. 1. Is there any functional setup I need to do? 2. How could I make this work…Cleton Carvalho 21 views 2 comments 0 points Most recent by Gal_Var-Oracle Receivables & Collections
-
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver…Krishna Manmohan 11 views 1 comment 0 points Most recent by Krishna Manmohan Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 184 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP
-
Request for REST API Details for SLA Accounting Journals (AR/AP)Hi Team , We are unable to locate the REST API name related to SLA accounting journals (e.g., AR, AP) in the Oracle documentation. This information is required to develo…Tasweer ur Rehman 11 views 0 comments 0 points Started by Tasweer ur Rehman Subledger Accounting & Accounting Hub
-
How to move OTBI & BIP reports from one instance to anotherSummary: How to move OTBI & BIP reports from one instance to another instance? Looking for the easiest way to achieve this. Content (please ensure you mask any confident…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 103 views 7 comments 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM
-
FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud FusionHi all, I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are usi…Arthur Teodoro 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Implement Badging in Oracle Learning Cloud and Integrate with talent profileSummary: We are looking to implement badges in Oracle Learning Cloud Content (required): Hi All, Our client is looking for implementing Badging functionality in Oracle L…
-
Custom Payables Invoice Aging Report did not copy the parameterSummary: copy of the Payables Invoice Aging Report did not copy the parameter Content (please ensure you mask any confidential information): Version (include the version…ERP User 11 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Payables, Payments & Cash Management
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 124 views 6 comments 0 points Most recent by RithwikSivanand111111 Reporting and Analytics for HCM