BI Publisher
Discussion List
-
Need to capture individual feedback responses of multiple instructors in one offeringSummary Need to capture individual feedback responses of multiple instructors in one offering for the instructors dashboardContent Need a solution for a below usecase in… -
Empty fields are not displayed on the report output when exporting csvSummary: Empty fields are not displayed on the report output if it was Scheduled through Report and Analytics Content (please ensure you mask any confidential informatio…
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch the payment date field under the payment tab (query required)Summary: Hi, I need to verify some information using Oracle BIP tools. Could you please provide the table or the query that will allow me to display the payables invoice…Emilie06 173 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 31 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 101 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 11 views 0 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.6K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sayeed_ahmed 11 views 1 comment 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Encryption format supported by OracleSummary: The public key algorithm for this private key is not supported error while connecting to a FTP server Content (please ensure you mask any confidential informati…LeelaV 214 views 1 comment 0 points Most recent by GowriTatikonda Fusion Applications Administration
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 395 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Query for recepit method in AR transactionI want to display trx_number and the receipt method used in this transaction. Someone knows the query?ACNROMA2023 21 views 3 comments 0 points Most recent by Raghuram Saradka-Oracle Receivables & Collections
-
how to get data for destination location in Transfer order?I need destination location for transfer order. how to get that? which table i used to join with to get location name?
-
HCM Extract BIP report delivery handling of special XML CharactersHello All, We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the…
-
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific…Valerio Curzi 11 views 0 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 1.1K views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 368 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mallikarjuna Reddy 1 view 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to get manager comments from absence approval notification in BI reportsHi Team, How to get manager comments from absence approval notification in BI reports We are searching for table name and field name that stores manager's approval comme…Anup Karmankar 31 views 1 comment 0 points Most recent by Florin Dumitru-Oracle Workforce Management
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it…Aditya Jena 31 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 39 views 3 comments 2 points Most recent by User_KMKTM Reporting and Analytics for SCM -
We need a query to retrieve the AR remittance batch approver's name and approval dateHi, We have arequirement to retrieve the approver name and approval date for a remittancebatch. Could you please confirm if there’s an existing table, column, or queryth…
-
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…Lucas B Maciel 21 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM