Category 129
Discussion List
-
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 …Annie Li 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
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…George Mattar 82 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
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…Hitesh Khandelwal 11 views 2 comments 0 points Most recent by Hitesh Khandelwal Reporting and Analytics for ERP
-
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…Cesar Saveedra 427 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…
-
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…Seema_Intact 21 views 4 comments 0 points Most recent by Matt Luscombe Reporting and Analytics for ERP
-
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 …snagavarapu 41 views 1 comment 1 point Most recent by EGISEDGE TECHNOLOGIES PRIVATE LIMITED Reporting and Analytics for ERP
-
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…Rahul K-Oracle 2.1K views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
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 …Anjan Polimera 51 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
wanted to use Home state a as parameter.i wanted to use Home state as a parameter in above query. How can i add it?Chetana Pawar 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-…
-
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…Nikatfusion 93 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
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 …Thanigainathan R 567 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
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…Sergio F Oliveira 142 views 4 comments 1 point Most recent by Nalsoft Pvt Ltd Reporting and Analytics for ERP
-
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 …
-
How to see the list of ESS Jobs scheduled using BICC and UCMSummary: How to see How to see the list of ESS Jobs scheduled using BICC and UCM and their start time Content (please ensure you mask any confidential information): Vers…joelroshan92 31 views 6 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Parameter getting defaulted automatically - BI publisherSummary: When I run a report, one of the parameters is unusable because, after I select one value, it gets defaulted to "All" The data model works fine before running th…
-
BI report cannot be restricted with data access setSummary: A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well. (the user is …
-
Looking for query to get details of Review Budgetary Control Balances screen informationSummary: Content (please ensure you mask any confidential information): I am creating a custom report to get the details of Review Budgetary Control Balances screen. Ver…Rahul K-Oracle 24 views 5 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for ERP
-
BI Report Migration Not Captured in Audit LogSummary: We have noticed that some of the custom BI report and data model migrations are not captured in the audit log. The same functionality is working for the same us…Divya Sidhaiyan 21 views 6 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi…Bilalemail 864 views 4 comments 1 point Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Is it possible to export analysis results from pie chart drill down?I've created a performance tile pie chart for an infolet and linked it with an analysis. When you drill down into the pie chart, it provides the requested results from t…