Best Of

Re: Tax Data Refresh Functionality

Here is the information for Patch 37623069 which was released in Tax Update 25-B/PUM 52.

From page 61 of the 25-B Release Notes

DIRECT DEPOSIT WAGE STATEMENTS MISSING STATE ALLOWANCES FOR MONTANA WHEN USING U.S. TAX DATA REFRESH FUNCTIONALITY

DDP003.SQR prints Payroll Deposit Advice notices for employees who choose to have their pay deposited directly to their bank account.

Patch 37623069 modifies the program to include the allowances evaluation process for Montana for the U.S. Tax Data Refresh functionality.

Prior to the modifications, the program displayed the tax allowances for Montana on the advices, although the paychecks did not display the tax allowances.

DanM-Oracle

1

Re: April 15 Quarterly patches - is Combo OJVM and DB Oracle 19.27

The combo patches are designed to make things easier, so if only one of the patches (the JVM) has been released you could already install that one, on condition it's Linux as there is no DB versus JVM dependency.

Mr. C

1

Tax Data Refresh Functionality

This new KM document explains the Tax Data Refresh functionality mentioned in the release note of Patch 37623069.

Doc ID 3090805.1. https://bit.ly/45nHn0T

Candiceg-Oracle

1

Re: UBE Performance Tuning

Hello,

I would recommend to open a service request. The assigned support engineer can then address your question to the development team. I believe that NER BF would be better although it is executed within UBE. Creating a NER BF will give you the ability to use the same NER in interactive applications or in other UBEs.

Thank you!

Best regards,
Cezar

CezarB-Oracle

1

Re: What table stores the installation details in R12.2.13?

Got it thanks appreciate it.

Justin Greene

1

Re: requesting for certified upgrade path for Source :- PT 8.59/HCM 9.1/Bundle 5 /DB 19c Target :- PT 8

Hi - Refer below

Step 1: Choose windows 2022 server and perform tools upgrade from 8.59 to 8.62.

Step 2: Perform Application upgrade from HCM 9.1 to HCM 9.2 Image 24 in 8.62 tools version

Step 3: Perform image upgrade from image 24 to 52.

Let us know if you have any questions.

-Velu

Velu Angusamy

1

Re: What table stores the installation details in R12.2.13?

Hi Justin,

Installation details are part of CSI (Install Base) and are stored in the T tables.

You can use the following queries based on sales order line id

SELECT *
FROM csi_t_transaction_lines
WHERE source_transaction_id = :order_line_id;
SELECT *
FROM csi_t_txn_line_details
WHERE transaction_line_id IN
(
SELECT transaction_line_id
FROM csi_t_transaction_lines
WHERE source_transaction_id = :order_line_id);

Thank You !!

Piyush-Oracle

1

Re: Can we upload attachments (drawings, images, pictures for example) with WIP_EAM_WORKREQUEST_PUB publ

Hi,

No, Work Requests or any other entity is not using the product specific API but the generic FND Attachments APIs.

You can import any attachment to any entity using the fnd_webattch.add_attachment API. For EAM Work Requests you need to use parameters like:
category_id => &category_id,
entity_name => 'EAM_WORK_REQUESTS',
pk1_value => &Work_request_id
pk2_value => NULL
pk3_value => NULL
pk4_value => NULL
pk5_value => NULL

For category_id you need to get it based on the category you need to be used (but also enabled for the Work Request function). By default we have the Miscellaneous and the Work Request Attachments document categories associated to the Work Requests. To get the category_id for them you can use query:

select category_id, name, user_name from fnd_doc_categories_active_vl where user_name in ('Miscellaneous','Work Request Attachments');

See examples to use the API in document:

How To Import Item Attachments Via API or Interface? (Doc ID 1516752.1)

Please note that this API is not fully supported as it is designed to be used by product integration rather than external use. See:

Where to Find Documentation on Using API FND_WEBATTACH? (Doc ID 2779851.1)

Best regards,
Florin

Florin Stefan-Oracle

1

Re: Running a second multitenant CDB instance on the same server

Hi

For 19c, you do not need to set any special or version-specific parameter just because you are starting a second CDB instance for RMAN duplicate. Focus on unique ORACLE_SID, db_unique_name, and file paths.

Thanks
Swati A

Swati Aryasomayajula -Oracle

1