BI Publisher
Discussion List
-
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… -
Is there a seeded extraction for the payments part of France e-reporting ?Summary: Here is a list of the France e‑reporting Flow10 sub‑flows (10.1 → 10.4) which is mandatory in France from September 2026 : Sub-flow Purpose Trigger ERP Seeded E…
-
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 111 views 7 comments 0 points Most recent by Ritabrata Mukherjee Reporting and Analytics for HCM -
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… -
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 251 views 5 comments 0 points Most recent by Alice Gouzy Reporting and Analytics for HCM -
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… -
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 11 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 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 31 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 11 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 31 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 101 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM -
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 131 views 1 comment 0 points Most recent by Sanket Darokar Payables, Payments & Cash Management -
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 31 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? -
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 81 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… -
Charge Wise Total Report Producing Incorrect DataI am investigating a custom Oracle Fusion SCM query that calculates landed cost charges by charge name. The query returns correct charge totals for most receipts, but fo… -
The absence report should calculates absence durations based solely on working days.We have created a report name "Absence Balance Details Report" , which has below columns : EMPLOYEE NUMBER EMPLOYEE NAME LEGISLATION CODE LEGAL EMPLOYER NAME ASSIGNMENT …User_6VOPA 41 views 4 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM -
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment … -
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 71 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …Gurvinder Singh Gill 262 views 4 comments 2 points Most recent by mgoswami Reporting and Analytics for ERP -
AGIS tables PVO's doesnot existsSummary: Hi Team, The below AGIS tables PVO's does not exists in BICC. Can you please advice to me. FUN_BAL_INTER_RULES FUN_BAL_INTER_ACCOUNTS_ADDL Thanks Content (pleas…Siva Kumar Bondalapati 21 views 0 comments 0 points Started by Siva Kumar Bondalapati Reporting and Analytics for ERP