Category 385
Discussion List
-
Clarification on Delivery Status Storage in Receivables – AR_BPA_DELIVERY_DETAILS Table BehaviorWe are currently investigating where the delivery status is stored in Oracle Receivables. During our analysis, we identified the table AR_BPA_DELIVERY_DETAILS as a poten… -
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History
-
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464…
-
In case of SCFO context in AR invoice, how to get fullfillment line id?In oracle fusion, I want an sql query to find fullfillment line id in case of Supply Chain Financial Orchestration (SCFO). For DOO we are getting this from interface_lin…ManuYal 13 views 2 comments 0 points Most recent by Victor Martin Supply Chain Planning and Collaboration
-
Feasibility of Using PDF with Embedded Tags Instead of RTF TemplateCan we modify the PDF document to include tags/tokens such as P_SIGNER within the PDF itself and upload it in place of the existing RTF templateAprajita Gokhale 4 views 0 comments 0 points Started by Aprajita Gokhale Reporting and Analytics for ERP
-
how to customize FusionApproveRejectLinksHi, anyone knows how to customize FusionApproveRejectLinks for the approvals? Thanks
-
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 73 views 2 comments 3 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag…
-
Administer Salary Notification template modificationThe approval workflow for administer salary includes - current HRBP-> Second Level Manager -> AROC_COMPENSATION_ROLE EXCEPTION: if the person receiving the salary increa…
-
Query to fetch approvers listWe are trying to customize performance seeded report and trying to fetch the list of approvers/managers who has approved the document. We are trying to get the details f…
-
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …Shagulhameed 10 views 1 comment 0 points Most recent by Lily Wang 026 Reporting and Analytics for ERP
-
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 37 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Looking for report listing users and assinged user role with start and end date of role assignmentSummary: Report listing active users and current and past assigned roles Content (please ensure you mask any confidential information): Client is looking for a report th…
-
In Source to Settle InfoletIn some cases, drilling down is not an option (i.e. the pie chart displaying the supply base). I am unable to drill down on the 21%.
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… -
Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
-
What Subject Area is used to create a report for Item Batches and their overall statusWhat Subject Area is used to create a report for Item Batches and their overall status The purpose of the report is to see how many item batches are: Completede/In Progr…
-
Absence workflow approval notificationsTeam, we want to customize and hide attachments from approval workflow notification for absence approval. We want to customize the seeded template to hide the attachment…
-
Is it possible to register BICC Jobs in an ESS Job Set?Is it possible to register BICC Jobs in an ESS Job Set?
-
Difference in Accounts Shown Between Trial Balance Extract Report and SmartViewWe have a doubt regarding the Trial Balance. When we run the Trial Balance Extract Report from the Schedule Processes, the output is missing some accounts. However, when…Mukesh Sirigiri 33 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi…
-
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 24 views 3 comments 0 points Most recent by Pandit Yaashi Reporting & Analytics for Fusion Service
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 1.6K views 13 comments 1 point Most recent by Ashish_Goyal_MPC Applications Security
-
Issue with PO PDF Layout in Oracle FusionWhile customizing the Purchase Order PDF layout in Oracle Fusion, I encountered an issue with the standard data model. When the PO is in "Draft" status, all line details…
-
Total Outstanding Amount and Current Amount in FDI are retrieving incorrect information.I am working on an AP analysis in FDI and I am using the fields Total transaction Amount (AP Invoices), Total Outstanding Amount (AP Aging) and Current Amount (AP Aging)…Maria F Covarrubias-Oracle 16 views 0 comments 0 points Started by Maria F Covarrubias-Oracle Payables, Payments & Cash Management -
Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …Sreeram Tadepalli 335 views 4 comments 0 points Most recent by Sreeram Tadepalli Reporting & Analytics for Fusion Service
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…