-
Download reports xml using command line Catalog Manager and online mode
Hi, Is it possible to download all XML reports from a specific folder using Catalog Manager in command-line and online mode? Regards Szymon
-
'Print Receivables Transactions' Data Model does not return any Sample Data.
The underlying data model for 'Print Receivables Transactions', ' Transactions Print Data Model', does not return any sample data. I would need this to get a sample XML to create a custom template and for its testing. I tried it for a single Transaction as well and it keeps Processing and eventually get timed-out
-
From where we can download Informatica 10.5.9 at Oracle portal
Hello Team, It seems Oracle is providing Informatica license at Oracle portal/eDelivery. But we are unable to find Informatica version 10.5.9 software at Oracle eDelivery. We need to upgrade Informatica to latest version. We do use OBIEE and BIP as well. Whom should we reach out for help? Sales or licensing team at Oracle?…
-
How to replace "No results. The specified criteria (...) any data." with a customized tile?
Hi, I have a dashboard with 2 prompts filtering by asset state and location in one section and multiple small analysis in another section that show different type of models. Here below a dummy example with 4 tiles (each tile is one analysis and they all are in one section): 280 15 170 95 Notebook Large Notebook Large…
-
How to fetch the fetch the CONTENT ID based on ESS Job request ?
I need to fetch the Content Id (Output file)based on my ESS Job request Id, Join or table query also fine. Key Tables for Content IDs:- REVISIONS , FND_DOCUMENTS_TL and FND_ATTACHED_DOCUMENTS. I am failed to get the link between these… Please help. Thanks, Prasad.
-
SQL query for Review Cost Accounting Distributions information tab details in detail
Hi Support, SQL query for Cost information tab details in detail Review Cost Accounting Distributions - Could anyone help me to get the SQL query to get cost component wise amount. SQL query for Cost information tab details in detail CST_LAYER_COSTS - Table hold amount in summary level not in detail. Please provide the sql…
-
During Intall of Oracle Analytics toolkit got INST-07551
Found reference Knowledge Article regarding patch 37351880. The solution is to use OPatch 13.9.4.2.18 version so is this my solution and if so how do I get this version?
-
2 reports in this Ship Confirm Documents BIP Job set are facing issues to fetch data
Below are the reports in Job set: 1.Print Packing Slip Report Error: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo11g.xpath.XPathException: Extension function error: Error invoking round:java.lang.NumberFormatException 2.Print Commercial Invoice Report Error: <Line 151, Column 167>: XML-22044:…
-
Brazil ECD report -BIP report , output in pipe delimeted text
Team, Do we have any standard Brazil ECD BIP report , pipe delimeted text output. This report is to declare GL entries , balances to Brazil Govt. This is mandatory for any company having business in Brazil. I am looking for the standard report which can we customize, if needed.
-
How can we relate DOO_headers or with fulfill table with requisition/po/with receipt for BIP report
i need to find some connection. scm_supply_headers table is not there in the system,, What other tables i can use for connectivity. also source_document_id is not there in doo_fulfill_lines table to connect with po_header.
-
In FDI using a custom subject area, how to perform detail calculations at a record level?
In FDI using a custom subject area, how do I perform detail calculations at a record level before doing aggregation? We have customer shipments data; one line per shipment where the status of the shipment line can indicate that the item was shipped or the item was returned. Based on shipment line status and shipment date…
-
Is there any we can increment the parameters of scheduled FRS report
We have an FRS (Financial Reporting Studio) report that needs to be scheduled. For each scheduled run, the Accounting Period parameter should automatically increment to the next period. Is there a way to achieve this functionality?
-
DAC services are going down with below error.
Shutting down the server.... DAC Repository connection lost. Shutting down the server.
-
The dashboard error is occurring intermittently.
OBIEE 12C Analysis/Dashboard is giving below error: State: HY000. Code: 59001. [nQSError: 59001] Join operation is not permitted on operand(s). (HY000) State: HY000. Code: 46035. [nQSError: 46035] Datatype(CHAR) nullable(0) unicode(1) external char(0) conversion to datatype(INTEGER) nullable(0) unicode(1) external char(0)…
-
Power BI connector
Hi, We have semantic layer created in OAS that we want to use in Power BI with the help of a Power BI connector. We are not in cloud and cannot use the Power BI connector (Preview). Does anyone has any tips, workaround, or know when Power BI connector is available for OAS. Thanks Tasmeia
-
OBIEE Presentation variable stops refreshing
I use a column filter in an OBIEE analysis that is based on a presentation variable that is set when selecting a date from the dashboard prompt. The date is one of three columns to select from the prompt. This is the column: TIMESTAMPADD(SQL_TSI_MONTH, -11, "Receipt Organization Summary Fact"."Month") The filter on the…
-
BICC PVO missing information in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO
Hi, Could you help me please with some advices related to below issue? We configured FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO in order to get Supplier information, including IncomeTaxId value for each supplier. Even if the BIP Data set returns value for IncomeTaxId column from source table…
-
Need more info | Oracle Critical Patch Update for October 2025
Can you please review and let me know on below queries : 1.Is it applicable to only ERP or is it applicable to OTMGTM,Middleware,OIC and other areas as well, if all other areas please share the list of affected where we need to apply patches. 2. Do we need any downtime or it is online patching where no downtime is needed?…
-
How to display data for a month other than the current one in the calendar type
Hello everyone. I did some scheduling work and used the calendar type, and every month a different schedule is created. When I need to view a schedule from a past month, the calendar always opens to the current month, and I have to keep clicking to scroll back to the month and year I want to view. I saw and used this…
-
How to create Custom BICC PVO Creation in Fusion
Can someone share details on if it's possible to create Custom PVOs for the tables for which the standard PVOs are not available? If yes, please share the steps to create it.
-
Maps in OBIEE 12.2.1.4
Hi community, I would like to use maps in OBIEE 12.2.1.4, and I have a few questions first of all if there's any guide or tutorial to work with maps, is stricktly required to get aSpatial Provider like NAVTEQ, is there any other option? Thanks
-
For 'Humanoid Avatar + AI Agent' (to replace Call Center Operator), what kind of security required?
Now many parties are developing the 'Humanoid Avatar + AI Agent' in order to replace Call Center Operators. In this case, the Security issue will be a large concern. How can we protect our system?
-
How to fetch project source template details for a particular project in Oracle Projects module.
How to fetch project source template details for a particular project in Oracle Projects module in BI reporting. Not able to get the project and its template details using the 'pjf_projects_all_vl', 'pjf_projects_all_tl' or 'pjf_projects_all_b' tables.
-
Does anyone have and can share a presentation (ppt) for 8.2 OAS DV version new feature added?
Does anyone have and can share a presentation (ppt) for 8.2 OAS DV version new feature added comparing it with old version with screen shots whether it is login screen or navigation or outer join inclusion?
-
Internal Server Error while calling /biacm/rest/meta/export API
We are encountering an Internal Server Error (500) while trying to get a response from the API endpoint /biacm/rest/meta/export. Has anyone faced a similar issue or know what might be causing this error? Are there any specific configurations or prerequisites needed for this API to work correctly?
-
Is OAS 2023 certified with OBIA 11.1.1.10.3 PS4? I was told only 2024 & 2025 were certified.
-
DV Export To CSV export format- Date columns corrupted eg FIXE2LENGT02ATE
-
OAC Calculations
I’m building a pivot table in Oracle Analytics Cloud with Month on columns and Category on rows, showing three measures under each month: YTD Previous Year, YTD Current Year, and Evolution. For YTD Previous Year, I’m using the formula Filter(PERIODROLLING(SO Value, -24, -12, Month) using Year(Date) =…
-
How to check list of scheduled or standard notification jobs scheduled in oracle fusion for each mod
Hi Team, We need to see the list of all schefuled ess jobs mainly of those standard notifications getting triggered in Quality management module. How do we check the. We can srach for report jobs scheduled but need the ESS jobs/ standard oracle notifications triggerred for any of actions in Quality Actions/Issues.
-
Hello, I am trying to find the table that holds the selected educational institution in the employee
Hello, I am trying to find the table that holds the selected educational institution in the employee admission.
