BI Publisher
Discussion List
-
How to call ESS job by API erpintegrationsHi Experts, I 'm trying to execute ESS job "General Ledger Trial Balances Report" by API erpintegrations in postman. POST https://xx.fa.us2.oraclecloud.com:443/fscmRestA…Marcos Allonso-53979 32 views 3 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder… -
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,… -
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 12 views 0 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM -
1099 Future Support for IRS A2A (Application-to-Application) XML File FunctionalityDescription: We are seeking information on whether Oracle plans to support IRS A2A (Application-to-Application) XML file functionality within the product in future relea…Senthil Murugan J 96 views 1 comment 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
GL-HUB-AP report takes too long to runWe have a report which pulls GL, Hub and AP data by journal line level, it takes a long time to run since it is going back into Hub, which has +1mn transactions per day … -
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,… -
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 55 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM -
Which table holds Learning Initiative DataSummary Which table holds Learning Initiative DataContent Hi All, We are missing link to identify the only Initiative enrolled for specialization. We had built the below… -
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include … -
implement Segment Value Data Security (SVS) in BI Publisher ReportHi All, Could someone provide insights on how to implement Segment Value Data Security (SVS) in a BI Publisher Report on the GL budget balance table? We have a requireme…Veeragopathi 72 views 3 comments 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
Which table contains 'Collaborator' for Oracle Recruiting CloudSummary: Which table contains 'Collaborator' for Oracle Recruiting Cloud Content (please ensure you mask any confidential information): Hi, we would like to have a BI Re…Barile Alberto 43 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?After updating the Name of Department from '60508-East Operations-508' to '60508-Operations-508' via Setup & Maintenance > Manage Departments > Update > Submit The FND_F…Matt_C. 11 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)… -
Tables Name to Access to the employee's Compensation historySummary: Tables Name to Access to the employee's Compensation history Content (please ensure you mask any confidential information): Hi, we are looking for the tables wh…Barile Alberto 32 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…Lavina Bansal 421 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
How to Add a Project Filter Parameter to the Print Receivables Transactions ESS JobHello everyone, I would like to add a new parameter called “Project” to the Print Receivables Transactions ESS Job in Oracle Fusion Cloud. Objective: The goal is to be a… -
Configure print certificate template stepsSummary: Configure print certificate template steps Content (please ensure you mask any confidential information): In the setup steps for Configure Completion Certificat… -
Print Certificate Opens Blank PageSummary: Print Certificate Opens Blank Page Content (please ensure you mask any confidential information): Me > Learning > Open Completed Course > Actions > Print Certif… -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 2.2K views 11 comments 3 points Most recent by Luke Quell Reporting and Analytics for ERP -
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …Gaurav Rochwani 271 views 4 comments 1 point Most recent by Esraa Samir33 Reporting and Analytics for ERP -
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing … -
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …Priya J N Singh 23 views 2 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM -
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 51 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Descriptive flexfield WLF_LEARNING_REQUEST_DFFHi to all, We have created descriptive flexfield fields on the WLF_LEARNING_REQUEST_DFF code, in which BI table are they contained? Thank You Claudio -
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f … -
How GL Trial Balance Report is designed to sort account codes?Summary: Hello community members, I am wondering if anyone know how GL Trial Balance Report is designed to sort account codes? It looks like the report is designed to so…T. Kosami-Oracle 11 views 3 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Delivery Filename in BIP Bursting definitionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
My rtf template has "È" but report shows "Č" insteadSummary: Encoding issue Content (please ensure you mask any confidential information): Rtf template is: Final result is: Why? Version (include the version you are using,…Stefano_Mazzocca 11 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM