Category 129
Discussion List
-
DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL.DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL. The DFF's are BI Enabled. But these DFFs do not appear in the BICC extract Data Store. Can you ple…
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 14 views 3 comments 0 points Most recent by Luis Orihuela Reporting and Analytics for ERP
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP 12.2.1.4 desktop flagged with Malicious with high threat scoreSummary: Software packaging team has restricted BIP 12.2.1.4 desktop installation due to high threat score. Need a workaround so that we can continue to use BIP desktop …
-
view past versions of PDF in oracle fusionSummary: How to view the past revisions of PO PDF within Oracle Fusion ? Content (please ensure you mask any confidential information): Version (include the version you …
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th…
-
Oracle Fusion table for AP transactionsSummary: We are currently creating two BIP report to pull AP transactions. The first BIP report needs to pull AP transactions from GL table and the second BIP report sho…Gel Romero 28 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …JHould 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b…sailesh_cloudare 8 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…Joseph Rodriguez 22 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extractSummary: Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extract. Lot of BI enabled DFFs are not available in Doc ID 2463485.1. For ex…MohanPothuri 30 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report …Darwin HP 56 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle 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 3 views 2 comments 0 points Most recent by Sreekanth Kandula Supply Chain Planning and Collaboration
-
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …Frank.Steinjan 2 views 2 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
TAD Setups - For Project POs Charge AccountSummary: TAD Setups - For Project POs Charge Account Content (please ensure you mask any confidential information): According to business requirement, we have configured…
-
how to get production instance name in BIP reportSummary: How to check via SQL in BIP report whether the instance is Production vs non Production ? we have a requirement to put a check in the BIP report so that emails …
-
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES…Chetan Konda 558 views 8 comments 0 points Most recent by Natarajasuthan K Reporting and Analytics for ERP
-
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …
-
OTBI Analysis to get a value from the latest project budget versionI have created an OTBI analysis that shows values from the original budget version , but I want to compare it with the same values of the latest budget version, but when…Mohamed Abdelbar 8 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Project Management
-
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe…
-
Trial Balance Report IssueIn Report credit side are just totals wherein it should have been broken according to each related account, like shown in the debit side, below is the 2 SS with wrong on…Vivek Makwana - Finance 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
FRS - Option to get the 'Prompt' of the COA segment in the POV instead of the segment nameSummary: Hi All, We had a requirement to change the segment name of the Future segment. Since it had multiple implications as suggested in the forum we have only changed…Vipusha Chandrakumaran 5 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
FRS YTD HTD instead of Month/QuarterSummary: We are designing a new report with BU Assets and its balance. We see the dimension as Year, Quarter and Month. Is there any way we could use the option HTD (His…Ralex123 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Installment payment dateSummary: We would like to have the installment payment date on a report. Content (please ensure you mask any confidential information): We have a report with using the P…
-
Are there out of the box reports for financial reporting studioSummary: We wanted to see the capabilities/use case for Financial Reporting Studio. When you browse through the catalogue there it appears to use the same catalogue as O…Renee Dinh 13 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Oracle BICC Frequency options checkSummary: Hi , Oracle BICC has feature to schedule the data extract job with recurrence frequency of Hourly, Immediate, Daily, Weekly and Montly. However our client needs…