BI Publisher
Discussion List
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio…Ishtiaque AHmed 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create deep link for Items in Product Information Management module?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Uploading PGP keys in BI Administration failed with errorSummary: Uploading PGP keys in BI Administration failed with error 'Importing public key file .asc failed: reason=key file could not be imported: exit value=2' in 24D. I…Vidhya Nadarajan-Oracle 71 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle HCM Extract
-
What role/duty/privilege is needed to run Custom GL batch Delegation BI report with BPM tablesSummary: What role/duty/privilege is needed to run Custom GL batch Delegation report with BPM tables Content (please ensure you mask any confidential information): we ar…Jude Franco 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some …Jason Snipes 1 view 3 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Why do I get an SQL timeout limit error after 30 mins after 24D upgrade.Summary: Why do I get an SQL timeout limit error after 30 mins for one of the custom BIP report even though one of the other custom report with same properties and setti…
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
Create Settlement Batch is not generating any fileSummary: I tried to create a transaction and ran the Create Receipt Remittance batch and after that run Create Settlement Batch, But after the Create Settlement Batch pr…
-
Unable to generate a new PGP key in BI publisherSummary: Our current cloud BI Publisher PGP key is expiring on 26 Jan 2024. Bank want us to send our new PGP public key. When I download the new key from the PGP key are…Nallas 41 views 4 comments 0 points Most recent by PG_of_NSG-Oracle Payables, Payments & Cash Management
-
Getting multiple values with HZ_LOCATIONS queryHello, I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is …Vaishnavi Katiyar 72 views 0 comments 0 points Started by Vaishnavi Katiyar Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.Summary: We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) functio…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there… -
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Is there a way to auto-increment date parameter while running "Multiperiod accounting"process/reportSummary: We need "Create Accounting" and "Multiperiod Accounting" jobs to run daily. While the "Create Accounting" job’s date parameter is Incrementing automatically eve…Srikanth Dodla 112 views 1 comment 0 points Most recent by Priyaranjan Shetty-Oracle Payables, Payments & Cash Management
-
help to get SQL query to get the data from tax conditions to Value set valuesSummary: One of our tax determination factors is line account (one of the segments in CoA). We are looking for a report to get CoA values with tax rule name and tax rate…
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 2.9K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 126 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 31 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
General LedgerI' like to output the SEGMENT values (SEGMENT1~12) registered in GL that have an enabled flag of 'N', column by column. To achieve this with BIP, which table should I re…
-
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version…MandeepGupta 1.2K views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
sql query to get all the team members approved/rejected expenses reports data by passing manageridSummary: is there any sql query available for manager to get that will return all of his employees expense reports data Content (please ensure you mask any confidential …
-
Join Course and Offering assignment tableSummary: Hi, I'm trying to create a Datamodel (basically a query) to join Course Assignment and Offering Assignment. Both uses the same table WLF_ASSIGNMENT_RECORDS_F, j…
-
Need an SQL to list out all the Corporate card Transactions with Respective MCC codeSummary: Need an SQL to list out all the corporate card Transactions with Respective MCC codes & Expense Types -
Last modified date of Payables Unaccounted and Sweep Report does not match with 24C/24D upgrade dateHi, 24C patch was applied to our systems in August-24 and 24D in November-24, but the last modified date of Payables Unaccounted and Sweep Report is 10/3/24. The auditor…Pranita 51 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 1 view 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM