Public Sector
Discussion List
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T… -
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type field -
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …Doron de Jong-57089 133 views 9 comments 1 point Most recent by Ed Higgins Reporting and Analytics for ERP -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 24 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba… -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableuser12240811 24 views 5 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion clouduser12240811 10 views 1 comment 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Need Help with a Deep Link for RequisitionSummary Trying to Create Drill down from a Simple OTBI report to the Requisition ScreenContent Hello. Looking for some help on what we think is a simple deep link from a… -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I … -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…Sarah Munro 12024679 31 views 2 comments 0 points Most recent by Sarah Munro 12024679 Reporting and Analytics for ERP -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Supplier Registration Requests Error tableSummary Supplier Registration Requests Error tableContent We are trying to build a BI Report to send out a notification to the Supplier creation requester whose Supplier…SRINIVAS JAMPANI 16 views 1 comment 2 points Most recent by Piyush Singh-Oracle Reporting and Analytics for ERP
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently … -
Security Role for Access to Payable Invoice Register ReportSummary I'm looking to setup a custom role that gives access to the Payables Invoice Register ReportContent It seems like I've given permissions that should be sufficien…David Rabalais 15 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…User_J8VYU 34 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Electronic Purchase Order Submission ReportSummary Purchase Order submitted ElectronicallyContent hi Guys, I am creating a report for Purchase Order submitted Electronically. How do I identify PO is submitted ele…
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 44 views 3 comments 1 point Most recent by rajArun Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 54 views 3 comments 0 points Most recent by Lakshmi Sampath-Oracle Reporting and Analytics for ERP
-
Delivered Deep Link to the Audit > Manage Expense Reports pageSummary Delivered Deep Link to the Audit > Manage Expense Reports pageContent Is there a plan or timeline on when the ability to deep link to the Manage Expense Reports …Derrick Palmer-Oracle 36 views 2 comments 3 points Most recent by Derrick Palmer-Oracle Reporting and Analytics for ERP -
Sarah Munro 12024679 14 views 0 comments 0 points Started by Sarah Munro 12024679 Reporting and Analytics for ERP
-
Smartview and OTBISummary Smartview and OTBI not the sameContent When we run Smartview and OTBI reports simultaneously, many times they don’t balance. We are struggling to determine the c…Yasmin Kennedy 60 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…user12240811 14 views 3 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Sync COA valuesSummary keep the COA’s in all reporting cubes in syncContent Is there some way to keep the COA’s in all reporting cubes in sync? We have had issued where SMartview does …
-
Positive Pay Template ConfigurationSummary I'm looking for detailed instructions for how to break down and configure a positive pay template.Content By and large I'm looking for a guide for setting up a P…David Rabalais 22 views 7 comments 0 points Most recent by Glen Ryen Reporting and Analytics for ERP
-
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…Kamran Butt-161785 25 views 10 comments 2 points Most recent by Kamran Butt-161785 Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like …Dev Thota 103 views 6 comments 2 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for ERP