AR_INVOICE_TABLE_HANDLER.CREATE_BATCH Procedure Gives Batch Date With Timestamp
Last updated on FEBRUARY 21, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Running AR_INVOICE_API_PUB.CREATE_INVOICE creates a batch with timestamp ('DD-MM-YYYY HH:MM:SS') Example: 07-DEC-2016 09:55:19
The date format should be simple ('DD-MM-YYYY')
The issue can be reproduced at will with the following steps:
1. Run AR_INVOICE_API_PUB.CREATE_INVOICE
The code is modified to truncate the date before insertion to avoid timestamp in batch creation date.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms