OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Table replacement from 11i to R12

Home » Applications » Oracle Fusion Apps & E-Business Suite » Table replacement from 11i to R12 (Oracle Applications 11i/R12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table replacement from 11i to R12 [message #672254]

Tue, 09 October 2018 00:11

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

Report message to a moderator

Re: Table replacement from 11i to R12 [message #672257 is a reply to message #672254]

Tue, 09 October 2018 01:56

John Watson
Messages: 8989
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

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

Report message to a moderator

Re: Table replacement from 11i to R12 [message #672261 is a reply to message #672259]

Tue, 09 October 2018 03:27

John Watson
Messages: 8989
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?

Report message to a moderator

Re: Table replacement from 11i to R12 [message #673379 is a reply to message #672261]

Sun, 18 November 2018 22:46

adfnewbie
Messages: 54
Registered: January 2016

Member

Hi John,

I did check the docs.

Thanks for responding!

Report message to a moderator

Previous Topic:	Creating new PO lines in Oracle Purchasing R12.1.3
Next Topic:	PO_NOTES replacement in R12.1.3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 21 13:45:09 CDT 2025