Best Of
Re: Where can I download the correct opatch version?
Ah, I think that is it. Thanks for the keen eye. I swore I changed all my selections but clearly missed that. Thanks!
Re: Is there any way to delete the media Objects (in Bulk) but only for specific records ?
Please review these documents
E1: MOBJ: Finding Media Object Records in the F00165 Table (Doc ID 635593.1)
E1: MOBJ: Difference in the Media Object Table Structure of F00165 between Xe / ERP8 and 8.9 or Newer Releases (Doc ID 644903.1)
E1: MOBJ: Media Object Attachments Moved into the Database starting with Tools Release 9.2.1 (Doc ID 2212744.2)
Re: Where is Windows Patch for oracle 19.28?
John,
The current Windows Bundle patch will always conflict with the previous OJVM patch :
$> opatch rollback -id 37499406
then apply the 19.28 patches
Reference : Windows: Bundle Patch Conflicts with OJVM Patch (Doc ID 2022382.1)
regards,
Melody S - Oracle
Re: OCW Release Update 19.28.0.0.250715 fails, looking for ins_has.mk
$ opatch rollback -id <patch number>
Re: Is there a master list of all delivered roles from Oracle?
There is not a "master" list per se however per KM: E-SEC: Is There A Comprehensive List Of "Special" Roles? (Doc ID 2524423.1) it highlights that although there is "no such list" PeopleTools Security is not informed of nor keeps track of when other subproducts or Applications delivered hardcoded roles (not defined in the PSROLECLASS). Those roles are typically used with the PeopleCode API IsUserInRole(). A search be performed in PeopleCode looking for all instances of these roles in PeopleCode. Identifying the hardcoded roles in C++ would require scanning the proprietary code.
Re: Does anyone have a backup plan (disaster recovery) for DDP001 in the event the bank cannot accept
I hope our community members can share with you some guidance on how they provide similar payroll services for your scenario.
Re: How to mass update Days Late receiving parameter on open Blanket PO lines?
Hi @ismyth ,
Good Day,
There is no specific API or script for your request.
Please see Note 437587.1 - Release 12 Oracle Purchasing API and Open Interface Changes
Thanks
Nirmal Kumar N
Re: How can I get all 9 digits of precision in systimestamp?
One way would be executing OS command instead of SYSTIMESTAMP:
SQL> SELECT OSCOMMAND('/usr/bin/date "+%D %T.%N %z"') TS FROM DUAL;
TS
--------------------------------------------------------------------------------
07/23/25 16:56:24.343532143 -0400
SQL>
SY.
Re: How can I get all 9 digits of precision in systimestamp?
I've always seen triggers as being a sort of thing to use when all other methods wouldn't work, being a thing that exists and you can use, but the less you use them, the better. Sort of like symbolic links in Linux/Unix. You can use them, but the less and the shorter time you do, the better. I would guess insert triggers in addition to also be a performance thing as well, especially if doing mass actions. Oracle has built in functions left and right that can do similar or related functionality, with the same objective, and I would think it's a better idea to use these systems.
Mr. C
Re: What is the EOL date for Oracle LDAP 11.1.1.7.3 (ODSEE)
thank you for the detailed response