BI Publisher
Discussion List
-
26A Upgrade | Learning | Impact on Database value changeSummary: I have identified a potential impact following the 26A upgrade, based on the Community post (https://community.oracle.com/customerconnect/discussion/948343/data… -
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl…
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ…User_DNVLS 3 views 1 comment 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to add custom archival data to the GTN report?Summary: A customer needs to add custom deductions to the Gross to Net summary report, just as they can in the Payslip, which include this feature. The XML does not cont…
-
Turkey E-ledger requirementSummary: Hello Team, Our customer requires Turkey E-Ledger report to be developed as part of Turkey Localization. Please check and let us know if we have any out of box …Narayanan M S-Oracle 53 views 3 comments 0 points Most recent by AndresGlz2109 General Ledger & Intercompany
-
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 355 views 8 comments 0 points Most recent by Sampath Kamtala Payables, Payments & Cash Management
-
Is it possible to see the Old Value and New Values for Project Management Changes in Audit Data?Summary: I am trying to identify Project Management changes in BIP tables, specifically Project Org or "CARRYING_OUT_ORGANIZATION_ID" . We need to include the historic d…Kimberly Showman 17 views 2 comments 0 points Most recent by Kimberly Showman Reporting and Analytics for ERP
-
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…Shuai 875 views 8 comments 0 points Most recent by Chris_Peer_Gibraltar1 Reporting and Analytics for ERP
-
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…Jibin 12 views 1 comment 0 points Most recent by Global Oracle Support-Oracle General Ledger & Intercompany
-
Download Excel template BIP Report using SOAP Web ServicesThere was an error rendering this rich post. -
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 92 views 18 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
DML Operations like (Update,Delete) not working on ATPDB database table which is hugeSummary: DML Operations like (Update, Delete) not working on ATPDB database table which is huge. Archive table that is present where i want to do the operation and clear…Mahmoud Elbestawy 1 view 0 comments 0 points Started by Mahmoud Elbestawy General Ledger & Intercompany
-
Supplier master Alias name tableSummary: Need a query to get the Supplier master Alias name Content (please ensure you mask any confidential information): Hi, we are maintaining some naming conversion …Mamdouh Ahmed 11 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Can you send me a sample of email notification for payment approval workflowWe are not yet using the payment approval workflow. I only want is to see the format or template and details when we received the notification for approval.GRACE SORIANO 1 view 3 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
How can Fusion BI Report generate two different PDFs for same data at each ESS run.I have a requirement where my report should have two outputs one with all price columns other without for same data. Based on my bursting logic I can generate two emails…
-
Standard report to see the default expense account of an employeeSummary: The client is looking for any standard reports to check the default expense account assigned to an employee Content (please ensure you mask any confidential inf… -
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…
-
HCM Extract Email Bursting/DOR is getting failed when no data is returnedSummary: We have a requirement to burst the pdf file to employees and have the same added to DOR. When the extract returns data, the delivery option Email bursting and D…
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 322 views 17 comments 0 points Most recent by User_NF6P4 Reporting and Analytics for ERP
-
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 518 views 5 comments 0 points Most recent by Amit_Ekbote Reporting and Analytics for HCM
-
P60 reprint blank in document records but showing in flow correctlySummary: An employee had set their document delivery preferences to not have an online copy for a P60 produced. This resulted in the employee not having a P60 created in… -
Payment method details in the tables on the providersSummary: I need to identify which Oracle Cloud Fusion table stores the “Default” and “Payment Method” attributes within the Payments section of a supplier's main site (s…Cristian Rojas 22 views 3 comments 0 points Most recent by Md_Anees-Oracle Payables, Payments & Cash Management
-
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 44 views 7 comments 0 points Most recent by Larissa Meid Payables, Payments & Cash Management
-
SQL query to get position in performance documentSummary: SQL query to get position in performance document Content (please ensure you mask any confidential information): Could you please advise on the SQL query needed…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…