Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help understanding ERPi and planning

user9213000Feb 22 2011 — edited Feb 22 2011
Hi All,

Planning/Essbase. Version is 11.1.2.

Can you please help me understand the role of the ERPi adapter. I have hyperion planning that sits on an essbase cube. We load data and metadata from E-Business Suite 11. From forms and reports I want to drill back to the data in EBS. I have installed and configured the ERPi adaptor and the scenarios in ODI


Question 1)

Do I need to load data and metadata to be able to drill-through.

Question 2)
I have set my target and source systems - where do I configure the "Drill Through"

thanks in advance for any help offered.
This post has been answered by TonyScalese on Feb 22 2011
Jump to Answer

Comments

Carsten Czarski-Oracle
Answer

Hi,
this is odd ...
The APEX installer checks whether Oracle Spatial (the SDO_GEOMETRY) data type is available in your database. If that is the case, then spatial-dependent functionality will be installed. If not, these parts will not be installed.
The error messages indicate that the installer attempted to install such Oracle Spatial related functionality, although Oracle Spatial appears to be nonexistent in your database (MDSYS.SDO_GEOM, MDSYS.SDO_CS). However, the check for SDO_GEOMETRY at the beginning must have been positive - so there should be an MDSYS.SDO_GEOMETRY data type available.
Can you verify the Spatial / Locator setup in your database?
Is the MDSYS.SDO_GEOMETRY data type present or not present in your database
Are the MDSYS.SDO_GEOM and MDSYS.SDO_CS packages present or not present in your database
Does your database have any special setup regarding Oracle Spatial - have Spatial objects been manually dropped or changed ...?
Best regards
-Carsten

Marked as Answer by User_LELD2 · Sep 8 2021
User_LELD2

Hello,

-MDSYS.SDO_GEOM and MDSYS.SDO_CS packages are not present in the database
-MDSYS.SDO_GEOMETRY data type was present, that's why the check was positive
I dropped the MDSYS.SDO_GEOMETRY data type and the installation finished without problems.

Thank you very much for your help.

Hi,
great that things are working now.
Just one remark. Oracle Spatial no longer requires a separate license; so from a licensing point of view there is no need any more to remove Oracle Spatial from the database.
Best regards
-Carsten

User284650

Hello
i got the same issue but we are using oracle spatial MDSYS.SDO_GEOM .
Any workaround ?

Hi,
when you're using the MDSYS.SDO_GEOM package, then you should also have the SDO_GEOMETRY data type available, as SDO_GEOM uses that data type in its signatures. And then, you should also have the SDO_CS package, as this is part of Oracle Locator (SDO_CS was always part of Locator, even when Oracle Spatial required a license).
Are you having the same errors as described above - is the SDO_CS package missing in your database?
SDO_CS is normally installed together with SDO_GEOMETRY and SDO_GEOM. So why is it missing in your database? Has it intentionally been dropped? If yes, why?
The workaround would be to rectify the Locator / Spatial installation in your database.
Best regards
-Carsten

User284650

here the message :
not ok 2 - 312 actions passed, 1 actions failed | 19.97
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

I got the datatype , and package of oracle spatial mentionned in your answer.

Hi,
this log snippet is insufficient - it only tells us that there have been errors. Can you either look up the section with the detailed message or share the complete log here?
regards
-Carsten

User284650

first thank you for helping.
The log is big here the error
not ok 281 - Upgrade Before Enabling Constraints | 0.50

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

ok 282 - Enabling Constraints/Triggers | 0.32
ok 283 - Upgrade Metadata (2) | 0.00
ok 284 - Upgrade with enabled constraints | 2.23

Message: PERF: Statement took 2.03 min

Statement:

declare

c_old_import_in_progress constant boolean := wwv_flow.g_im

port_in_progress;

begin

wwv_flow_api.set_security_group_id(11);

wwv_flow.g_import_in_progress := true;

-- Remove Database Applications

for c1 in (select id

from wwv_flows

where security_group_id = 11

and id >= 7000 and id < 8000

or id in (8950,8951) ) loop

--

wwv_flow_api.remove_application( c1.id );

end loop;

-- Remove Templates

for c1 in (select id

from wwv_flows

where security_group_id = 11

and id >= 8801 and id < 8900 ) loop

--

wwv_flow_api.remove_application( c1.id );

end loop;

-- Remove Websheet Applications

for c2 in (select id

from wwv_flow_ws_applications

where security_group_id = 11

and id in (1097894920371103914,1097895031667

  1. ) loop

--

wwv_flow_api.remove_ws_app( c2.id );

wwv_flow_ws_import_api.remove_ws_components( c2.id );

end loop;

commit;

wwv_flow.g_import_in_progress := c_old_import_in_progress;

end;

ok 285 - Recompiling APEX_210100 schema | 0.70
ok 286 - Configuring Restricted Schemas | 0.00
ok 287 - Upgrading ACL | 0.02
ok 288 - Installing 4411 | 0.92
ok 289 - Installing 4155 | 0.05
ok 290 - Installing Internal Themes | 0.77
ok 291 - Installing 4000 | 6.17
ok 292 - Installing 4020 | 0.45
ok 293 - Installing 4350 | 0.62
ok 294 - Installing 4050 | 0.87
ok 295 - Installing 4550 | 0.05
ok 296 - Installing 4600 | 0.28
ok 297 - Installing 4650 | 0.15
ok 298 - Installing 4700 | 0.08
ok 299 - Installing 4750 | 0.07
ok 300 - Installing 4500 | 1.35
ok 301 - Installing 4300 | 0.12
ok 302 - Installing 4900 | 0.48
ok 303 - Installing 4850 | 0.27
ok 304 - Resetting Internal Authentication | 0.00
ok 305 - Installing Dictionary View Metadata | 0.00
ok 306 - Installing Advisor Metadata | 0.02
ok 307 - Updating App Owner/Version | 0.00
ok 308 - Updating Plug-in settings of Applications | 0.00
ok 309 - Update Plug-In Settings of Applications | 0.00
ok 310 - Copying Instance settings | 0.00
ok 311 - Copying Instance Settings | 0.03
ok 312 - Enabling WS Constraints | 0.25
ok 313 - Dropping Upgrade Triggers in APEX_040200 | 0.07
not ok 2 - 312 actions passed, 1 actions failed | 19.97
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

Hi,
OK - this looks like a completely different issue and not related to Spatial or SDO_GEOMETRY.
Can you send the full log privately to me ...? Either as a PM in the forum, or by email: {firstname}.{lastname}<at>oracle.com.
Best regards
-Carsten

User_AU9FI

Hi,
When I try to install Apex version 21.2 in my database, I got this error:
imagen.pngI try to install 22.1 or 22.2, and it returns de same error.
The database version is:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0

Thanks

This is a different error; it looks like JSON functionality is not available in your database, although it's a 19c one. How is the COMPATIBLE parameter set?

User_AU9FI

Thanks for the quick reply Carsten,
Does this tell you something or you need anything else?
imagen.pngRegards

Hi,
that actually looks good. Based on the installation error, there is a problem with the JSON_OBJECT function in your database.
Do you have the PL/JSON open source package installed in your database, by chance?
Can you run the following query and see whether it works?

SQL> select json_object( 'dt' value sysdate) from dual;

JSON_OBJECT('DT'VALUESYSDATE)
--------------------------------------------------------------------------------
{"dt":"2022-11-22T14:36:29"}

1 row selected.
User_AU9FI

How can I know if it is installed?
It returns the following:
imagen.png
Thanks

hmmm ... also looks good.
let's check on the synonyms, as the original error was about synonyms: What does this query return?

select owner, synonym_name, table_owner, table_name from dba_synonyms where synonym_name ='JSON_OBJECT';

regards
-Carsten

User_AU9FI

Returns the following:
imagen.png"No row selected"

Thanks

hmmm ... I have to say that I'm running out of ideas now.
I never have seen that error before. I suspect something's not right with your database, whatever it is. Based on the error positions from the Installation Screen you have posted before, there is an issue with the JSON_OBJECT function which one of the APEX packages uses.
The only recommendation I have would be to look whether the database contains a non-Oracle object named JSON_OBJECT, which would collide with the built-in one.

select owner, object_name, object_type from dba_objects where object_name = 'JSON_OBJECT'

If that all does not help, I'm afraid I have no idea - the only remaining option then is to file a ticket with Oracle support and to investigate the issue from there.
regards
-Carsten

User_AU9FI

Perfect Carsten, thanks for your help.
Let`s see if we can solve it.
Best Regards

Iosu

Anshuman Singh-Oracle

Hi I got the exact same error while installation can you please tell me how did you resolve this thank you in advance

Anshuman Singh-Oracle

hi Carsten,

I got this error during installation:

not ok 281 - Upgrade Before Enabling Constraints | 0.12

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

Message: ORA-01422: exact fetch returns more than requested number of rows

Statement:

not ok 2 - 312 actions passed, 1 actions failed | 6.30
begin
*
ERROR at line 1:
ORA-20001: Install errors found in phase 2, see "not ok" messages above for
details.
ORA-06512: at "APEX_210100.WWV_INSTALL_API", line 465
ORA-06512: at line 8

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics

can you please help.

1 - 20
Locked Post
New comments cannot be posted to this locked post.

Post Details