BI Publisher
Discussion List
-
Print Receivable Transaction to print invoices taking more than 20min for one transactionsSummary: Hi All, We are currently using the “Print Receivable Transaction” to print invoices. However, it is taking more than 20 minutes to print a single invoice, even …Vnr Karthikeya-Oracle 22 views 0 comments 0 points Most recent by Vnr Karthikeya-Oracle Receivables & Collections -
Suppliers are not receiving Remittance AdvisesSummary: For some reason, none of our suppliers are receiving any Remittance Advises. The configuration on disbursements options, Payment process profiles, and supplier …Murali M. 571 views 17 comments 0 points Most recent by Thriveni Gudipati Payables, Payments & Cash Management
-
HCM Extract for assignment changes only generating previous sequenced rowSummary: I've created a HCM Extract that pulls assignment details for employees, including past, present, and future assignments. The only filtering criterion I use is t…
-
Encrypt the request and response of Oracle fusion SaaS webservicesWe would like to encrypt the data traffic between external service and Oracle SaaS SOAP services eg BIP webservices. Did anyone work on this data security scenario ? If …
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
Display Latest Approver in Custom Payables InfoletSummary: Hi All, Currently, I have created a custom Payables Infolet, in which I added the "Approval Status" and "Approver" information. However, the application display…Ucup Maulana 31 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…George Mattar 443 views 4 comments 0 points Most recent by Sridhar_Rejeti_1423 General Ledger & Intercompany
-
BIP report use '_vl' view cannot switch language by user language preferenceUse '_vl' view to extract data in BIP report, but it didn't display in correct language based on user's BIP preference session language. Given that, I selected :xdo_user…Skye Liu 31 views 4 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 192 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 781 views 8 comments 0 points Most recent by Hemanth Kumar Reddy Reporting and Analytics for HCM -
How to reuse RTF of Packing slip report in BOL report which has different data models and parametersWe have one requirement with below 2 reports 1 . Packing Slip report -------- /Supply+Chain+Management/Warehouse+Operations/Shipments/PackingSlip.xdo 2. BOL report. ----…ManuYal 15 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…Pritha 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…Pritha 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM PVO extract numeric data type content column contents charactersThe HCM PVO extract within BICC for numeric data type column contents characters in the extract result. During our extract offering creation and job setup, no additional…
-
BI Publisher – Unable to Set Default Parameter to Week Start (Sunday) and Week End Date (Saturday)We are trying to configure a BI Publisher report parameter in Oracle Fusion Cloud to automatically default to the start and end of the week Week Start = Sunday Week End …Deepika Maddirala 13 views 2 comments 0 points Most recent by Deepika Maddirala Reporting and Analytics for ERP
-
BI Catalog change audit dataSummary: Is there a way to audit the changes done on BI catalogs in Oracle Fusion Cloud? Content (please ensure you mask any confidential information): Version (include …AnuradhaMupdathi 15 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
Swift code for bank in fusionContent Where to provide Swift code for Banks in fusion? In EBS R12, SWIFT Code is entered at bank branch level and it should be entered in the field "Bank Identificatio…
-
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
How can I ensure my BIP report for line managers only returns results of their reporting line?Summary: I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all …
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
Budget date was changed and now initial budget is split between periods on BC reportSummary: We have an instance of a project budget which was initially $173,581.00 with a starting period of Dec-24. The Project Owner updated this to Jan-25. Now when I r…
-
What is the table where is stored the accounts segments values used in a Tax Condition Set ?Content Hello, I would like to know the name of the table where the accounts values used in a Tax Condition Set are stored. I checked the following tables : * zx_conditi… -
Does the output of Payables Period Close Exceptions Report placed in UCM?Summary: Hello Everyone, We have a requirement where the output of report - 'Payables Period Close Exceptions Report' needs to be downloaded for users who does not have …Anuj Gupta 11 views 0 comments 0 points Most recent by Anuj Gupta Payables, Payments & Cash Management
-
Issue in Dynamic URL in StructureSummary: We are trying to use dynamic url in structure tab in instance (https://ehzq-dev14.fa.ocs.oraclecloud.com/) to navigate to the report folder but the web applicat…
-
Disability status of My Contacts (People to Cover)Summary: Hi Experts, We have requirment to send email notification to employees when Employee added Contact Relationship (Me→Benefits→Before you enroll→My Contacts) with…Murugaganesh 31 views 2 comments 0 points Most recent by Murugaganesh Reporting and Analytics for HCM -
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…JSAHOO1988 193 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Request for SQL Query to Retrieve Cash Balances with Specific ColumnsSummary: Provide a SQL query for Cash Balances to include columns with Legal Entity Name, Entity ID, Bank Account Number, Bank Account Name, Bank Account Type, Currency,…Guthi Mallikarjun 339 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Email Sent Without PDF Attachment using Print Receivables TransactionsWe are using the “Print Receivables Transactions” functionality to send billing invoices to customers via email. The emails are being sent successfully, and normally the…