Customizing LCT File: Concurrent Program download LCT File(afcpprog.lct)

Usually we do not require ALL the Concurrent Programs for a Custom schema to be downloaded to an LCT File unless it’s an initial CUSTOM Object migration (or) Data reconciliation (or) Mass update of some fields.

The FNDLOAD Command SYNTAX to download the Program is as below
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXXYY_TEST_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXXYY" CONCURRENT_PROGRAM_NAME="XXXYY_TEST_PRG"


This would download a specific concurrent program and does the job, and I believe an human error can cause a misery to the case if any of the parameters say for ex:CONCURRENT_PROGRAM_NAME is misspell or an underscore missing. Let’s assume the same command as below replacing CONCURRENT_PROGRAM_NAME with CONCURRENT_PROGRAM_NAME1. The FNDLOAD command ignores the second parameter and fetches the complete Application level Programs to an LDT File.

FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXXYY_TEST_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXXYY" CONCURRENT_PROGRAM_NAME="XXXYY_TEST_PRG"

Sometimes this discrepancy can be identified/caught by opening the file, File size, doing tests in the test environment and these can still be missed at a crucial time causing haywire

And also Suppose there are only 2-5 Concurrent Programs then those 2-5 Concurrent Programs will be downloaded instead of a particular program causing you to believe the size of the file.

To avoid this, the customized the LCT File to download the Program only if CONCURTRENT_PROGRAM_NAME parameter is provided. This goes to the underlying Logic in the LCT File where it considers NULL Application names and NULL Concurrent Program names. Deleting the respective Clauses in the SQL Statements should do the trick for you.

CUSTOM LCT File Upload

Print This Post

FND-CP-ESP: Child: exec:: No such file or directory

There could be 2 reasons this error could arise,

1. No Proper Symbolic link created or
    To resolve this create a Symbolic Link as below, without the file extension

    ln –s $FND_TOP/bin/fndcpesr $XXXX_TOP/bin/XXXXXXX

    XXXX – Custom TOP Name
    XXXXXXX – Executable name of the Program

2. The PROG File that’s created might have accidentally converted to DOS due to File Copy Mode.
 
    To resolve this, Convert the File to UNIX fileformat as below,
    dos2unix <FileName>.txt

Print This Post

SQL Tuning Advisor

The SQL Tuning Advisor analyses high-volume SQL statements and offers tuning recommendations. The SQL Tuning Advisor provides advice in the form of precise SQL actions for tuning the SQL statements along with their expected performance benefits.

Open a New SQL Worksheet and prepare the SQL for which you want to run the SQL Tuning Advisor for and Press Ctrl + F12 or the icon

The output would be as below with the recommendations,

Statistics: In this analysis, objects with stale or missing statistics are identified and appropriate recommendations are made to remedy the problem.

SQL Profile: In this section,  SQL Tuning advisor recommends to improve the execution plan by the generation of a SQL Profile, which is the optimized plan to be used for that SQL

Indexes: This recommends whether the SQL statement might benefit from an index. If necessary, new indexes that can significantly enhance query performances are identified and recommended.

Restructure SQL:  In this analysis, relevant suggestions are made to restructure the selected SQL statements for improved performance.

In order to run the SQL Tuning advisor, user needs to have ‘ADVISOR’ and ADMINISTER SQL TUNING SET privilege.


Print This Post