Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, December 8, 2016

Oracle General Ledger Test Details

Script: StpSrc - Setup to check Approval
Responsibility: General Ledger, Vision Operations (USA)
Task: Ensure that the Manual Journal Source does not require approval.
Actions:
1.         Navigate: Setup/Journal/Sources
2.         Query the Journal Sources by selecting View/Query By Example/Enter
3.         Enter:
Description: Manual Journal Entry
4.         Execute Query by selecting View/Query By Example/Run
5.         Verify if parameter Require Journal Approval is checked.
If Require Journal Approval is checked, deselect. Otherwise leave it as is.
6.         Save the change by selecting File/Save from the pull down menu
7.         Select File/Close Form from the pull down menu to close the Journal Sources form.

Verifications:
1.         The Journal Sources form is displayed when View/Query By Example/Enter.
2.         Source: Manual is displayed
3.         Journal Sources form is displayed with Source: Manual
4.         Journal Sources form closes and return to the Navigator form.
5.         _____ mark if changes have been made.

Script: JrlEnt - Enter Batch and corresponding Journals
Responsibility: General Ledger, Vision Operations (USA)
Task: Enter Journal Entries
Actions:
1.         If pop up list reads “Document”, change to “Functions
2.         Navigate: Journals/Enter
3.         Click New Batch button.
4.         Enter:
Batch Name: <B><initial><date>-01
Accounting Period: Mar-99 or any open period ___________
Description (optional)
5.         Click Journals button
6.         Enter:
Journal Name: <J><initial><date> -01
Category: Additions
Description: optional
7.         Enter Line number: Line: 10
Account: 01-000-1560-0000-000
Debit (USD): 500.34
Line: 20
Account: 01-000-1110-0000-000
Credit (USD): 500.34
8.         Click the Other Information sub tab
9.         Enter:
Reference: Manual Journal Batch
10.       Click SAVE icon
11.       Place the cursor in the journal field (if not default) and down arrow to enter next journal line.

Task: Add a second journal line from above
Actions:
1.         Click on Lines sub tab
2.         Enter:
Journal Name: J<initial><date> -02
Category: Additions
Description: optional
3.         Enter Line number: Line: 10
Account: 01-000-1210-0000-000
Debit (USD): 3490.99
Account: 01-000-1110-0000-000
Credit (USD): 3490.99
4.         Click on Other Information sub tab Enter:
Reference: Manual Journal Batch
5.         Save the Journal Batch by selecting File/Save and Proceed from the pull down menu
6.         Close the Journal form by selecting File/Close Form from the pull down menu

Verifications:
1.         Find Journals Form is displayed when View/Query By Example/Enter.
2.         Batch Form is displayed
3.         Record Batch Name:____________________
4.         Journals Form is displayed
5.         Verify: Balance: Actual Currency: USD
Accounting Period - (from above)
6.         Record Journal Name:____________________
7.         Two ways of entering account:
1.         Account alias (If you know which account alias to use)
2.         Press <Enter> at the Account alias edit field to bring up the Operations Accounting Flex
8.         Get: FRM 40400 Transaction complete: 4 records applied and saved.
9.         Journals form is cleared
10.       Verify: Balance: Actual Currency: USD

Accounting Period - (from above)
11.       Record Journal Name:____________________
12.       Two ways of entering account:
1.         Account alias (If you know which account alias to use)
2.         Hit <Enter> at the Account alias edit field to bring up the Operations Accounting Flex
13.       Get: FRM 40400 Transaction complete: 4 records applied an saved.
14.       Journal is saved, the and focus is returned to the Journals form and the Journal form is cleared ready for user to enter a new journal
15.       Journals form closes and returns to the Navigator form.

Script: JrlPst - Post a Journal
Responsibility: General Ledger, Vision Operations (USA)
Task: Post a Journal
Actions:
1.         Navigate: Journal/Post
2.         Enter the following search criteria in the Find Journal Batch Window: Period: Current Period
Batch: <B><initial><date>-01
3.         Activate the Find button in the Find Journal Batch Window.
4.         Check the radio box on the left most column of first line in the Post Journal Window.
5.         Activate the Post button in the Post Journal Window.
6.         Click the OK button on Note window.
7.         Select View/Requests from the menu bar of the Post Journal Window.
8.         Check radio button for Specific Requests and input request ID for above at the Request ID field of the Find Requests Window.
9.         Click Find.
10.       Close the Requests form.
11.       Close all forms.

Verifications:
1.         Find Journal Batches form opens when Navigate: Journal/Post.
2.         Post Journals window opens when Activate the Find button. Verify the following: Period: Current period
Batch: <B><initial><date>-01 (from above)
Balance Type: Actual
Debit: 3991.33
Credit: 3991.33

