EBS specific process definitions
This process is used to configure the Oracle based Redwood Finance Automation solution.
- FCA_EBS_FND_ATTACH_DOCUMENT - Attach an external Document in Oracle EBS
- FCA_EBS_FND_CHART_OF_ACCOUNTS_MAINTENANCE - General Ledger Chart of Accounts Maintenance
- FCA_EBS_FND_FDFCHY - Compile value set hierarchies
- FCA_EBS_FND_SHORTHAND_FLEX_ALIAS - Add or update an Alias for an Key Flex Field
- FCA_EBS_FND_UPLOAD_FILE - Upload an external Document into Oracle EBS database
- FCA_EBS_GL_INTERFACE_INSERT - Insert rows into table GL_INTERFACE
- FCA_EBS_SQLGL_GET_REFERENCE_IDS - Get the batch and header ID that belongs to the current journal import
- FCA_EBS_SQLGL_GLPPOSS - Post Single Ledger
- FCA_EBS_WorkFlow_AcceptReject - Workflow with Accept/Reject
- FCA_EBS_WorkFlow_Confirm - Workflow for confirm
- FCA_EBS_WorkFlow_RestartContinueAbort - Workflow with Restart/Continue/Abort
FCA_EBS_Configuration
No Configure Redwood Finance Automation™ for EBS
FCA_EBS_FND_ATTACH_DOCUMENT
Attach an external Document in Oracle EBS
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| P_FILE_NAME | File name | In | String |
| P_MEDIA_ID | Media ID | In | String |
| _formName | Attach to Form | In | String |
| P_DATA_OBJECT_TYPE | Data Object Type | In | String |
| P_DATA_OBJECT_ID | Data Object ID | In | String |
| P_CATEGORY_ID | Category | In | String |
| P_SECURITY_TYPE | Security Type | In | String |
| P_PK1_COLUMN | Primary Column Key 1 | In | String |
| P_PK2_COLUMN | Primary Column Key 2 | In | String |
| P_PK3_COLUMN | Primary Column Key 3 | In | String |
| P_PK4_COLUMN | Primary Column Key 4 | In | String |
| P_PK5_COLUMN | Primary Column Key 5 | In | String |
FCA_EBS_FND_CHART_OF_ACCOUNTS_MAINTENANCE
General Ledger Chart of Accounts Maintenance
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| P_Application | Application | In | String |
| P_Title | Title | In | String |
| P_Structure | Structure | In | String |
| P_Segment | Segment | In | String |
| P_Value | Value | In | String |
| P_Description | Description | In | String |
FCA_EBS_FND_FDFCHY
Compile value set hierarchies
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| FlexValueSetId | FLEX value set ID of General Ledger | In | String |
FCA_EBS_FND_SHORTHAND_FLEX_ALIAS
Add or update an Alias for an Key Flex Field
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System Name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| P_ApplicationId | Application | In | String |
| P_IDFlexCode | Title | In | String |
| P_IDFlexNum | Structure | In | String |
| P_AliasName | Alias Name | In | String |
| P_AliasDescription | Alias Description | In | String |
| P_ConcatenatedSegment | Concatenated Segment | In | String |
FCA_EBS_FND_UPLOAD_FILE
Upload an external Document into Oracle EBS database
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_UserName | Database UserName | In | String |
| OraApps_Database | Database Name | In | String |
| OraApps_Password | Password | In | String |
| P_FILE_NAME | File name | In | String |
| P_MEDIA_ID | Media ID | Out | String |
FCA_EBS_GL_INTERFACE_INSERT
Insert rows into table GL_INTERFACE
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System Name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| TableName | Table name | In | String |
| ParametersToInsert | Parameters to insert | In | String |
FCA_EBS_SQLGL_GET_REFERENCE_IDS
Get the batch and header ID that belongs to the current journal import
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| P_REFERNCEID | Reference ID | In | String |
| P_PK1_COLUMN | Primary Column Key 1 | Out | String |
| P_PK2_COLUMN | Primary Column Key 2 | Out | String |
FCA_EBS_SQLGL_GLPPOSS
Post Single Ledger
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| OraApps_ResponsibilityName | Responsibility name | In | String |
| LedgerId | Ledger ID | In | String |
| AccessSetId | Set ID of the Asset profile | In | String |
| Chart Of Accounts ID | COA ID | In | String |
| Posting Run ID | Id of the posting run | In | String |
| OraApps_PrinterStyle | Printer Style | In | String |
| OraApps_PrinterName | Printer Name | In | String |
| OraApps_NumberOfCopies | Number of Copies | In | Number |
| _userExit | Specific PL/SQL script to execute | In | String |
FCA_EBS_WorkFlow_AcceptReject
Workflow with Accept/Reject
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| MX_To | List with TO: Userids or email addresses | In Out | String |
| MX_Cc | List with CC: userid's or email addresses | In Out | String |
| UserMessage_SelectedAction | User message action to perform | Out | String |
| UserMessage_Participants | Participant Users | In | String |
| MX_BCc | List with BCC: userid's or email addresses | In Out | String |
| UserMessage_Comment | Comment specified on the user message | Out | String |
| UserMessage_Roles | Participant Roles | In | String |
| MX_ReplyTo | Reply-To: userid or email address | In Out | String |
| UserMessage_Attach | Attach notification? | In | String |
| OVERRIDE_MX_TO_MAIL_ADRESSES | Override To email adresses | In | String |
| MX_Subject | Mail Subject | In Out | String |
| MX_Urgent | Raise/Lower importance of mail | In Out | String |
| Mail_Attachments | Mail Attachments | In Out | String |
| MX_Body | Mail Body reference (Document ID) | In Out | String |
| MX_Text | Mail Text (Document ID or plain text) | In Out | String |
| MergeRecord | Result list for table display | In Out | String |
| RecordColumnList | List with columns for result list table | In Out | String |
| Message1 | 1st Message | In Out | String |
| Message2 | 2nd Message | In Out | String |
| Message3 | 3rd Message | In Out | String |
| Message4 | 4th Message | In Out | String |
| Message5 | 5th Message | In Out | String |
| IN_UM_TEXT | User message short text | In | String |
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| rMail_Subject | Mail Subject | In | String |
| rMail_Cc | Mail CC addresses | In | String |
| rMail_ReplyTo | Reply To address | In | String |
| rMail_HTML | HTML result mail | In | String |
| _SYSTEMID | System ID of FCA | In | String |
| rInbox_HTML | HTML result for display in the Inbox | In | String |
FCA_EBS_WorkFlow_Confirm
Workflow for confirm
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| MX_To | List with TO: Userids or email addresses | In Out | String |
| MX_Cc | List with CC: userid's or email addresses | In Out | String |
| UserMessage_SelectedAction | User message action to perform | Out | String |
| UserMessage_Participants | Participant Users | In | String |
| MX_BCc | List with BCC: userid's or email addresses | In Out | String |
| UserMessage_Comment | Comment specified on the user message | Out | String |
| UserMessage_Roles | Participant Roles | In | String |
| MX_ReplyTo | Reply-To: userid or email address | In Out | String |
| UserMessage_Attach | Attach notification? | In | String |
| OVERRIDE_MX_TO_MAIL_ADRESSES | Override To email adresses | In | String |
| MX_Subject | Mail Subject | In Out | String |
| MX_Urgent | Raise/Lower importance of mail | In Out | String |
| Mail_Attachments | Mail Attachments | In Out | String |
| MX_Body | Mail Body reference (Document ID) | In Out | String |
| MX_Text | Mail Text (Document ID or plain text) | In Out | String |
| IN_UM_TEXT | User message short text | In | String |
| MergeRecord | Result list for table display | In Out | String |
| RecordColumnList | List with columns for result list table | In Out | String |
| Message1 | 1st Message | In Out | String |
| Message2 | 2nd Message | In Out | String |
| Message3 | 3rd Message | In Out | String |
| Message4 | 4th Message | In Out | String |
| Message5 | 5th Message | In Out | String |
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| rMail_Subject | Mail Subject | In | String |
| rMail_Cc | Mail CC addresses | In | String |
| rMail_ReplyTo | Reply To address | In | String |
| rMail_HTML | HTML result mail | In | String |
| _SYSTEMID | System ID of FCA | In | String |
| rInbox_HTML | HTML result for display in the Inbox | In | String |
FCA_EBS_WorkFlow_RestartContinueAbort
Workflow with Restart/Continue/Abort
Parameters
| Name | Description | Direction | Data Type |
|---|---|---|---|
| MX_To | List with TO: Userids or email addresses | In Out | String |
| MX_Cc | List with CC: userid's or email addresses | In Out | String |
| UserMessage_SelectedAction | User message action to perform | Out | String |
| UserMessage_Participants | Participant Users | In | String |
| MX_BCc | List with BCC: userid's or email addresses | In Out | String |
| UserMessage_Comment | Comment specified on the user message | Out | String |
| UserMessage_Roles | Participant Roles | In | String |
| MX_ReplyTo | Reply-To: userid or email address | In Out | String |
| UserMessage_Attach | Attach notification? | In | String |
| OVERRIDE_MX_TO_MAIL_ADRESSES | Override To email adresses | In | String |
| MX_Subject | Mail Subject | In Out | String |
| MX_Urgent | Raise/Lower importance of mail | In Out | String |
| Mail_Attachments | Mail Attachments | In Out | String |
| MX_Body | Mail Body reference (Document ID) | In Out | String |
| MX_Text | Mail Text (Document ID or plain text) | In Out | String |
| MergeRecord | Result list for table display | In Out | String |
| RecordColumnList | List with columns for result list table | In Out | String |
| Message1 | 1st Message | In Out | String |
| Message2 | 2nd Message | In Out | String |
| Message3 | 3rd Message | In Out | String |
| Message4 | 4th Message | In Out | String |
| Message5 | 5th Message | In Out | String |
| IN_UM_TEXT | User message short text | In | String |
| IN_RESTART_STEP | Restart Option GoTo Step | In | String |
| IN_CONTINUE_STEP | Continue Option GoTo Step | In | String |
| IN_ABORT_STEP | Abort Option GoTo Step | In | String |
| OraApps_SystemName | Applications System name | In | String |
| OraApps_UserName | User name | In | String |
| rMail_Subject | Mail Subject | In | String |
| rMail_Cc | Mail CC addresses | In | String |
| rMail_ReplyTo | Reply To address | In | String |
| rMail_HTML | HTML result mail | In | String |
| _SYSTEMID | System ID of FCA | In | String |
| rInbox_HTML | HTML result for display in the Inbox | In | String |
financeTopic