BI Publisher
Discussion List
-
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…Annie Li 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
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 22 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 11 views 0 comments 1 point Started by SivaRamaKrishna-Oracle Payables, Payments & Cash Management
-
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 43 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…
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
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…
-
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 31 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 …
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 773 views 9 comments 0 points Most recent by Subhojit31 Reporting and Analytics for ERP
-
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-…
-
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…Nikatfusion 51 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 62 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
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. …
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentAbhishek A 21 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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…User_KZGJG 21 views 6 comments 1 point Most recent by Lee Eslick-Huff 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 …
-
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
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
How to convert Customer TRX ID into textHi Team, We have developed Invoice Extract report and the output is in the CSV format. In the report having the column as Customer trx id which is the length of 8/9numbe…
-
AP check template MICR Font is showing as square boxesSummary: I am working one of the Saas Customer and trying to customize the AP check template. Existing custom template was build by Solution Implementation team is worki…Madhan Sanjeevi-Oracle 2 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …
-
Query to identify BPA changesSummary: Query to identify BPA changes Content (please ensure you mask any confidential information): I am building a query to identify BPA's that have had their UNIT_PR…
-
How to convert the “Amount in words to be changed to Millions and hundreds?We need to get the “Amount in words to be changed to Millions and hundreds instead of Crores and Thousands for all non INR invoices.