BI Publisher
Discussion List
-
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 261 views 9 comments 3 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 13 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP -
create customer statements ESS job output in Excel formatSummary: Requirement is to generate Statements in PDF and Excel format for the standard ESS job "Create Customer Statements". No option to select output type as Excel. A…Anand Kandasamy 6 views 1 comment 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti…Phani Sajja 21 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Send Dunning Letter Job getting errored out while trying to load new templateSummary: Hi Team, Send Dunning Letter Job getting errored out while trying to load new template. Attached the error details. Thanks. Vidhya Content (please ensure you ma…
-
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled …
-
Oracle Fusion AP - How to correctly pair Debit and Credit XLA lines for AP Invoice accounting reporthi We are building a custom BI Publisher report in Oracle Fusion Cloud (Oracle ERP Cloud) that shows AP invoice journal accounting details with debit and credit account …
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…Rakesh Viswam-Oracle 213 views 7 comments 0 points Most recent by User_EFY2A Reporting and Analytics for ERP
-
Query or report to print approver hierercy once the Invoice approval initiatedSummary: We need to know a report name or query so that we can run this report or build a report from the query which will provide al approvers name list which we genera…Sam Samaddar 7 views 1 comment 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
How to attached Invoices to Payments Remittance Advice Notification via EmailSummary: The accounting team is requesting to attach the invoices to the Payments Remittance Advice Notifications sent via Email Content (required): We have a custom pay…Patricia Gonzalez 74 views 4 comments 0 points Most recent by Rohan Kamat Payables, Payments & Cash Management -
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat…Stefano_Mazzocca 98 views 19 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 84 views 15 comments 0 points Most recent by Balwinder Singh Reporting and Analytics for HCM -
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…Venkatesan 45 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How does Print Receivables Transactions divides the transactions into batches for processingSummary: Hi, We have queries on the functionality of following Standard process: Parent Job-Print Receivable Transaction Child Job- Print Receivables Transactions: Invoi…Pooja K 26 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections
-
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). …Victoire Bizieau 20 views 4 comments 0 points Most recent by Amar.Patel Reporting and Analytics for HCM -
Is there a Receivables equivalent for the "Payables Unaccounted Transactions and Sweep Report"?Summary: Looking for a report that shows what has been swept and what had been accounted. The only workaround I can think of is reviewing the Sweep output report after i…
-
Leave balance ytd in oracle payroll run resultsSummary: Hi All, We have a requirement to get the Sick leave ytd balance in the report. Could you please help me to get the query for the same? or How can we get the Sic…Amarnath Podaralla 18 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…Mamdouh Ahmed 18 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct…
-
person security profile required to custom query to restrict location and email?Summary: Summary: threre is location page- hr1, hr2 and hr3 are DFF stored employee emails. suppose one of the employee login as HR , all location assoicated to hr emial…
-
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.5K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 420 views 17 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 9 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Receivable Module : Print Attachment without Invoice Print BI reportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Hi team, We h… -
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …Sai Krisna 28 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontendSummary: I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position. When n…Vishal Purohit 9 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 116 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 291 views 4 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for HCM
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 44 views 4 comments 0 points Most recent by CSINGH_KCC Reporting and Analytics for HCM