Fusion Supply Chain Management reporting
Discussion List
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o… -
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 60 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 800 views 11 comments 0 points Most recent by User_2Y0JM Reporting and Analytics for ERP
-
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad…
-
Return to Vendor Report?Summary: Business needs a report of completed and pending RTV/RMA transactions. Content: Business is using Sales Orders to ship product to customers. Need a report to tr… -
Order Management Extension to copy Inventory Organization from Original Sales Order to RMASummary: Customer needs to copy warehouse information from the original sales order when creating a referenced RMA but we couldn't do it using pretransformation rules. I…
-
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …Shahid Qureshi 51 views 8 comments 0 points Most recent by Mahesh Kumar C Reporting and Analytics for ERP
-
How to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql queryHow to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql query(Fusion). SELECT INTRANSIT_TIME FROM msc_interorg_ship_methods mism, msc_s…Sreekanth Kandula 1 view 2 comments 0 points Most recent by Sreekanth Kandula Supply Chain Planning and Collaboration
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 679 views 14 comments 1 point Most recent by Adwait Rajmane 1 Reporting and Analytics for ERP
-
How to we call multiple Standard Packages in Data ModelSummary: As part of our requirement we need club two standard FA report columns. Two report called two different Standard Default Packages and in Report triggers also. C…Sarala B-Oracle 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 883 views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
BI Cloud Connector (BICC) - Not all columns selected by default in PVOSummary: By default, not all columns are enabled in PVOs (This can be noticed when we enable a PVO in a BICC job). - Is there any logic used to choose the default column…
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 13 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
INV_ACCESSIBLE_ORGANIZATIONS_V View Not AccessibleThe INV_ACCESSIBLE_ORGANIZATIONS_V view that is used in our BI reports is previously accessible using other roles even without the Application Implementation Consultant …Czarina Morales 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…Abdullah Munaz 41 views 2 comments 0 points Most recent by Abdullah Munaz Reporting and Analytics for ERP
-
UNSPSC Code HierarchyDoes there exist within ERP a full listing of available UNSPSC codes and its potential hierarchy? I am assuming this data is available within ERP but I can't see it if i… -
Adding extra filters to Infolets (Order Management - Seeded Infolets)Summary Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'Content Currently the system allow users t…Senthilrajan V 139 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
sql query to fetch sales order(export order) related details from oracle fusionhow to get delivery mode(FOB,DDP etc), Exporter(To ship) address,fumigation status(YES/NO) and type of certificate required for a sales order export compliance from orac…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 43.7K views 126 comments 30 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Connect GL Location Segment to Location AddressHi, we have Locations in Oracle we need to associate with the Location Segment in the GL Account String. Scenario: We have Account Aliases we are using to decrement our …Becca Edwards 31 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the …
-
Requirement to add Custom fields on EDI856 in Collaboration Messaging FrameworkSummary: We have done the setups in Collaboration Messaging Framework(CMK) in ERP Cloud Fusion for EDI 856 (Advance Shipping Notice). Our client is looking for few of th…Amit Sutar 111 views 6 comments 0 points Most recent by Datta Ghuge Acn Reporting and Analytics for ERP
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
List of all seeded reports navigation path required for procurement contracts, SCM, ProcurementI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…Santosh Kumar,Rayudu 43 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
TIP: Relative deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 57 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
Unable to generate consolidated output for Create Customer Statement Report.Summary: We have a requirement to customize and enable consolidated output for Create Customer Statement Report. Although we have activated the feature to display consol…
-
Customizing Accrual Reconciliation report and status is Retrying when running ess jobSummary: Customizing Accrual Reconciliation report and create a new custom ESS job by copying standard ESS job but when running it then the status is Retrying Standard E…MANOJVERMA090908 23 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM