BI Publisher
Discussion List
-
How to fetch picked_from_subinventory for a receivables invoice?Summary: How to fetch picked_from_subinventory for a receivables invoice? Content (required): We have a requirement to display all invoices shipped to a country for tax … -
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance…Valerio Curzi 804 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL Query to Retrieve based on Customer ShipTo Site NumberSummary: Hi, I need SQL Query to Retrieve below data from Ship to Site Number OrigSysShipPartyId OrigSysShipPartySiteId Original System Ship-to Customer Reference Origin…Mahmoud9308 814 views 3 comments 0 points Most recent by Karun Jain-Oracle Receivables & Collections -
How to Organize the BI Publisher reports and create Library and definitions inside HCM?We implemented Oracle HCM back in 2019, and since then we created a lot of BI Publisher reports across the modules. Those reports are very useful, however, the report na…Raed Ibrahim 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Automating HDL Worker loading via BIP ReportWhat is the process to Automating HDL Worker loading via BIP ReportVinay Prasad 14 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
AbcdAbcdShyam Rajbhar 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 499 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Supplier AgingSummary: We want to develop a custom report basis on the payables aging as on date Content (please ensure you mask any confidential information): Is there any specific t…V.Bharath 41 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…ShawShankk 132 views 11 comments 1 point Most recent by Ankam Vasantha Reporting and Analytics for HCM
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl…Hiba Ghoualmia 302 views 7 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Pass Parameter to Order By condition in Data Model (BI Publisher)Summary I'm trying to configure a Data Model to use a Parameter. I want a user to be able to choose a column to Order By.Content Hi, I'm trying to configure a Data Model…
-
Is it possible to do the modification in U.S. 1099 Standard Report pdf template.Is it possible to do the modification in U.S. 1099 Standard Report pdf template, Please find the below Standard Report details: Report Path : Shared Folders/Financials/P…
-
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…Valerio Curzi 11 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 61 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S…Muriel Sindyla 12 views 1 comment 0 points Most recent by Rajesh Tota Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
Alerts: set the reminder 7 days before the assignment due date expirationSummary: Hi experts, I have created an alert to remind learner to complete an assignment by the due date. The reminder should be send 7 days before the due date expirati… -
Email blocking problems? SPF SetupSummary: Hi, Are any other UK customers experiencing problems with emails from HCM being blocked recently? We are starting to get emails (delivered as part of HCM Extrac… -
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Learning is there a seeded notification to learners upon incomplete assignments?Summary Learning is there a seeded notification to learners upon incomplete assignments?Content Hello , In learning We would like have automatic notification reminders s… -
how to migrate the attachment on transactions in oracle fusion from EBSSummary: How to migrate all the attachments on the transactions like (Suppliers, PR, PO, AP Invoices, Payments, AR Transaction & Receipt) from Oracle EBS to Oracle Fusio…Raoof Ahmed 196 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …Madhu A 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to cancel double row in changes BIP report?I have a BI PUBLISHER report that shows changes in addresses and marital status of an employee. I use the table HRC_EVT_OBJ_CHANGE_COMPONENTS, The problem is that it sho…Alex_Balanovsky 12 views 1 comment 0 points Most recent by User_4XX09 Reporting and Analytics for HCM
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc…