| FRM-40200:Field is protected against update during enable auditing [message #473709] |
Tue, 31 August 2010 05:26  |
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 #474269 is a reply to message #474042] |
Sat, 04 September 2010 05:42  |
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 #474312 is a reply to message #474281] |
Sun, 05 September 2010 04:12 |
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,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
