SDE_ORA_SLAJOURNALFACT, SIL_AR_TRANSACTION_FACT.W_AR_XACT_F interface leads to slow performance of load. The incremental load has gone from 4 hours to 10 hours.
Folks Please help me out in this. Its Very urgent.
Thanks
Babu
First and foremost:
2907462 wrote:Its Very urgent.
==> "Also, please remember that all users have normal jobs to do to get the bills paid. Phrases as ‘ASAP’, ‘urgent’ have no meaning at all . There is no ‘Service Level Agreement’ attached to the OTN Community Spaces. If you need urgent help you should use support.oracle.com, the paid support Oracle offers."
And:
2907462 wrote: The incremental load has gone from 4 hours to 10 hours.
Have you done any analysis at all? Checked the logs? Looked at the SQL statements? Checked the explain plans?
At the moment this "question" is just you asking other people to solve your issue (and do you work) without providing any pertinent information at all.
Hi 2907462/Babu -
If you are still seeing this issue, please reply with some addtional details. You could start with your version number(s). Also, which step, in the load plan, is spending the most time? We would need to narrow this down some to make any progress.
If you have taken this to support, kindly close this thread ...
Regards,
Charles
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
