Home » Applications » Oracle Fusion Apps & E-Business Suite » FRM-40200:Field is protected against update during enable auditing (R 12.0.3, AIX 5.3)
FRM-40200:Field is protected against update during enable auditing [message #473709] Tue, 31 August 2010 05:26 Go to next message
userpat
Messages: 5
Registered: August 2010
Location: Saudi
Junior Member
Hi,

When i am trying to add a new column and trying(navigation-system Administrator>audit trail->table) to click checkbox with already configured audit table it giving error "FRM-40200-Field is protected against update" at the bottom of the form.kindly suggest me.

Thanks
Re: FRM-40200:Field is protected against update [message #473739 is a reply to message #473709] Tue, 31 August 2010 09:25 Go to previous messageGo to next message
Alien
Messages: 282
Registered: June 1999
Senior Member
Hi,

the checkbox is for the primary key. This is automatically set when the column you add is part of the primary key. (As defined in the table form in application developer).

Regards,

Arian
Re: FRM-40200:Field is protected against update [message #474035 is a reply to message #473739] Thu, 02 September 2010 03:04 Go to previous messageGo to next message
userpat
Messages: 5
Registered: August 2010
Location: Saudi
Junior Member
Thanks for replying.

Is this valid only for primary key?
Re: FRM-40200:Field is protected against update [message #474042 is a reply to message #474035] Thu, 02 September 2010 04:28 Go to previous messageGo to next message
Alien
Messages: 282
Registered: June 1999
Senior Member
yes.

regards,

Arian
Re: FRM-40200:Field is protected against update [message #474269 is a reply to message #474042] Sat, 04 September 2010 05:42 Go to previous messageGo to next message
userpat
Messages: 5
Registered: August 2010
Location: Saudi
Junior Member
Thank you.

whenever submit "AuditTrail Update Tables" request it completed with error.Find below some lines of log file.

INSERT INTO PAY_ELEMENT_ENTRY_VALUES_A
VALUES(SYSDATE,'I',NUSER,NULL,USERENV('SESSIONID'),NXT,CMT,ROWKEY,E0,E1,E2,NULL);
execute IMMEDIATE 'alter session set nls_date_format="'||nls_date_fmt||'"';

END PAY_ELEMENT_ENTRY_VALUES_AIP;

Fatal error in fdasql, quitting...
ORA-24344: success with compilation error
Fatal error in fdactr, quitting...
Fatal error in fdactr, quitting...
commit

commit

----->Delete Invalid Columns
----->Drop Triggers
DROP TRIGGER GL_LEDGERS_AI
DROP TRIGGER GL_LEDGERS_AI
ORA-04080: trigger 'GL_LEDGERS_AI' does not exist
DROP PROCEDURE GL_LEDGERS_AIP
DROP PROCEDURE GL_LEDGERS_AIP
ORA-04043: object GL_LEDGERS_AIP does not exist
DROP TRIGGER GL_LEDGERS_AD
DROP TRIGGER GL_LEDGERS_AD
ORA-04080: trigger 'GL_LEDGERS_AD' does not exist
DROP PROCEDURE GL_LEDGERS_ADP
DROP PROCEDURE GL_LEDGERS_ADP
ORA-04043: object GL_LEDGERS_ADP does not exist
DROP TRIGGER GL_LEDGERS_AU
DROP TRIGGER GL_LEDGERS_AU
ORA-04080: trigger 'GL_LEDGERS_AU' does not exist
DROP PROCEDURE GL_LEDGERS_AUP
DROP PROCEDURE GL_LEDGERS_AUP
ORA-04043: object GL_LEDGERS_AUP does not exist
DROP TRIGGER GL_LEDGERS_AC
DROP TRIGGER GL_LEDGERS_AC
ORA-04080: trigger 'GL_LEDGERS_AC' does not exist
DROP TRIGGER GL_LEDGERS_AH
DROP TRIGGER GL_LEDGERS_AH
ORA-04080: trigger 'GL_LEDGERS_AH' does not exist
DROP TRIGGER GL_LEDGERS_AT
DROP TRIGGER GL_LEDGERS_AT
ORA-04080: trigger 'GL_LEDGERS_AT' does not exist
Cause: Table name is GL_LEDGERS_A.
APP-FND-00016: No primary key information exists for table , audit table not made.

Action: Define primary key information for table. Auditing cannot occur on tables without primary keys.
Fatal error in fdagcn, quitting...
Fatal error in fdadv, quitting...
Fatal error in fdadic, quitting...

Kindly suggest me.

Regards
Re: FRM-40200:Field is protected against update [message #474281 is a reply to message #474269] Sat, 04 September 2010 11:38 Go to previous messageGo to next message
Alien
Messages: 282
Registered: June 1999
Senior Member
Hi,

it seems you're missing the primary key on 'GL_LEDGERS'. Navigate to Application Developer:/Application/Database/Table.

Query GL_LEDGERS, go to 'Primary Keys' and enter a row with 'LEDGER_ID'. Then save and retry.


Regards,

Arian
Re: FRM-40200:Field is protected against update [message #474312 is a reply to message #474281] Sun, 05 September 2010 04:12 Go to previous messageGo to next message
userpat
Messages: 5
Registered: August 2010
Location: Saudi
Junior Member
Hi,

As you said to perform That row is already there.

Find below the value While click 'Primary Keys'

Name GL_LEDGERS_PK

Type Surrogate Description No REMARK column in CI_CONSTRAINTS

Seq Name

1 LEDGER_ID

suggest me.

Many Thanks,
Re: FRM-40200:Field is protected against update [message #474325 is a reply to message #474312] Sun, 05 September 2010 11:59 Go to previous message
Alien
Messages: 282
Registered: June 1999
Senior Member
Hi,

ok. Can you check if you enabled audittrail for the GL-user?
/Security/Audittrail/Install and query username 'GL'.

I assumed it was enabled. But just found a bug that it might give the same error.

Regards,

Arian
Previous Topic: E business suite query
Next Topic: User Survey about Cost Effectiveness of Large ERP systems and Outsourcing
Goto Forum:
  


Current Time: Thu Sep 16 20:22:09 CDT 2021