PAXINRVW: Unable To Change Invoice Date To System Date When Releasing Invoice: Invalid invoice date. Please check the exception and enter a valid invoice date (Doc ID 420077.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

Unable to place an invoice date as system date that is outside of the current open Projects (PA) and General Ledger (GL) periods.  This error is retrieved:

ERROR

Invalid invoice date. Please check the exception and enter a valid invoice date.
The exception contains: "Could not create a valid GL date for provider"

STEPS TO REPRODUCE
System Date is outside the current PA and GL periods:

Example: SYSTEM DATE = 27-FEB-23

PA Periods:

STATUS       PA Period             Effective Date From        Effective Date To
------              ---------                ------------------          -----------------
Open            FEB-WK4-23       18-DEC-2023               27-FEB-2023


GL Periods:

Status             Period Name               Start date                 End date
------             --------------              ----------                 -----------
Open              FEB-23                       28-JAN-2023         24-FEB-2023

A draft invoice is approved.  It is created with bill-through set to 27-JAN-23. Under Invoice Review for the transaction, click 'Release' which has:

Invoice Date = 27-JAN-2023

GL Date = 28-JAN-2023

GL period Name = FEB-23

GL Period Status = Open

Change the invoice date to 27-FEB-23 (today’s date) and click 'OK'. This results in error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.