Best Of
Re: How to Modify the Column Length in a Standard Report - Account Analysis report?
Hi @User_K95XS,
Thank you for visiting My Oracle Support Community and posting your question here! I want to let you know I have moved your thread to our EBS Customizations (MOSC) subcategory for those subject matter experts to engage.
If an answer resolves your question, please choose the "YES" on that comment for "Did this answer the question?".
In the meantime, feel free to review the following information to learn more about our Community:
- How to Find and "Follow" Categories - Learn how to Follow Categories of interest
- Setting Up Category Notifications for New Content - Learn how to get notifications on content
- How to Search and Do Advanced Search - Learn how to get to advanced search and filter options
- Visit our MOSC Resource Center
- Browse all our represented Product Categories
- How to Edit Your Community Username - Details are provided to change your default display name, which will allow for a more personalized profile
- How to Ask a Question and View Answers in the My Oracle Support Community - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question
- Community Guidelines
- How to be a good Community Citizen
- Not posting Private Information
- How to be a Community Star
Thanks,
Gail
Re: Where can i download a patch for Oracle client 19C and 21C for fix 36103137
For Oracle Client 19c, the Bug Fix 36103137 has been incorporated into the DBRU/WINDBBP since JUL2024 (19.24). Solution is to apply the 19.24 DBRU/WINDBBP or newer to the Oracle Client 19c.
For Oracle Client 21c, for anything other that the back port of Patch 36103137 to overlay OCT2021 (21.4) DBRU/WINDBBP, you will need to work with Oracle Support.
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
Can you confirm that Oracle 19c installed successfully on RHEL 8 without any issues/errors?
Below are the basic steps for performing an install of Oracle 19c on OL8 / RHEL8, complete with the latest quarterly patches (APR2025 "19.27.0.0.0" at the time of this writing):
=====================
= Performed as root user =
1 - Install Prerequisite RPMs:
Oracle Linux 8 <<>> # dnf install oracle-database-preinstall-19c
Red Hat Enterprise Linux 8 <<>> # dnf install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make 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 8 <<>> # yum install oracle-database-preinstall-19c
Red Hat Enterprise Linux 8 <<>> # yum install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make 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 37591516: COMBO OF OJVM COMPONENT 19.27.0.0.250415 + GI RU 19.27.0.0.250415
https://updates.oracle.com/download/37591516.html
p37591516_190000_Linux-x86-64.zip
4 - Execute Oracle 19c Installer:
$ cd $ORACLE_HOME
$ ./runInstaller -applyRU <extracted patch 37591516>/37641958 -applyOneOffs <extracted patch 37591516>/37499406
--
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
This typically indicates that the libsqlplus.so library is missing, inaccessible, or not resolvable due to incomplete installation, incorrect environment variables, missing system prerequisites, or permissions issues. To resolve, first verify and set environment variables in ~/.bash_profile (e.g., export ORACLE_HOME=/oracle/app/oracle/product/19.0.0/dbhome_1; export PATH=$ORACLE_HOME/bin:$PATH; export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH), then source the profile and check if $ORACLE_HOME/lib/libsqlplus.so exists using ls -l; if missing, relink binaries with cd $ORACLE_HOME/bin; ./relink all and review logs for errors. Ensure RHEL 8 prerequisites are installed via yum (e.g., libaio, libaio-devel, libnsl, etc.), diagnose dependencies with ldd $ORACLE_HOME/bin/sqlplus, and check SELinux status with getenforce—set to Permissive temporarily if Enforcing. If unresolved, reinstall Oracle 19c.
Cheers
Arsalan
Re: Version number of expense PO (conversion PO) is not changing, after changes in the PO
Hi @User_RC567
Record missing in Archive table could be possible cause
please check for the working case it might be having a record in archive table
Possible cause during the time of import the Archive on option might be COMMUNICATE
Option 1
for testing
- Change the Archive On option to communicate
- Now query the Approved PO in PO summary form → Tools → Communicate → please check the archive table has records if it got populated
- (Also run PO output for communication) program for one PO with regenerate
Now the archive table should get populated once its done then you can change to approve and create a revision and validate
If Archive table is the cause
I think do have a data fix we will check the owning engineer
Thanks
Nirmal
Re: Version number of expense PO (conversion PO) is not changing, after changes in the PO
We got datafix from Oracle to upload data in Archive tables, and then is working fine for standard PO and BPA
Waiting for datafix for BPA releases
Re: Purchase Order Approval Issue – Record Not Appearing in Approval Screen
Hi Mahesh,
Thank you for the input. The issue is resolved by following the steps you mentioned.
Regards,
Vaibhav
Re: Credit Card Payments - Customer - Recurring
Hello,
Please review below notes for the complete setup:
- Note 745996.1 > section 4 > a. Assign default payment details at the customer account or site level for the Customer setup needed to default the Credit Card Payment Method while creating AR Invoices
- Note 1098583.1 to review the defaulting logic of the payment instrument when importing Invoices through Autoinvoice.
Regards
Re: MasterCard CDF3 Transaction Loader program is now populating Billed Date after upgrade to 12.2.13.
Hi Sharla,
Your query/ question would be better served in a Service Request (SR) opened in My Oracle Support (https://support.oracle.com/).
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.
Regards
George