Category 129
Discussion List
-
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 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 41 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…
-
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 21 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 425 views 5 comments 1 point Most recent by suamanch-Oracle 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?
-
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 11 views 3 comments 0 points Most recent by Thulasipriya K-Oracle Reporting and Analytics for ERP
-
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex…
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 152 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP
-
Custom LOV search in ESS JOB is not case insensitiveSummary: Hi All, Is there a way to make the LOV search case-insensitive? I have an LOV for Supplier Name. When the LOV popup appears, users can enter a name in the searc…RupaliGahalot 151 views 16 comments 1 point Most recent by Ashwani Kumar Mallia Reporting and Analytics for ERP
-
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST …
-
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 161 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
eText BIP Template inserting blank row at top of output fileSummary: eText BIP Template inserting blank row at top of output file Content (please ensure you mask any confidential information): Hello, We have a BIP eText template …
-
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…VaibhavChavan20_ 64 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…Sudhir Behera 11 views 1 comment 0 points Most recent by Yann Consolin-Oracle Supply Chain Planning and Collaboration -
Need a sql query to fetch approver history for contract managementSummary: Need a sql query to fetch approver history for contract management Content (please ensure you mask any confidential information): Version (include the version y…Dilip.Murugan-Oracle 11 views 1 comment 0 points Most recent by Akanksha Srivastava-Oracle Enterprise Contracts
-
Extract Report OutputSummary: Extract Report Output and populate standard attachment table for Payables Invoices Content (please ensure you mask any confidential information): I'd like to kn…
-
About the table having Segment HyerarchyI want to use information about Segment Hyerarchy in GL with BIP but I am not sure which table I should refer to. If you know, please let me know.
-
BIACM data models not returning any valueSummary: We are building a data warehouse and needs to utilize the default models provided by Oracle via BIACM to extract values needed for this project. When started wi…
-
sql query or table name for Manage Account RulesSummary: Hi team, We need a table name or SQL query to get fields for the values type and values under the setup Manage Account Rules Content (please ensure you mask any…
-
Getting error ORA-00918: column ambiguously defined while adding table to seeded reportSummary: I am trying to modify the datamodel of Journal Entry Reserve Ledger - seeded report while adding this table FA_MASSADD_DISTRIBUTIONS. Content (please ensure you…
-
Track usage of Account InspectorSummary: Customer (Old Mutual Limited) asked if any options exist to track the usage of Account Inspector (Financial Reporting Center). They want to have a view of users…AVorster-Oracle 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Hide Data Models from BI Author and BI Consumer Roles - Access Impact?Summary: Content (please ensure you mask any confidential information): We want to remove the BI Author and BI Consumer roles from any folders that just contain data mod…Rory Mullin 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP