E1: 43E: Next Number By Company/Fiscal Year not Retrieving Correct Next Number Value During Requisition Entry (P43E10) (Doc ID 2933761.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When creating a requisition using the P43E10 (Requisition Entry), the next number being assigned (by company and fiscal year) is not using the current fiscal year defined in the P0010 (Company Constants). The next number being assigned is for the next fiscal year and a new record will be inserted into the new fiscal year.

STEPS
-----------------------

1. Setup the Company Constants to have the fiscal year set in 2022. Use a fiscal date pattern of J, with the start date 4/1/22 (April 2022). Set the current period to 12. This would be March of 2023 based on the date pattern.
2. Set the Next Number Constants to Method 2 (Next Numbers by Company. If not found, use the standard next numbers)
3. Setup a Next Number by Company for OR document type in fiscal year 22. Imbed Digits set to 2, Check Digit N, a next number and auto reset equal to 1.
4. Go to the P43E10 and add an eReq. The document number assigned starts with 23 (Ex: 23000001).
5. Go back into the Next Numbers by Company and a new record has been created for FY23 for the OR document type.
6. Resetting the above values and running a test with the P4310 provides different results. It uses a document number starting with 22 for the next number by company in FY22. This is correct since we are still currently in FY22 (period 12).

 

Cause

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