BI Publisher
Discussion List
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur… -
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin… -
Automatic Report Printing PaymentsDear All, I have successfully customized two BI reports using my own data model and RTF template—one for cash payments and the other for check payments. I need to config…George Mattar 1 view 1 comment 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management
-
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 21 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
trigger a Oracle HCM Cloud BIP report based on an onlineSummary: There is a requirement in our project that once a certain transaction is submitted in the system (Newly created candidates' security verification custom field o…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …Uma Scherer 521 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Matrix Report with Pre-Defined Excel FormulasSummary: Once the report is downloaded if user modifies any value in a column then the dependent columns should recalculate the values based on the new value and excel f…Ripendra Kumar-Oracle 21 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 126 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP -
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 112 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens… -
CANCELED_HIRE system person type not populated after cancellation of employee work relationshipSummary: CANCELED_HIRE system person type not populated after cancellation of employee work relationship Content (please ensure you mask any confidential information): W…
-
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 11 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Reporting for Workers CompGood morning. I am in need to find a report that will show rates and also a worker's comp audit report. Has anyone had success with these types of reports.?User_2025-11-21-00-15-21-711 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…User_2025-02-04-07-19-57-588 10.9K views 32 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Fusion Learn: Not able to fetch the assignerCommentsToLearner field in BI queryHi Team, We are using below rest API and payload for enrolling the learners at course level. But we want to fetch the assignerCommentsToLearner field in BI query that we…
-
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode…
-
where is the sql pruning switch in data modelSummary: oracle doc says to turn off sql pruning when getting unsupported with in Data Model in BIP. Cannot find that switch in properties Content (please ensure you mas…Kevin Gherlone 21 views 2 comments 0 points Most recent by Kevin Gherlone Reporting and Analytics for ERP
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Report SchedulerHi Team, When scheduling any reports in Oracle Fusion, we have a field to enter 'Email To'. Is there an option to restrict a specific domain there. Our client wants to p… -
Issue with Subquery/Outer Query with BOM LEVEL - Results Messed UpSummary: Hi everyone, I would greatly appreciate any suggestions or help regarding the use of outer queries or subqueries. I want to use multiple subqueries and join the…
-
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
How to have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 752 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Chetana Pawar 811 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM