Category 129
Discussion List
-
Historic table for EFF "ego_item_eff_b_" is timing out.I am writing a very simple query to see historical EFF data for an item and It is timing out when I tried to search with the inventory Item ID. What is the issue with th…Ramsha Zameer 15 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Product Master Data Management -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf… -
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…Sheshan Ukkalkar 72 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP -
To restrict access so that only pending workers can use the username and password.Hi All, Can someone provide insights on how to implement restricted access so that only pending workers can use the username and password login while everyone else uses …Sheshan Ukkalkar 24 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur… -
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin…
-
trigger a Oracle HCM Cloud BIP report based on an onlineSummary: There is a requirement in our project that once a certain transaction is submitted in the system (Newly created candidates' security verification custom field o…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
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 35 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …Uma Scherer 465 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
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 15 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
where is the sql pruning switch in data modelSummary: oracle doc says to turn off sql pruning when getting unsupported with in Data Model in BIP. Cannot find that switch in properties Content (please ensure you mas…Kevin Gherlone 17 views 2 comments 0 points Most recent by Kevin Gherlone Reporting and Analytics for ERP
-
standard reportsSummary: Can I get a list of the canned reports for accounting? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
FSGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Frankie Chan-Oracle 4 views 0 comments 0 points Started by Frankie Chan-Oracle 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…Ramsha Zameer 13 views 2 comments 0 points Most recent by Ramsha Zameer Reporting and Analytics for ERP
-
Getting Null value For Pricelist Name While Extracting CO Item from BIP report inSummary: Getting Null value For Pricelist Name While Extracting CO Item from BIP report in , what can be the reason behind this issue. Content (please ensure you mask an…
-
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 66 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
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…CraigP 639 views 5 comments 0 points Most recent by Shivendra Kumar-Oracle Reporting and Analytics for ERP
-
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…
-
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 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
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 19 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 47 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 21 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…