BI Publisher Reports
Discussion List
-
Can we create a separate queue for some priority processes within the ESSSummary: We have few priority requests which needs to run in the system as these are dedicated for patient care , is there a way we can create a new ESS manager to run t… -
Notification email to Procurement Manager on pending requisitions and purchase ordersSummary: We have a requirement to send the list of Requisitions pending approval as a weekly email notification with few details such as ( Requisition Number Requester N…
-
SQL Query to fetch Negotiation Lifecycle ActivitiesSummary: Hi Experts I am trying to find the tables to fetch negotiation lifecycle activities particularly below columns Technical Evaluation- Close Date Bid Opening Date…
-
Custom report to get Available to reserve column in Inventory managemntHi Team, We have a requirement to get a custom report where Available to reserve column should have the below formula Available to Reserve equals the quantity on hand mi…
-
How to Query the Available to Transact and Available to Reserve Quantity of an Item in an inventoryI need a query to get the Available to Transact and Available to Reserve quantities of an item in inventory. I request you anyone can help on getting a query. Thanks in …
-
Report to extract Review Item Supply and Demand UI detailsSummary: Hi Team, Need to build a report to extract the Review Item Supply and Demand UI details, but couldn’t find the exact schema details to do the same. Can anyone p…
-
BI SQL query to get the Review Item supply and Demand in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data …Umamaheswara Reddy Karri 60 views 4 comments 2 points Most recent by Alon Hadar Tamir 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… -
We want to stop sending this negotiation pdf attachment in email to suppliersWe have a requirement. We want to stop sending this negotiation pdf as attachment to supplier and all invitations to supplier by email must go without attachments. Can w…
-
RFQ Supplier notification email attachmentHello Everyone, I am working on Oracle Fusion Sourcing (Procurement). When an RFQ is submitted and published, the system sends an invitation email to the supplier with a…
-
ONE TIME LOCATION is not populated in attribute1 for POR_ONE_TIME_LOCATIONS TableWe came to know that one time location address is earlier stored in attribute1 of POR_ONE_TIME_LOCATIONS Table. Our PO PDF report uses this column to populate one time a…
-
PO Approval Notification – Custom Field Not Reflecting After Report CustomizationSummary: We would like to customize the PO approval notification by adding a new field. We have already customize the Purchase Order Notification Report and added the re…
-
Request Delivery Status Notification (Schedule Report Job)Summary: We have a client requirement where they would like to request Delivery Status notification to make sure that the Purchase Order document was successfully delive… -
report only returns current live inspection dataWe have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations. The re…Patrick Chrabieh 5 views 0 comments 0 points Started by Patrick Chrabieh Reporting and Analytics for SCM -
Table name for data stored in "Manage Catalog Category Hierarchy"Summary: Need table name for data stored in "Manage Catalog Category Hierarchy" Content (required): Version (include the version you are using, if applicable): Code Snip… -
INTENDED USE value on TableSummary: I need to get the Intended Use value from tables but it appears null: I check that we haven an ID: But I do not know to which table it is linked. I need to get … -
We need deep link for Inventory Transfer OrderHi Community, We have a requirement where from excel report user wants to navigate to Inventory Transfer order. Can anybody share Transfer order deep link for viewing de…
-
Need Join between projects and item tables in fusionHi Team, I am using below query to fetch the data for Project Budget details. I am unable to fetch the join between project and egp_system_items_b tables.If any one havi…Uday Bobba 14 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM
-
Communicate Purchasing Documents ESS job not printing ATO configurationsSummary: Communicate Purchasing Documents ESS job not printing ATO configurations Content (please ensure you mask any confidential information): Hi, We have ATO purchase…
-
BICC PVO details for ITEM_UOM_CONVERSIONSSummary: Hi Team, We need to extract complete data from ITEM_UOM_CONVERSIONS table. Can you please help us with PVO details Thanks, Content (please ensure you mask any c…
-
Can i create own tools like page composer or structures...etcDear Experts. Is it possible to create custom tools like page composer or structures or Appearence…etc Thanks For Your Help!! Ravindra
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 8 comments 4 points Most recent by Siddarth G L Reporting and Analytics for SCM -
Sales order report customization and how to get XML for current Sales orderSummary: I have to customize Sales order report of the below path. But this Data Model SQL query is not exposed. Oracle has provided the sample xml in datamodel properti…ManuYal 15 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Add requisitioner email address to purchase order rtf templateSummary: We got a requirement to add 'Requesitioner email id to purchase order document. At the moment buyers email id is included in the RTF template Content (please en…
-
How to remove footer page number from "Supplier Negotiation PDF Report" which is auto populatedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL Query to fetch Invoice to GRN Matching Report which includes PO ,Invoice and Receipt detailsSummary: Need proper joins Content (please ensure you mask any confidential information): PO_NUMBER GRN_NUMBER INVOICE_NUMBER QUANTITY QUANTITY_RECEIVED QUANTITY_OUTSTAN…
-
Customize Create Customer Statements ESSJOBHi. Does anyone have any idea if it is possible to customize the Create Customer Statement ESSJOB to include three more parameters? Client wanted to include a parameter … -
AP And PO Accrual Reconciliation Report in FusionSummary: We are looking AP And PO Accrual Reconciliation Report which was available in oracle EBS. Please let us know if the same or similar available in Oracle Fusion. …
-
How to View the Output of an ESS Jobs Submitted By Another UserSummary: How to View the Output of an ESS Jobs Submitted By Another User? I am unable to view it even though I have ESS Monitor Role. Only people with BI Admin are able …Sivabalanarayanan-Enphase 124 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM