Category 385
Discussion List
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l… -
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 44 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…Amritha2184-Oracle 81 views 5 comments 1 point Most recent by Todd Hensley Reporting and Analytics for HCM
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 166 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
Invoice summary details table for APWhich table stores Invoice summary details in Fusion cloud. I am looking for the column which stores Accounting informationKavya Gururaj 13 views 4 comments 0 points Most recent by Salu Prabhakaran Payables, Payments & Cash Management
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 14 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Timecard not populating to HXT_TM_MTRX table .When we are submitting Time card through Redwood page one of the attribute value of timecard not populating to HXT_TM_MTRX table . Still, we are getting data once creati…Mazumder Sourav-Oracle 84 views 4 comments 1 point Most recent by David Boudreau Workforce Management
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 25 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
While selecting parameters for custom ess job I am getting error.Hi Team, One of our client wanted to make a parameter mandatory while submitting Create Electronic Payment files ess job, which is seeded ESS job. We have duplicated the…Syamakalla_Venugopal 63 views 5 comments 0 points Most recent by Sudheer P Payables, Payments & Cash Management
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 917 views 22 comments 0 points Most recent by Rabia Hasan Human Capital Management
-
Extract journal with debit and credit in the same lineSummary:Extract journal with debit and credit in the same line Content (please ensure you mask any confidential information): The client requested the extraction of acco…User_Q4SYX 7 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …Shahid Qureshi 01 3 views 0 comments 0 points Started by Shahid Qureshi 01 BI Publisher Learning Center
-
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…
-
How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th…
-
In case of SCFO context in AR invoice, how to get fullfillment line id?In oracle fusion, I want an sql query to find fullfillment line id in case of Supply Chain Financial Orchestration (SCFO). For DOO we are getting this from interface_lin…
-
withdraw issuewithdraw issue
-
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 32 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI) -
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 47 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service -
Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…Vagicherla Harish 3 views 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management
-
audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 22 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 13 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service
-
How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…Ritu123 38 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Receivables & Collections