View Accounting - Function Not Available

User is getting below error when trying to see View Accounting from Receiving Transactions summary form.


Navigation:
--------------
Receiving ----> view receiving transactions ---> select org xxx--->enter receipt number---->xxxxxxx---> Find ----> click on transactions
View accounting or view accounting events and observe reported error

See the following error:

function not available to this responsibilty or contact your system administrator

Searched on: "function not available" "Receiving Transactions Summary"

Found:

1. Receiving Transactions Summary - View Accounting - Function Not Available To This Responsibility ( Doc ID 865884.1 )


SYMPTOMS
-----------------
While attempting to view the accounting information from View Receiving Transactions of Inventory Receiving, the following error occurs:

Error:
--------
Function not available to this responsibility.Change responsibilities or contact your System Administrator

Steps to Reproduce:
-----------------------------
1.Open Inventory Responsibility
2.Receiving
3.View Receiving Transactions
4.Query the receipt number
5.Click Transactions
6.Click on Tools>View accounting
7. The above error is encountered.

CAUSE
----------
Function is not available for this responsibility.

SOLUTION
------------------
To implement the solution, please do the following steps :

1.Go to System Administrator Responsibility
2.Click Application/Menu
3.Query the menu = INV_NAVIGATE
4.Write down the submenu name = INV_TRANSACTIONS

5.Click Application/Menu
6.Query the menu = INV_TRANSACTIONS
7.Write down the submenu name = INV_RECEIVING

8.Click Application/Menu
9.query out Menu = INV_RECEIVING
10. Add a new entry:
Prompt = Accounting
Submenu = Accounting:
Function = Blank
Description = Blank

 
 

APP-OFA-48676

Error 
----------------------- 
APP-OFA-48676: You are attempting to overlap this amortization with a previous transaction. Proceed with this amortization? 

Problem Description 
---------------------------------------------------
When trying to change the date placed in service (DPIS) for a group asset in the addition period the following errors are received:


Problem Summary 
---------------------------------------------------
APP-OFA-48676


Solution from oracle SR
-----------------------

You said that you cannot change DPIS for a group asset in the addition period, but the asset trace uploaded is not for a group asset type (not even a member asset).
Also the addition period of that asset, Capitalized asset, is 736113 (30-Sep-16) and the current period is 736479 (1-Oct-17).
DPIS for asset number = 1000680 is 01-AUG-2008
Depreciation was run for the asset in case.
So, you cannot change the DPIS for the asset number = 1000680

Please review :
Oracle Assets User Guide Changing Financial and Depreciation Information (pag 3-7)

"Before running depreciation (in the period in which you added the asset), you can
change any field.

After you have run depreciation (in any period after the one in which you added the
asset), you can change asset cost, salvage value, prorate convention, depreciation
method, life, capacity and unit of measure (in the corporate book), rate, bonus rule,
depreciation ceiling, and revaluation ceiling."

As I said, after the Depreciation is run, the only fields that can be update are:
asset cost, salvage value, prorate convention, depreciation
method, life, capacity and unit of measure (in the corporate book), rate, bonus rule,
depreciation ceiling, and revaluation ceiling.

Setup RMAN backup in EBS R12.2.4 database

RMAN CONFIGURATION
==================


RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name JTCPROD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/JTCPROD/ora_prod/11204/dbs/snapcf_JTCPROD.f'; # default


CRON JOB FOR RMAN BACKUP
=======================


[oraprod@proddb122 ~]$ crontab -l

00 02 * * * /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.sh >> /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.log


( to edit $crontab -e , the above cron job will run daily at 2:00 am)


SCRIPT for level 0 full backup including archive and controlfile
============================================================

[oraprod@proddb122 ~]$ vi /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.sh

#!/bin/bash
ORACLE_HOME=/u01/JTCPROD/ora_prod/11204; export ORACLE_HOME
ORACLE_SID=JTCPROD; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
/u01/JTCPROD/ora_prod/11204/bin/rman  target / @'/u01/JTCPROD/ora_prod/scripts/rmanscript.sh'



[oraprod@proddb122 ~]$ vi /u01/JTCPROD/ora_prod/scripts/rmanscript.sh

run
{
backup incremental level 0 database format '/u01/BACKUP/RMANBKP/%d_DB_%T_%u_s%s_p%p';
sql 'alter system archive log current';
backup archivelog all format '/u01/BACKUP/RMANBKP/%d_ARCH_%T_%u_s%s_p%p';
backup current controlfile format '/u01/BACKUP/RMANBKP/control_%t.bak';


Compress the RMAN Backup and delete the obsolete backup and schedule it using cron job
=================================================================

[root@proddb122 TARRMANBKP]# crontab -l

30 02 * * * /u01/JTCPROD/ora_prod/scripts/tarbkp.sh >> /u01/JTCPROD/ora_prod/scripts/tarbkp.log


[root@proddb122 TARRMANBKP]# vi /u01/JTCPROD/ora_prod/scripts/tarbkp.sh


#Compress of backup files ###

echo "Timestamp : `date` :Backedup Database files compression in process ..."

tar -czvf /u01/BACKUP/RMANBKP/JTCPROD_Backup_`date +%d%m%Y`.tgz /u01/BACKUP/RMANBKP/*

echo "Timestamp : `date` :Backedup Database files compression completed successfully..."


echo "Timestamp : `date` :Copying tar file in process ..."

cp  -r /u01/BACKUP/RMANBKP/*.tgz /u01/BACKUP/TARRMANBKP # copying backup files from backup location to other directory

echo "Timestamp : `date` :Successfully copied tar files"

Removing tar and backup files to release space #######

echo "Timestamp : `date` :removing files from backup location in process ..."

rm -rf /u01/BACKUP/RMANBKP/*

echo "Timestamp : `date` :Successfully removed files from backup location"
~

Download EBS R12.2.7 Software from new oracle cloud website

Download R12.2.7

LOGIN  to https://edelivery.oracle.com

Type the required software in search tab and add to cart and click on select software

Just select all here, in the next page you can select the required packages to download

Select following packages to download.

DOCUMENTS FOR R12.2

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1).docx

R12.2 How To Create the Stage In Preparation For Installation (Doc ID 1596433.1).docx

Download EBS R12.1.1 software from new oracle cloud website

Download R12.1.1 

 LOGIN  to https://edelivery.oracle.com

Type the required software in search tab and add to cart and click on select software

 Just select all here , in the next page you can select the required packages to download

  

Select following packages to download.

Oracle E-Business Suite 12.1.1.0.0 for Linux x86-64

             

B53824-01_1of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 29.3 MB

B53824-01_3of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 393.1 MB

             

B53824-01_2of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 97.3 MB

             

B53824-01_4of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 81.6 MB

             

V15688-01_1of2.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 9, 1.6 GB

             

V15688-01_2of2.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 9, 1.1 GB

             

V15684-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 834.6 MB

             

V15684-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 1.4 GB

             

V15684-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 1.4 GB

             

V35224-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 1.2 GB

             

V35224-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 1.7 GB

             

V35224-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 762.8 MB

             

V15686-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 1.5 GB

             

V15686-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 541.1 MB

V15686-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 1.5 GB

V15691-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15691-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15691-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15681-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 1.5 GB

V15681-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 1.7 GB

             

V15681-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 508.8 MB

             

V15687-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 1.4 GB

             

V15687-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 1.5 GB

             

V15687-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 950.1 MB

             

V15690-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 283.1 MB

             

V15690-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 1.6 GB

             

V15690-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 1.6 GB

             

V15685-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.2 GB

             

V15685-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.3 GB

             

V15685-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.4 GB

             

V15689-01.zip Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Tools - Disk 1, 1.5 GB

             

V15683-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 1.5 GB

             

V15683-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 744.5 MB

             

V15683-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 1.5 GB

 V15682-01_3of3.zip   Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.0 GB

             

V15682-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.4 GB

             

V15682-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.3 GB

             

V15680-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 1.7 GB

             

V15680-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 1.4 GB

             

V15680-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 588.2 MB

DOCUMENTS FOR R12.1

=====================

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)

MD5 Checksums For R12.1.1 Rapid Install Media (Doc ID 802195.1)
R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

 Oracle E-Business Suite Release 12 Installation Guidelines (Doc ID 405565.1)

Oracle E-Business Suite Release 12 High Availability Documentation Roadmap (Doc ID 1072636.1)

Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0) [ID 735276.1].docx  -- to upgrade ebs r12 database.

Java heap Space error in Journal Entries report EBS R12.2.4

Java heap Space error in Journal Entries report EBS R12.2.4

Error:
-============================

Journal Entries report standard was completing with error.

Reason:
================================

java memory issue .

Solution:
=================================


a) checked the following patch is applied on EBS R12.2.4 environment.

SQL> select bug_number from ad_bugs where bug_number='20518047';

BUG_NUMBER
------------------------------
20518047

SQL> select BUG_ID from ad_bugs where bug_number='20518047';

    BUG_ID
----------
    495937




b) Check your heap , Are you using 32 bit or 64 bit JRE
See below KM doc:Sizing Business Intelligence Publisher Components To Handle Large Volumes of Data with E-Business Suite XML Publisher / BI Publisher ( Doc ID 1630732.1 )

SQL> select DEVELOPER_PARAMETERS from FND_CP_SERVICES
2 where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
3 where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

DEVELOPER_PARAMETERS
--------------------------------------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2560m

in my case, already the max heap size  is set to 2.5 GB


========================================================================


followed these steps to prevent JAVA Heap Space error:



1. in XML Publisher Administrator responsibility navigate to Administration > Configuration

- under : Properties -> General -> set a temporary directory

This directory should be at least 5 times larger than the largest anticipated data file.

Support recommends the directory to be at least 20GB.



2. in XML Publisher Administrator responsibility navigate to Data Definition

Although the scalable feature of the XSLT can be set at the Site level, it is recommended to enable it rather at the Data Definition level for those concurrent programs that are expected to produce large XML data files.

Navigation Path : XML Publisher Administrator responsibility

- query the data definition used by the report with large data

- on the View Data Definition page select Edit Configuration button

- set 'Use XML Publisher's XSLT processor' to True

- set 'Enable scalable feature of XSLT processor' to True

- set 'Enable XSLT runtime optimization' to True

Note that these property values, when set at the Data Definition level, takes precedence over values set at the Site level.



3. Then, in System Administrator resp, navigate to Profile > System

- set Concurrent:OPP Process Timeout = 43200 ( in my case , increased from 7200 to 43200)

- set Concurrent:OPP Response Timeout = 43200 ( in my case , increased from 7200 to 43200)

(these values are for 12 hours in seconds)


4. 1)Log into EBS
   2)Navigate following window.
     Responsibility: System Administrator
     N)Concurrent -> Program -> Define
    3)Search the following concurrent.

      Program : <Program name>
      Short Name : < program short name>

     Entry the following to Options of Executable region.

      -ms1024m -mx1024m

    Note : About specifying -ms and -mx ( -ms and -mx is same as -Xms -Xmx.)
          -Xms (-ms): initial heap size
          -Xmx (-mx): maximum heap size

in my case the value( -ms1024m -mx1024m ) worked for me.

Note : If this error still happens, you can use the following Option ins above Step4.
(a) -Xmx512m -Xss1024k
(b) -Xmx512m -Xss2048k
(c) -Xmx512m -Xss4096k
(d) -Xmx1024m -Xss1024k
(e) -Xmx1024m -Xss2048k
(f) -Xmx1024m -Xss4096k

-Xmx (-mx): maximum heap size
-Xss : Java stack size

5.bounced the concurrent manager ./adcmctl.sh stop/start


6. rerun the journal entries report now , completed normal successfully.

RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request

RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request in EBS R12.2.4

Error :
==============================================
In R12.2.4, User trying to do LOV from GL account forms using quick customer responsibility, and he was hit by below error.

From RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request

the request could not be understood by the server due to malformed
syntax. the client should not repeat the request without modification.

Followed the action plan from ERROR-400 Bad Request while Selecting LOV for GL Code Combinations ( Doc ID 2286951.1 ).

solution :
===============================================
[applprod@prodapp122 ~]$ cd $OA_HTML

[applprod@prodapp122 html]$ $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'frameRedirect.jsp' --flush
logfile set: /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
loading deplist...7829
enumerating jsps...7829
updating dependency...0
initializing compilation:
enumerating jsps...1
eliminating children...1 (-0)
translating and compiling:
translating jsps...1/1 in 28s
compiling jsps...1/1 in 4s
Finished!

[applprod@prodapp122 scripts]$ ./adadminsrvctl.sh stop

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Stopping WLS Admin Server...
Refer /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/JTCPROD/appl_prod/fs1/FMW_Home/user_projects/domains/EBS_domain_JTCPROD/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[applprod@prodapp122 scripts]$ ./adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/JTCPROD/appl_prod/fs1/FMW_Home/user_projects/domains/EBS_domain_JTCPROD/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for more information ...

and restest the issue with user , problem remain the same.

So , restarted all the application services, issue resolved.