Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to extract data from BICC in PST time zone

Accepted answer
13
Views
1
Comments
User_R2WZN
User_R2WZN Rank 2 - Community Beginner

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

Best Answer