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
-
SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values SourcesSummary: SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources Content (required): I have entered below SQL on the Query b… -
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot… -
lineage document for SCM AND PPMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
split Interactive BIP report into multiple excel sheet outputHi, I have an interactive BIP report which needs to generate output into 2 different formats for which I need outputs to be in 2 separate excel tabs How can this be done…
-
How does gms_ffr_indirect_expenses table get populated? Is it from another source tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
how to store burden rate details to table gms_ffr_indirect_expensesSummary: Where do data come from for the Federal Financial Report table gms_ffr_indirect_expenses Content (please ensure you mask any confidential information): Version …
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…
-
OTBI report for FND LOOKUPSSummary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsService…
-
Alternative to Oracle BI Mobile appSummary: Earlier oracle provided the ability to scale the report output to fit the screen size of the device using the Oracle BI Mobile app. However, the app is now in d…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
Need query to get Job details oracle fusionHi Team, Please correct me if i am wrong, once we have submitted Job from schedule jobs then we can see the data in the below tables fusion.ess_request_history fusion.es…
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r… -
Report for supplier invoice with address not pullingWe are developing a supplier invoice report BIP report using the below listed tables. Admin users are able to get the data, but the end user with access to just this BIP… -
Privileges required by the FAWService account that is created in Oracle Fusion ERP and used by FAWWe are creating the FAW instance and configuring out of box Pipeline between ERP and FAW to get the ERP data. For this purpose we need to create a user in ERP that can b…
-
Need help to modify SQL to retrieve the journal approver field pleaseSummary: I am trying to update the GL Ledger script to include the following additional fields Journal Approver name beginning and closing GL account balances for the se…
-
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …
-
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in …
-
Query to get credit memo details applied for an invoiceSummary: Content (please ensure you mask any confidential information): I am looking for the details of credit memo applied for an AR invoice. For the invoice 1004830 he…
-
Is there any possibility to increase number of threads in ESS job (through JMS Configuration)Hi Team, Loading balances into FCCS from Oracle ERP Cloud application through ESS Job ‘Extracts General Ledger Cube Balances’ ends in error intermittently. It is fixed t…
-
Auditing the data access set accessesWe have enabled Audit for Oracle Platform Security Services. However, we are unable to see the data access set access changes/updates in the Audit Report. We want to aud…
-
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …
-
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti… -
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…
-
Purchase Order PDF Using Sub TemplatesSummary: We have multiple entities and developed a custom data model and appropriate custom purchase order PDF's. All working fine for PdfDraft and PdfArchive sections. …
-
How to implement the Column Group in OTBISummary: I am checking a seeded report "Top 10 Requisitions Breakdown". can anyone help me how to implement the below column group functionality in OTBI report? Also, Ho… -
Max columns display in BIP dynamicallySummary: Hello, We have a requirement to display more columns dynamically in BIP, would like to know any limitations in MAX columns display. If not, please suggest us. T…
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using …