To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for SCM
Discussion List
-
work order fetch based on asset number and asset work center nameSummary: Hi Experts I want to create a BIP report to fetch work orders with parameters asset number, asset work center name, item number and work order work center name.… -
Fusion SCM Analytics for MFG and Planning?Summary: Does Oracle has any plans to extend its current footprint of Fusion SCM Analytics with pre-build (industry standard) KPIs for MFG and Planning ? Content (requir…
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c… -
What is the formual to use when scheduling a report to pull data from the previous monthSummary: I am attempting to run a scheduled report. The report would run on the first of the month for the previous months cycle count program results. In past releases,… -
UCM vs Object Storage for BICCSummary: UCM vs Object Storage for BICC Content (required): What is the recommended approach? Our end goal is to load the extracts into a database. Version (include the …
-
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…
-
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
New Records in OTBI ReportNew Records are not showing OTBI Report as it's taking a couple of hours to show in reports Let's say, I create New categories under the same catalog and want to see the…
-
In which table we can find reference type for costingDear , Can anyone tell me which table i can find Costing reference type i cant find these check picture for reference Thanks -
Seeded pick slip report submitted from inventory UI in wrong languageSummary: Content (required): 1- Log in to Oracle in French (All the settings in French in manage user preferences) 2- Go to manage pick slip screen in the inventory modu…
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed… -
How to Send Multiple files in one mail using Bursting(BI Report-EText template).Summary: Trying to Send Multiple files in one mail using Bursting(BI Report-EText template). How can we achieve this? Version (include the version you are using, if appl…
-
What DFF's or Flex fields are we able to bring into to OTBISummary: Looking for documentation about which dimension in OTBI we can extend with flex fields. We found in finance module that not all flex fields were eligible to com… -
How to Remove Edit Option for OTBI Report.Summary: Content (required): Hello Friends We have made a custom role and added duty role -"Receiving Transaction Analysis Duty". Assigned this role to a user. But I do … -
Moved: Error while loading Sales order through FBDIThis discussion has been moved.Aravindan Sankaramurthy -Oracle 1 view 0 comments 0 points Started by Aravindan Sankaramurthy -Oracle -
Supplier(vendor name) table in Manage Serial screenSummary: Hi Supplier (vendor) table in Manage serial screen . Is there any query for BIP? Content (required): Version (include the version you are using, if applicable):…
-
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…
-
Customising Purchase Order Data ModelSummary: How to customise the purchase order data model Content (required): The Line.NOTE_TO_VENDOR column appears in the PdfArchivePurchaseOrderLine dataset but not the…
-
Can we use decode or if-else in excel templateSummary: Hi Team, Can we use decode or if-else in excel template for BI report. If yes. can you please share sample example. Regards Nidhi... Content (required): Version…
-
OTBI report - Pending PR list for all buyersSummary: Currently Buyers can view the pending PR for his/her requests. But it needs to view all the Purchase Requisitions by the buyers including his/her requests. Cont…
-
Org LOV throwing error in Standard Report - Exception Summary by ItemSummary: Org LOV throwing error (Attached Screenshot) in Standard Report - Exception Summary by Item. Content (required): Org LOV throwing error (Below Screenshot) in St…
-
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…
-
Table and column for Firm DateSummary: The supply planning UI shows Firm Date as a column in the supplies and demands table. This date reflects when the product is expected to arrive. What is the tab…
-
FBDI Import -Items (FBDISummary: High volume data in Products while loading Inventory Orgs Content (required): Hi Folks, We are in process of Loading Items in our projects we have 11 lakh recor… -
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i… -
How to schedule a report that requires more than 25k linesSummary: When I schedule a report I am finding that I only ever get a maximum of 25k lines. This is not sufficient for the reports that we run regularly Content (require…
-
Is there a Rest API to fetch report (OBIEEE reports)Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):