adadmin compile flexfield error

[steve]

Hi Erman,

can you help me please
we are getting an error while compiling flexfield with adadmin;


APP-FND-00798: Invalid reference FA_ACTIVE_CORP_BOOK in value set attached to segment Physical Inventroy

APP-FND-00798: Invalid reference CLE_F248_YES_NO in value set attached to segment Vat Type

APP-FND-00798: Invalid reference GL_SRS_LEDGER_FULL in value set attached to segment From Period

[ErmanArslansOracleBlog]

Hi Steve,

When was the issue started?
Did you do an upgrade or did you patch your system recently..

This looks like the cases where the issue occurred after the upgrade where a specific ldt was not loaded automatically during the upgrade process or during a patching process.

If that's not the case, you probably will need a functional assistance or you may need to create an SR.

[steve]

ty for your care,

this is our new 12.2.5 installation.We are testing it.

[ErmanArslansOracleBlog]

I give Apps DBA(EBS Admin)/DBA/OS/Exadata/ODA etc.. kinds of support here.
Your issue is more like a functional one, but I will try to help you anyways.

Check the Apps tier filesystem for those value sets.. Try to find the file ldt file, which includes those problematic values set in the apps tier file system and then try to upload it to the database with force option..
(for FA_ACTIVE_CORP_BOOK the ldt file name seems to be fapvs.ldt)

As for the CLE, I suggest you to review the localization patch log files and the FNDLOAD method describe above..

There are examples for these kinds of solutions in Oracle Support:

Unable to Compile Flexfield $SRS$.PAYFRASD, APP-FND-00798 (Doc ID 282270.1)

Account Analysis Report Errors With APP-FND-00798 invalid reference GL_SRS_BALANCE_TYPE (Doc ID 1371522.1)

+

Read these documents and see the solutions documented in them. They might give you a clue for building your solution..

When Compiling Flexfields Using ADADMIN For Flexfield Name GLHPEXT Get APP-FND-00798: Invalid reference GL_SRS_LEDGER_ID_UNVALIDATED in value set attached to segment Period Name (Doc ID 1954059.1)
R12 FA_ACTIVE_CORP_BOOK Value Set Does Not Display Asset Books End-Dated in the Future (Doc ID 1621280.1)

Note: 1621280.1 is directly related with the FA_ACTIVE_CORP_BOOK..

+

I don't know if it is a VISION or FRESH instance that your using, but it may be a good idea to check your functional setup, as well.. (in case some setup tasks may be missing)