Best Of
Re: API or Interface table to Update Min Max Quantity at Organization Level
If the response on this thread was helpful, please close this thread by choosing the "YES" on that comment for "Did this answer the question?". This helps identify effective monitor threads and encourages community users to assist others by providing potential solutions.
Re: GMF BATCH QUANTITY - IN THE REPORT BATCH INGREDIENTS QUANTITY TOTALLY DIFFERENCE
Hello -
The formula will be scaled to the standard quantity on the recipe validity rule.
Thank you.
Re: SINGLE BATCH SCALLING ISSUE
Hi,
The only way to stop a product or ingredient from scaling is to set the Scale Type on the product or ingredient line to Fixed.
Regards,
Glenn
Re: I am experiencing a critical internal 11.2.0.1 ORA-06512+ORA-00600+ORA-07445+ORA-00602
Hi,
According to the trace, you might be hitting ORA-00600 [13011] when delete from MGMT_SYSTEM_PERFORMANCE_LOG table (Doc ID 2227027.1)
Re ORA-00600: internal error code, arguments: [kgscCacheHit] - there are multiple bugs that might be related, but to narrow it down you need to file an SR.
Please note that 11.2.0.1 version is extremely old. You should upgrade asap.
AFAIK, your version is not supported unless you have upgrade license and you are on 11.2.0.4 and applied the latest PSUs.
Refer to Release Schedule of Current Database Releases (Doc ID 742060.1)
Br,
krisz
Re: API or Interface table to Update Min Max Quantity at Organization Level
Hi
As workaround you can use INCOIN to import the changes:
See the following example:
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(ORGANIZATION_ID,
MAX_MINMAX_QUANTITY,
MIN_MINMAX_QUANTITY,
SEGMENT1,
PROCESS_FLAG,
TRANSACTION_TYPE,
SET_PROCESS_ID
)
VALUES
(&org_id,
&max,
&min,
'&item_code',
1,
'UPDATE', --CREATE or UPDATE
1);
commit;
Then run item import program.
For more information, please refer to below note:
Inventory Item Open Interface (IOI) Service Request Template (Doc ID 458544.1)
Hope the above helps
Thanks
Naga Kumari
Re: PO Creation Issue when carrier number is blank.
Issue is resolved now.. Values were missing in UDC 49|TP
Amith-R
Re: how to find os watcher log file location
Re: how to find os watcher log file location
Hi User_POJAT,
You can use below command which shows oswatcher archive destination.
ps -ef |grep -i osw
Thanks
Sajith, RAC Community Leader
Re: DRP/MRP - Increase & Decrease Messages
Hello Jay,
Per KM Solution E1: 34: Deleting E - Expedite Message In UDC 34/MT Doesn't Prevent MRP From Generating E - Expedite Messages In P3411 (Doc ID 2819757.1), Users can delete only G and L messages from UDC 34/MT.
While deleting the G and L messages types from UDC 34 MT is supported, recommendation is to validate your planning results before and after the change.
The absence of an L decrease can result in excess inventory, based on changes in demand. The absence of a G increase should result in a net new order.
For a full list of the message types, refer to KM Solution E1: 34: R3482/R3483 Understanding & Use of Material Requirements Planning (MRP) (Doc ID 2252184.2).
Regards,
Jeff
Re: E1: 43: How to inquire a reversal receipt? (P43214)
Follow up from Oracle: I have confirmed that there is no application specifically to view receipts that have been reversed; perhaps the best way to identify orders where the receipt has been reversed is in the F43121 record directly, where the Match Type (MT) record is set to value '4' - 'The Receipt order has been reversed'.
We could consider an enhancement request under a Service Request if needed, though our ability to implement the functionality could be made difficult by a note in the F1 Help text for the "MATC" / Match Type field, below:
"Note: Record types 3 and 4 are audit records only; you cannot access these record types for the Voucher Match program (P4314) or the PO Receipts program (P4312)."
With regards,
-Matt