BI Publisher
Discussion List
-
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 91 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
add 2 columns in ExcelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…ScottSpivey 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
List of all Custom ReportsSummary: Can we get a list of all reports (Custom + Standard) using a query? Also, users who are all having access to these reports? Content (required): Version (include…
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 1.1K views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…marc.joed.de.guzman 41 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections
-
Deleted contacts in AR Customer still appearing in TableSummary: Hi, I have created AR Customer and Customer Account, Site and Contact. When checking in Table using below query, it is working as expected. select * from HZ_REL…Sathyamoorthy Ramakrishnan-Oracle 21 views 1 comment 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 131 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to identify the employees who didn't receive Outlook invites after a course is assigned?Summary: Hi, Is there a query to identify the recipients of Outlook invites after a course is assigned? we have a situation where some individuals received the invites w… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi @everyone We need your help to get below requirement: in case we do personalization through transaction design studio, we can unhide a section in the page wh…
-
Can we change the View Profile link to navigate to Skills Center in the ProfileChangeNotification?Hi All, We have a requirement to open the link of the 'View Profile' option button from Connections to the Employee Skills Center page in the ProfileChangeNotification W…
-
Query to retrieve entity code and gl account code from oracle fusionI need to develop a query to retrieve both entity code and gl account code from oracle fusion tables. But unable to link both the tables. Can anyone please help in devel…
-
How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated?Summary: How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated? Content (please ensure you mask any confidential information): Version (include the vers…User_VJR36 31 views 1 comment 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
What is the difference between Apply of the filter and Refresh of the report outputSummary: We have built a report within a Subject Area, for which we have created a Dashboard. In this Dashboard, there is a section for the Prompt and a section displayi…AnnelizeHenskens 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Duplicated Job Definition not creating privilegeSummary: I am duplicating a delivered job definition and updating it to the custom report created. Based on documentation, it should create a privilege in order to grant…
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in… -
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…Robert of STAU 312 views 6 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
What are the calculations or processes inside &L_DEPRN_SUMMARY of Asset Register Report?Hello, We are investigating an unexpected behavior which cause an issue and some discrepancies in our reporting. We need to know what is the content of the lexical, &L_D…
-
SQL - GL Balances for IntercompanySummary: Can anyone help, I understand with subledger queries I can filter to accounting_class_code = 'INTER', is there any equivalent means of getting ONLY intercompany…Robert of STAU 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
What is SrcDescriptiveFlexField?We are using the standard Oracle data model TransactionDocumentExtractDm to review Payment files for XML and standard remittance template building but are not sure what …Cam Mistry 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
DELETE Data into HCM Fusion using parameterized BI Publisher ReportSummary: We want to delete time cards via parameter through flow pattern. QUERY: SELECT HTRG.TM REC GRP ID TIMERECORDGROUPID, substr(replace (HTRG.START_TIME, '-','/'), … -
How can i caculate in BI Publisher rtf templete the number of days between report day and Due date?Summary: Hello! Trying to create a report of Open Receivables Transaction. So i have the column of Due Date () and i'm running the report with parameter of As of Date ( …Yftach Paschur-Oracle 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…Robert of STAU 47 views 3 comments 1 point Most recent by User_PZBRW Reporting and Analytics for ERP
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 21 views 5 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…User_2025-03-07-21-11-01-091 278 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP