Post date: Oct 08, 2015 7:49:13 AM
Analyzers are designed by Support to proactively assist you to better diagnose and maintain your Oracle Application environments. We welcome and encourage you to share your feedback via the EBS Oracle Receivables Period Close Analyzer in the My Oracle Support Oracle Receivables Community. Your feedback shapes the content of existing Analyzers and drives creation of new Analyzers.
The EBS Oracle Receivables Period Close Analyzer is a self-service health-check script that reviews Oracle Receivables related data, analyzes current configurations and settings for the environment and provides feedback and recommendations on best practices. Analyzers may also be used as data collection tools by Support Engineers. Your application data is not altered in any way when you run this analyzer.
NOTE: This is a non-invasive script - the Analyzer does not perform any INSERTs, UPDATEs or DELETEs to your data; it just reports on it.
The Analyzer identifies known issues and provides solutions and recommended actions to be performed for the specific instance it was run on and can be run at any time.
For production instances, you should first apply any recommended actions or solutions to a recent clone to ensure an expected outcome.
Audience
DBAs and System Administrators - run the script and review the output
Product Specialists and Business Analysts - review the output
Other interested parties/end users - review output to resolve identified opportunity improvement areas
Benefits
Immediate analysis and output of EBS Oracle Receivables Period Close data from a particular environment
Identifies
Receivables system setup and configurations
Common data integrity issues across Receivables Transactions and Receipts tables
Provides recommended actions and best practices
Runs as a standalone or Concurrent Request
Download the latest EBS Oracle Receivables Period Close Analyzer version (200.1)
New for Sysadmins/DBA’s! EBS Analyzer Bundle Menu Tool Doc ID 1939637.1 to provision and maintain all your analyzers. Analyzer Bundle Menu Tool is a perl menu system to easily execute, update and install analyzers as concurrent programs/assign to request groups.
Since Analyzers are regularly updated to include newly identified issues and solutions, we highly recommend always using the latest version. To verify the version of a previously downloaded Analyzer:
Execute the Analyzer via SQL script or concurrent request and review the Execution Details section in the generated output HTML file.
Alternatively, you can find the Analyzer version information in the
Header section of the PL/SQL script file (ar_periodclose_analyzer.sql)
Report Executable Package ar_periodclose_analyzer_pkg
You can also run the following in SQL:
select name, text from DBA_SOURCE
where name = 'AR_PERIODCLOSE_ANALYZER_PKG'
and text like '%$Id%';
p_org_id: (Required) Enter Organization ID
p_period_name: (Required) Enter the period name
Run the script ar_periodclose_analyzer.sql as user APPS to create the package definition. This is required each time you download a new version of the script:
sqlplus apps/<apps_password>
SQL> @ar_periodclose_analyzer.sql
The EBS Oracle Receivables Period Close Analyzer can either be run as a Concurrent Request or via SQL*Plus. Instructions for both options are listed below:
Running the Analyzer as a Concurrent Request allows functional users to run the Analyzer without needing the APPS user password.
Install the package using the SQL*Plus commands above.
After running the SQL*Plus commands above, define a new Concurrent Program using the FNDLOAD utility.
$ $FND_TOP/bin/FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct arperanl.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE
Add the new concurrent program = Period Close Analyzer to the Receivables All Request Group.
$ $FND_TOP/bin/FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct arperanl_rg.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE
The above commands create the concurrent program definition and registers it, so you can run it from the application.
To run the analyzer:
Responsibility: Receivables Manager
Navigation: View > Requests
Submit a New Request > Single Request > Receivables Period Close Analyzer
Enter the required parameters:
Operating Unit: (Required) Enter Organization ID
Period Name: (Required) Enter the Period Name
Then click on Submit.
Log into SQL*Plus as the APPS user, SPOOL a meaningful output file name and run the script. The following is an example, replace parameter values with your values.
$ sqlplus apps/<apps_password>
begin
ar_periodclose_analyzer.pkg.main(
p_org_id => 204,
p_period_name => 'Jan-15');
end;
Run the wrapper provided in the attached .zip file: ar_periodclose_analyze.sql, and provide the input parameters as requested.