You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with a date column in customized Asset Register report in Oracle Fusion

in Assets

Hi,

We customized the Fixed Assets "Asset Register" report. There's a date column whose logic is as below.

(SELECTTO_DATE(TO_CHAR(fcp.end_date, 'MM-DD-YYYY'), 'MM-DD-YYYY')

FROM fa_calendar_periods fcp

WHERETRUNC(fab.creation_date) BETWEEN TRUNC(fcp.start_date) AND TRUNC(fcp.end_date))DATE_ADDED

For the date added field, we're using asset creation date from FA_ADDITIONS_B fab and checking in which period the date falls under from the Asset calendar and fetching the last day of that period.

However, when doing this, the query is fetching the correct date i.e., 26-04-2025 which is the last day of the April period in the Asset calendar based on the asset creation date but the report is showing the date as '25-04-2025' even though the report's XML data shows correct date. When checked with the same XML data locally using BI Publisher plug-in, it's working fine.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!