Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to tackle different date formats being entered by user in Supporting Reference in BIP Report? — Cloud Customer Connect
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

How to tackle different date formats being entered by user in Supporting Reference in BIP Report?

1
Views
2
Comments
edited Apr 5, 2022 9:34AM in Reporting and Analytics for ERP 2 comments

I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References.


Also users tend to enter wrong date formats and date gets in the xla table as junk value.

How to avoid the report getting erroring out?

Issue arises when we query the Supporting Reference data in a BIP Report.

Have someone experienced the same issue?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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