On-Premises Oracle E-Business Suite (EBS) Integration
These are theTask Manager Integrations for EBS Event Monitoring:
- EBSJournalApprove
- EBSJournalPost
- EBSJournalPeriodClose
- EBSJournalPeriodOpen
- EBSJournalPeriodReopen
- EBSAPJournalPeriodOpenClose
These are the events that can be monitored:
Table 13-20 Oracle E-Business Suite Events and Descriptions
Integration Name | Event Name | Description |
---|---|---|
Journal Approve Event |
oracle.apps.gl.Journals.journal.approve |
General Ledger: Journal Approved |
Journal Post Event |
oracle.apps.gl.Journals.journal.post |
General Ledger: Posting Completed |
Journal Period Close Event |
oracle.apps.gl.CloseProcess.period.close |
General Ledger: Period Closed |
Journal Period Open Event |
oracle.apps.gl.CloseProcess.period.open |
General Ledger: Period Opened |
Journal Period Reopen Event |
oracle.apps.gl.CloseProcess.period.reopen |
General Ledger: Period Reopened |
Payables Period Open/Close Event |
oracle.apps.ap.CloseProcess.period |
Accounts Payables: Period Open/Close/Reopen |
Table 13-21 General Ledger Journals Integration Type Parameters
Name | Type | Required | Order | Hidden |
---|---|---|---|---|
Batch ID | Text | Yes | 1 | N |
Table 13-22 General Ledger Close Process Period Integration Types Parameters
Name | Type | Required | Order | Hidden |
---|---|---|---|---|
LedgerID | Text | Yes | 1 | N |
PeriodName | Text | Yes | 2 | N |
Table 13-23 Accounts Payable Integration Types Parameters
Name | Type | Required | Order | Hidden |
---|---|---|---|---|
LedgerID | Text | Yes | 1 | N |
PeriodName | Text | Yes | 2 | N |
Action | Static List | Yes | 3 | N |
Verifying Results by Raising Business Events
Once you have configured the EBS Business event system to subscribe to the required events, you can verify your results by raising business events. The following sections describe how to run the EBS tasks that raise the events you track.
General Ledger - Journal Approved
oracle.apps.gl.Journals.journal.approve
EBS Steps
-
Log on to EBS.
-
Select General Ledger, and then the Vision Operations (USA) role from the left tree.
-
Select Journals, and then Enter and wait for Oracle Applications to start.
-
Click No for the "Find records in this folder?" message.
-
On the Find Journals screen, click New Batch.
Window (Vision Operation (USA)) displays.
-
In Batch, enter a unique batch name.
Note:
When you click Save, the cursor needs to be inside the Batch field.
-
Select File and then click Save to save the batch.
Note:
When you save, the cursor needs to be inside the Batch field. -
Click OK for the "Please enter one or more Journals" message.
-
Click Journals.
-
Enter a unique name in Journal field.
-
Provide Line entries starting with Line 1. Provide debit and credit values for the accounts.
-
After you finish entering the line values, move the cursor into the Journal field.
-
Navigate to the File menu and click New.
-
Click Yes for "Do you want to save the changes you made?" message.
Note:
By clicking Yes, you will be able to add multiple Journal entries into the Batch.
After you finish the journal entries for the last Journal, move the cursor into the Journal field.
-
Select File and then click Save to save the last journal entry.
-
Focus on the Batch (Vision Operation (USA) and select Batch field.
-
Click Help and select Diagnostics, and then Examine.
-
Enter Oracle password:APPS.
-
In Field, enter JE_BATCH_ID and click inside Value to get the unique Journal batch ID. For example,
- Block: BATCH
- Field: JE_BATCH_ID
- Value: 4776732
Copy this value to Notepad. This batch ID will be used as the value for the
Batch ID
parameter of the Event Monitoring task.
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for event monitoring task to monitor Journal Approve Event (
oracle.apps.gl.Journals.journal.approve
). -
On the Parameters tab, provide a value for Batch ID as the journal batch ID from EBS.
-
Save the task and set the schedule to Open state.
Next Steps in EBS
-
On Batch (Vision Operation (USA), the Approve button is now enabled for the specified batch.
-
Click Approve to raise the journal approval event.
Next Steps in Task Manager
-
Wait for the task to be set to Open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Refer to this document for further information on Journal Batch Approval related information: http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/gl/journa09.htm#t_ja_submit
General Ledger - Journal Post Event
oracle.apps.gl.Journals.journal.post
EBS steps
-
Log on to EBS.
-
Select General Ledger, and then the Vision Operations (USA) role from the left tree.
-
Select Journals, and then Enter and wait for Oracle Applications to start.
-
Click No for the "Find records in this folder?" message.
-
On the Find Journals screen, click New Batch.
Window (Vision Operation (USA) displays.
-
In Batch, enter a unique batch name.
Note:
When you click Save, the cursor needs to be inside the Batch field.
-
Select File and then click Save to save the batch.
Note:
When you save, the cursor needs to be inside the Batch field. -
Click OK for the "Please enter one or more Journals" message.
-
Click Journals.
-
Enter a unique name in the Journal field.
-
Provide Line entries starting with Line 1. Provide debit and credit values for the accounts.
-
After you finish entering the line values, move the cursor into the Journal field.
-
Navigate to File and then click New.
-
Click Yes for "Do you want to save the changes you made?" message.
Note:
By clicking Yes, you will be able to add multiple Journal entries into the Batch.
After you finish the journal entries for the last Journal, move the cursor into the Journal field.
-
Select File and then click Save to save the last journal entry.
-
Focus on the Batch (Vision Operation (USA) and select the Batch field.
-
Click Help and select Diagnostics, and then Examine.
-
Enter Oracle password: APPS.
-
In Field, enter JE_BATCH_ID and click inside Value to get the unique Journal batch ID. For example,
- Block: BATCH
- Field: JE_BATCH_ID
- Value: 4776732
Copy this value to Notepad. This batch ID will be used as the value for the
Batch ID
parameter of the Event Monitoring task.
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for event monitoring task to monitor Journal Approve Event
(oracle.apps.gl.Journals.journal.post
). -
On the Parameters tab, provide a value for Batch ID as the journal batch ID from EBS.
-
Save task and set the schedule to Open state.
Next Steps in EBS
-
On the Batch (Vision Operation (USA), the Approve button is now enabled for the specified batch.
-
Click Post to raise the journal approval event.
-
Examine the status of EBS request by selecting the View, then Requests, then Specific Requests.
-
Specify the Request ID that was noted earlier.
Next Steps in Task Manager
-
Wait for the task to be set to Open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Refer to this document for further information on Journal Batch Post related information: http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/gl/conten07.htm#w_conts_post
General Ledger - Journal Period Close
oracle.apps.gl.CloseProcess.period.close
EBS Steps
-
Log on to EBS.
-
Select General Ledger, and then the Vision Operations (USA) role from the left tree.
-
Select Open/Close, and then Enter and wait for Oracle Applications to start.
The Find Periods dialog displays.
-
Click Find. The Open and Close Period dialog displays.
- From the list of displayed periods, choose which one you want to close.
- Select the Status column for that period.
- Click Status Options. The status list box opens.
- Select the Closed status and click OK. Then note the period in Notepad.
-
To save the status, select File and then click Save.
- Select the Status column for that period.
-
Click Help and select Diagnostics, and then Examine.
-
Enter Oracle password: APPS.
-
In Field, enter LEDGER_ID and click inside Valueto get the unique Ledger ID. For example,
- Block:
PREVIOUS
- Field:
LEDGER_ID
- Value:
1
Copy this value to Notepad. This Ledger ID will be used as the value for the
LEDGER_ID
parameter of the Event Monitoring task. - Block:
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for event monitoring task to monitor Journal Close Event (
oracle.apps.gl.CloseProcess.period.close
). -
On the Parameters tab, provide a value for Ledger ID and Period Name from EBS. For example: Period Name: Dec-10 and Ledger ID: 1
-
Save the task and set the schedule to Open state.
Next Steps in EBS
-
Close the Open and Close Period dialog.
-
Click OK in the Submit Request Node message box.
- Examine the status of EBS request by selecting View, then Requests, and then Specific Requests.
Next Steps in Task Manager
-
Wait for the task to be set to Open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Refer to this document for more information on General Ledger Periods:
http://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/openper.htm
General Ledger - Journal Period Open
oracle.apps.gl.CloseProcess.period.open
EBS Steps
-
Log on to EBS.
-
Select General Ledger, and then the Vision Operations (USA) role from the left tree.
-
Select Open/Close, and then Enter and wait for Oracle Applications to start.
The Find Periods dialog displays.
-
Click Find. The Open and Close Period dialog displays.
- From the list of displayed periods, choose which one you want to open.
-
Copy the period you want to open in Notepad.
- Select the Status column for that period.
-
Click Help and select Diagnostics, and then Examine.
-
Enter Oracle password:APPS.
-
In Field, enter LEDGER_ID and click inside Value to get the unique Ledger ID. For example,
- Block:
PREVIOUS
- Field:
LEDGER_ID
- Value:
1
Copy this value to Notepad. This Ledger ID will be used as the value for the
LEDGER_ID
parameter of the Event Monitoring task. - Block:
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for an event monitoring task to monitor Journal Period Open Event (
oracle.apps.gl.CloseProcess.period.open
). -
On the Parameters tab, provide a value for Ledger ID and Period Name from EBS. For example: Period Name: Dec-10 and Ledger ID: 1
-
Save the task and set the schedule to Open state.
Next Steps in EBS
-
Click Open Period.
-
Select the period to open and click OK to raise the event.
- Examine the status of EBS request by selecting View, then Requests, and then Specific Requests.
Next Steps in Task Manager
-
Wait for the task to be set to open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Refer to this document for more information on General Ledger Periods:
http://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/openper.htm
General Ledger - Journal Period Reopen
oracle.apps.gl.CloseProcess.period.reopen
EBS Steps
-
Log on to EBS.
-
Select General Ledger, and then theVision Operations (USA) role from the left tree.
-
Select Open/Close, and then Enter and wait for Oracle Applications to start.
The Find Periods dialog displays.
-
Click Find. The Open and Close Period dialog displays.
- From the list of displayed periods, choose which one you want to reopen.
-
Copy the period you want to reopen in Notepad.
- Select the Status column for that period.
-
Click Help and select Diagnostics, and then Examine.
-
Enter Oracle password:APPS.
-
In Field, enter LEDGER_ID and click inside Value to get the unique Ledger ID. For example,
- Block:
PREVIOUS
- Field:
LEDGER_ID
- Value:
1
Copy this value to Notepad. This Ledger ID will be used as the value for the
LEDGER_ID
parameter of the Event Monitoring task. - Block:
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for an event monitoring task to monitor Journal Period Reopen Event (
oracle.apps.gl.CloseProcess.period.reopen
). -
On the Parameters tab, provide a value for Ledger ID and Period Name from EBS. For example: Period Name: Dec-10 and Ledger ID: 1
-
Save task and set the schedule to Open state.
Next Steps in EBS
-
Click Open Period.
-
Select the closed period to open and click OK to raise the event.
- Examine the status of EBS request by selecting View, then Requests, and then Specific Requests.
Next Steps in Task Manager
-
Wait for the task to be set to Open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Refer to this document for more information on General Ledger Periods:
http://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/openper.htm
Account Payables Period Open/Close
oracle.apps.ap.CloseProcess.period
EBS Steps
-
Log on to EBS.
-
Expand Payables, and then the Vision Operations (USA) role from the left tree.
- Expand Accounting, and select Control Payables Periods. This launches the Control Payables Periods form.
- Specify the Ledger and Operation Unit. Do not close the Find Payables Periods dialog. Instead, perform the following steps to identify the Ledger ID value.
-
Click Help and select Diagnostics, and then Examine.
-
If requested for credentials, specify the APPS schema credentials. The Examine Fields and Variable Values form displays.
-
In Block, enter PERIOD_QF. In Field, enter SET OF BOOKS, and click inside Value, to get the unique Ledger ID numeric value. For example,
- Block:
PERIOD_QF
- Field:
SET OF BOOKS
- Value:
1
Copy this value to Notepad. This Ledger ID will be used as the value for the
LEDGER_ID
parameter of the Event Monitoring task. - Block:
Next Steps in Task Manager
-
Create a new Schedule in Pending state.
-
Create a task for an event monitoring task to monitor Payables Period Open/Close Event (
oracle.apps.ap.CloseProcess.period
). -
On the Parameters tab, provide a value for Ledger ID, Period Name and Action from EBS. For example, Ledger ID: 1, Period Name: Dec-10 and Action: Closed
-
Save the task and set the schedule to Open state.
Next Steps in EBS
-
Find the period in EBS Control Payables Periods.
-
Click on Period Status column for that period.
- In Control Statuses form, select the appropriate status.
- Select File, and then Save to raise the event.
Next Steps in Task Manager
-
Wait for the task to be set to Open state. It takes a few minutes to capture the EBS event.
-
After 2-3 minutes, click Refresh in Task Manager.
Note:
The EBS implementation raises the events only for Closed and Open statuses. Permanently Closed status will not raise any event.https://docs.oracle.com/cd/A60725_05/html/comnls/us/ap/ctlperst.htm