Blog – SyedSaadAli

Blog

August 1, 2017 ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files

APPS DBAErrors/Workarounds-ApplicationsErrors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle APPS DBAOracle Database Material

ERROR

ARC3: Error 19809 Creating archive log file to ‘+DISKS’

Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used,

and has 0 remaining bytes available.

SOLUTION

This problem normally occurs when our flash recovery area is full , we have two option to solve this problem:

1. Add size to flash_recovery_area if we have free disk space.

SQL> alter system set db_recovery_file_dest_size=5G;

2. Delete some archivelogs to free flash_recovery_area.

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

RMAN> delete obsolete;

August 1, 2017 Not showing Open Interface Tab in Cash Management Form

Cash ManagementErrors/Workarounds-CMOracle Functional

ERROR

Not showing Open Interface Tab in Cash Management Form For Matching Open interface transactions for reconciliation.

(more…)

August 1, 2017 This general ledger account is not authorized for use in Treasury

Errors/Workarounds-GLGeneral LedgerOracle Functional

ERROR

This general ledger account is not authorized for use in Treasury. Please authorize this general ledger account for use in Treasury by company: &COMPANY_NAME

(more…)

August 1, 2017 Error while running AR auto Invoice import program

Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

Error while running AR auto Invoice import program

arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

SOLUTION

Setup the Auto Accounting for all the Accounting Types.

NAVIGATE: Receivables -> Setup -> Transactions -> AutoAccounting

The minimum mandatory types are below:

1.FREIGHT
2.REC
3.REV
4.SUSPENSE (AutoInvoice Clearing)
5.TAX
6.UNBILL (Unbilled Receivable)
7.UNEARN (Unearned Revenue)

Use below script to identify the missing auto accounting types;

SELECT GL_DEFAULT_ID,

TYPE FROM RA_ACCOUNT_DEFAULTS_ALL

WHERE ORG_ID = &orgid

AND TYPE IN

(‘FREIGHT’, ‘REC’, ‘REV’, ‘SUSPENSE’, ‘TAX’, ‘UNBILL’, ‘UNEARN’);