Batch Information region:
Post Status: Postable
Batch Status: Unposted
3.         Entire line is highlighted when check the radio box.
4.         Note window comes up with the following message when Activate the Post button: Your concurrent request ID is XXXXXXX
5.         Find Journal Batches form back in focus when click the OK button on Note window.
6.         Find Requests form appears when Select View/Requests.
7.         Request form opens up when click the Find button. Verify process Posting Single Ledger has phase of Complete and status of Normal. Click the Refresh Data button if phase is Running.
8.         Find Journal Batches form back in focus when close the Requests form.
9.         Navigator back in focus when close all forms.

Script: RevJrnEntPst - Reverse Journals
Responsibility: General Ledger, Vision Operations (USA)
Task: Query Journal Entry and Reverse 1 of 2 Journals with Predefined Periods Actions:
1.         Navigate: Journals/Enter
2.         Find the Journal Batch from previous step.
3.         Enter Batch Name from above.
4.         Click Find button.
5.         Select the first journal line (J<initial><date> -01) and press the Review Journal button.
6.         Click Reverse Find.
7.         Select the open period to reverse, then click OK.
8.         Click OK.
9.         Close the Journals form by selecting File/Close Form from the pull down menu.
10.       Select View/Requests from the menu bar.
11.       Check radio button for Specific Requests and input request ID for above at the Request ID field.
12.       Click Find.
13.       Query for the above reversed batch.

Verifications:
1.         Find Journals form is displayed when click Find button.
2.         Enter Journals form is displayed with the two Journals created from previous step
3.         With predefined periods, default reverse period is used.
4.         Note form is displayed:
Record Concurrent ID:____________________
5.         Note form closes and returns to the Journals form
6.         Journals form closes and returns to the Navigator form
7.         Find Requests form opens.
8.         Request form opens up. Verify process Reverse Journals. has phase of Complete and status of Normal.
9.         Click the Refresh Data button if phase is Running.
10.       Verify the correct batch is retrieved.

Responsibility: General Ledger, Vision Operations (USA)
Task: Post a Journal Batch
Actions:
1.         Navigate: Journals/Post.
2.         Query and Find the Journal Batch.
3.         Enter Batch Name (%Rev%Request ID%) from above and press the Find button.
4.         Select the line for posting.
5.         Click Post button.
6.         Click OK button in the Note message box.
7.         Select View/Requests
8.         Select Specific Requests and enter the Post Concurrent ID from above.
9.         Click Find. The Posting request is completed with a Normal status
10.       Verify the report by clicking the View Output button to view the report
11.       Select File/Close Form to close the Report form.
12.       Select File/Close Form to close the Requests form.
13.       Selecting File/Close Form to close the Find Journal Batches form.

Verifications:
1.         Find Journal Batches form is displayed when Query and Find the Journal Batch. The Post Journals form is displayed with your journal batch.
2.         The selected batch is highlighted in blue when select the line for posting.
3.         Note message box is displayed when click Post button.:
Your Posting Concurrent request ID is :_____________________
4.         Focus returns to the Find Journal Batches form when click OK button to the Note message box.
5.         Find Requests form is displayed when click Find button. Requests form is displayed with your request.
6.         The Posting Execution Report is displayed.
7.         Report form closes and returns to the Requests form when select File/Close Form.
8.         Requests form closes and returns to the Find Journal Batches form when select File/Close Form.
9.         Find Journal Batches form closes and returns to the Navigator form when select File/Close Form.

Responsibility: General Ledger, Vision Operations (USA)
Task: Find Journal Batch to review the Batch Status
Actions:
1.         Navigate: Journals/Enter
2.         Query and Find the Journal Batch.
3.         Enter Batch Name from above
4.         Click Find.
5.         Select File/Close Form to close the Enter Journals form.

Verifications:
1.         The Find Journals form is displayed when Click Find button. The Enter Journals form is displayed with the two journals entered in the previous step and their status: Posted
2.         Enter Journals form closes and returns to the Navigator form when Select File/Close.

Script: ReStpSrc - Reset the Source setting to original env setting
Responsibility: General Ledger, Vision Operations (USA)
Task: Return journal approval option to its original stage.
Actions:
1.         Navigate: Setup/Journal/Sources
Note: This step is required if changes have been made previously on the Journal Sources form. Otherwise, this step can be skipped.
2.         Select View/Query By Example/Enter to query the Journal Sources.
3.         Enter:
Description: Manual Journal Entry
4.         Select View/Query By Example/Run to execute the Query.

Verifications:
1.         Journal Sources form is displayed when select View/Query By Example/Enter.
2.         Journal Sources form is displayed when select View/Query By Example/Run.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect