BI Publisher
Discussion List
-
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t… -
whats argument2 in Load Interface File for ImportSummary: whats argument2 in Load Interface File for Import Content (please ensure you mask any confidential information): Im trying to submit Load Interface File for Imp…Jaeyshree Kumaran Kalpana 31 views 2 comments 0 points Most recent by Mahindra reddy-Oracle General Ledger & Intercompany -
Business Intelligence Publisher Bursting to Email upper ThresholdContent Business Intelligence Publisher Bursting to Email upper Threshold Requirement: 50000 Bursting records get selected and they need to be sent as Email Attachment i…Shivakumar Ayyanagowdar-Oracle 269 views 13 comments 1 point Most recent by Prudvi_Batlanki Reporting & Analytics for Sales -
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 233 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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 38 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 Started 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 71 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 41 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 37 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 31 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 417 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.1K 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 270 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 22 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 53 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 …