HI Looks like this is a data conversion issue. Check the column date how the data format is stored in the database table/column accordingly build the SQL in that format and validate the results

Hi Please try to use Sum(Required Quantity) group by Item name https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html#GUID-56B8E03F-E6A6-4421-AD81-DDD72B5D68F4

Hi Amel Ahmed Please login into BI Application with BI Admin user—>Navigate to catalog shared folder and search for the Agent from where this email is invoked. Once you find the Agent details. Click on More—>Disable the Agent

Hi Wendy Please review the HCM OTBI subject area lineage mapping details HCM Filter the data based on the subject area name and identify the Database objects. Job Application - Electronic Signature---database table(IRC_ESIGNATURES),database column(SIGNATURE_DATE) To view OTBI column output data in date & time format.…

Hi Please review the given OTBI LIneage mapping documentation link details.https://community.oracle.com HCM ===== https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1 SCM ====…

Hi Menna Allah Please use "customize" option before making any customization on the seeded report/template. Also ensure to keep all custom contents inside /shared/custom folder. Refer to the given documentation Fusion Applications BI Publisher : How Should We Create New BI Publisher Reports or Customize Existing Seeded BI…

Hi Rojhat Sinan Balka Can you please try the below Login into BI application with BI Admin user—>Navigate to catalog shared folder of the OTBI analysis report—>Click on Edit—>Click on Criteria—>Navigate to catalog column(Item Description)—>Click on Properties—>Click on column format tab—>select Suppress option and click ok…

Hi Please review the given help centre documentation links and do the security setup as per your requirement https://docs.oracle.com/en/cloud/saas/human-resources/23d/ochus/business-intelligence-roles.html#s20044632 How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)

Hi Anjan Please review the help center documentation about TIMESTAMPADD https://docs.oracle.com/en/cloud/saas/taleo-enterprise/22a/otbou/c-datetimefunctions.html#id20131114135318992

Hi Patrick Please review the given documentation it might be helpful

Hi Bursting will split the data based on the split by Key hence output file contains only the data fetched as per the split key value not the parameter value.

Hi Patrick Please review the given help center documentation link about BIP Translation. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/what-can-i-translate-publisher.html#GUID-9959B5D5-3350-41D9-8580-11178228FDEB

HI Please review the given documentation link about the Pivot table in OTBI https://docs.oracle.com/cd/E12096_01/books/AnyUser/PivotView.html

Hi Please review the given help center documentation link about Null values in Views Also, To try hide the column please try the below Edit the Pivot table view—>Click on Column Properties—>Hide the column as per your requirement.

Hi Thank you for the details. Please try the below for group by clause Example:sum("Procurement - Purchasing Real Time"."Purchase Order Header Detail"."Purchase Order Amount" BY "Procurement - Purchasing Real Time"."Supplier Profile"."Supplier Name")

Hi Please provide us the below details for our review a) catalog using the archive option b) NQSQuery.log of the report. Follow the below steps Doc ID 2225909.1 Fusion Applications: How to Get nqquery Using Manage Session

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Dharma Database timezone in UTC hence data is filtering in UTC format. Database timezone cannot be changed. Thanks & Regards Rajasekhar

Hi Please review the given cross-subject area guidelines. https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63 When the report build with more than one subject areas, things to consider You should have a common dimension in all the subject areas…