My Oracle Support Banner

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

Last updated on JULY 26, 2018

Applies to:

Oracle Assets - Version 12.2.7 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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