BI Publisher
Discussion List
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple… -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 824 views 9 comments 0 points Most recent by User_P172L Reporting and Analytics for HCM -
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…Sara Suleiman 94 views 5 comments 0 points Most recent by Alice Gouzy Reporting and Analytics for HCM -
WLF_ASSIGNMENT_TASKS_F LAST_UPDATED_BYSummary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn… -
IFRS 18 Compliance- step by step instruction for setup for Hongkong ClientsHi, From January 2027 onwards IFRS 18 is going to be implemented, is it mandatory for Hongkong based clients? If yes, provide us the approach given by Oracle to acheive …Rachaiah Vadlakunta 2 views 0 comments 0 points Started by Rachaiah Vadlakunta General Ledger & Intercompany -
Data Extraction Using Read-Only Replicated Data - 26B ReleaseHas anyone successfully enabled the 26B feature: Data Extraction Using Read-Only Replicated Data? (Feature ID: F44066). The step to Enable Security Console External Appl… -
Why created Global access groups are not showing for communities Membership?Summary: Why created Global access groups are not showing for communities? we have created three Global access groups, we want to reuse the same access groups. And let u… -
Which table has the information for Rule Builder for Checklist Template redwood taskSummary: Hi team, Which table has the information for Rule Builder for Checklist Template redwood task. Need the table where Rule builder name stores for the checklist c… -
Payslip XML returns INPUT_VALUE_5 (Rate) as -1 but Rate is null in element entry pageSummary: We have created a Legacy element entry for a person through HDL with Input values for Original start date, Original end date, Multiple, Amount. All the values a…Satheesh Nesamani 13 views 0 comments 0 points Started by Satheesh Nesamani Reporting and Analytics for HCM -
Time Change Request Type TableSummary: Hello, does anyone know which table stores the values of Request Type column in Time Change Request page? We are currently building a BIP report and was able to… -
disabling the View invoice button from the notification sent by BPM work List - AP invoiceSummary: Need to disable View button based on certain Roles user has access to. There is a rtf template attached to it as will , have attached the same. Please help. Con… -
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 138 views 6 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to remove line feed and Carriage return from clob columnSummary: How to remove line feed and Carriage return from clob column, without using Translate function and Exclude Line Feed And Carriage Return for LOB option in prope…Ranjith1166 25 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ORA-64203:destination buffer too small to hold to hold clob data after character set conversationSummary: I was using below logic for getting job profile responsibilities and it was throwing the error "ora-64203:destination buffer too small to hold to hold clob data…Ranjith1166 26 views 2 comments 0 points Most recent by Gail Langendorf-Oracle 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 14 views 5 comments 0 points Most recent by Mahmoud Elbestawy General Ledger & Intercompany -
Configuring Descriptive Flexfield Segments With Expense Report ParametersContent What attributes are enabled as flexfield parameters, and the syntax to be used in the value set logic for the Expense Report? I'm creating a new flexfied, in the… -
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I… -
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…Vinayak Hegde 41 views 3 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM -
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm…Ramachandran Mani 37 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 67 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM -
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…Gurivi Reddy-Oracle 23 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
CAMT053 Bank statement load failing with CE-660228 Despite custom JPM FormatSummary: We are trying to load JPMorgan chase CAMT053.001.02 bank statement files into oracle fusion CM using the Load and import bank statement ESS process. The file co…Prashant Prashant 38 views 1 comment 0 points Most recent by Sanket Darokar Payables, Payments & Cash Management -
per_national_identifiers security?Does the table per_national_identifiers have AOR security? I see quite different row counts depending on whether I run a count (*) from pni when logged in as a country H…Stephen Jones 18 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…Naveen_CCC 16 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP -
Can we exclude minimum amount receipts from AR Aging report (like -0.01)Our customer don't want receipts which has amount less than $1 in their AR aging report (attached ss for the same), can we exclude those receipts from this report?Jayshree Chavan 4 views 4 comments 0 points Most recent by Jayshree Chavan Receivables & Collections -
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 69 views 3 comments 1 point Most recent by User_6GELQ Payables, Payments & Cash Management -
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…