Category 174
Discussion List
-
Need the base table/Query to extract the number of Open Production Exceptions in Work ExecutionSummary: Need the base table to understand the list of Open Production Exceptions in the Work Execution > Manage Production Exceptions Content (please ensure you mask an…Vignesh Subramanian 15 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How can we customize the Receivables customer statement report with new parametersSummary: we have a requirement where we have to add a couple of dffs as parameters to the standard Customer statement report. Is this possible? Also, the customer wants … -
not able to locate any PVOs that expose the DFFs for Transfer Order Header and LineSummary: In the 25B release, I’m trying to create a BICC data extract job for Transfer Order Headers and Transfer Order Lines, including their Descriptive Flexfields (DF…User_CK3H0 32 views 2 comments 0 points Most recent by Janakrm-Oracle Reporting and Analytics for SCM
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In…PeterBridge 30 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas…Jai.S.Chavan 13 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha…missy_21 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…PrasadN 9 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…MichaelV823 9 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Lexical parameter values for Movement Request Pick Slip Report data model changesSummary: We are working on the SQL query for Oracle Seeded Data Model - Movement Request Pick Slip Report Data Model where it shows some lexical parameters and asks to p…Suyog Dhongade 18 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we fetch tax classification code using subject areas under supplier address levelHi , We are trying to add tax classification field in otbi report using subject area Supplier - Supplier Real Time, we can get the details of tax classification code und…Vinay414 18 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Parameter names with values does not appear on the custom ESS jobSummary: We've created a custom job mirroring the standard ESS process - Release Pause Tasks. The only change is that we have made the order field as a required field an…Mary Jane Sariba 36 views 2 comments 0 points Most recent by Mary Jane Sariba Reporting and Analytics for SCM -
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…Cameron Campbell 54 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
BIP report use '_vl' view cannot switch language by user language preferenceUse '_vl' view to extract data in BIP report, but it didn't display in correct language based on user's BIP preference session language. Given that, I selected :xdo_user…Skye Liu 38 views 4 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
How to reuse RTF of Packing slip report in BOL report which has different data models and parametersWe have one requirement with below 2 reports 1 . Packing Slip report -------- /Supply+Chain+Management/Warehouse+Operations/Shipments/PackingSlip.xdo 2. BOL report. ----…ManuYal 14 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
sample xml file to add column for workflow email notification not workingSummary: sample xml file to add column for workflow email notification not bringing columns to add to the email notification report Content (please ensure you mask any c…
-
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
REST API services feature for Oracle BI PublisherSummary: We are trying to access BI report through rest API. When we try the Oracle BI Publisher REST resources using the following URL structure https://:/xmlpserver/se…Kannan Ranganathan 561 views 8 comments 0 points Most recent by Sukanya Mukherjee Reporting and Analytics for SCM
-
Need Guidance on BI Report Performance Discrepancy (AR Invoices) - 25D PatchHi everyone, We’re running into a puzzling issue with a BI report based on AR Invoices and hoping for some advice or shared experience. Scenario: Our report joins ra_cus…
-
Can REST API be used to run ESS BIP Job Type? It returns Request Id = -1Summary: Can REST API be used to run ESS BIP Job Type? Why does the REST API return Request Id = -1? Content (please ensure you mask any confidential information): Oracl…Catherine Alequin 54 views 1 comment 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM -
Error when running report using REST apiSummary: Error when running/calling the report using REST api. Content (please ensure you mask any confidential information): Hello Experts, Is there a way to call or ru…Shiva Kumar Bandaru 52 views 6 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for SCM
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 851 views 6 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Transfer Orders enabled - table fieldSummary: Transfer Orders enabled - table field Content (required): I am looking for what the correct database table field is for the below highlighted field in the UI un…KDR 64 views 5 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for SCM
-
inventory aging preview feature in FDI--how to fully enable?I have enabled the feature inventory aging in the preview section of Fusion Data Intelligence. We are running version 25.2. But I don't see a new subject area called SCM…
-
BIP Report issueSummary: Hi I am trying to extract Item master data . Count is huge and getting below error. What is way to extract all records in csv Content (please ensure you mask an…
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 28 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 53 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM