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
-
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 display clob data in oracle in readable formatSummary: My results are not as expected even i I followed the below link https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6C8C333C-FF56-4376-9914-C298DF0DCE83.htm…
-
How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?Summary: We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs t…
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…
-
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…
-
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.
-
Visual builder redwood for ERP-FIN-SCMD modules. Any news?Summary: Please, ERP-FIN-SCM team, is there any plan to migrate any screen from ADF to Visual Builder Redwood? I mean suppliers/customers/invoices/journals, etc. Thanks …
-
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…
-
Is it possible to generate barcode for space in BIP fusion?Summary: Is it possible to generate barcode for space in BIP fusion? Content (please ensure you mask any confidential information): We've already setup BIP barcode font … -
ERP Cloud -- Add digital signature to AR invoice PDFOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): DHL Supplychain Limited Description (…
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second… -
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch… -
Is it possible to extract a single audit report for all the audit enabled products and objects?Summary: Is it possible to extract a single audit report for all the audit-enabled products and objects using the audit policy capabilities of Oracle Fusion? Content (pl…
-
Is there any termination date set for the Audit report ( or can it be set)?Summary: I was wondering if the audit trail captured in the audit report remains infinitely in the system or does it gets purged/terminated. Content (please ensure you m…
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…
-
23D Table ImpactedHello Team, Can anyone tell me the List of Table that is getting depreciated or new table being introduced in 23D release of Oracle Cloud ERP. Thanks, Sandeep Shaw
-
Why is the PVO for project team members not appearing anymore in Oracle 23... versions?Hi, We noticed that the following PVO, used to extract data for project team members: FscmTopModelAM.PjfProjectDefinitionAM.ProjectTeamMemberPVO , does not appear anymor… -
PGP Encryption for RunReport SOAP Web ServiceSummary: Is there a way to encrypt the Report output when the report is extracted using the following SOAP API: Service WSDL URL: https://servername/xmlpserver/services/…
-
Feasibility check to customize Disbursement PPP File to generate xml output with attribute values.Summary: Requirement is to customize Disbursement Payment File for a bank to generate an xml output to display attribute values from CE_BANK_ACCOUNTS, IBY_EXT_BANK_ACCOU…
-
audit report for approval group changesSummary: The audit log generated by Tools>Audit Reports is not rendering information based on the changes we make in the system, despite previously enabling logging on n… -
Schedule Report > Dest FTP > Case When There is No Data > Ability to Not Generate Output FileSummary: BIP Report > Schedule Report > Destination FTP > Case When There is No Data > Ability to Not Generate Output File Content (please ensure you mask any confidenti…
-
What is the roadmap for rollout of Redwood themes across the application?Summary: Currently a number of HCM pages has redwood themes as well as the SSP pages. What is the roadmap for further rollout in ess pages, for instance expenses? Conten… -
OTBI Incremental Date Parameter ValuesHi, We have a requirement to run the Payables Invoice Register OTBI report with incremental date parameters. We would like to schedule the Payables Invoice Register OTBI…
-
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…
-
Need an help for SQL query.Hello experts, I need some quick help in for my Bi Report which is for Receivables Module - I have query in which it has three corelated subqueries. I want to use the ou…
-
Hot to fetch bursting delivery notification detailsSummary: Looking for a query or table which would fetch bursting delivery notification details. Content (please ensure you mask any confidential information): We have a …
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Quarterly Update Feature Listing and Maintenance Pack DocumenationHow can we know what maintenance pack items are included in the Cloud-apps-feature-listing listing? For example, what maintenance pack items are included by default in t…
-
Report to Monitor User ActivitySummary: Hi All, We have a ask from the customer where in if a collection rep logs in and works an 8 hour shift, manager would like to pull a report to see how many tran…