BI Publisher
Discussion List
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 118 views 2 comments 3 points Most recent by Roberto de Santos 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 15 views 2 comments 0 points Most recent by Kevin Gherlone Reporting and Analytics for ERP -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
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 19 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 57 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 11 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 603 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…
-
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 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 24 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
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 449 views 5 comments 1 point Most recent by suamanch-Oracle 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 15 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 160 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 152 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 177 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
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_ 92 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
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.
-
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…
-
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 25 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf templateLakshmiVanarasi 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee…slopez 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP