Category 129
Discussion List
-
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 11 views 3 comments 0 points Most recent by Luis Orihuela 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 31 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 165 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 1 view 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 21 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 42 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 111 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 1 view 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 1 view 2 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
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 1.3K views 8 comments 0 points Most recent by Natarajasuthan K Reporting and Analytics for ERP -
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…
-
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 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 11 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 21 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…
-
Getting Error while calling US 1099 Payments reportSummary: Hi Team, We are getting Error while calling US 1099 payments report. Error Details : java.sql.SQLSyntaxErrorException: ORA-00904: "CPI"."CLEARING_CCID": invalid…SukaShah 71 views 1 comment 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCMSummary: Staff List by System Role Report Content (please ensure you mask any confidential information): Where do I find these fields - Data Access Permissions, Data Acc…Pradnya_Pampatwar 91 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for HCM
-
default oracle fusion bi publisher reports listSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manda Abhinav Reddy 31 views 9 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Which table store node descriptionSummary: Which table stores node description Content (please ensure you mask any confidential information): I have to pull in the node description for a cost centre on m…