R12.2: Prepare Mass Addition Concurrent Program Book LOV Issue After Upgrade To 12.2.7 (Doc ID 2427037.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

After upgrading from 12.2.3 to 12.2.7, the following change has occurred for Value set = FA_BOOK_TO_AUTO_PREPARE


Where clause :

## 12.2.3 ##
Where NVL(BC.DATE_INEFFECTIVE, SYSDATE+1) > SYSDATE
AND EXISTS (SELECT 1
FROM FA_MASS_ADDITIONS MA
WHERE BC.BOOK_TYPE_CODE = MA.BOOK_TYPE_CODE
AND MA.POSTING_STATUS NOT IN ('POSTED', 'DELETE'))
ORDER BY BC.BOOK_TYPE_CODE


## 12.2.7 ##
Where NVL(BC.DATE_INEFFECTIVE, SYSDATE+1) > SYSDATE
AND EXISTS (SELECT 1
FROM FA_MASS_ADDITIONS MA
WHERE BC.BOOK_TYPE_CODE = MA.BOOK_TYPE_CODE
AND MA.POSTING_STATUS NOT IN ('POSTED', 'DELETE'))
AND (ORG_ID = :$PROFILES$.ORG_ID OR ORG_ID IS NULL)
ORDER BY BC.BOOK_TYPE_CODE

Now, the LOV for Books parameter for Prepare Mass Addition concurrent program shows the Book attached to the Organization which is set under MO:Operating Unit security profile, if that organization falls in the hierarchy from assigned security profile. If not, LOV is empty.

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.