BI Publisher
Discussion List
-
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 5 views 4 comments 0 points Most recent by Gaurav Kumar-100036 General Ledger & Intercompany -
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 759 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Table or logic to find Account Coding Status in ap invoicesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Prasadreddyv 7 views 2 comments 0 points Most recent by Gaurav Kumar-100036 Payables, Payments & Cash Management
-
Merging Multiple PDF Attachments as Additional Pages in a Single PDF Output BIP ReportI am working on a BI Publisher report in Oracle Fusion and would like to understand whether the following requirement is technically feasible. For an AP Invoice, there m…User_HRWJI 8 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
query that fetch failed transactionSummary: SELECT * FROM ( SELECT DISTINCT HTCE.TRANSACTION_ID, HTCE.PROCESS_CATEGORY, HTCE.OBJECaT_NAME, HTCE.CREATED_BY, papf.PERSON_NUMBER, ppnf.FULL_NAME, TO_CHAR(HTCE…Bindiya S.K 7 views 1 comment 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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…
-
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…
-
Inconsistent Display of Chart of Account (COA) Segments in Expense Approval NotificationSummary: We are experiencing inconsistent behavior in the content of Expense Approval Notifications sent to supervisors and managers. The Chart of Accounts (COA) details… -
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 477 views 4 comments 0 points Most recent by SMalhotra Reporting and Analytics for HCM
-
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…Venkatesan 111 views 6 comments 0 points Most recent by UchihaItachi Reporting and Analytics for HCM
-
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 313 views 11 comments 10 points Most recent by UchihaItachi Reporting and Analytics for HCM -
Delivery of balance forward bills stops in Retry In Progress statusSummary: Delivery of balance forward bills stops in Retry In Progress status Content (please ensure you mask any confidential information): You're about to run create a …Yuma Suzuki-Oracle 203 views 10 comments 0 points Most recent by NeelamTejwani Receivables & Collections
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 75 views 11 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM -
How can I pull in all ledgers within one report regarding 'Subledger Period Close Exceptions Report'We have 20 + ledgers and have to run a report for each due to 'Ledger' as a required field. Does anyone have any workarounds if Oracle has not created another BIP report…
-
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err… -
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20AUser_2025-02-05-04-17-04-394 400 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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…
-
How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates?Summary: How to handle single quotes within an if statement value in Oracle BI Publisher RTF templates. Content (please ensure you mask any confidential information): To…
-
Trade Reference Letter aka Credit Reference Letter - Available?Does Oracle have functionality to generate a trade reference letter aka credit reference letter? If so, from which module? I am not asking about a letter of credit but i…
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
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…
-
Generate Nutrition Facts Panel / Label in Oracle Fusion CloudIs there a way to generate and print nutrition facts panels or labels in Oracle Fusion Cloud? Maybe using BI Publisher or other tools.Srinivas Somanchi 2 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
Print Receivables Transactions – multiple invoices for same customer in one email or PDFSummary: We are using the standard Print Receivables Transactions job in Oracle Cloud ERP to generate and burst invoice PDFs to customers via email. The standard process…
-
Looking for guidance on custom email solution for Oracle Fusion - Receivables Print TransactionsSummary: We are currently using the standard Oracle bursting process (Job: Receivables Print Transactions) in Oracle Fusion Cloud Receivables to generate and email custo…
-
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 15 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
In which bip table to find Administator conversation commentHello, I am looking into a way to report on the comment found in the page "administator conversation" in offering page. Could you please advise ? Thank you !