BI Publisher
Discussion List
-
Report to show Employees serving Probation PeriodSELECT Command for extracting Employees that are serving probation period. -
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM -
Customer Statement - Advise of unsuccessful emailed statementsSummary Customer Statement - Emailed - Advise of unsuccessful emailed statements requiredContent This surfaced after a training session with the client where in the ques… -
How do I connect SmartView to ERP Cloud?Hi, It's been a long time. In the past when Cloud ERP was fairly new(4yrs ago). I remember on a project we connected SmartView to Cloud ERP. If I remember right, ERP spi…Hyperion_Junkie 838 views 2 comments 0 points Most recent by Hyperion_Junkie Reporting and Analytics for ERP -
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.5K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP -
Migrate update to extract definitionHi Experts, We have a case where the report Extract Definition is already in production and has been used but we need to update the extract definition with additional de… -
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
How can we retrieve the AR Invoice PDF from UCM?Summary: How can we retrieve the AR Invoice PDF from UCM? Content (please ensure you mask any confidential information): Not Applicable Version (include the version you …Deepthi Suravaram 41 views 1 comment 0 points Most recent by Richa Priya-Oracle Receivables & Collections -
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio…Simon Tomey 245 views 5 comments 0 points Most recent by Simon Tomey Reporting and Analytics for HCM -
Need to identify the logic of seeded LookupVO in flow pattern -Run Type|RuntypeLookupVOSummary: WE need the table or Query to identify the LookupVO in flow pattern -Run Type|RuntypeLookupVO. Flow Pattern: Calculate Payroll Flow parameter -> Run Type: Run T… -
What are the native reivables dashboards and what is the execution path?Summary: I need to know what the native bashboards of the accounts receivable module are so that the client can use them Content (please ensure you mask any confidential…MARCO GARCIA TOVAR 33 views 1 comment 0 points Most recent by Helle Hennings-Oracle Revenue Management -
can we add checklists completion status in hcm extract filtersIs it possible to add checklists filters in the hcm extract. Is there any user entity specific to checklists data or can we modify the user entities. we want to get the … -
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when … -
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 12 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Document on User Validations under Manage FormatsSummary: Document on User Validations under Manage Formats Content (required): Hi Experts, Do we have any good document on User Validations under Manage Formats which hi…NikhilJain_10-Oracle 41 views 2 comments 0 points Most recent by Swapnil Nagvekar-Oracle Payables, Payments & Cash Management -
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio… -
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 545 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
Report for Disabled GL account code combinations with balancesSummary: HI Team, Is there any report in Fusion GL which can list the disabled/invalid account code combinations along with their balances. Thanks Content (please ensure…Mayank Sapra 131 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Need query/Table details to fetch the Status details like the Number of a Task of Flow patternwe used the following query but its showing only the Total count, but not the details like success/error count . attached the screenshot showing the same. Query ===== SE… -
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha…
-
Error on Submitting ExtractSummary: I created a Extract and when i submit it, it throws below error. Please find the screen shot. How to solve this? Content (please ensure you mask any confidentia… -
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi… -
excel output, splitd linesSummary: Content (please ensure you mask any confidential information): HI team, I have a report that one of the field is HTML with new lines, the problm starts where I …Hadassah Friedman 21 views 3 comments 0 points Most recent by Hadassah Friedman Reporting and Analytics for HCM -
Items Revaluation ReportSummary: Hi, How to list all documents associated with Revaluation Report (Receivables and Payables) in a single(custom) output?. We need to print additional information…Camilo Reyes 21 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab… -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 141 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 191 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP -
Ability to Drill down from OTBI to edit journal passing data access set on general accountingSummary: Deeplink on a column in order to edit the journal , also if the user is set on general accounting on a ledger different from the report row ledger Content (plea…GNCC33 305 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany