Tag Archives: Journal Import

Setting Up Custom GL Menus and Functions

Posted by on July 23, 2007 No comments

Step 1: Navigate to Security > Responsibility > Request. Enter a new record with a new Group, Application, and Code. Then enter a new Request type.

Step 2: Next, navigate to Application > Function. Press F11 and search for CS%FND%. Locate CS_FNDRSRUN. Click the Form tab. Copy and paste the Parameters value to text file.

Step 3: Insert a new record in Form Functions named MFGL_FNDRSRUN. Paste the copied value into the Parameters field and modify the APPL_SHORT_NAME.

Step 4: Get menu name: GL_SUPERUSER

Navigate to Security > Responsibility > Define. Search for the custom responsibility by pressing F11 and entering the searching string, then press Ctrl+F11.

Step 5: Navigate to Application > Menu. We want to modify the Import Journals and review data Menu. Pull up GL_SUPERUSER menu and click View Tree. Navigate to Journals, then Import. Right-click and choose Properties. Alternatively, search for GL%IMPORT%.

Step 6: The GL_SU_J_IMPORT menu appears. Insert a new menu line together with its Prompt and Function Name. Then Save.

Journal Importing GL_INTERFACE Data

Posted by on October 10, 2006 No comments

This documentation shows how to load journals that were loaded into the GL_INTERFACE table.

Step 1:        Log on as a user with access to the GL responsibility and select the General Ledger Manager responsibility.

Step 2:        Navigate to Journals > Import > Run.

Step 3:        Enter the Source and Group ID. Select Without Validation.

Step 4:        Click Import.

Step 5:        To delete imported journals, navigate to Journals > Import > Delete.

Step 6:        Enter the Source, Request ID and Group ID.

The Request ID is that of the request used to import the journals (check View Requests to determine this ID).

Importing Data from GL Interface Table

Posted by on August 29, 2006 No comments

 Problem: After loading data into the GL_INTERFACE table, how is the data imported into the base tables?

Solution:

Step 1:        Log on to E-Business Suite and select the General Ledger Superuser responsibility.

Step 2:        Navigate to Journals, then Import and finally Run.

Step 3:        On the Import Journals form, enter the date range.

Enter data into the Source, Selection Criteria and Specific Value fields, and then click Import.

For example, ‘History’, ‘Selected Group ID’ and Value ‘1’.