Home » Applications » Oracle Fusion Apps & E-Business Suite » Table replacement from 11i to R12 (Oracle Applications 11i/R12)
Table replacement from 11i to R12 [message #672254] Tue, 09 October 2018 00:11 Go to next message
adfnewbie
Messages: 54
Registered: January 2016
Member
Hi People,

Greetings!

I am working on an upgrade assignment and I require some help to identify if the below tables are obsolete in R12 and if yes, what are the replacement tables?

1. financial_system_parameters
2. ap_system_parameters

Current version:
------------------
RDBMS : 11.2.0.3.0
Oracle Applications : 11.5.10.2

Upgrade version:
------------------
RDBMS : 11.2.0.3.0
Oracle Applications : 12.1.3


Thanks!
RC
Re: Table replacement from 11i to R12 [message #672257 is a reply to message #672254] Tue, 09 October 2018 01:56 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Have you look at the docs, on http://etrm.oracle.com you will find that ap_system_parameters is indeed an EBS supplied object and financial_system_parameters is not. Have you been creating your own objects in the supplied schemas?

[Updated on: Tue, 09 October 2018 01:57]

Report message to a moderator

Re: Table replacement from 11i to R12 [message #672259 is a reply to message #672257] Tue, 09 October 2018 02:15 Go to previous messageGo to next message
adfnewbie
Messages: 54
Registered: January 2016
Member
Hi John,

Thank you for writing.

Sorry for the typo, it is FINANCIALS_SYSTEM_PARAMETERS, not FINANCIAL_SYSTEM_PARAMETERS.

FINANCIALS_SYSTEM_PARAMETERS - This exists in 11.x versions It is a seeded view in APPS schema. I am looking for it's replacement in R12.1.3.

Thanks,
RC
Re: Table replacement from 11i to R12 [message #672261 is a reply to message #672259] Tue, 09 October 2018 03:27 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
You have not looked at the docs, have you? Even though I gave you the link. It is a view in the APPS schema in 11.5.10, it is a synonym in the APPS schema in 12.2.2. What's the problem? Do you not trust the upgrade process to sort it all out?
Re: Table replacement from 11i to R12 [message #673379 is a reply to message #672261] Sun, 18 November 2018 22:46 Go to previous message
adfnewbie
Messages: 54
Registered: January 2016
Member
Hi John,

I did check the docs.

Thanks for responding!
Previous Topic: Creating new PO lines in Oracle Purchasing R12.1.3
Next Topic: PO_NOTES replacement in R12.1.3
Goto Forum:
  


Current Time: Mon Mar 18 22:32:56 CDT 2024