Error Script Logic FXTrans

[Former Member]

Hi All,

Under script logic section under my application, I have maintain

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY_SET%','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

and added below it the following

*INCLUDE SYSTEM_CONSTANTS.LGL

*INCLUDE SYSTEM_LIBRARY.LGL

*SYSLIB MULTICURRENCYTRANS.LGF

I receive the following error, " Application: FINANCE

Logic file: FXTrans.LGF

Validation status of executable file: Failed

- missing file:D:\PC_MS\DATA\WebFolders\BSB\AdminApp\FINANCE\SYSTEM_LIBRARY.LGL

Validation status of syntax: Failed

- Invalid syntax found; see statements in red"

The Red ones are

- SYSTEM_LIBRARY.LGL

- MULTICURRENCYTRANS.LGF

Could anyone advise me how do go about on this

Thanks

Zan

[Former Member]

Hi,

How change them ? Their extension as mention from SYSLIB MULTICURRENCYTRANS.LGF

into *SYSLIB MULTICURRENCYTRANS.LGL

Please advise

Zan

[Former Member]

Hi,

I'd like to clarify first that SPRUNCONVERNSION and MULTICURRENCYTRANS.LGL do the same thing using different methods. The first requires you to maintain appropriate business rule table called Currency Conversion and the latter is Script Logic-based functinality. Typically you do not need to maintain bot as SPRUNCONVERSION is pretty robust and should fulfil all your needs unless you have to do some truly exotic variation of the business calculation.

So to conclude you probably only need the following in your script logic:

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY_SET%','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

*COMMIT

and also maintain rates in the rate application. Please refer to user guide section Business Rule Management for further details: [http://help.sap.com/saphelp_bpc75/helpdata/en/b1/f5839e6ba74a22aa4ce9470179c854/content.htm]

In order to use script logic you will need to write the logic yourself or to use the one supplied with the system (in the SYSTEM_LIBRARY).

The logic library is stored in the file on the server %APPSET%\System Library\Logic Library\SYSTEM_LIBRARY.LGL

IN your script logic you need to include the library to use in your logic:

*SYSLIB SYSTEM_LIBRARY.LGL (SYSLIB tells the system to look at the specific place in the appset folder and LGL is the extension for appset-level logic files)

After this you need to call appropriate subprogram from that library and pass some parameters to it:

RunFX(%APP%,%CATERGORY_SET%)

*COMMIT

for example.

Hope this helps,

Madis

[former_member186498]

Hello Zan,

the *SYSLIB refers to a specific folder "...Webfolders\<Appset>\SYSTEMLIBRARY\LOGIC LIBRARY" that I indicate before, where the system search the system files.

In this folder you will found the .LGL files that you indicate (not LGF), therefore you must substitute the extension of the MULTICURRENCYTRANS declaration in your script logic file.

Best regards

Roberto

[Former Member]

Hi Roberto, I am using BPC MS v 7.5.109 and cannot find any SYSTEM_LIBRARY.LGL file. I really need some functions there (specially ROLLTOBS and ACCUMULATE), however when I look for any .LGL file on the server I can only find Constants, MdxLib, System_Constants and Stored_procedure_wrapper. Could you help me distributing this file or giving me any advice of where to download it or include it during my installation? Thanks a lot, regards.

Ivan

[Former Member]

Hi Ivan,

Please find the attached file which comes from IFRS kit for BPC 7.0.

Hope this helps,

Madis

System_Library.txt.zip

[Former Member]

Thanks a lot Madis!

[former_member186498]

Hi Ivan,

normally this file is in the path I've given before, if you don't have it in your appset try looking in the same path in the APShell.

Kind regards

     Roberto

[former_member186498]

Hello Zan,

I think you must change the statement

*SYSLIB MULTICURRENCYTRANS.LGF

into *SYSLIB MULTICURRENCYTRANS.LGL

and check if in your ...Webfolders\<Appset>\SYSTEMLIBRARY\LOGIC LIBRARY are present the SYSTEM_LIBRARY.LGL and MULTICURRENCYTRANS.LGL files.

Best regards

Roberto

Edited by: Roberto Vidotti on Nov 22, 2011 4:55 PM