My Oracle Support Banner

Error Reported While Calling the API MSC_ATP_PUB: ORA-00164: Distributed Autonomous Transaction Disallowed Within Migratable Distributed Transaction (Doc ID 3036731.1)

Last updated on JULY 30, 2024

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


While executing the API call to MSC_ATP_PUB, following error is reported in some environments:

ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction


The error is raised when the PL/SQL code calls from MSC_ATP_PUB in the ERP database to MSC_ATP_PVT in ASCP instance across the database link EBS_TO_APS.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.