To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
Table containing Candidate personal information(Recruiting module)Hello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. Need to create BI report on t… -
Security of custom reports to be only appear to specific rolesHello, we made custom reports with specific details which should only appeared to specific roles, For example Report A only appear to employees with roles HR Specialist …
-
How to print space between currency symbol and priceHi, I have added the below formula in the rtf template to display the price along with the price currency code. Formula: Output $50 UNIT_PRICE & INVOICE_CURRENCY_CODE d…
-
how to ftp a csv file with column headings without underscoreHow to send a FTP text file with heading First Name(two separate words) instead of First_Name.
-
Can we create custom DB package in oracle fusionHi, I would like to recreate a seeded package (AR_ARXA7ACCT_XMLP_PKG) with minor changes. Is there any possibility to create a package in SAAS. If yes, please help help …
-
Table containing Candidate personal informationHello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. We have a requirement to crea…
-
BIP to burst the file to SFTP Server with 0 KB in case there is no data extractedSummary: We have requirement to burst BIP report output to SFTP server with 0 KB size in case there is no data extracted after data model query being executed. Content (…
-
Sql to find weekdays between two DB dates in fusionI want the query for Fusion to find weekdays between two dates skip the saturday and sunday and give the subtracted days dates may be have differnce of 1 day or 10 days … -
SQL to get both po with requisition and without requisition in a single queryHi All , I need a query to get SQL to get both PO with requisition and without requisition in a single query and the columns I am trying to fetch are below mentioned que…
-
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …
-
BI Report for Receipt Accounting BU, Commodit Code as input parameter an get PR,PO,Receipt detailsHi Experts, Can someone please help in below requirement. I am looking for sample query and relevant table information where I need to pass date range,BU,LE and Commodit…
-
Not able to print columns in the rtf templateHi, I am trying to customize one of the seeded reports to add additional columns. I have added additional columns in the data model by creating a new group and establish…
-
Can I get a report with a full list of ERP Roles that displays the access to Create FBDI Journals?For Audit controls creation of FBDI report and then ensure all the roles from that reports are reviewed. -
Looking for PVOsSummary: Looking for PVOs under biacm for the below tables msc_sr_assignments msc_customers msc_customer_sites_msc_v msc_items msc_sr_source_org msc_sr_receipt_org -
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…
-
How to identify bit mapping for change_bitmap in EGO_ITEM_EFF_B tableIn Fusion Database we have table EGO_ITEM_EFF_B, everytime we make changes to EFF attributes change_bit_map column stores the information that which column is changed in…
-
How to reduce execution timeHi, I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.…
-
BIP Report to Get Last 30 Days User Login DetailsSummary: The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last l…
-
Moved: Is It possible to get out put In JSON Format for BIP ReportsThis discussion has been moved.
-
how to find source to disable autorun for an OTBI report?Customer is getting a delivery report but now they don't want to use it further, We are trying to find a way to disable the autorun of the report. FYI: We were not able …
-
Bursting report in procedure call data setSummary: Content (please ensure you mask any confidential information): I have a requirement to insert/update the lookup code and print and deliver the PDF through email… -
-
Audit eventSummary: Event type and Attributes required to audit Role/Priv creation and maintenance Content (please ensure you mask any confidential information): We would like to r…User_2025-12-05-00-49-06-629 22 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle
-
How to add a specific offering to BIACM extract in Fusion?Hello all, I am unable to locate and add the below data store. FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventsExtractPVO Can you please help? Thanks
-
We need a API SOAP or REST to trigger a specific BICC jobs from OICWe have a requirement to trigger BICC jobs through API rather than doing it on cloud connector manually
-
SQL Reporting TransactionsHi I need to check a Approved documents of records transactions. But I couldnt Get The Transaction Id which matches with my Document_Code from Hrc_Txn_Header and Hrc_Txn… -
How to convert primary ledger currency balances to USD currency balance in Oracle FRS reports?Need to get the primary ledger currency balances to USD currency balance, based on 'Period Average Rate.'
-
How to get user login history or user wise application usage of Oracle fusion applicationsHow to get user login history or user wise application usage of Oracle fusion applications
-
Adding PDF attachment to RTF TemplateHi Team, We have checklist named Onboarding US. It is triggers notification whenever action named 'Add pending worker' We want to add PDF as an attachment to RTF templat…
-
Report to identify terminated employees in BPM workflowSummary: Content (please ensure you mask any confidential information): Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle wo…