Category 129
Discussion List
-
Any SOAP or REST calls available to see status of scheduled BIP reports?Hello Gurus, I am looking for SOAP/REST calls that can tell me whether the scheduled BIP report failed or succeeded. The navigation is Reports and Analytics → Home → Rep…Sheetal VBCS 11 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP -
Income Statement and Balance Sheet are returning error values for Net Income and Asset balancesWhat are the possible reasons for Net Income and Asset values showing error values in the Income Statement and Balance Sheet generated in FRS? Investigation performed so…
-
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…Naved Khan 410 views 6 comments 0 points Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP -
Unwrap Text in BIP Report Panel LayoutSummary: Please let me know if anyone worked on below functionality. I have a BIP report that uses a template designed using Oracle Fusion Reports and Analytics. The rep…Bala Murali SV8 23 views 4 comments 0 points Most recent by Bala Murali SV8 Reporting and Analytics for ERP
-
OTBI analysis on duplicate expense linesSummary: How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice …
-
FRS reporting issues- dimension placement making huge differencesI’m having an issue with an FRS report. When I place the scenario in the columns, the trial report doesn’t match the one from the generated from scheduled process, but i…
-
To identify last modification details in Item Master , Item Locator and SubinventorySummary: We want to identify last modification details in Item Master , Item Locator and Sub inventory other than the 'last update date' , 'creation date', 'last updated…PrerakKhandelwal 4 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…Sowbhagya B 33 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Locating PVOs and Data Stores for ar_batch_sources_all and ar_credit_memo_amounts Tables in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Edit template and add new column in the existing excel templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Santhosh M-Oracle 6 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Query to retrieve list of bi publisher jobs in oracle fusion.Summary: Hello Team, Could you please help in providing the query to show all the scheduled jobs from BI publisher page. Content (please ensure you mask any confidential…Srushti Dhote 20 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
ESS Job Report Output File NameSummary: After running the ESS job in Oracle Fusion 'Default Document', we can see the output name. Can we set this output name to reflect the order number or invoice nu…
-
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 14 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Is there a way to change the format of the output from a report?We currently have a custom report we use for maintenance, and the user is requesting we help him change the output options so CSV can be used. We currently only have HTM…
-
What is the recommended way to extract data in bulk from the compensation external data tables?Summary: I need to extract Total Compensation Statement data from the the external data tables. What is the recommended way of doing that? Content (please ensure you mas…
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 115 views 2 comments 0 points Most recent by Regie Mercado Reporting and Analytics for ERP -
Upload Image in Financial Reporting CenterSummary: Upload Image in Financial Reporting Center Content (please ensure you mask any confidential information): Hi, How to upload the image such as logo into FRS and …
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…Mainur-Oracle 84 views 9 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…Tomoyuki Hyakutake-Oracle 29 views 3 comments 1 point Most recent by Ilmars K. Reporting and Analytics for ERP
-
How to establish Linkage in SAwhat is the linkage between Procurement - Pending Change Orders Real Time and Procurement - Purchasing Real Time Subject Areas. Although Order and Order Number from resp…Raakesh Piranawar 24 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c…
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…sarathkumarkondadadi 17 views 0 comments 0 points Started by sarathkumarkondadadi Reporting and Analytics for ERP
-
Unable to find error details in interface table GL_SEGMENT_VALUES_INTERFACESummary: Hi Experts, Could anyone please provide the details for 'GL_SEGMENT_VALUES_INTERFACE' table. The import program 'Import Segment Values and Hierarchies' getting …Sai Krishna Chelikani 14 views 0 comments 0 points Started by Sai Krishna Chelikani Reporting and Analytics for ERP
-
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…PrerakKhandelwal 23 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
How i could find KB29474Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL for all roles and it's inherited roles for BIP.Summary: Hi, I have a requirement to create a BIP report to fetch the details of all Roles and its inherited roles. I have seen that it can be achieved by OTBI but can't…Sameer Khan 29 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI 条件分岐Summary: I want to implement conditional branching in OTBI. What operations are required to achieve this? Content (please ensure you mask any confidential information): …