BI Publisher
Discussion List
-
Custom lovSummary: How to incorporate custom lov Content (please ensure you mask any confidential information): I have an existing audit report which has two prompts. 1. Employee … -
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…User_IYN7Q 885 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Standard report to provide Cost, YTD and Depreciation Reserve before running Depreciation programIs there any standard report which will provide the Cost, YTD depreciation and Depreciation reserve of assets after mass additions/mass copy in tax book before running t…
-
Learning Assessments (Exams/Scoring Questionnaires)Summary: The data associated them is held with the Talent and Performance area of Fusion. We need a report that can be run by a 'Learning - Read Only' role (and the Lear…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Query to fetch the item wise lots with the on-hand per subinventorySummary: Request to have a select query to fetch the item wise lots with the on-hand per subinventory Content (please ensure you mask any confidential information): We h…Mamdouh Ahmed 22 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…
-
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 321 views 6 comments 0 points Most recent by User_MFDCB Payables, Payments & Cash Management
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 24 views 0 comments 1 point Started by Noorul Ariff1986 Reporting and Analytics for ERP
-
Print Receivables Transaction Programwe are looking for an option to generate one email in one run with multiple AR invoice PDF attachments? we understand this is not possible through print receivables stan…Champion_Homes_Phani 5 views 2 comments 0 points Most recent by Champion_Homes_Phani Receivables & Collections
-
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t…SAI KOMATIREDDY 13 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 83 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 71 views 9 comments 0 points Most recent by Surjith Kumar Reporting and Analytics for HCM
-
Can anyone help to understand from where data is coming from Intercompany Reconciliation DashboardSummary: We are looking to build a report based on the data coming from this dashboard, can anyone please help to understand from where is the data appearing into this d…Fazil_Shahid_Khan 2 views 0 comments 0 points Started by Fazil_Shahid_Khan General Ledger & Intercompany
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 28 comments 2 points Most recent by Veeru S M-Oracle Reporting and Analytics for HCM -
HDL Error Updating ActivityAttemptActualEffort for Completed RecordHello, we are trying to update ActivityAttemptActualEffort via HDL using LearningRecordActivityAttemptV3 for a learning record already in Completed status. The HDL file …
-
Join Course and Offering assignment tableSummary: Hi, I'm trying to create a Datamodel (basically a query) to join Course Assignment and Offering Assignment. Both uses the same table WLF_ASSIGNMENT_RECORDS_F, j…
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 91 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP
-
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 188 views 8 comments 0 points Most recent by Neeraj_Pal Payables, Payments & Cash Management
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 23 views 4 comments 6 points Most recent by Kathy F. Reporting and Analytics for HCM
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 50 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
Provide the supplier balance aging report logic from backend.Summary: Hi Team, Could you please help us to provide the supplier balance aging report logic from backend. We were not able to see the logic of supplier balance aging r…Arjunayan 41 views 3 comments 0 points Most recent by Vishnu Kommineni-Oracle Payables, Payments & Cash Management
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 22 views 6 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 1 view 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to fetch Burden Cost Burden Cost Code (Oracle Project Costing) — tables/SQL?Hi All, We’re trying to fetch burden cost details along with the burden cost code in Oracle Project Costing. Environment (please confirm) Product: Oracle Fusion Cloud: 2…