Best Of
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
Re: What is the EOL date for Oracle LDAP 11.1.1.7.3 (ODSEE)
Dear Customer,
Oracle Directory Server Enterprise Edition 11g is supported by Oracle Support under Oracle's Lifetime Support Policy.
As per Lifetime Support Policy :
https://www.oracle.com/us/support/library/lifetime-support-middleware-069163.pdf
For Oracle Directory Server Enteprise Edition product Premire and Extended Support ended on 31st December 2022.
All versions of ODSEE are now covered under the Sustaining Support model. This means:
- - Sustaining Support provides access to pre-existing fixes, patches, and knowledge articles.
- - Certification on new platforms, patches/fixes, and security updates are outside the scope of Sustaining Support.
- - In addition, 24x7 coverage may not be available for products covered by Sustaining Support.
Oracle Unified Directory (OUD) is the next product to Oracle Directory Server Enterprise Edition (ODSEE).
Oracle Support recommends migrating to the latest version of our Java based directory server: Oracle Unified Directory Server. The latest version of OUD is fully supported at the Premium level of Oracle Lifetime Support.
Kind regards,
Gavril
Oracle Customer Support
Re: We want DFF under the project financial plan version area
Hi User_V86RE,
The Projects Implementation Guide Appendix E lists all of the DFF's available for Projects. The only DFF's available for budgeting and financial plans are:
Budget Entry Methods
Budget Lines
Budget Types
Budget Versions
Financial Plan Types Create / Update Plan Type
Thank you,
Sherry
Re: Oracle WebCenter Enterprise Capture - Base Installation
Hello,
The "Oracle WebCenter Enterprise Capture" product installation is included with the Oracle WebCenter Content installation media. It fuinctions on top of the Oracle WebLogic server application server the same way Oracle WebCenter Content does.
You can either search for the Oracle WebCenter Content installation media on edelivery.oracle.com or you can download from the link below:
Thanks.
Re: Unable to create accounting for AP invoice as the mapped CODE_COMBINATION_ID is -1 not valid value.
Hi,
Please check below in your TEST instance
1. Navigate to Setup > Accounts > Chart of Accounts Mapping in the General Ledger (GL) responsibility
2. Query the Mapping between Primary Ledger Name and Secondary Ledger Name
3. Verify that mapping exists for accounts affected. Save.
4. Run the run the concurrent program 'Chart of Accounts - Mapping Rules' for Chart of Accounts Mapping between the primary and secondary ledgers
Navigation: General Ledger Manager responsibility - Menu > View > Requests > Submit a New Request... > Single Request
Select from List of Values (LOV) > Chart of Accounts - Mapping Rules
5. Re-account the transactions
Regards,
Jagdish
Re: install Oracle 19c with the latest patch for version 28 in RHEL 9.6
Below are the basic steps for performing an install of Oracle 19c on OL9 / RHEL9, complete with the latest quarterly patches (JUL2025 "19.28.0.0.0" at the time of this writing):
====================
= Performed as root user =
====================
1 - Install Prerequisite RPMs:
Oracle Linux 9 <<>> # dnf install oracle-database-preinstall-19c
Red Hat Enterprise Linux 9 <<>> # dnf install bc binutils compat-openssl11 elfutils-libelf fontconfig glibc glibc-devel ksh libaio libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libgcc libibverbs libnsl librdmacm libstdc++ libxcb libvirt-libs make policycoreutils policycoreutils-python-utils smartmontools sysstat
Alternatively, the RPM can be installed with older YUM utility if not comfortable with the new DNF utility for RPM installations:
Oracle Linux 9 <<>> # yum install oracle-database-preinstall-19c
Red Hat Enterprise Linux 9 <<>> # yum install bc binutils compat-openssl11 elfutils-libelf fontconfig glibc glibc-devel ksh libaio libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libgcc libibverbs libnsl librdmacm libstdc++ libxcb libvirt-libs make policycoreutils policycoreutils-python-utils smartmontools sysstat
2 - Ensure "/dev/shm" & "/tmp" are mounted without "noexec":
Check if "/dev/shm" & "/tmp" are mounted with "noexec":
mount | grep tmp | grep noexec
If need to remount without "noexec":
mount -o remount,exec /dev/shm
mount -o remount,exec /tmp
======================
= Performed as oracle user =
======================
1 - Download & Extract Oracle 19c into the directory you want as the Oracle Home:
Oracle Database 19c Download for Linux x86-64
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
LINUX.X64_193000_db_home.zip
$ cd $ORACLE_HOME
$ unzip <parent dir>/LINUX.X64_193000_db_home.zip -x OPatch*
2 - Update the OPatch Utility in the extracted Oracle Home:
Patch 6880880 version OPatch 19.0.0.0.0
https://updates.oracle.com/download/6880880.html
p6880880_190000_Linux-x86-64.zip
$ cd $ORACLE_HOME
$ rm -rf OPatch
$ unzip <parent dir>/p6880880_190000_Linux-x86-64.zip
3 - Download & Extract the OJVMRU + GIRU Bundle:
Patch 37952382: COMBO OF OJVM COMPONENT 19.28.0.0.250715 + GI RU 19.28.0.0.250715
https://updates.oracle.com/download/37952382.html
p37952382_190000_Linux-x86-64.zip
4 - Execute Oracle 19c Installer:
$ cd $ORACLE_HOME
$ ./runInstaller -applyRU <extracted patch 37952382>/37957391 -applyOneOffs <extracted patch 37952382>/37847857
--
Requirements for Installing Oracle Database/Client 19c (19.22 or higher) on OL9 or RHEL9 64-bit (x86-64) (Doc ID 2982833.1)
