Best Of
Re: OCW Release Update 19.28.0.0.250715 fails, looking for ins_has.mk
I ran into this too, and while I appreciate the response "not intended for Oracle Client" … this raises a HUGE question for me personally. I have an open SR about it too.
January '25 was applied without issue, April '25 was applied. All of 2024, 2023, etc. back to the original 19c.
So, i went digging … the reason WHY it is failing is that the section that executes the "make" has been moved, again. Each month it was different. WHY?
January '25 CPU:
37262208/37257886/37268031/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
</oracle.has.db.cvu>
Make located in: oracle.rhp.common
April '25 CPU:
37591516/37641958/37654975/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
</oracle.has.db.cvu>
Make located in: oracle.has.crs
July '25 CPU:
37952382/37957391/37962946/etc/config/actions.xml
<oracle.has.db.cvu opt_req="O" version="19.0.0.0.0">
<copy backup_in_zip="false" file_name="cv/cvdata/cvu_prereq.xml_db" name="cvu_prereq.xml" path="%ORACLE_HOME%/cv/cvdata" retain_permission="true" shaolue="6EA609ABC1738B54145FC6ADD37329FBCBB1E113"/>
<make change_dir="%ORACLE_HOME%/srvm/lib" make_file="ins_srvm.mk" make_target="install_srvm"/><make change_dir="%ORACLE_HOME%/racg/lib" make_file="ins_has.mk" make_target="install"/>
</oracle.has.db.cvu>
Notice that the "make" commands now exist in "oracle.has.db.cvu", the last few that I have checked, they existed in different components. Perhaps there is a logical explanation. But this becomes a moving target and hard to justify to any type of auditor why the OCW is now stuck at 19.27.0.0 when everything else has move to 19.28.0.0
Moving the "make change_dir" out of "oracle.has.db.cvu", I was able to successfully apply this patch, which maybe is NOT ideal … Since though it exists on Oracle Client, but "it isn't required" … what options actually exist?
Re: Can HMR modify the SIP Method?
Hello,
It is written in HMR configuration guide, that manipulation cannot change one method to another. I was checking log.sipd and came across a system message, that the CSeq field and RURI field itself are somehow protected against such manipulations as well as From/To tag uri-parameters.
Regards,
Daureen
Re: Unable to create requisition for Description based item through work order in EAM
Can you please provide the error messages ?
If not present in the Req Import output report then use this query:
SELECT POE.COLUMN_NAME,
POE.ERROR_MESSAGE,
RQI.INTERFACE_SOURCE_LINE_ID,
RQI.WIP_ENTITY_ID,
RQI.TRANSACTION_ID,
RQI.PROCESS_FLAG,
RQI.AUTHORIZATION_STATUS,
RQI.DELIVER_TO_LOCATION_ID,
RQI.PREPARER_ID,
RQI.DESTINATION_ORGANIZATION_ID,
RQI.DESTINATION_TYPE_CODE,
RQI.SOURCE_TYPE_CODE,
RQI.LINE_TYPE_ID,
RQI.ITEM_ID,
RQI.NEED_BY_DATE,
RQI.QUANTITY,
RQI.UNIT_PRICE
FROM PO_REQUISITIONS_INTERFACE_ALL RQI,
PO_INTERFACE_ERRORS POE
WHERE RQI.WIP_ENTITY_ID in
(select wip_entity_id
from wip_entities
where wip_entity_name = '&WO_Number')
AND RQI.TRANSACTION_ID = POE.INTERFACE_TRANSACTION_ID(+)
AND RQI.INTERFACE_SOURCE_CODE = 'EAM';
Regards,
Florin
Re: Unable to create requisition for Description based item through work order in EAM
Where do i need to enter the deliver location @SriniS-Oracle, @Piyush-Oracle
Re: Unable to create requisition for Description based item through work order in EAM
Department definition.
Re: When will the OLAM ansible playbook code be upgraded to support 2.3 and OL9?
I opened a new issue @
Thanks
Jim Davis
Re: Where is Windows Patch for oracle 19.28?
OJVM Patches being incorporated into the DB Patches with 21c and newer is not a "fix", it's simply a change in delivery method (which has been used for the past decade). There is nothing to "fix", as there is nothing "broken".
Upgrading from a Long Term Support release to a Feature Release, just to have a difference in patch delivery method is not a "fix", and would not be recommended as such by Oracle Support.
Re: eProcurement and OBN/OSN Oracle Business Network integration
HI Stacy,
Thanks for posting your question to the SCM community.
If other customers/partners have implemented OBN , I encourage you to share your feedback or provide any insights.
Thanks,
Wael
Re: Performance Issues with INV Tables and Indexes in Oracle EBS R12.2.10 – Need Expert Guidance
Hi Mohammed,
One thing is to make sure you keep the statistics updated. Work with your DBA to find the best parameters to use when running statistics on them. When tables become very large, it takes longer and longer to hit the defaults, so sometimes you are running stats but not getting the impact you could. For example, if the default is to update statistics when a table has grown 10%, but the table has 500M records already, it wouldn't update the stats until there are 50M new rows. When the table grows to 700M rows, it won't update stats until there are 70M new rows. And so on.
Try this to get some basic information: select table_name, num_rows, last_analyzed from all_tables where table_name in (<list of tables>)
Interface tables can become fragmented because data is inserted then deleted. Your DBA will be able to check that for you. Depending on your business processes, there could be a couple of actions. If you can confirm that the interface table is completely empty, you can truncate it to quickly free up space and eliminate all fragmentation. The tables are shared by all organizations, though, and if there is always data in there, the DBA should have some other methods of defragmenting.
