BI Publisher Reports
Discussion List
-
Blanket Purchase Agreement Leakage ReportSummary: Blanket Purchase Agreement Leakage Report Content (required): We have BPA's with the supplier, but still requester purchase the items outside the BPA. We are lo… -
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL …user10645928 5 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
PO PDF Signature based on amount on PO PDF reportSummary Need to display PO PDF Signature based on Ordered amount on PO PDF reportContent Need to display PO PDF Signature based on Ordered amount on PO PDF report. Used … -
How to add Buyer Electronic Signature in systemSummary How to add Buyer Electronic Signature in system and where to check the signature is available in fusion systemContent Hi Experts , How to add Buyer Electronic Si… -
MATERIAL TRANSACTION: REFERENCE SOURCE TYPESummary INV_GENERIC_DISPOSITIONS HAS NO DATAContent Hi All, I need to get the reference number for each transaction. like for example sales order and it is reference num… -
Any suggestion how to make dependent Parameter in BI ReportSummary Any suggestion how to make dependent Parameter in BI ReportContent Hi Any suggestion how to make dependent Parameter in BI Report, Example , PO Number always dep…
-
Is there any way we can do Putaway activity using webservicesSummary Is there any way we can do Putaway activity using webservicesContent Hi All, My client is looking to perform Put Away Receipts activity using Custom page which a…Ghanshyam M-Oracle 29 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Inventory Management
-
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query …User_2025-02-11-22-16-56-998 1.5K views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Requirement to delete PRC PO Incomplete Status bulk orders from Oracle cloud FusionSummary How to delete PRC PO Incomplete Status bulk orders from Oracle cloud FusionContent My client is doing reimplementation hence we have high volumes of incomplete s…
-
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 23 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…Sushan Peiris 340 views 5 comments 5 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
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 183 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 803 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 71 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 934 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…