OTBI
Discussion List
-
Funds Available Balance reportProblem Summary Funds Available Balance report Problem Description As per "Using Financials for the Public Sector" guide under: Surplus Funds to Carry Forward A sample o… -
Data Model link between FSCM and OBIEE latencySummary: Data Model link between FSCM and OBIEE too slow. Content (please ensure you mask any confidential information): When I create a financial data model that links …
-
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table stores the PO fund check information?Hi all, I'd like to create a report about PO line funds check. May I know which table stores the information about PO funds check status? Thanks in advance! -
Budget Vs Actual reportSummary: Is there a Budget Vs Actual vanilla report/ OTBI report? Content (please ensure you mask any confidential information): Version (include the version you are usi…
-
What is table and column name for project budget dateSummary: Hi All We want to know the date of final approval of project budget with current baseline or current and original baseline. We need this: Please help us to find…
-
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… -
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 692 views 9 comments 0 points Most recent by MFlannery Reporting & Analytics for Sales -
Unable to open reports under Reports to work area mapping in oracle fusion?I am currently experiencing an issue with accessing the reports under the "Reports to Work Area Mapping" section in Oracle Fusion. Could anyone kindly assist me in resol…
-
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 11 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 21 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 -
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 42 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 352 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Cost of all make items under work orderSummary: We have a work definition for Assemble item#117474-03. Under those assembly items(Explode the bom), there are multiple make items containing the work definition…
-
OTBI - Work Relationship Start DateSummary Trying to return a single line per employee instead of all dates of job change.Content The work relationship start date returns a row of data for employees for e…
-
How can we obtain XML to build our reportSummary: We are trying to create a custom report that pulls data from an approval flow. In the previous SR it was recommended that the information is stored in XML. We a…
-
OTBI Recruiting Candidate Data SecurityHello, We currently operate in multiple GDPR countries, and our Legal/Data-Privacy departments are requiring that we lock down candidate and job requisition data based o…Nick Dorfner 11 views 2 comments 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
DR number and Shipment number not appearingSummary: I have 3 lines on one SO, all lines are closed and billed. But when checking on OTBI (sales invoice report), DR and Shipment number is not appearing on one SI. …
-
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 63 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management