BI Publisher
Discussion List
-
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 136 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
While Downloading the General Ledger Details Report in CSV format getting Date format IssueWe are experiencing major flaws in one of the mostly widely used out-of-box report "General Ledger Accounts Details Report" in Fusion (Standard Report). — Accounting Dat…Sai Kumar Bhanumukkula -Oracle 11 views 1 comment 6 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Query/BI Report - Pay Elements Paid Past Term DateHi I am looking for a query/BI report that will show me pay elements that have been processed and paid past the employee's termination date. I tried searching the commun… -
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 975 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM -
BIのサブジェクトエリアSales CRM LeadResourceでリードのチームメンバーを取得したいサブジェクトエリアSales CRM LeadResourceでリードのチームメンバー全員を取得したいです。 方法を教えてください。M.AZUMA 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Write a sql query to fetch average number of learning days per employeeSummary: Write a sql query to fetch average number of learning days per employee (includes all formal learning). Content (please ensure you mask any confidential informa…
-
In the BIP report we need Virtual Classroom Type from Learn ModuleWe need to fetch Virtual Classroom Type from learn module. Which table field is to be mapped to get the below required details.
-
Ability to store Email ID on Order and then use it for sending invoices to customerSummary: Content (please ensure you mask any confidential information): Need an ability to capture ordering email id for credit card customers and use that to send an em…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 43 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …Sheetal VBCS 32 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
write a sql query to fetch Total number of Learning Request Approved in last 1 yearSummary: write a sql query to fetch Total number of Learning Request Approved in last 1 year Content (please ensure you mask any confidential information): Version (incl…
-
Report BI - double column headerHi, is there an alternative to RTF for making a report with two headers on the columns? Example I have these columns: Organization Tot Male Female Tot Male Female Org1 4…
-
How to make the email confidential through bursting in BIPSummary: We have a requirement to make the email confidential in BIP , we are sending the email to recipients through bursting . Content (please ensure you mask any conf…
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 85 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree…
-
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…User_39SVE 64 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
what table stores payment date of quick prepayments?Summary: hi All , i need to get the below payment date for BIP but i am not able to get the table which stores this. Please help. i tried PAY_REL_PAYMENTS_VL PAY_PAYROLL…Divya Vaish 21 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Whether increasing the maximum length of existing value set used for GL DFF cause any impact ?In Oracle Fusion Financials, can we increase the maximum length of existing value set used for GL DFF. Will there be any negative impact for this?raveenasingla 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
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.Roy1823 35 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 159 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
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 33 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 52 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
1-click Links Broken with Latest UpdateSummary: Do any customers still use 1-click links for direct links to register for enrollments? I created a report years ago to automate the creation process (link to th… -
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the…Siddhesh Nisal 31 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
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 31 views 4 comments 0 points Most recent by Bala Murali SV8 Reporting and Analytics for ERP
-
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…zakir112443 73 views 1 comment 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for HCM
-
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 41 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
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 31 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP