Reporting - EBS (MOSC)

MOSC Banner

WebADI DATE getting truncated to DD-MON-YYYY format

edited Mar 3, 2016 9:37AM in Reporting - EBS (MOSC) 2 commentsAnswered

We have created a custom ADI to upload time and attendance , table contains colmn as START_DATE and END_DATE with TIMESTAMP values but while uploading date is getting truncated.

PROCEDURE LOAD_ADI  (REGN_NO             IN NUMBER,

                           TRANSACTION_DATE    IN DATE,

                           DRIVER_PIN          IN NUMBER,

                          TRIP_START          IN DATE,

                           TRIP_END            IN DATE,

                           DURATION            IN NUMBER,

                           TOTAL_DISTANCE      IN NUMBER,

                           RUNNING_FARE        IN NUMBER,

                           WAITING_FARE        IN NUMBER,

                           CONV_CHARGE         IN NUMBER,

                           DISC_AMT            IN NUMBER,

                           TOTAL_FARE          IN NUMBER,

                           TOTAL_CASH_FARE IN NUMBER,

                           TOTAL_CREDIT_FARE IN NUMBER,

                           PAYMENT_TYPE        IN VARCHAR2,

                           PICK_UP_LOCATION    IN VARCHAR2,

                           DROP_OFF_LOCATION   IN VARCHAR2,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Reporting Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center