BI Publisher
Discussion List
-
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 41 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is there a report that can fetch a list of all created Expense Policies?Summary: We need to be able to pull a report that can fetch us the list of expense policies in our system, that is required by our audit team. I tried looking in OTBI, b… -
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
ADFDI Upload Error - Remote Server Returned an error (500). Internal Server Error.Summary: We are not able to import journals using ADFDI spreadsheet. Whenever the user creates a I/C transaction in spreadsheet and click save and submit button, then he…
-
invoice approval report with signatures of all approversHi, Business requirement is to create a payable invoice pdf template with signatures of all approvers. Currently we are having signatures on PO pdf output but only of la…Rahim Azam Butt 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
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 524 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 120 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 12 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…