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
-
Query to fetch the Requisition job pending approval details in oracle fusionSummary: In purchase requisitions we have to prepare a bi report for the pending approval status and their job name Content (required): Version (include the version you … -
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde… -
BI Cloud Connector (BICC) - Only limited columns selected by default in PVOSummary: While configuring data extract from BICCC, we notice that within a particular PVO, only limited columns are selected by default. While we can customize and sele…
-
how can we schedule the archive processhow can we schedule the archive process Content (required): how can we schedule the archive process for custom reports Version (include the version you are using, if app…
-
Moved: Need document on Localization for Israel, Switzerland and Portugal in Oracle Fusion ERPThis discussion has been moved. -
Ctreating a report for my PPM moduleDear all I am creating a report for my PPM module I just want to list the project name - task name and number - Cost and Resource I found all the above except the Resour… -
The report cannot be rendered because of an error, please contact the administrator.Summary: We have a custom report and when business user is trying to run the report below error is displayed Content (required): The report cannot be rendered because of…
-
Why the condition row value is not able to sum up as expected.Summary: We have got a requirement where either of one value is nonzero consider that value for result row. Row values are Account 400000 Department 555015,Account 40000…
-
How to wrap BI ParametersHi, I would like to have two lines for parameters instead of a single line when reports have more than 4 parameters. Is there any way to wrap or split BI report paramete…
-
Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLSummary Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALLContent Need relation between WSH_DELIVERY_DETAILS & DOO_FULFILL_LINES_ALL -
How to make MICR bold in AP checks?Summary: Couldn't make MICR bolder using the AP checks in RTF Template. Content (required): i I have tried changing the MICR tag bold in RTF template ii I have tried add… -
Why to use e-text format in BIP report when we can use default csv formatSummary: Why to use e-text format in BIP report when we can use default csv format Content (required): Why to use e-text format in BIP report when we can use default csv…
-
Ability to Search ESS- Using Report parameterSummary: There are standard or Custom Reports to be scheduled for autorun, and the output is being sent to the Printer or any other communication method. If there is a f…
-
How to View BIP Report Output in CSV Without Creating a LayoutSummary: Default the output of BIP Report to csv without having to setup a layout Content (required): In order to set the Default Format of a BIP report to csv you must …
-
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…
-
OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO ITD YTD PTDContent I spent (as a newbie in OTBI) a couple of days trying to display the same column measure but with differe… -
How to access P2P OTBI Dashboards in Oracle.Summary: A user is requesting access to P2P OTBI Dashboard they saw in Oracle Learning, we don't know how to get to it. Content (required): From that user: "I’m in Oracl…
-
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-… -
Populate DFF value in Journal Screen based on another field in JournalSummary: Define a DFF at the journal line level and default the parent level COA segment value in this DFF based on the child level COA segment in the journal line COA.… -
PPM: Data Security in Custom I Publisher ReportSummary: We need some sort of Data Security to be handled in Custom BI Publisher Reports related to Projects module. We are looking for options related to the seeded Sec…
-
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …
-
Find all emails sent by OracleSummary: Find all emails sent by Oracle Content (required): Hi, An email should've been sent to a user once he did the reception in Oracle but it seems he didn't receive… -
Deeplink to GL Journals from OTBISummary: Hi All, Trying to implement the deeplink in OTBI to GL Journals. No Subject area in OTBI has jeBatchId column. Validate this in Fusion OTBI Data Lineage Mapping…
-
How t get login detail report in oracle fusionSummary: Content (required): Dear All How we can generate login report in oracle fusion for all the users , with Date , Time , user Name etc.. Version (include the versi…
-
The BIP Excel layout returns no dataSummary: I downloaded a data sample from the data model, added the fields to Excel (creating a XDO_Metadata sheet). The template with the sample data looks fine: But whe…
-
Request for Oracle User Access ReportSummary: Hi all, Thank you in advance for your help and support. I have a question regarding Oracle user access. Is it possible for us to extract a report that provides …
-
How to disable Edit option in OTBI Reports?Summary How to disable Edit option in OTBI ReportsContent Need to disable the Edit Option from the OTBI Analysis. Could you please suggest how we can achieve this? -
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…
-
Where can I find the list of native reports that exist in OTBI for purchase contracts?Hello colleagues, I need to know if there is a document that specifies those native or standard reports that Oracle offers, if you have a document with this information … -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…