BI Publisher
Discussion List
-
How to disable "Import Payable Invoices Report" generating for every Import Payables ESS Job run?Our client uses another system to process their AP Invoices. They validate the invoices triggering the web service for Invoice Import (7.5-10k per day). This process is …Camilo Botín-Oracle 51 views 1 comment 0 points Most recent by dwalia-Oracle Payables, Payments & Cash Management -
Where to find the client channel data (i.e., the payment initiation method) in ERPHi, The requirement is to identify where the client channel data (i.e., the payment initiation method, such as H2H or J.P. Morgan Access) is stored in Oracle Fusion, and…Keerthana Sekar 11 views 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
can not see all records in AP_IDR_INVOICE_TRACE_DYD tableSummary: Table - AP_IDR_INVOICE_TRACE_DYD, this table is used in standard invoice document recognition tracking report. But when we have queried the table, we can not se…Rama Krishna T 48 views 2 comments 0 points Most recent by Rama Krishna T Payables, Payments & Cash Management -
Setup PrinterHi, I need to print a receivables report directly to a printer in another physical location. 1. Is there any functional setup I need to do? 2. How could I make this work…Cleton Carvalho 21 views 2 comments 0 points Most recent by Gal_Var-Oracle Receivables & Collections -
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc… -
Send Payslip to Printer For Teminated employeesSummary: Hi Everyone, We have one requirement that we need to send Payslip for only terminated employees to Printer. I have created different template and add in deliver…Krishna Manmohan 11 views 1 comment 0 points Most recent by Krishna Manmohan Reporting and Analytics for ERP -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 184 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP -
Request for REST API Details for SLA Accounting Journals (AR/AP)Hi Team , We are unable to locate the REST API name related to SLA accounting journals (e.g., AR, AP) in the Oracle documentation. This information is required to develo…Tasweer ur Rehman 11 views 0 comments 0 points Started by Tasweer ur Rehman Subledger Accounting & Accounting Hub -
How to move OTBI & BIP reports from one instance to anotherSummary: How to move OTBI & BIP reports from one instance to another instance? Looking for the easiest way to achieve this. Content (please ensure you mask any confident… -
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 101 views 7 comments 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM -
FND_FLEX_VALUE_RULE_LINES equivalent table on Oracle Cloud FusionHi all, I'm working on an EBS to Cloud project, and we have the following requirement - Send to the legacy system all the valid account combinations. Today, they are usi…Arthur Teodoro 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Implement Badging in Oracle Learning Cloud and Integrate with talent profileSummary: We are looking to implement badges in Oracle Learning Cloud Content (required): Hi All, Our client is looking for implementing Badging functionality in Oracle L… -
Custom Payables Invoice Aging Report did not copy the parameterSummary: copy of the Payables Invoice Aging Report did not copy the parameter Content (please ensure you mask any confidential information): Version (include the version…ERP User 11 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Payables, Payments & Cash Management -
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee. -
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 128 views 6 comments 0 points Most recent by Hemanth Kumar Muthyala Reporting and Analytics for HCM -
Need a package "ar_arxagmw_xmlp_pkg" logicSummary: There is mismatch found in the custom and seeded report (Receivables Aging by General Ledger Account Report) in the amount remaining balances. We would like to … -
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t… -
Updated Supplier Profile/Address level bank account number is not visible before change req approvedHello Team, I'm in need of information regarding supplier-level bank account number updates. When we do any update in bank account number in supplier profile or supplier…SritharThangavel 131 views 4 comments 0 points Most recent by Anum Arshia Payables, Payments & Cash Management -
Unable to fetch details of entries coming from subledger in secondary booksSummary: Content (please ensure you mask any confidential information): We are trying to build a Custom Account Analysis Report, but unable to fetch details of entries c…Divya2307 1 view 1 comment 0 points Most recent by Matt Lennon - Terillium General Ledger & Intercompany -
Scheduling BIP report is failingI have a BIP report which has bursting enabled. The underlying data model has 2 datasets- 1 is of type HTTP (XML feed) and 2nd is of type SQL query. HTTP dataset calls a…Neha Aishwarya 21 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
last update date not getting for Business unitSummary: Hi We have deactivated Business unit. i was looking for last update date in view#fun_all_business_units_v but i am not seeing any change last_update_date. May I… -
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir… -
We need to enable Date Format in DD/MM/YYYY. This has to be done at Global Application level.Summary: We need to enable Date Format in DD/MM/YYYY. This has to be done at Global Application level. I know we can set this at individual preference level but is there…MeghashyamMantripragada 1 view 0 comments 0 points Started by MeghashyamMantripragada Receivables & Collections -
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti… -
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio… -
Payment Approval Is Not TriggeringSummary: Payment approver is not triggering any approval for condition is 1=1. It means approval should trigger for all the payments. But its not triggered. I am not als…Kish_Hariharan 31 views 4 comments 0 points Most recent by Kish_Hariharan Payables, Payments & Cash Management -
How to restrict Asset Book parameter in ESS Job and BIP based on user granted access?Summary: Content (please ensure you mask any confidential information): We have a custom BIP report to extract asset details which contain the 'Asset Book' parameter, th… -
Quick action menu created for BIP is not visible after 25DSummary: I have created Quick Action Menu item for BIP report course completion certificate. after 25D, its not appearing , when I checked in Sandbox , it shows message …Raghavendra M 21 views 1 comment 0 points Most recent by Yashaswi Sanjeev Kulkarni Reporting and Analytics for HCM -
link to data set parameterSummary: Working with BI Publisher I have 5 different data sets. There is the header query and then there are children queries which are all linked, one of which has a t…