BI Publisher
Discussion List
-
How to display in a Report a Document of Records (DoR) Image AttachmentSummary: is it possible to achieve the following requirement? 1. Update an image to a DoR as attachment 2. In a report enter a DoR ID as a parameter and then print/displ… -
How to capture line level applied amount of a credit memo amount on a ar invoice lineSummary: We have applied a credit memo 48012 on a line number 2 of AR invoice 48011. From application UI we can view details of credit memo is applied to line 2 of invoi…ShubhamTiwari93 21 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Restrict report access based on AORHi All Can we restrict the report access on a common report which has Master details based on the department. Lets say there are 10 departments in the report and Person …Dhilipkumaar-Oracle 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
how to add additional attributes in payslip xmlSummary: how to add additional attributes in payslip xml Content (please ensure you mask any confidential information): Hi All, We need to add emp's passport detail in p…Venkatesan 122 views 7 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
Table with the worker number field of the HCM module in Oracle Cloud FusionKind regards, Please help me to identify the table that has the worker_number field, it is not the person_number of the HCM module in Oracle Cloud Fusion. Thank you for …Jhonattan Diaz 72 views 2 comments 0 points Most recent by Jhonattan Diaz Reporting and Analytics for HCM
-
How to display sysdate in an excel template. I am using an HCM Extract.Summary: I want to display the sysdate in one of the columns of an excel output. I am using an excel template. Content (please ensure you mask any confidential informati…
-
License Count IssueSummary Identifying Authorized Hosted Named Users (Doc ID 2512770.1) does not Provide the Correct ResultsContent Hi, We are using the Oracle License count report to get …Sahil_Makhiza 1.1K views 10 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction
-
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…Global Support Desk 23 views 2 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
Unable to convert our customer outstanding balances to USD for Indian EntitiesSummary: Hi Team, We have requirement to convert customer outstanding balances for India entity to show in USD. In OTBI if you provide option convert outstanding balance…Rajasekhar Reddy Adam 13 views 2 comments 0 points Most recent by Rajasekhar Reddy Adam Receivables & Collections
-
Designing a BIP report that calculates the number of receipt notifications issued each dayHi , We Would like to explore if we can build a BIP report which calculates the number of receipt notifications issued per day. Can you please let us know if it is possi…
-
How to create a document of record to run BI Publisher report from it?Summary: I need to create a document of record in oracle fusion, this document of record will contain few fields to be used as a report parameter, the purpose of the doc…
-
What's the best way to view a report of journal submitters and approvers?When we want to view a report of journal submitters and journal approvers, we run the Journal Approval Rules Report and the Approval Groups Report. But is there an easie…
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 149 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
BIP | SFTP issuesSummary: In which table holds the FTP failure error messages. Content (please ensure you mask any confidential information): Assume that BIP report unable to place the f…
-
BI Publisher - Data RequirementsI need help trying to find Tables that contain the following information for HCM if possible Full Time Equivalent (FTE) Maximum salary in Oracle Country Gender e.g. M, F…Josh Dewar 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Missing conditional paragraphs in Job Offer previewHello, I have created custom Job Offer RTF template with Oracle BI Publisher tool. I have included multiple conditional paragraphs, but only facing issues with paragraph…Piotr Kiewro 32 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
How do I query Administrator Profile Options?We often find that there are Administrator Profile Options that are enabled or disabled during upgrades that we are unaware of and are not part of the release notes. Bec… -
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 184 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.4K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to fetch content ID generated after running the Mass Create Printable Page Performance DocumentsWe are migrating the performance documents form an old fusion environment to a new one since we cannot load the item level ratings we are planning to load print of the e…
-
Scheduled Report taking the extract in UTCSummary: Hello, The query is that if we are scheduling a custom report in IST time zone like 2.45 AM IST BUT the scheduled report is extracting the data from form 9.15 P…Awadhendra Tripathi 12 views 1 comment 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitleSummary: HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitle showing NULL VALUES Content (please ensure you mask an…Prakash Maram 1 view 0 comments 0 points Most recent by Prakash Maram Reporting and Analytics for HCM
-
View Formatted HTML Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 91 views 3 comments 1 point Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 96 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Unable to view the Output in ESS JobHI Team, When invoice import is done the ESS job(Import Payables Invoices Report) is being executed and the report is not generating at ESS Job level as showed in attach…Sarath Lakshman 113 views 2 comments 0 points Most recent by Sarath Lakshman Payables, Payments & Cash Management