BI Publisher
Discussion List
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL TableHi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle… -
Need API for Lookup type PAY GROUP in Manage payables lookupsSummary: Hi Team, Do we have any REST API to get data for the lookup type for PAY GROUP under Manage payables lookups ? We found one API for this is not working to get f…
-
How to link xla_distribution_links with fa tables to get the catchup depreciationSummary: How to link xla_distribution_links with fa tables (Depreciation, Transactions, Adjustments) to get the catchup depreciation (link other than event_id) to find d…
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Transfer Customer Payment on Bill Management Portal to BankSummary: We are looking to transfer Customer Payment (Bank Method) on the Bill Management Portal to the Bank. Does anyone have any such integration experience with Wells…Suprit 23 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there …Parag Hiremath 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 261 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
Export Learning Certificate using APISummary: Hi, We have requirement to export the learning completion certificate from oracle and send it to a third party system via integration. Content (please ensure yo… -
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Can we integrate 2 LinkedIn accounts for same user with oracleSummary: Can we integrate 2 LinkedIn accounts for same user with oracle Content (please ensure you mask any confidential information): Can we integrate 2 LinkedIn accoun…
-
Do we have a delivered NACHA Format template for Fund Disbursement in Customer Payment?Summary: I am looking for a NACHA Format template for Fund Capture that can be used as a reference for customization. I am only able to see the NACHA Format available fo…Suprit 1 view 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Oracle Fusion Cloud Sustainability posibility to report via OTBI/Subject AreasThere is a module available for all ERP customers where you can store sustainability data. Created via AP invoices or imported via external systems. This is something th…AnnelizeHenskens 1 view 2 comments 0 points Most recent by AnnelizeHenskens Reporting and Analytics for ERP -
Data missing in xla_transaction_lines tableWe could see the data available from 07-Nov-2024. Previous dates data are missing. Is there a automatic purging happening ?
-
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
How to output of a BIP Report in multiple excel sheets in XLSX format?Hi we would like to know if there is the way to output of a BIP Report in multiple excel sheets in .XLSX format. Currentry we can see only .XLS format is avaiable when E…Karen Ito-Oracle 71 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 551 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Standard report to see the default expense account of an employeeSummary: The client is looking for any standard reports to check the default expense account assigned to an employee Content (please ensure you mask any confidential inf… -
How to create Bursting without linking / upload attachment to a Transaction?Summary: Hello, we are using a customized Datamodel for the Print Receivable Transactions process. We also use our own bursting which creates multiple PDFs for a transac…Frank.Steinjan 31 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 447 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to default invoice template on collection dashboard preview screenIn collection dashboard when you select customer delinquency there is option of preview, when i click on preview it;s picking INFUSION default template . How to default …charanjeet 1 view 1 comment 0 points Most recent by Vitalie Rusanovschi-Oracle Receivables & Collections
-
How to auto increment the date parameters of the seeded report?Summary: I need to schedule the report on a monthly basis and will auto increment the said parameters. Payables Invoice Register: -From Entered Date -To Entered Date -Ac…Mikee Tamonan 56 views 5 comments 1 point Most recent by Venk Kudire- Support-Oracle Payables, Payments & Cash Management
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
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 391 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM