ODI Step SDE_ORAR1213_ADAPTOR_SDE_ORA_SLAJOURNALFACT in 11.1.1.10.1 running forever

user5861392

Hi All,

I have completed the domain mappings and running the initial ETL Process to load Financials in a 11.1.1.10.1 environment. Step SDE_ORAR1213_ADAPTOR_SDE_ORA_SLAJOURNALFACT has been running for  almost 11 hours before a stopped it. I am running against a Vision instance of EBS 12.1.3 and loading only 2 ledgers with ledger_type = "Primary" and limiting Subledger Module List to three document sources of 200, 201, 707.

I can run this same step using an earlier version on OBIA 11.1.1.8.1 and the step will complete in 94 minutes and extract 4.5 million records. I have not performed a compare between the SQL code of the two versions but do notice Database Hints are used in the 11.1.1.10.1 version.

Any suggestions besides removing the hints? Is anyone else experiencing this issue in this version?

Thanks in Advance.

Message was edited by: user5861392 I have since tried to modify the hints but with no luck. Was able to skip the SLAJournal extract step and the Load Plan completed with no errors. Will log an SR.

3019808

Hi, I am also facing same thing few time. its basically happens due to table maintenance . Just execute gather stats for source tables for this interface, then restart the load.

user5861392

Thanks, I did check stats and that was not the issue. To correct the issue we had to change the hints in the step in order for the step to complete. I did create an SR for this issue and Oracle sent a MS Word document with steps to

modify SDE_ORAR1213_ADAPTOR_SDE_ORA_SLAJOURNALFACT, which also worked but took 20 minutes longer to perform the extract than our solution. However it did complete.