Best Of
Re: Is Oracle SQL Client 11.2 vulnerable to log4j issues(CVE-2021-4104, CVE-2019-17571) ?
Clearly he refers to the Oracle Database Client (some people call it "fat client"). The sqlcl or sql developer are not clients, they are tools which use the Oracle Client to connect to DB.
@User_U1NRI @tamdba you can refer to the Doc ID 2830143.1 which says that Oracle doesn’t believe that the Oracle Client is affected by vulnerability CVE-2021-45046. Unfortunately I found no clear info about CVE-2021-4104 or CVE-2019-17571.
BR
anilech
Re: How to capture user machine and ip on Weblogic Forms application
Hello Doug Clark,
Thank you for contacting Oracle Communities.
Login to Admin console, browse to Servers -> Managed Server -> Logging -> HTTP -> Advanced
In the Extended Logging Fields
Check if "cs-username" is added in the fields this will capture the OS username.
cs(X-Forwarded-For) date time cs-method cs-uri sc-status c-ip cs-username
Thanks, suresh
Re: Can we put invoice lines on hold in the AR Interface table for them not to be picked up by Autoinvoi
Hello Amit,
There is no standard way in Receivables which can track if all the lines for a particular sales order has been interfaced and only after that it will be processed by Autoinvoice program. Hence you have to use your custom workaround.
Autoinvoice will particularly see the INTERFACE_STATUS in RA_INTERFACE_LINES_ALL table.
- NULL - Will be picked by Autoinvoice
- P - Has been processed successfully to Receivables by Autoinvoice
Setting RA_INTERFACE_LINES_ALL.INTERFACE_STATUS to some random alphabet other than 'P' or NULL will help in putting the lines on hold.
Also if the REQUEST_ID column is NULL, it assumes that the row is available to be picked by Autoinvoice.
In short, marking both REQUEST_ID and INTERFACE_STATUS columns with NON NULL data will stop the rows from being picked by Autoinvoice Program.
Best Regards,
Chinmayee
Note : Consider marking replies as correct and/or helpful as this will make it easier for other community members to find replies that might help them in a similar situation. This also acknowledges my contribution.
Re: How to find project status change history in projects
PA_OBJ_STATUS_CHANGES has a column called OBJECT_TYPE and STATUS_TYPE
If OBJECT_TYPE = PA_PROJECTS and STATUS_TYPE= PROJECT
then the OBJECT_ID in PA_OBJ_STATUS_CHANGES links to the project_id in pa_projects_all.
Re: For WLST Experts: Oracle Forms Instance Creation From A Command Line
Thread was split to address a different query.
Solution
Hi Suresh,
Thank you for your suggestion.
Finally, i used a "workaroud" that is to create Forms instance offline,
After the installation is complete. I stop all the infrastructure then create my forms instances offline for each server (VM) i need. And it works fine.
Just to know, how many forms instance can i start on one server ? How much (RAM CPU) one forms instance is consuming ?
Server is 2 CPU. 12 Cores (2*6) and 128GB Ram
Thank you for your attention
Best Regards
Michel