BI Publisher
Discussion List
-
What is the maximum number of lookup codes that can be defined in a common lookup?Summary: We have a requirement on custom BIP report for AR Receipts, if the report is printed again for the same receipt number then report output should have 'REPRINT' …Mayur_Gidwani 81 views 12 comments 0 points Most recent by Venkat Patlola-Oracle Receivables & Collections -
Adding distribution budget date, accounting date and expenditure item date to AP Invoice Approval RTSummary: Has anyone added these fields to the AP Invoice Approval RTF? Content (required): Users are requesting we add this to aid in year end processing of invoices to …Alex Glose 81 views 3 comments 0 points Most recent by Alex Glose Payables, Payments & Cash Management -
Invoice Print Template criteriasSummary: I would like to have 2 different criteria for Invoice Print Template Content (please ensure you mask any confidential information): If I have only criteria like…usr_a.nv 32 views 6 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 71 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 51 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Where can we see the audit details for Payable invoiceSummary: Hi Team, I have created two invoices with an invoice amount of 2000.00 INR. Subsequently, I updated one of the invoices with the amount of 3000.00 INR, and for …Venkateswari 11 views 3 comments 0 points Most recent by Jesus N Payables, Payments & Cash Management
-
All cost centers are not appearing in gl_seg_val_hier_rfSummary: We have few cost center present in same tree node still few are missing in gl_seg_val_hier_rf What can be possible reason? Content (please ensure you mask any c…Nidhi Chhajed 107 views 4 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI Publisher -
Count of development Goals analysisSummary Can't add people with 0 Goals altogether with other Assignment fieldsContent Hi Team, We are trying to build an OTBI analysis that lists Person Name, Person Numb…Alvaro Couto 21 views 3 comments 1 point Most recent by Shawn Gertler Reporting and Analytics for HCM -
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 71 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to create Formula type Depreciation Method with different Depreciation Rates for different PerioSummary How to create Formula type Depreciation Method with different Depreciation Rates for different Periods?Content Hi Experts, I have requirement to create the calcu…
-
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 674 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.4K 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… -
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 31 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 11 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 544 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM