BI Publisher Reports
Discussion List
-
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
do you know which table store the records of attached Contracts page Details in fusion?Summary: do you know which table store the records of attached Screen Details in fusion. Content (please ensure you mask any confidential information): Version (include …B.Anil 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to identify the Fusion Cloud user, how he/she has login through (REST API/OIC/URL)Summary: We used FND_Session table to identify the user, who has been logged in to cloud. but this does not tell about, how the user has been logged in. Manually( URL lo…
-
Review Receipt Accounting Distributions Details OTBI ReportSummary How to pull OTBI data for details shown in Review Receipt Accounting Distributions user interfaceContent Does anyone know how to pull Review Receipt Accounting D…
-
Need to display transaction details present under Review Production Transaction History ScreenSummary: I Need to display all the transaction details present under Review Production Transaction History Screen. Please let me know the table that stores Production Tr…
-
How to modify the alignment in the PO Terms and condition setupSummary: Term and condition pulling from the purchasing setup in PO PDF report but We needs to do the alignment changes as per the business requirement. Please let us kn…Thanigainathan R 2 views 2 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for SCM
-
Unable to retrieve information stored in the user session variables can be retrieved via SQLSummary: We are creating custom infolets and deploying them on the landing page as a part of our implementation. These infolets have parameter prompts. We wanted to popu…Shradha Lahoti 2 views 0 comments 0 points Started by Shradha Lahoti Reporting and Analytics for ERP
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 498 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
How to configure Process Payment Request to trigger custom DM for Disbursement Payment File Format?Summary: We have created a custom Data model and added custom template to Disbursement Payment File Format. Please help us to configure the Process Payment Request to tr…
-
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 2 views 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 46 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM
-
Are there any seeded infolets available for HCM?Summary: I enabled HCM Infolets in Rel 23C. However, it only resulted in a blank HCM infolets page. Are there any seeded infolets available for HCM? If so, how can I ena…
-
RTF Font not being rendered in PDF outputSummary: RTF Font not being rendered in PDF output Content (required): We are trying to use a specific font in our PO RTF template called Script MT Bold : However when w…
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…Mariyam129 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
OTBI REPORT from Purchase requisition to Invoice paidSummary: Report from Purchase Requisition to Invoice Paid Content (required): We need a report which show a full flow status from PR to purchase order to receipt and fin…Najumah Bibi Abdool Rahman 51 views 2 comments 0 points Most recent by Najumah Bibi Abdool Rahman Reporting and Analytics for SCM
-
Query to Derive tax amount for a purchase orderSummary: Looking for a query to calculate tax amount for a purchase order Content (required): Looking for a query to calculate tax amount for a purchase order Version (i…Ripendra Kumar-Oracle 1.3K views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 108 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Need corresponding technical information on the R12 views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_VSummary: Looking for the replacement view or table information for the R12 supply chain planning views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_V. Content (required): Curr…Santhi 77 views 2 comments 0 points Most recent by Manojj Basetti-Oracle Reporting and Analytics for SCM
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 179 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Is there a table that holds - Reports usage metricsSummary: Is there a table that holds - Reports usage metrics Content (required): Is there a table that holds - Reports usage metrics, we want to understand which reports…Ramesh Devarakonda 31 views 4 comments 0 points Most recent by Ramesh Devarakonda Reporting and Analytics for SCM -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 32 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Display "No Record Found" in BI Report with XPT Template if query returns 0 RecordsSummary: Looking for an option to display "No Record Found" in BI Report with XPT Template if query returns 0 Records without Impacting Performance. Content (required): …Karthik Chedella 168 views 0 comments 0 points Started by Karthik Chedella Reporting and Analytics for ERP
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 112 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…Giuseppe Galluzzo 265 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…Sravana Pydimarry 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever…