Best Of
Re: Not Able to open any object Start Form/Report Design Aid
Try doing a get/advanced get for P9861 and P98220 and see if it makes any difference.
Re: API for mass transaction of Miscellaneous Receipts for Serial control enabled items.
Very useful information, Thanks Lonut
Re: API for mass transaction of Miscellaneous Receipts for Serial control enabled items.
Hi Qamar,
Thanks for following the correct approach to issue out the on hand prior to updating the serial attribute.
Regarding performing miscellaneous receipt with serial number in bulk, i recommend using Material Transactions Interface to do it.
You need to populate mtl_transactions_interface and mtl_serial_numbers_interface tables with the needed data, then launch the Inventory Transactions Manager (INCTCM) through the Interface Managers Window or wait for some time for it to process the records (customers usually have this manager scheduled to run every 5 minutes).
Please refer to the below note for sample scripts of inserting the data in the interface tables :
Sample WMS Open Interface Insert Scripts -- How To Insert Into Transaction Open Interface MTL_TRANSACTIONS_INTERFACE Table (Doc ID 357535.1)
Focus on Scenario 6: Misc. Receipt (with LPN and serial).
In case you do not use Warehouse Management or the organization is not WMS enabled, you can ignore populating the LPN columns.
Regards,
Ionut
Re: Is there a database client 19.27.0.0.250415 available?
To add to Anuj's response, if you need to apply the 19.27 patchset to the client for any reason, then download the Database Release Update and apply it to the 19.3 Client you installed or have.
Opatch will pick up that this is a CLIENT install and apply only the Client patches.
References:
Doc ID 19202504.9
Doc ID 1561792.2
Hope it helps!
Kindest regards
Roy
Re: Is there a database client 19.27.0.0.250415 available?
Hi,
Direct database client 19.27.0.0.250415 is not available.
You can download 19.3 client which is supported for all the latest and greatest db version.
You can refer the oracle notes (Doc ID 207303.1) for Client / Server Interoperability matrix details.
- To download the latest instant client you can refer below,
2. To download latest 19c client you can refer the below link,
Oracle Database 19c Client (19.3) for Microsoft Windows (32-bit)
NT_193000_client_home.zip or NT_193000_client.zip
LINUX_193000_client_home.zip or LINUX_193000_client.zip
Please note, For any further assistance, kindly create SR with oracle install team so that you will get all the step by step guidance.
Re: Sales Order Header - Create Date
Thank you Scott - without knowing the full business process it's difficult to make a recommendation. Let's dig deeper under a Service Request (SR) please, if you can attach a document that shows the current setup and whether that config is working and/or causes issues, that would be appreciated.
One piece of functionality to throw out there is the "User Reserved" fields - there are 5 of these and one of them is intended to handle dates. Please refer to our document ID 1678558.1 for details; this master document contains links to other module-specific papers.
With regards,
-Matt
Re: UBE csv output missing a column and columns are overlay
Does it look correct if you open the csv using notepad or notepad++ ?
Re: UBE csv output missing a column and columns are overlay
I redid all of the report title column, every column in the detail line, and I was able to eliminate the problem
It is very challenging for the report with so many columns and various long-length variables.
Thanks for your attention and support