Best Of
Re: ODA 19.27 with KVM / SWAP Issue
Hi Sergej,
In theory, you have sufficient amount of memory to run App KVMs.
On the other hand, it seems you run databases in App KVM which is not a good practice and it could be a contributor to swapping.
App KVMs are not designed to run databases:
- They run from normal memory instead of hugepages (DBsystems run from hugepages and hugepages is configured inside the dbsystem as well to avoid swapping.
Running databases on Linux requires hugepages along with use_large_pages=only init parameter - App KVMs don't have direct access to disks which results in slow IO compared to running databases in DBsystems
- DBSystems are designed to run databases, hence they can access ASM disks and they are pre-tuned from OS perspective as well
You could file an SR and ask support to check if there is any process running on bare metal that consumes lots of memory which leads to swapping.
Move all databases to DBSystems or to bare metal.
Br,
krisz
Re: Not able to have the RTV delivery note autocreated
Hello
Again a delivery number is not automatically created per the standard flow as per design. You can log an idea for this to be considered for future release.
Thank you,
Bobbi
Re: How do we identify the PUM images for Peoplesoft Portal and EPM environments ?
There's a page called "About Applied Updates" which queries the PS_PTIAMMCPKGAPPDT table for some of these details. Run the following query to get some info on what PUM Images have been used to apply updates:
select * from PS_PTIAMMCPKGAPPDT order by ptiasppkgapplydttm asc
I don't think the table/page is 100% accurate but it does give some high-level info on the environment.
JM1
Re: PATCH 36047272 failing with ARXTWMAI.pll compilation error
Hello All,
We flushed the share_pool and then recompile this pll. It then compiled without issue.
alter system flush shared_pool;
Re: Auto Create NCR Below a Certain Threshold to a PO
Hi @David T ,
Option 1 - We can use createpo workflow with CPA to convert and PO
Other option we can explore SPOT Buy
Spot Buy is the ability given to requesters through roles to specify single or multiple suppliers with pricing while creating a requisition. Requester can rank suppliers and award one supplier.
If requisition amount is within the threshold limit defined, the Purchase Order can be created automatically. If the requisition amount is not within the threshold, buyer reviews the supplier, and create the PO.
.. but need to check whether it will meet your requirement
FAQ - Spot Buy Feature (Doc ID 2244757.1)
What Is Spot Buy Autocreate Criteria (Doc ID 2244708.1)
Thanks
Nirmal Kumar N
Re: xstore configure.bat and baseconfigure.bat
Hi,
No, there are no longer and batch files used to update any type of Xstore properties file.
All documentation can be found here:
Thanks
Re: Sales Order Request Date - Mass update
From Oracle Support: thank you for the post John.
The PCW61 functionality is limited to the "style" items under our Apparel Management system (41F), so if that is not being used in the organization, it will not return results, by design. Let me check for alternatives in the EDI space and/or exiting UBEs that can handle this, possible enhancement requests etc.
With regards,
-Matt
Re: Need Data Selection Extract in MS Excel
Review E1: RDA: Print Data Selection and Sequence Values in a Report (Doc ID 1398066.1)
Re: Audit expense reports with expenses older than a specified number of days
Hi Joanne,
Regret and yes for now its not available.
Thank You,
Bhaskar
Re: Create accounting is ending in completed error for Payables AP invoice and customer sales order.
Hi @User_P8CCR ,
This issue or question would be better served in a Service Request (SR) opened in My Oracle Support ( ). Detailed logging and/or specific customer details may be required for resolution, and for your protection we ask that this sort of information be transmitted only via a secure SR. When creating your SR, you can reference the URL of this community post.
Kind Regards,
Alexandru.