BI Publisher Reports
Discussion List
-
How to control or restrict the Buyer from choosing other Buyer while creating the Purchase Order?Content What is the logic behind the Buyer field being open (LOV) and our client is having an issue because the Buyers are creating the POs on behalf of others with wron… -
How to locate documents in someone queue for approval and then reassign them to someone elseContent There are few POs sent to the user for approval and the user is not available to approve them. They are pending his approval so how to identify them and reassign…
-
Need a table name for the schedule process ess job namesSummary Need a table name for the schedule process ess job namesContent We are not able to get the exact name from the ess job name we are able to get the alternative na…Koteswararao Yenikepalli 185 views 8 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for SCM -
Tracking ESS Jobs ScheduleSummary Tracking ESS Jobs ScheduleContent Hi, We are on R12. We have scheduled some ESS jobs and found that some of the jobs were failing often (for various valid reason… -
Is it possible to use bold characters and underlined text in a burst notification?Content Hi, We have a requirement to send out a burst report to all our PO owners about how much of it is invoiced, funds remained on POs etc. The Procurement team gave …
-
Table for Subinventory Valuation reportContent Hi , I am preparing a custom Subinventory Valuation report and have used the Oracle standard view/table "csv_costed_attr_onhand_v" but it is givng me the negativ…
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Total Received/Delivered Amount on PO is not Matching with Inventory Valuation/Liability Account.Summary Total Received/Delivered Amount on PO is not Matching with Inventory Valuation/Liability Account.Content Hi Team - I created a PO with 2 qty and unit price 100. … -
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 796 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 67 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM
-
UK: Streamlined Energy and Carbon Reporting compliance.Summary I'm trying to find out if Oracle have plans to develop functionality to enable UK organisations comply with Streamlined Energy and Carbon Reporting compliance.Co…User_2025-01-28-05-22-13-213 28 views 3 comments 1 point Most recent by User_2025-01-28-05-22-13-213 Purchasing -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 935 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 1.1K views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Where can i find Good Receipt status in AnalysisSummary Where can i find Good Receipt status in AnalysisContent Hi I am trying to build OTBI Report for Invoice, po, receipt.... need to include receipt status columnUser_2025-02-11-08-59-18-251 28 views 1 comment 0 points Most recent by Sushan Peiris Inventory Management
-
DFF on PO with the display type as "Inline Search" is breaking the PO page completely upon adding 2Content Created a DFF at Purchase Order Header called "Dept Location" and display type given as "Inline search" deployed. Logged into new session, created a new purchase…
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 102 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…Mayank Pande 114 views 1 comment 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
How to link or add Negotiation details like Negotiation Number, Award Date etc. on PO or AgreementsContent Is there any way to link the negotiation details (negotiation number and award date) or be transferred automatically from negotiation to PO or agreements that ar…
-
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 36 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM
-
XML to EDI Translation in OICSummary Need pointers w.r.t XML to EDI translations in OIC from the Mapping of fields if anyContent Hi Experts , We are looking to begin EDI interactions with one partic…
-
Problem to change email notifications, example NegotiationInvitationEMailBodyReport.rtfSummary Problem to change email notifications, example NegotiationInvitationEMailBodyReport.rtfContent Hello, I followed the step of customizing the system messages and …