BI Publisher
Discussion List
-
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 167 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 102 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 197 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 393 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 344 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 40 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 24 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Learning Content reportingSummary We could not find information on Learning content in OTBIContent Hi Team, Could you please help us to find in OTBI the information listed in these tables: wlf_li… -
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for…
-
Need table where Learning Outcome Details are storedSummary Need table where Learning Outcome Details are storedContent Hi, I am trying to find out the table where Learning Outcomes are stored but could not succeed. Can y… -
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…