Best Of
Re: MasterCard CDF3 Transaction Loader program is now populating Billed Date after upgrade to 12.2.13.
Thanks, George. I will do that.
Thanks,
Sharla
Re: How to generate Cash at Bank Account with Location (seg2)
Thanks, from Bharat's advice and referring Doc ID 1544633.1 we able to configure the SLA/ADR to generate the Cash Account with location segment based on Mapping.
Re: Can we update accounts column in mtl_system_items_b directly.
also refer the note
1. How to use the Item Open Interface (INCOIN) (Doc ID 1457314.1)
Re: How to generate Cash at Bank Account with Location (seg2)
Hi
How are you directly moving Receipt from Confirmed to Cleared without Remittance ?
Once receipt is remitted, it will appear in cash management bank statement for reconciliation.
The Cash account is derived from Receipt Method Bank setup, it won't change.
You need to change it during accounting by doing Application accounting definition customization in SLA.
Best Regards,
Bharat
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