To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ… -
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …
-
Unable to view audit data in _ tablesSummary Unable to view audit data in _ tablesContent Hi All I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract … -
Oracle Fusion Financials Localization for IndiaSummary Oracle Fusion Financials Localization for India neededContent Hello all, Is there an Oracle Fusion Financials Localization for India white paper document? I am l…User_2025-02-07-09-54-58-093 125 views 2 comments 0 points Most recent by User_2025-02-07-09-54-58-093 -
What View Object uses GL_DAILY_RATES in 20A?Summary I need a VO that uses the data in that table to export via BIACC.Content Hi. I need to export the daily currency rates my company loads in Oracle. I checked the …
-
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, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
Remove zero lines from customer statementSummary Remove zero lines from customer statementContent Hi, I am trying to modify the attached customer statement template to exclude lines where F_amount = 0 Any idea ? -
FRS Studio PDF preview not workingSummary When selecting either PDF or HTML Preview in FRS Studio, not shows in preview windowContent Anyway having or had this issue? Tks!
-
BI Analyis Natural Account ParentSummary No data using Parent of natural accountContent Hello: Does anyone know how to use the natural account's Parent in filter? As long as the filter contains bottom o…
-
BI Analysis Error - custom column format may contain HTML tagsSummary Prior created report now giving this error when trying to edit and saveContent Reports created months/years ago are now giving me a message when trying to edit a…
-
need erp r12 tables (oe_order_headers_all,oe_order_lines_all) in oracle fusion cloudSummary need erp r12 tables in oracle fusion cloudContent need erp r12 tables (oe_order_headers_all,oe_order_lines_all) in oracle fusion cloud -
60 Day Retention on ESS JobsSummary Retention Policy on ESS JobsContent Hi All, does anyone know much about the 60 day retention policy that Oracle has in place for ESS jobs? Jobs that past 60 days…
-
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…
-
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data… -
Suggest Process of Data migration Reconciliation Process for Fusion applications like AP,AR,FA,PO etSummary Suggest Process of Data migration Reconciliation Process for Fusion applications like AP,AR,FA,PO etc.Content Hi Forum, Request you to please suggest the process… -
Using a graph as filter to another graph in Analysis?Content In Tableau I can easily use a graph (lets say, a vertical column of income per month) to filter another graph when clicked on the first one (ie, a second one wou…User_2025-02-07-06-48-26-537 50 views 5 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
Oracle Fusion Financials Localization for GermanySummary Oracle Fusion Financials LocalizationContent Hello Where can I get the Oracle Fusion Financials Localization for Germany white paper document? Actually I was abl…
-
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr…User_2025-02-05-22-11-22-331 59 views 2 comments 0 points Most recent by User_2025-02-05-22-11-22-331
-
How to Get BIP report output from UCM server through webservicesSummary Access BIP report output from UCM server/BIP report UCM locationContent Hi All, Query Client team does not want to go with exportBulkData webervice as they want …
-
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…
-
Report to find which users of Expense module have a banking addressSummary Report to find which users of Expense module have a banking addressContent Hello, I need to write a BI Publisher report that lists all users that have access to …
-
Product licensesSummary Product licensesContent Hi, How can i see my Product licenses list from the application ( including the licenses part numbers ) ?
-
BI Publisher- Watermark with rtf template (should be visible with table) and excel templateContent Hi All, I need your help. I am trying to implement watermark with rtf and excel template. With rtf, I am able to see watermark only on the last page, where data …
-
Parameter not printing in XPT templateSummary Parameter Value not printing on XPT template LayoutContent Hi All, I have created XPT template layout for my data model. I have created text element to show para…
-
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…
-
SQL ErrorORA-01795: maximum number of expressions in a list is 1000Content When running Upload Printed Receivables Transactions Child Process the following error has been received: SQL ErrorORA-01795: maximum number of expressions in a … -
email bursting is not working, although it says completed successfullySummary email bursting is not working, although it says completed successfullyContent email bursting is not working, although it says completed successfully. Please see …