Unable to extract data from BICC in PST time zone

Ismail_70

Hi Team,

I have extract the data using BICC but the data is in UTC time zone in order to validate the data with application(front end) , we are unable to extract in PST Time zone.

Please find the below example
from the AP_invoices_all Table For a particular Invoice front end creation date : 4/15/2024 9:30 PM (PST), but in the extract Creation date is showing as 4/16/2024 4:30:11 AM (UTC)

Just would like to know if we can extract the data from BICC in PST instead of UTC. Thanks.

Kindly provide your inputs. Thanks.

Regards,
Ismail

SteveF-Oracle

 Business Intelligence Cloud Extract is part of Fusion Apps, so I would redirect you to ask your question in a Fusion Apps forum

This community is for OAC and OAS.

Christian Berg-0racle

@User_R2WZN This is the Fusion Analytics forum: https://community.oracle.com/products/oracleanalytics/categories/fusion-analytics