Issue: The descriptive flexfield with application name XX(XX) and name $SRS$.XX ($SRS$.XX) is not compiled. Please contact your system administrator"
Solution:
We can retrieve and check the flexfield context definition by running the following SQL statement:
select *
from FND_DESCR_FLEX_CONTEXTS_VL
where descriptive_flexfield_name like '%IBY_FC_CREATE_SETTLE_BATCHES%'
To compile the parameter flexfield use the following steps:
1. System Administrator > Concurrent Request > Program > retrieve the concurrent program (e.g.XXABC_Report).
2. Click Parameters button.
3. Update description of one parameter e.g. add XX to description of P_CONC_PROGRAM_NAME parameter for example: Concurrent Program Name XX
4. This will trigger compilation of this DFF (internally it will run a PL/SQL package, not a concurrent request).
5. If you want the original description to remain, revert back the changes in step 3 and save. This will force another recompilation and description will remain as seeded.
6. Test again the concurrent program. It should not fail this time.
Solution:
We can retrieve and check the flexfield context definition by running the following SQL statement:
select *
from FND_DESCR_FLEX_CONTEXTS_VL
where descriptive_flexfield_name like '%IBY_FC_CREATE_SETTLE_BATCHES%'
To compile the parameter flexfield use the following steps:
1. System Administrator > Concurrent Request > Program > retrieve the concurrent program (e.g.XXABC_Report).
2. Click Parameters button.
3. Update description of one parameter e.g. add XX to description of P_CONC_PROGRAM_NAME parameter for example: Concurrent Program Name XX
4. This will trigger compilation of this DFF (internally it will run a PL/SQL package, not a concurrent request).
5. If you want the original description to remain, revert back the changes in step 3 and save. This will force another recompilation and description will remain as seeded.
6. Test again the concurrent program. It should not fail this time.