Audittrail Update Tables Error
Needed - System Administrator 1. Define audit Group Navigation - Security->Audit Trail->Groups Enter Application Name fatal error in afuddl quitting and Tables What need to be Audit and Save the change fatal error in fdacts quitting Note: When you first create the audit group the group status will be'Enable Requested'this will automatically fatal error in fdasql quitting be changed to'Enabled'once theAuditTrail Update Tables concurrent request is run(Step 5) 2.Define Which columns to be audited Navigation - Security->Audit Trail->Tables 3. Enable auditing for schema owners Navigation - Security->Audit Trail->Install 4. Enable ‘AuditTrail Activate' profile option 5.Submit the 'AuditTrail Update Tables' concurrent request Solution for AuditTrail Update Tables program error on R12 While runningAuditTrail Update Tablesconcurrent request It's completed with Error. To fix the issue Check if you have enabled auditing for APPLSYS,APPS and the application schema owner you want to audit, if not enable the auditing for the schema you wish to audit. Then change the group statue for the Audit Group AP_SYSTEM_PARAMETERS_ALL to disable - purge table and run the concurrent request'AuditTrail Update Tables' again. Posted by Mohamed Bishrul Hussain at 10:41 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Blog Archive ► 2016 (13) ► September (1) ► August (2) ► July (1) ► June (3) ► May (3) ► March (2) ► January (1) ► 2015 (28) ► December (1) ► November (3) ► October (3) ► July (2) ► June (3) ► May (1) ► April (1) ► March (3) ► February (4) ► January (7) ▼ 2014 (24) ▼ December (4) Step by Step RMAN Restoration in R12 Enable Audit Trail and Resolve Fatal e
Packages Oracle Fusion ApplicationsOracle EBS R12Oracle Fusion MiddlewareCore Oracle TechnologyOracle Banking & Billing ManagementBuy Certification Mock ExamsFusionFusion Financials Latest ArticlesOracle Fusion Applications Training IndexOracle Fusion HCMFusion CRMFusion Procure To PayFusion PayRollOTBIADF TrainingBPELAPEX-Oracle Application ExpressWeblogic ServerOracle Data IntegratorOBIAOBIEEOESOracle Identity and Access ManagementOFSAA http://mohamedbh.blogspot.com/2014/12/enable-audit-trail-and-resolve-fatal.html - Oracle Financial Services Analytical ApplicationsR12Common Apps Training ArticlesiProcurementOracle GrantsFinancial ModulesSupply Chain & ManufacturingR12 11i DifferencesFinancials DocumentsAME and Self Service HRMSFinancial Functional DocumentsReceivablesGeneral LedgerOracle HRMS Payroll MigrationHRMS MiscellaneousOracle PayrollOracle HRMS Payroll Training IndexSolutionsOracle Workflows Training IndexOther http://apps2fusion.com/apps/apps/65-audit-trail-in-oracle-apps-ebs R12 ArticlesOA Framework Training IndexOracle ScriptsGeneral Apps TopicsOracle Apps Interview QuestionsVirtual MachinesSOA SuiteApps DBABI Publisher - XMLPMobile Supply Chain Application FrameworkBlogsJayashree PrakashAshish HarbhajankaSurinder SinghKrishnakumar ShanmugamTrending AuthorsPrasad ParmeswaranKalimuthu VellaichamyKishore RyaliSivakumar GanesanSenthilkumar ShanmugamPrasad BhoglePrabhakar SomanathanArun SistaRanu SrivastavaRathan KinhalAhmad BilalTheTechnoSpiderAnshuman GhoshContact UsSupport TicketHRMS - Payroll Functional TrainingOA Framework TrainingOracle BPEL Development Training Miscellaneous Register Login HomeTrainingsOracle TrainingOpen SourceBig Data TrainingsSAP TrainingTraining ScheduleTestimonialsOur BooksCloud Software TrainingService Now SalesforceSelf PacedCertificationData WarehousingForumRetail Training ForumCorporate Training ForumBuy Training PackagesBuy NowBuy TrainingOracle TrainingsOracle Fusion ApplicationsOracle EBS R12Oracle Fusion MiddlewareCore Oracle TechnologyOracle Banking & Billing ManagementBuy Certification Mock ExamsFusionFusion ApplicationsOracle Fusion FinancialsFusion Financials Latest ArticlesOracle Fusion Applications Training IndexOracle Fusion HCMFusion CRMFusion Proc
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. https://community.oracle.com/thread/2563640 Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General EBS Discussion All PlacesOracle ApplicationsE-Business SuiteE-Business Suite http://www.orafaq.com/forum/t/161197/ TechnologyGeneral EBS Discussion This discussion is archived 3 Replies Latest reply on Jul 25, 2013 12:39 PM by Asif Muhammad AuditTrail Update Tables does not create views and ends fatal error in error user558306 Jul 25, 2013 11:54 AM Good DayI am having trouble with the below issue when creating an audit on a custom table. I have read the posts on the forums and on metalink, however my problem still persists.RDBMS : 11.1.0.7.0Oracle Applications : 11.5.10.2Here are the steps taken to create this audit1. Created a custom table XXAIPH_TRD_CUST_WHOSALE fatal error in with Primary key XXAIPH_TRD_CUST_WHOSALE_ID, under APPS.2. Registered the table as below:DECLARE CURSOR c1 IS SELECT column_name ,table_name ,column_id ,data_type ,data_length ,nullable FROM dba_tab_columns WHERE table_name = 'XXAIPH_CUST_PROVISIONS' ORDER BY column_id; r1 c1%ROWTYPE;BEGIN ad_dd.delete_table('APPLSYS', 'XXAIPH_CUST_PROVISIONS'); ad_dd.register_table('APPLSYS', 'XXAIPH_CUST_PROVISIONS', 'T'); FOR r1 IN c1 LOOP ad_dd.register_column('APPLSYS' ,r1.table_name ,r1.column_name ,r1.column_id ,r1.data_type ,r1.data_length ,r1.nullable ,'N'); dbms_output.put_line(r1.column_name || ' registered.'); END LOOP; ad_dd.register_primary_key('APPLSYS' ,'XXAIPH_CUST_PROVISIONS_PK' ,'XXAIPH_CUST_PROVISIONS' ,'XXAIPH_CUST_PROVISIONS' ,'S' ,'Y' ,'Y'); ad_dd.register_primary_key_column('APPLSYS' ,'XXAIPH_CUST_PROVISIONS_PK' ,'XXAIPH_CUST_PROVISIONS' ,'XXAIPH_CUST_PROVISIONS_ID' ,1); COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; END;3.Enable the application to be audited 4.Create the Audit Group and include the tables to be audited with the columns5. Run the "AuditTrail Update Tables" concurrent program and it yields the error below. I have read almost every post or thread to resolve this and I am still battling. Please come to my aid...FNDATUPD module: AuditTrail Update Tables+---------------------------------------------------------------------------+Current system time is 25-JUL-2013 10:07:54+---------------------------------------------------------------------------+----->Expand RowscommitDELETE FROM FND_AUDIT_TABLES WHER
:: Message Navigator E-mail to friend FRM-40200:Field is protected against update during enable auditing [message #473709] Tue, 31 August 2010 05:26 userpat Messages: 5Registered: 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 Report message to a moderator Re: FRM-40200:Field is protected against update [message #473739 is a reply to message #473709] Tue, 31 August 2010 09:25 Alien Messages: 245Registered: 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 Report message to a moderator Re: FRM-40200:Field is protected against update [message #474035 is a reply to message #473739] Thu, 02 September 2010 03:04 userpat Messages: 5Registered: August 2010 Location: Saudi Junior Member Thanks for replying. Is this valid only for primary key? Report message to a moderator Re: FRM-40200:Field is protected against update [message #474042 is a reply to message #474035] Thu, 02 September 2010 04:28 Alien Messages: 245Registered: June 1999 Senior Member yes. regards, Arian Report message to a moderator Re: FRM-40200:Field is protected against update [message #474269 is a reply to message #474042] Sat, 04 September 2010 05:42 userpat Messages: 5Registered: 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