Best Of
Re: Load csv file to oracle database
Hello,
welcome to the MOSC forums! Note that you can very easily modify your display name to a more "human-friendly" value, it takes about 2 minutes; please have a look at
Idea: 1) create an external table pointing to your csv file with it 73 columns, then 2) simply insert what you want in the (72-column) target table -example:
INSERT INTO target_72 SELECT col1, col3, col4, ..., col73 FROM external_source_73;
HTH,
Bruno Vroman.
P.S. note that there are also many other interesting notes to welcome you to MOSC, look at
Delegation Framework
Hello,
We have enabled delegation framework and we have enabled delegation for the below delegation transactions.
- Expense Report
- Cash Advance
- Voucher
- Payment Request
When user creates delegation, all users dont see all the transactions for selection. For eg
- When user 1 logins in and created delegation, the user is able to see the below transactions
- expense report
- cash advance transaction for selection.
- When user 2 login and create delegation, the user is able to see all below transactions
- expense report
- cash advance transaction for selection.
- Payment request
- When user 3 login and creates delegation, the user is able to see all below transactions
- expense report
- cash advance transaction for selection.
- Payment request
- voucher
Question: What criteria or setup controls the display of transactions for selection when creating delegation ?
Thanks.
Re: MRP is not generating mesages for component items for all future planning months
Solution provided via SR raised by Customer:
With R3482>Processing Options>Parameters Tab>2. Generation Type set to 1-Single Level MPS/DRP, no Pegging records will be created, which in turn will not generate any messages when R3482 is run with Generation Type being 4-MRP with/without MPS across the Sub-Assembly and Component Items. Hence, below are the alternate options which you may consider to generate messages across the Sub-Assembly and Component Items.
* With R3482>Processing Options>Parameters Tab>2. Generation Type set to 1-Single Level MPS/DRP, no Pegging records will be created, which in turn will not generate any messages when R3482 is run across the Sub-Assembly and Component Items. With this option, messages obtained across the MPS Item (FG) needs to be processed which will create the Work Orders and freezes the MPS. R3482 then needs to be run across the Sub-Assembly and the Component Items with the Generation Type being 5-MRP with Frozen MPS.
* With R3482>Processing Options>Parameters Tab>2. Generation Type set to 3-Multi Level MPS Items, which does create Pegging records. With this option, R3482 can be still run across only the FG Item and later R3482 can be run across the Sub-Assembly and Component Items with Generation Type being 4-MRP with/without MPS which will generate the messages appropriately.
Please do review KM Doc E1: 34: R3482/R3483 Understanding & Use of Material Requirements Planning (MRP) (Doc ID 2252184.2)>Setup Tab>R3482 R3483 Requirements Planning Processing Options, section 'Parameters Tab' within that '2.Generation Type'.
Regards,
Naveen
Re: Oracle Database Enterprise Windows Database July 2026 Bundle Patch 19.32.0.0.260721 - Patch 39418910
Please disregard I found it:
OJVM RELEASE UPDATE 19.32.0.0.0(Patch:Microsoft Windows x64 (64-bit))
p39222882_190000_MSWIN-x86-64.zip
For any other users that have a difficult time finding patch information I will use the following link going forward:
Applies To
Database Administrator
Summary
This interactive Oracle Patch Widget allows users to browse and download Oracle database patches by first selecting their Oracle version (19c, 21c, etc.), then choosing a patch type (like Database Release Updates). Users can view patch details organized by release version, Home, etc.. explore recommended patches for specific updates, and see detailed information about bug fixes their descriptions, installation requirements. The widget also features expandable sections for viewing recommended patches and provides a CSV download option for exporting recommended patch data.
This document was MOS Document ID: 2118136.2 in Legacy MOS
https://support.oracle.com/ic/builder/rt/customer_portal/live/webApps/customer-portal/?anchorId=&km…
Hope this is helpful for someone else.
JT
Re: BSSV activate debug log
Hello,
This is to get captured in the *.out file the headers exchanged between SOAP client and Weblogic.
The knowledge article provides all the details you need to enable this.
Please check also the KB308429 - How to Capture SOAP UI Response Message in WebLogic Server Logs article.
Thank you!
Best regards,
Cezar
Re: Few users are complaining after selecting value from LOV on the OAF page not accepted by the field
Thanks for the workaround and it's working fine now
Configure Templates for COGS Revenue Matching Report
Learn how to set templates for the COGS Revenue Matching Report efficiently. Doc ID 3051128.1. https://bit.ly/4dZAa8q
#EBS #CostManagement
Re: Term Fee Setup: Charge By Session not respecting Min/Max Code when enrolled in 3+ sessions
Hello User_UI7BD.
Thank you for your posting to the Campus Solutions community.
The following documentation may be helpful when reviewing the setup, as it explains that Charge By = Session calculates charges based on enrollment within each session, while minimum/maximum fees can be configured at both the term and session levels:
- Setting Up Term Fee Codes
- Defining Minimum and Maximum Fees
We also found KB883065 as a related min/max-fee reference. However, it addresses STDNT_CAR_NBR and academic-year processing, so we cannot confirm that it applies to the session-based scenario described.
- KB883065 Tuition Calculation Assigns Incorrect STDNT_CAR_NBR for Min/Max Fees Causing Waiver and Charge Inconsistencies
If, after reviewing the setup, the behavior remains unexpected, please open an SR for further investigation. Including the term-fee and min/max configuration, a reproducible example with the session/unit breakdown, and the resulting Tuition Calculation charges will help us evaluate it further.
Thank you.
T
Re: nnSCZ1010p1-img-vm_kvm.tgz upgrade from Acme Packet 4600 SCZ9.3.0 Patch 2 (Build 98)
Hi.
- The correct patch is 39573227 (Oracle Communications Session Border Controller SCZ10.1.0p1 LI Platforms 3900/3950/4600/4900/6350/6400). Do not use versions for virtual SBC (KVM, VMware, VHD) on 4600
- According to 10.1 version release notes, the hitless upgrade path is
S-Cz9.2.0p13 (or higher) to S-Cz10.1.0
S-Cz9.3.0p9/S-Cz9.3.0p11 (or higher) to S-Cz10.1.0 »»» thus you have to make an intermediate upgrade p2 → p9 at least.
- LI license key is generated for your 4600's serial numbers. You do not need to obtain new LI licenses. Existing lawful-intercept configuration is also not affected.
Regards. Daureen
