Invoicing is Failing but Committed Transaction is not Rolling Back in Multi Schema (Doc ID 2654551.1)

Last updated on APRIL 23, 2024

Applies to:

Goal

Scenario:

• In the invoice policy fm_inv_pol_prep_invoice.c, one has done some customization to create a custom object using PCM_OP_CREATE_OBJ, for example, /my_custom_object.
• During invoicing, due to some issue there is an error and invoicing failed.
• This error is apparently because it is a multi schema setup and the account is in schema 1 while the invoice object is being stored in schema 2.
• But it is seen that the custom object /my_custom_object gets created and is not rolled back, so there is still an entry getting created in the associated table, which should not be the case.

Question:

How to overcome this situation, that is, how to be able to rollback the database updates done in the policy file fm_inv_pol_prep_invoice.c via PCM_OP_CREATE_OBJ?
 

Solution

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