Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit on Database

775371Aug 22 2019 — edited Feb 9 2021

Hi,

I have moved audit trails to new tablespaces and enabled audit trail parameter to DB, extended.

But while doing application (ERP- EBS R12.2) user is getting

ORA-02002 Error while writing to audit trail

ORA-22275 invalid LOB locator specified

I have verified space is there in tablesspace

Please suggest

Comments

Paavo

Hi

perhaps make additional column read_only for toggling read only which is computed based on various values of col1 ? I remember that I had challenges with IG read only settings if there are nulls in the read_only column, so it should be not_null. I am not near my app now, but will check.

rgrds Paavo

Sgodavar-Oracle

I'm not sure how to update that column, if i add another read-only column?. I should be able to select the "col2" and update, when it's not read-only (on change of col1).

Paavo

Hi

How about making app to apex.oracle.com with your requirement ?

rgrds Paavo

Veerendra Patil
Answer

Hi,

Can you use Disable Column col2 on DA

Suppose col1 has 2 values in LOV - 1,2.

On selecting value 1 in col1 - col2 should be disabled,

On selecting value 2 in col1 - col2 should be enabled to select values.

Create a DA on change on col1- as below

1.png

1.png

Create the opposite Action as Enable.

Hope this suits.

Thanks,
Veerendra.

Marked as Answer by Sgodavar-Oracle · Sep 27 2020
1 - 4

Post Details

Added on Aug 22 2019
3 comments
78 views