Best Of
Re: Oracle 19c CIS Recommendation: Ensure 'EXECUTE' is revoked from 'PUBLIC' on "DBMS_CREDENTIAL
Hi,
In my opinion, the warning about "internal query execution" is a valid general principle but does not apply to DBMS_CREDENTIAL in the same way it applies to DBMS_SQL or DBMS_LOB. You can revoke it if you explicitly grant it back to your scheduler/monitoring admins. So as Rahul mentioned above, if you do want (need) to revoke PUBLIC from those packages anyway, I would recommend you test all options in your own (lower) environment first.
Cheers
Arsalan
Re: Query of OPATCH_XML_INV after applying 19.24.0 on Windows takes up to 8 minutes
Hi,
the issue is tracked with this bug:
36509398 SLOW QUERY PERFORMANCE WITH EXTERNAL TABLES USING PIPES ON WINDOWS
and the fix is included in 19.29.0 WinBP.
Regards,
Martin
Re: Advisor Webcast: PeopleSoft 1099 Update for 2025-Get your Copy B’s out on time! on November 19, 2025
Hello,
The above issue was intermittent. When combined 3 bugs change package was successfully applied to other non-prod envs.
I ran 1099 Analyzer 200.5 after applying the change package based on bugs 3834292, 38652909, and 38662599. The change package review shows the following included bugs
37234282 ENH PSFTAP-8261 PRESSURE SEAL 1099 FORMS
37366259 FOREIGN SUPPLIER PROVINCE CODE ERRONEOUSLY INCLUDED IN IRS FILE K RECORD
37396293 SUPPORTING BUG FOR 37366259 - AP: FOREIGN SUPPLIER PROVENCE CODE ERRONEOUSLY INC
37806480 ENH - PRESSURE SEAL 1099 FORMS FOR 1099-MISC, 1099-INT, 1099-NEC
38342920 AP: NEW 2025 IRS REQUIREMENTS FOR REPORTING 1099-NEC/MISC
38479968 1099 UPDATE FOR 2025
38540366 PRESSURE SEAL FORM FOR 1099-G
38600273 SUPPORTING BUG FOR BUG 38479968 - 1099 UPDATE FOR 2025
38603341 SUPPORTING BUG 2 FOR BUG 38479968 - 1099 UPDATE FOR 2025
38652909 1099 UPDATE FOR 2025 - 1099-MISC FORM REVISION DATE AND 1099 JOB WITHHOLDING PRO
38662599 1099 UPDATE FOR 2025 - CFSF INDICATOR MISSING FROM THE IRS FILE FOR 1099-NEC
The Patch Verification shows Missing Patch
From Analyzer the Missing Patch
Bug 38603341 in in Patch 38652909 (see above, this already included in the change package)
The fix for Bug 37388209 has been incorporated into PRP Patch 37366259
The fix for Bug 37379656 has been incorporated into PRP Patch 37366259
Patch 37366259: AP: FOREIGN SUPPLIER PROVENCE CODE ERRONEOUSLY INCLUDED IN IRS FILE K RECORD shows This Patch is Obsolete. It cannot be Downloaded.
The only missing bug/patch is 38576864. Which I have downloaded and will be applying.
Can you please confirm?
Francis
FrancisF
Create employee data using Web ADI
- Login as user with Web ADI responsibility.
- Open Desktop Integrator menu. You will see HRMS ADI Create Document and HR ADI Seeded Integrated Form functions as the Submenus. If required, add these two submenus to Desktop Integration Menu.
- Launch Create Document from Web ADI
- You will see Integrator, Viewer Layout content and Review pages.
- Select 'HR Integrator Setup' Integrator and Click on Next
- Select the correct Excel version. Uncheck reporting checkbox because you are going to upload the data and not creating reports
Keep Content None - In the Review details click create content
- HRMS Intergrator Template will open up in Excel.
- Go to Excel Options and make sure Macros are enabled, Enter following details
- Metadata Type: CREATE
- Application Short Name: PER
- Intergrator User Name: <define your user>
- View Name: <BLANK>
- Form Name: GENERAL
- API Package Name: HR_EMPLOYEE_API
- API Procedure Name: Create_Employee
- Interface User Name: APPS
- Interface Parameter List Name- <Give Name>
- API Type: Procedure
- Click on Add-Ins on the Excel top menu. Select Oracle and Click on Upload. Select All rows and upload.
- Login as user with System Administrator responsibility.
- Navigate to Application --> Function
- Enter function and function name.
- Under Properties tab, select Type as Sub-function. Note down the User Function Name you have selected.
- Open the Desktop Intergrator Menu again and add the function created as above.
- Click on Create Document under Web ADI responsibility
- Select "HR Maintain Integrator Form Function Associations" integrator.
- Again you will see the 5 pages
- In the Integrator select application name PER
- Integrator User Name: Should be populated. If not, enter your Integrator User Name
- Form Function Name- Give the function that you created
- Click on the Oracle and select Upload to Upload into Oracle.
- Launch Define Layout from Web ADI in Oracle EBS R12
Your setup is completed.
- Launch create document from Web ADI
- In the list of Integrator, you should see the new integrator created as above.
- Select the new integrator
- Select the layout
- Finally a blank template will open up in your Excel.
- Copy and Paste Employee list.
- Click Upload.
- the data will be loaded to Oracle EBS.
Re: WEB ADI Set Up Step (What am I NOT doing?)
If you are trying to create Custom Integrator you can follow steps below:
1.Check your IE and Excel/Word Settings
2.Add Responsibility Desktop Integration to your User.Select the ‘Desktop Integration’ Responsibility
3.Click ‘Create Document’ function
4.Uncheck the Reporting Checkbox as this integrator is for uploading. Select the Viewer as Excel
5.Select the ‘HR Integrator Setup’ as the Integrator.Click "Next"
6.Select Content as "None" as we need to create the blank document for upload and Click "Next"
7.Click on "Create Document "
8.Once the spreadsheet is created, enter the following details and upload it back into the system.
Metadata Type : DOWNLOAD – to create download integrators
UPDATE – to create download / upload integrators
Application Short Name : PER
Integrator User Name : <User Defined Name for Integrator>
View Name : <User Defined View>
Form Name : Name of the Form to which the integrator is to be associated
API Package Name : API Package Name used to Upload Data (Only for UPDATE Integrators)
API Procedure Name : API Package Procedure (Only for UPDATE Integrators)
API Type : PROCEDURE / FUNCTION
Click on Oracle -> Upload to create the integrator
9.Define a Function using System Administrator -> Application -> Function. This function will be used to restrict the Responsibilities for which a particular integrator is available.
Function = Internal Function Name
User Function Name = User Defined Function Name
10.Create the Form Function Association Document using Web ADI Menu –Desktop Integration -> Create Document
Select Integrator as "HR Maintain Integrator Form Function Associations" and repeat step 4
11.Select the application in which the integrator is defined and the Integrator User Name for the Form Function Association has to be done. Click Next to continue.
12.Click on "Create Document" and Attach the Form Function created in step 9 i.e.Internal Function Name to the Integrator in the document created in the above step and upload the same.
13.Define the Layout for the Integrator created in above steps using
Desktop Integration -> Define Layout
14.Select the integrator for which the Layout has to be defined and click Go to continue.
15.Select the columns that will be displayed and click Apply
16. Navigate to the Form which you have attached in step 8 and Click on Export Icon.
You will be able to view the Integrator.
Regards,
Sushant
Re: ELM Privacy/Security Problem - Learners able to access other users courses after launching course.
Hello AG Reddy,
I found the SR you created, I recommend to continue the investigation in the SR and update this post once a conclusion is reached.
I updated the SR with the URL of this community post.
Re: Does anyone have information on the changes with the Notify button on the HCM pages?
We use the enableWorklistNotify property on the web profile configuration custom properties in order to continue using the Send Notification page for the notify button.
USR_123
Re: Does anyone have information on the changes with the Notify button on the HCM pages?
Yes, the page uses the classic version and functions the same.
USR_123
Re: JDE Orchestration Studio Notification
I see your enhancement! I have already upvoted it in the tool, I encouurage y ou to publicize and have others in your company vote as well. https://cloudnnf.questoraclecommunity.org/questenhancementtool/ViewEnhancement.aspx?id=17008
Re: JDE Orchestration Studio Notification
Fantastic, welcome! It's an incredible group. We get lots of things done especially moving good ideas forward to make it into the software.