BI Publisher
Discussion List
-
Manage Delegations ReportSummary: Is there a seeded report that would list all the active employees that are able to create expense reports for employees? There is not a way to download to excel… -
Schedule process runs on working daysHello, Is there a way we can schedule a process for a BIP report which runs first 8 business days on hourly basis and from 9th day to end of month to run daily basis. Pl…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 382 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 168 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
How can I add custom columns and layout to a seeded report in Oracle Fusion?Hi everyone, I’m working with a seeded report (Funds Capture Authorization and Settlement Formats) in Oracle Fusion Receivables, and I need to add custom columns to the …
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 71 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 141 views 5 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
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 12 views 2 comments 0 points Most recent by AnamariaRoman-Oracle 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 -
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 12 views 0 comments 0 points Most recent 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 111 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 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 12 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 163 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 …
-
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 32 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 Most recent 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…