BI Publisher
Discussion List
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction… -
how to populate rejection reason for expense auto rejected by WorkflowSummary: Whenever an expense report is auto rejected due to workflow the user wants to see a descriptive reason for teh rejection but currently in expense report only th…User_PZTF9 31 views 4 comments 0 points Most recent by Yahya Khan Payables, Payments & Cash Management
-
Mapping Payment Format - Replace decimal with commaSummary: Mapping Payment Format - Replace decimal point with comma Content (please ensure you mask any confidential information): EText RTF Template - Fixed position tem…Amit Patnaik 11 views 1 comment 0 points Most recent by Amit Patnaik Payables, Payments & Cash Management
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Does exist a BIP table/view with both Person Number and Employee Name?Summary: Building a valueset Content (please ensure you mask any confidential information): I need to create a value extracting person name, person number and person id.…Stefano_Mazzocca 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
Table to view Project Expenses Mass Adjustment Reason and TypeSummary: Which table can I use to get the "Adjustment type" and "Adjustment Reason" for mass adjustments made against Project Expenses. I found the table PJC_TXN_MASS_AD… -
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
AR Print Receivables should send invoice pdf file and attachments seperately to SFTPOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte USI Description (Required): …
-
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…TestUser35 1.1K views 4 comments 0 points Most recent by L.G.M Manikanta Reporting and Analytics for HCM
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
How do we split the invoice and supporting attachments into separate files in Print ReceivablesCurrent State : Invoice and supporting attachments are sent as one file to the customer from the client when they run the Print Receivables Job in Oracle Fusion Requirem…
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Add parameter to Seeded report- Statement Generation data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 1 view 0 comments 0 points Most recent by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
what is the relevant table for ap_batches_all table in oracle fusionwe have AP_BATCHES_ALL table in oracle fusion, but we don't see any data in table . Is there any relevant table for ap batchesHarshitha S Motagi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 730 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP
-
Equivalent FUNCTION (per_bipntf_utility) for XPATH QuerySummary In Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE) and advised to replace XPATH …Sandeep19rm 1.6K views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM -
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
what is the XML Field for file modifier in payment file ACH formatwhat is the XML Field for file ID modifier in payment file ACH format for Bank of America. Attached is the bank specifications.Harshitha S Motagi 11 views 0 comments 0 points Most recent by Harshitha S Motagi Payables, Payments & Cash Management
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…Swati Rana2805 11 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to center align a custom bip notification with an rtf templateHello, Can anyone tell if there is a possible solution to center align a custom bip notification in the user's end. We are using an RTF template. While viewing it on the…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 11 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP