Best Of
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
Re: Sales Order Header - Create Date
From Oracle Support: thank you for the post.
I think the field you are looking for is the Order Date, TRDJ…..please check and advise.
-Matt
Re: Can Links to Fluid Pages on the Fluid Expense Workcenter Open without leaving the Workcenter?
I have created SR 3-41987700991 for this issue.
Re: Inquiry on Availability of IRS Consolidated Per Diem Rate File for CONUS (FY-2026)
Hello @User_GGAJ6 ,
I hope all is well with you over there ;o)
Thanks for your latest post into the PeopleSoft ESA Community, where the Expenses module queries can be raised.
The page link, and the instructions you shared, are from my own experience, the correct ones, and the ASCII format file for the CONUS/OCONUS Per Diem Rates on 2026 Fiscal Year should be available there. I am able to download the 2025 year:
August is usually the month when the DoD - GSA provides the new Per Diem Rates, but they do not come into effect until October 1st for the Fiscal Year 2026. As the same ASCII file is available for 2025, it is my assumption that in the coming weeks, the 2026 Fiscal Year option should be enabled. It may be just a matter of a bit more time.
I will leave it to other customers though to reply with their experiences, and if they have been able to get such files from some other place.
I hope that the information provided has clarified all your doubts. Should you have additional related questions, do not hesitate letting us know. On the contrary, if all your queries, and doubts have been successfully addressed, please make sure to mark 'YES' on the 'Did this answer the question? Yes-No' link. This will enable other Community Users to quickly identify the solution suggested, and see that this post has been successfully
answered.
Have an excellent day!
Pere Taulé
