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
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i… -
BIP 12.2.1.4 desktop flagged with Malicious with high threat scoreSummary: Software packaging team has restricted BIP 12.2.1.4 desktop installation due to high threat score. Need a workaround so that we can continue to use BIP desktop …
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…
-
after email updates(change) user not able to access Favorites & My folder..Hi Team, after email update(change) user not able to access Favorites & My folder..Is there anyway to restore that data ?? and what precaution we should take to retain t…
-
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu… -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b… -
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…
-
Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extractSummary: Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extract. Lot of BI enabled DFFs are not available in Doc ID 2463485.1. For ex…
-
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report … -
ODI Marketplace integration with SharepointSummary: Team, do we have any possibility of connecting ODI with SharePoint for data exchange. Has anyone on the team encountered this need before? can you please share …
-
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
how to get production instance name in BIP reportSummary: How to check via SQL in BIP report whether the instance is Production vs non Production ? we have a requirement to put a check in the BIP report so that emails …
-
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES… -
Data Extraction Approach for Oracle tables that doesn't have PVO'sProblem We need to understand what is the best Data Extraction Approach for Oracle tables that doesn't have PVO's Came across below approaches: Approach 1: Steps: 1. Cre…
-
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe… -
Installment payment dateSummary: We would like to have the installment payment date on a report. Content (please ensure you mask any confidential information): We have a report with using the P… -
Oracle BICC Frequency options checkSummary: Hi , Oracle BICC has feature to schedule the data extract job with recurrence frequency of Hourly, Immediate, Daily, Weekly and Montly. However our client needs…
-
default oracle fusion bi publisher reports listSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query to get all possible list of ess job statusesHi, Is there a standard or common lookup which holds all possible values of ESS Job statuses like Succeded, Error, Warning etc. ? There's one common lookup 'ORA_WLF_ESS_… -
How to let trial balance report show both PTD and YTD informationSummary: Our user would like to have YTD and PTD shown in one report rather than export twice separately. Is there any standard function to satisfy this requirement? If …
-
Validate OTBI Table Access for User based on Item Class RulesSummary: We have assigned the group “HPSA_CHANGE_REQUESTER” to Item Class “IC_HPSA”. And then assigned the role “HPSA_CHANGE_REQUESTER” to some users in order to assure …
-
Calling another template in RTF left-justifies the alignment instead of justifySummary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issu… -
What is the difference between Uploading a BIP report vs. Archiving a BIP ReportSummary: There are two options to take a copy or get a copy of Data Model and Reports. XMLPServer and click on Upload/Download Catalog folder and Archive/Unarchive Conte…
-
OTBI BIP - Secured List Views for ERP and SCMSummary: With reference to the Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1) - (Refer the document sectio…
-
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t… -
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg…