Category 129
Discussion List
-
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 3 views 0 comments 0 points Started by Nishanth B Jain Reporting and Analytics for ERP -
Deep link for changes failed to navigate to open up the correct page. BI Publisher ReportI have created a deep link for the Change Order in my report, but the URL opens a blank page and does not work as expected. I tested it by hardcoding a Change ID, but ev… -
User is facing time out error while running OTBI reportHow can i increase query governing execution time for see error below Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 1005…Shahid Qureshi 10 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Overridden Seeded Workflow Notification Templates - what do we do to get the seeded templates?It seems that we no longer have the seeded templates in our Seeded folders. Not sure how long this has been the case, but could be since Go Live (>4 years ago) How do we…Rebecca Hawker 14 views 7 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for ERP -
Is there a function to get the display name from the username?Summary: Content (required): I'm looking for a function where you can pass the username and get the display name returned? I know I can do a query to the per_users table…
-
Project Adjustment Costs Error Exception DetailsSummary: I wanted to build a report which illustrates all the error-ed Cost Transactions ( Expenditure Item Costs ). In Costs dashboard, I have 1800+ error-ed transactio…
-
I am looking for a database table from oracle fusion for resourc override screen from work executionHi All I am looking for a Oracle fusion table for Resource Override screen from Work Execution. Also, need to know how we can join it with shift exception table 'rcs_pla…
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 922 views 13 comments 5 points Most recent by Remigious Reporting and Analytics for ERP -
OBTI Analysis Scehduler Agent - Default PromptsSummary: OBTI Analysis Scheduler Agent - Default Prompts/Add Parameters to the report Content (please ensure you mask any confidential information): We are Scheduling an…
-
Need to highlight the all the changed fields of PO Changed Order on PO PDF report.Summary: Need to highlight all the changed fields on a changed purchase order on PO PDF report. Content (please ensure you mask any confidential information): Fields can…
-
How to upload sftp private key in oracle b2b console, what we need give in the private key fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sindarapu 12 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
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 3 views 0 comments 0 points Started by Ripendra Kumar-Oracle Reporting and Analytics for ERP
-
How can we accurately pull the unpaid invoice amount in an analysis reportHi All, We have an analysis report that was made to assist with pulling the unpaid invoice amount, however it is pulling 3x the value for some invoices and other invoice…FlatFish534 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
How to download pdf report in oracle apex?Summary: There is a provision to upload report layout and report queries in shared components in Oracle Apex application . We need a alternate method to call that report…Ajay Penkey 37 views 4 comments 0 points Most recent by Sylvain Martel Reporting and Analytics for ERP
-
How to monitor who and when ran a BI report that was not scheduled?We need to see who and when people run the BI Reports without scheduling.Kristel Janssens 16 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t…
-
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 16 views 1 comment 0 points Most recent by Shahid Qureshi Reporting and Analytics for ERP
-
How to find which attribute is being updated based on Order Attribute Updated business event.Summary: How to find which attribute is being updated based on Order Attribute Updated business event. Content (please ensure you mask any confidential information): Ver…User_9HG0E 22 views 2 comments 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…SuniChacko 215 views 5 comments 1 point Most recent by suamanch-Oracle Reporting and Analytics for ERP
-
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…
-
how to convert Amount to WordsSummary: in EBS we Used Pacjage AP_AMOUNT_UTILITIES_PKG to convert Amount numbers into Word We see the same package in fusion but We do not understand how to use it - SQ…
-
Duplicate lines in PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVOIn the Oracle Business Intelligence Cloud Connector (BICC) Console, the Support Incremental option is enabled under Manage Job for FscmTopModelAM.FinExtractAM.GlBiccExtr…Jaydeep_Chaudhari_1802 1 view 0 comments 0 points Started by Jaydeep_Chaudhari_1802 Reporting and Analytics for ERP
-
How To Design FRS Report That Shows all the transaction Balances For a specific account Periods?We want to create an FRS report that will prompted for the Account and Period and will show the all accounting entries with journal type for the input, is it possible?
-
OTBI results in errors saying "The specified criteria didn't result in any dataSummary: Error in OTBI report using the Labor Distribution Cost Analysis Real Time subject area I am using the Projects - Labor Distribution Cost Analysis Real Time subj…Anand.a.Gaurav-Oracle 1 view 0 comments 0 points Started by Anand.a.Gaurav-Oracle Reporting and Analytics for ERP
-
Help finding FND_ATTACHED_DOCUMENT table in ApBicc PVO in FDI?I need some help to find out if a PVO exists that is accessible in FDI that contains the FND_ATTACHED_DOCUMENTS table - namely I'm after a column called "URL Attachments…
-
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 1 view 0 comments 0 points Started by LakshmiVanarasi Reporting and Analytics for ERP
-
Are there any fusion tables that store the Daily Amount and Days on ExpensesAs in "Expenses - Expense Transactions Real Time" Subject Area Daily Amount and Days these fields are not present so is there any fusion table where we can get these det…
-
BI Publisher Pivot Table Limit/Configuration of able to add only 5 columnsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 12 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP
-
Project Budgeting is done at resource level or task levelSummary: Hi experts, Is there a way or a flag or field which indicates if the project budget is done on the resource level or task level ? we are trying to identify that…