Re: fdlget failed due to ORA-00904: "APP_CODE": invalid identifier. (693 Views)
Reply
Advisor
Posts: 20
Registered: ‎04-25-2013
Message 1 of 4 (705 Views)
Accepted Solution

fdlget failed due to ORA-00904: "APP_CODE": invalid identifier.

Hi Experts, 

I need a help with this issue :)

In the attached document I explain better, with error screens. 


When I try to select a Specific Concurrent, I got this error: 
APP-FND-01564: ORACLE error 904 in fdlget 
Cause: fdlget failed due to ORA-00904: "APP_CODE": invalid identifier. 

 

Concurrent Output:

Concurrent Manager        DB: DEBSCNO - Could not find @DEBSCNO_PPM. Omitting

                           from view definition.

 

                           DB: QEBSCNO - Could not find @DEBSCNO_QEBSCNO.

                           Omitting from view definition.

 

More Information
1. Object Migration version: 7.5 
2. Oracle app version on O*M instance: EBS Version: 12.1.3 
3. Data Base version for Oracle app: 11.2.0.3.0 

4. PPM Version: 9.20

Let me know if you need any more information, ok ? 

Honored Contributor
Posts: 737
Registered: ‎07-13-2010
Message 2 of 4 (696 Views)

Re: fdlget failed due to ORA-00904: "APP_CODE": invalid identifier.

Check whether the DB LINK "DEBSCNO_PPM" exist in your PPM schema.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Frequent Advisor
Posts: 45
Registered: ‎05-23-2011
Message 3 of 4 (693 Views)

Re: fdlget failed due to ORA-00904: "APP_CODE": invalid identifier.

Check the CLM_DB_LINKS Value Set, and also the DB Links using the APPS account.

Verify the tnsnames.ora entries.

 

Regards

Advisor
Posts: 20
Registered: ‎04-25-2013
Message 4 of 4 (658 Views)

Re: fdlget failed due to ORA-00904: "APP_CODE": invalid identifier.

Hi Guys, tks for quick reply....

I checked the dblinks and really had to change some things.

Now I have other problem, with DBLinks. I have three db_links (DEV, QA and TEST). QA saw all db_links. But the DEV and TEST, not.

I thing this a problem with a DBA of the customer, so......

Tks a lot for help, guys !!!

Best,
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.