Sub-Ledger Document Sequence Assignment Count and End Date - Ledger Wise

SELECT count(*)
FROM FND_DOC_SEQUENCE_ASSIGNMENTS
WHERE     
            SET_OF_BOOKS_ID = 2021 -- (Enter Ledger ID)
AND   APPLICATION_ID IN (200,222,660,101,260)
AND   START_DATE >= '01-APR-2024'
AND   END_DATE IS NULL;

UPDATE
FND_DOC_SEQUENCE_ASSIGNMENTS
SET     
END_DATE = '31-MAR-2025'
WHERE     
            SET_OF_BOOKS_ID = 2021 -- (Enter Ledger ID)
AND   APPLICATION_ID IN (200,222,660,101,260)
AND   START_DATE >= '01-APR-2024'
AND   END_DATE IS NULL;

--------------------------------------------------------------------------------------------------------------------------------#Oracleebs #documentsequence #documentassignments #ledger #applicationid #yearendactivity #r12
--------------------------------------------------------------------------------------------------------------------------------