Best Of
Re: How to find the link between Invoice and Late charges' Debit Memo
Hi Mallik
When you choose option to create Adjustment for Late charges it can be seen in the Invoice.
For Debit Memo late charge ,the linking report is not there.
You may want to create a custom report /query.
Best Regards,
Bharat
Re: How to find the link between Invoice and Late charges' Debit Memo
Hi Mallik
I appreciate if you mark the Question as Answered for benefit of community and its users.
Thanks
Bharat
Re: Oracle Optimizer not using Index when the query has bind variables AND pagination clause
Hello Jonathan Lewis,
Thanks again for your response. Apologies for my delayed response.
That Hibernate thread was shared by our developers as they were also investigating the issue.
Regards,
Thiru
Thiruc
Re: ODA X11 new deployment
Hi Krisz,
Perfect.
Thanks for the prompt response.
Thanks,
James
Re: Reducing Cluster factor
Hi
I am not an expert in DBA but i have come across the below thread please check this might be helpful
Thanks
Nirmal Kumar N
Re: Reducing Cluster factor
A comment worth making about the PK index (and possibly the SYS_C009729 index is also a primary key index), the use of the index is likely to be restricted to queries like "primary key = constant" rather than "primary key between constant1 and constant2" in which case the clustering_factor does not come into play in costing the query.
Given the size of the tables and the fact that the clustering factors are large percentages of the number of rows I think you may be seeing the basic side effect of ASSM (automatic segment space management) and highly concurrent inserts of sequence numbers or timestamps.
Under ASSM different users sessions will be assigned different table blocks for their inserts - but usually these blocks will be a fairly small group, so "similar" data values will tend to be fairly well clustered; however when calculating the clustering_factor Oracle doesn't allow for the way in which a number of similar values are loosely clustered in a small area and sees the "slight scatter" that's really there as a completely table-wide scatter.
Oracle introduced a "table preference" for gathering stats in 11g that allowed you to make the optimizer more aware of the clustering of the data. I suggest you read this "tip" that I wrote for IOUG in 2015 - the second feature it mentions is the table_cached_blocks preference which still defaults to 1 and ought (for most people, probably) to be more like 16, or 16 * number of RAC nodes. The note describes what it does and how to set it.
Regards
Jonathan Lewis
Updated to correct a couple of typos.
Re: Automatically starting Listener after server restart on RHEL 9
I don't have a license of either RHEL 9 or Oracle 19c to test this out, but something you can try is to create a custom service unit for the listener. For example:
sudo vi /etc/systemd/system/oracle-listener.service
Try something like this:
[Unit]
Description=Oracle Net Listener
After=network.target [Service]
Type=forking
User=oracle
Group=oinstall
ExecStart=/u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl start
ExecStop=/u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl stop
Restart=always [Install]
WantedBy=multi-user.target
Adjust the Oracle Home path (/u01/app/oracle/product/19.0.0/dbhome_1) and Oracle user/group to your environment.
Then reload and enable:
sudo systemctl daemon-reload
sudo systemctl enable oracle-listener
sudo systemctl start oracle-listener
As always, there are many ways to achieve the desired results in Linux, but this one is clean, restart-aware, integrates with journald logs, and plays nice with RHEL 9.
Give it a try and let me know if you face any issues.
Best regards.
Re: After Creating New Locator and Assign to Sub inventory Not able to fin Locator
Hi Ionut,
Very Grateful for Quick and Precise Answer , Point no 3 Is solve my problem it has Restriction check box check.
Appreciate your help.
Thanks
Altaf Shaikh
Re: After Creating New Locator and Assign to Sub inventory Not able to fin Locator
Hi Altaf,
Please find below a few points to check :
- Check Locator Setup (based on your post i assume this is fine)Ensure the locator is accurately defined for the correct Organization and Subinventory.
Go to: Inventory > Setup > Organizations > Locators
Make sure the Locator Type and attributes (such as Active, Enabled, etc.) are set properly. - Assign Locator to Subinventory (based on your post i assume this is fine Go to: Inventory > Setup > Organizations > Subinventories
Query the concerned subinventory.
In the Locators section, ensure your new locator appears and is checked as Enabled. - Subinventory Locator ControlCheck if the Subinventory uses Locator Control: Prespecified/Restricted/None.
If set to Prespecified or Restricted, only assigned locators will appear in LOV during transactions.
If None, no locator will be prompted.Make sure the subinventory is not set to None if you want to see locators. - Check Start Date/End DateConfirm that your locator's Start Date is today or earlier, and End Date is blank or in the future.
- Organization AccessEnsure that you have roles and organization access for the one where locators are defined
- Check Data in SQL
SELECT *
FROM MTL_ITEM_LOCATIONS
WHERE SUBINVENTORY_CODE = '&subinventory_code'
AND DESCRIPTION = '&locator_name';
If this returns no rows, your locator is not assigned properly.
7. Compile Value Sets and Flexfields (Stock Locators)
Check if Stock Locators flexfield is compiled successfully, you can try to unfreeze and freeze to trigger recompiling.
8. Validate other transactions like miscellaneous receipt into the newly created locator
If none of the above helps, you can raise a service request to look into it further.
Regards,
Ionut
Re: Decommit Inventory
Hi Naveen
Related to this , we don't use the lot control and use only the primary location.is there a way to decommit the stock from hard commit to soft commit.Any suggestion please?
sai