Best Of
Re: JAVA JRE download
Depends on the version but I would start here for the latest:
Previous releases can be found here:
Re: Is it possible to only Logically delete old Year end closure Journal after a re-run?
Hi,
it works for us but you need to use GL_YC and to have document sequencing turned on for the GL BU.
Regards,
Jakub
Re: Oracle EBS Windows 11 Certification ETA
Hi, we are successfully using Windows 11. This is my solution. I found that there is a trusted sites area in Windows 11 for when opening a WebADI worksheet, the process “hangs” on the Processing: Create Document screen.
To add *.harvard.edu as a trusted site: Search for Control Panel, open Control Panel > Internet Options > Security tab > click on the Trusted sites icon > click the “Sites” button > Uncheck the box “Require server verification (https:) for all sites in this zone” Then, click in the first box, which reads “Add this Web site to the zone:” > Type *.harvard.edu > Click Add, The line should drop from the top box to the bottom box. > Recheck the box “Require server verification (https:) for all sites in this zone” > Click Close > Click OK.
Further info for Windows 11 (or it could just be Excel updates)...I also found that Excel notes a Security Risk Microsoft has blocked macros from running because the source of this file is untrusted. The latest version of Microsoft (MS) Office has added security. It is, therefore, necessary to add the download / working path to trusted locations and save the webadi files there before opening.
To implement the solution, please follow the steps below : 1) Open any blank MS Excel worksheet 2) Navigate to File > Options > Trust Center > Trust Center settings > Trusted locations 3) Click on "Add locations" button and add the appropriate path where the WebADI document is downloaded / saved. Please note at times ADI has issues with uploading journals from share drives because of the long path names. If your ADI is on a share drive, you may want to try adding your desktop to upload from instead. 4) Click "Ok" 5) Re-test the issue by downloading new WebADI document
Alternatively, users can unblock a single document at a time. The user will be able to go to the Properties dialog for the file and select Unblock which will allow the macros to run, as long as no policy or Trust Center setting is blocking.
All the best,
Sharon_O
Re: OVMAPI_4024E Cannot take ownership of server
Thank you @JanuszU - we had the same issue, and your instructions allowed us to finally resolve after days of working with support and a lot of trial and error. We didn't originally remove the key file and reboot - didn't have luck until we did those last two steps. Thank you!!!!!
TLS orapki, openssl and SAN with EBS 12.2
I was following the note to install TLS 1.2 for EBS 12,2
I have a primary and standby., so I want to use the same certificates across both servers.
That means that I need to have the appropriate Subject Alternate Names.
Due to the vagaries of the certificating system that we use I need the SAN to be in the csr
This doesn't seem possible with orapki from 11.1.1.9.
So the question is do I need to use orapki to create the wallets etc or can I use openssl where I can specify the -ext parameter. Is this a supported method ?
Thanks
Dominic
djwest
Re: Machine Name table
Hi
The data for this page comes from the business view V98611 which in turn comes from F98611
Are you trying the change the Database server. If yes it would be better to follow the below document
E1: DB: How To Change Out A Database Server? (Doc ID 1944173.1)
Regards,
Prabhu
Re: How to correct wrong RMAN version after July CPU patches to the oracle database?
I found the following document:
RMAN-06035: wrong version of recover.bsq, expecting ... found ... After Upgrade (Doc ID 2886952.1)
Re: New Org Setup Question
Hi Pete,
You will also need to look into migrating data from all your subledgers, you can't just point them to a new GL. So for AP, you would want to pay out as much as you are able, then move just the open invoices to the AP module under the new GL. For AR, you'll close out your receipt batches then move all the open invoices. AP and AR each have an interface table, and you could use sql to read the open invoices and load them into the interface table with the new ledger and operating unit info. For Assets, you'll need to convert them including the current status (original value, prior depreciation, current value, etc.). There is a webADI front end for Assets to do a Mass Load. You'll need to post to the GL; if you load the open items and then post, the GL journal should be only the conversion data; if you don't want to keep the journal then you can reverse it. In all cases, confirm that the total ending amount in the old ledger equals the total starting amount in the new ledger. Close all the periods in the old ledger, so it's there for reporting but can't be transacted.
Something to consider is whether you want YTD to be accurate. Suppose July is the open period. The simple thing would be to convert everything into July and check the inception-to-date values match. That does work, but be aware that YTD through June will be zero and MTD July will be the inception-to-date value, so that if you compare month-to-month or year-to-year, it won't be accurate. That isn't significant in some businesses. But if you want YTD to be accurate, then open Dec-2024 and convert ITD through Dec-2024 balances. Post and close, so Jan-2025 starts as it did in the original ledger. Then migrate Jan-25 from old to new, post and close, and continue each month. This approach gives you accurate ITD, YTD, and MTD values if you need them.
Good luck with your move,
J
