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
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential… -
Need guidance on Malaysia specific localizationWe are looking for information regarding Malaysia localization changes that have been implemented from reporting perspective. What are the possible changes we need to ca… -
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …
-
What would cause the same data to be bursted across multiple days?Summary: We have quite a few Bursting notifications but one of them bursts the same data across two different days. This Notification is a generic email and an excel att… -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
How do I add the FDI link onto our oracle cloud homepageI am looking for the steps to add a link to FDI from our Oracle Cloud Homepage as shown in the screenshot below:
-
Which Table Stores the GL Overridden Natural Account Code in Oracle Fusion?Summary: Hello everyone, I am currently working on a data model in Oracle Fusion and need to identify which table stores the value for the GL overridden natural account … -
Anyone have experience in importing catalog file using PublicReportWSSServiceSummary: Can anyone help us to get the sample payload required to call PublicReportWSSService to upload catalog file in Oracle Fusion ERP application? Content (please en…
-
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…
-
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…
-
oracle.xdo.XDOException: Template type 'etext' is not yet supported.Summary: DataException:[INSTANCE_JOB_ID=1343928] oracle.xdo.XDOException: Template type 'etext' is not yet supported. oracle.xdo.servlet.data.DataException: oracle.xdo.X…
-
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue? -
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…
-
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
How to create a hyperlink to another sheet within same excel -BIP report Excel templateSummary: I am trying to create an Excel template in which there are 2 tabs. One will have budget control balance details and other sheet will have PO details. Expected f…
-
From address change to display company domain in BPM workflow shows as "External mail" in OutlookHow to configure the BI publisher—> Administration—> Delivery configuration for Email delivery of all workflow emails from Company domain. Currently I have added the Fro…
-
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…
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…
-
UNSPSC Code HierarchyDoes there exist within ERP a full listing of available UNSPSC codes and its potential hierarchy? I am assuming this data is available within ERP but I can't see it if i…