BI Publisher
Discussion List
-
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 111 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 11K 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…Hemali Khatri 2 views 0 comments 0 points Most recent by Hemali Khatri Reporting and Analytics for HCM -
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 750 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…
-
Chetana Pawar 811 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
Deep link for changes failed to navigate to open up the correct page. BI Publisher ReportI have created a deep link for the Change Order in my report, but the URL opens a blank page and does not work as expected. I tested it by hardcoding a Change ID, but ev…Ramsha Zameer 21 views 2 comments 0 points Most recent by Ramsha Zameer Reporting and Analytics for ERP -
Not able to add Concatenated Segments for the expenses inside the Expense Approval Report Template.Summary: We are trying to include concatenated segment string for each expense item. Content (please ensure you mask any confidential information): Hi, We've a requireme…
-
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 131 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
User is facing time out error while running OTBI reportHow can i increase query governing execution time for see error below Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 1005…Shahid Qureshi 121 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Self Service related Privilege's for Oracle Fusion PayablesSummary: We are looking Self service related Privilege's to Invoice Payables. The below two privileges provide access to Payables and are considered part of the license …Linga Murthy 231 views 4 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Overridden Seeded Workflow Notification Templates - what do we do to get the seeded templates?It seems that we no longer have the seeded templates in our Seeded folders. Not sure how long this has been the case, but could be since Go Live (>4 years ago) How do we…Rebecca Hawker 11 views 7 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for ERP -
Can't access report and analyticsSummary: Content (required): All the users can't access to Reports and analytics even in admin User. The error massage is Insufficient permissions You do not have suffic…LiorZiv 661 views 10 comments 0 points Most recent by Parth Trivedi-Oracle Reporting and Analytics for HCM