Unable to extract data from BICC in PST time zone

Question

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

[Deleted User] · Answer

@User_R2WZN This is the Fusion Analytics forum:

https://community.oracle.com/products/oracleanalytics/categories/fusion-analytics

Steve F-2 · Answer

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.