BI Publisher Reports
Discussion List
-
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li… -
Issue with HTML Tags in Excel Output from Oracle Fusion BIP ReportWe are encountering an issue in Oracle Fusion where HTML tags are appearing in the Excel output of a BIP report. This problem was observed during the creation of an RFQ …Venkatesh Babu Somalinga 13 views 2 comments 0 points Most recent by Venkatesh Babu Somalinga Reporting and Analytics for SCM -
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…Manish Maheshwari 11 views 2 comments 0 points Most recent by Manish Maheshwari Reporting and Analytics for SCM
-
Print Commercial Invoice is ending up with retrying status.Hi All, We have a custom role and with privilege assigned print shipping reports. When i'm trying to run the Print commercial invoice, it is ending up retrying status. I…KSowmya 44 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to retrieve data from Item 'History' tabSummary: I need to extract data from Item 'History' tab, like which Field(s) are Updated/Inserted with Old and New values and Date of action. If anyone having such sampl…Shamsul_Wzd 73 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 537 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM
-
What tables stores fixed choice list dependency created using application composerSummary: A custom application was created using Application Composer. A fixed choice list field was set up to depend on another fixed choice list. However, the selected …
-
How to apply modifications to the Redwood Oracle Analytics Publisher template?Summary: We have been using a customized template for Requisition Approval Notifications. As per Oracle documentation, starting from 25A, businesses are required to reap…Vikrant Bhardwaj-Oracle 41 views 1 comment 0 points Most recent by Vikrant Bhardwaj-Oracle Reporting and Analytics for SCM
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 41 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
What is template name of email body and subject of awarded negotiation that send to supplier?Actually our client want to customized the email body and subject name for Negotiation Invitation and Negotiation Awarded email that send to Supllier. We are to able fin…Chandan Kr 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to undo LTR Direction that impact Data Model and Reporting BI AnalyticSummary: Hi everyone, I'm seeking help. Has anyone ever used the 'Force LTR Direction' option in an RFT template? I clicked it by mistake and can't undo it Content (plea…Dinar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM
-
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 32 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
query to stop message in bursting reportSummary: Hi Folks, We have a requirement to create a bursting report alert that triggers a notification whenever a course is assigned to a learner. However, since the al…
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 1.8K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
SQL query time exceeds the limit (1800 sec).Summary: I am building a report - Accounts Payable Trial Balance. While I am scheduling the BIP report, I am getting the error - SQL query time exceeds the limit (1800 s…Ritu123 78 views 1 comment 1 point Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Table for Source Reference field on Completed Transaction page - SCM CloudSummary: Hello, We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field. Content (plea…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 111 views 6 comments 0 points Most recent by Rajesh.arunagiri Reporting and Analytics for SCM
-
Merge PO header attachment pdf and BIP report in Oracle Fusion.Hi Team, I have a requirement to merge multiple PDFs into a single PDF. Specifically, when clicking the View PDF button on the PO page, a BIP report is generated. Simult…
-
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 1 view 5 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …
-
Need to call "Print Movement Request Pick Slip Report" from Movement Request pageSummary:Need to call "Print Movement Request Pick Slip Report" from Movement Request page Content (required):Need to call "Print Movement Request Pick Slip Report" from …User_2025-03-08-03-49-56-344 11 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Item "Where Used" report in Oracle fusionSummary: Item "Where Used" report in Oracle fusion I want to prepare the data which tells this Item is used in all different work definition and its parent name. In EBS …Jignesh_HAE 21 views 3 comments 1 point Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
How to enable send icon in ESS job outputSummary: I have a question of how to enable the send icon in the ESS job output. Content (please ensure you mask any confidential information): Version (include the vers…Yeung Shing Keith 52 views 7 comments 1 point Most recent by wasim ashraf-Oracle Reporting and Analytics for SCM
-
Pick slip running for too long after bursting customizationSummary: We have customized print pick slip report to burst to email.However , its running for too long post changes. Any suggestions? Content (please ensure you mask an…Akshitha Vyas 12 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…
-
Unable to access data from content serverI have a text attachment in work order operation level. I would like to print the contents of the text in work order traveler report. I would like to know how can I acce… -
sql query to get details from Receivables > Accounts Receivable > Manage Tax on Advance ReceiptSummary: Looking for tables and sql query for the detail from page - Receivables > Accounts Receivable > Manage Tax on Advance Receipt Also the line and tax details from…