Extension Flex Fields - RODS data extract failure

This article explains how to fix data extraction errors for Fulfill Lines Extension Flex Fields (EFF) in Oracle.

Typically, EFF extraction errors happen because the relevant business view or flex field hasn't been deployed yet.

Step 1: Identifying the Issue

You observe that the RODS data extract job has failed.

Check the corresponding ESS job request and confirm it failed as well.

Open the child request output file to inspect the failure. You will see a status of "failed" along with an error message similar to this:

Error processing extract: "DOO_FULFILL_LINES_EFF_B_BackorderExtract_1783432279245. advancedQueryExtraction: An error occurred while processing request.. Details: Request refers to a BOSS artifact that doesn't exist. Name: oraScmCoreOrderMgmtOrders.ora_..., Type: Business Object.oracle.boss.batch.BatchException: advancedQueryExtraction: An error occurred while processing request.",

Step 2: Checking the Extract Definition

Go to the extract definition and edit it.

Try to select attributes with in any of the object contexts.

You may see a "failed to load attributes" error in the object attributes selection.

Step 3: Resolving the Issue

This issue usually occurs because the flex fields are not deployed for RODS data extraction.

To resolve it, enable and deploy the Extension Flex Fields business views for RODS data extraction. Follow the detailed steps in this guide:

After deploying the flex fields, you should be able to view and select the EFF business views in your data extracts.

Read More »

Deploy Pre-built OCI Function & Configure Event Rule

This article details the process for deploying a pre-built OCI Function and configuring an OCI Event Rule to trigger it automatically.

1. Log In to Oracle Cloud 

Go to cloud.oracle.com, enter your Cloud Account Name, and click Next. Then, enter your username and password to log in.

2. Navigate to Pre-Built Functions

Open the main navigation menu, go to Developer Services, locate Functions, and click Pre-Built Functions.

3. Select the Function Template

Find and select the Object Storage File Extractor pre-built function card, then click Create function.

4. Configure Function Details

Enter a unique Name for your function, select the appropriate Application compartment and Application, and then click Create.

5. Review Dynamic Group and IAM Policies 

If automatic IAM policy creation is enabled, OCI will automatically create the required dynamic group and assign the policies (provided you have sufficient permissions). If you lack administrative rights, work with your administrator to set up the dynamic group and assign policies manually.

6. Verify Function Creation

Navigate to your selected Application to verify that the function appears in the list and shows an Active status.

7. Navigate to OCI Events Service

Open the main menu, navigate to Observability & Management, and select Rules under the Events Service section.

8. Define Rule Conditions

Click Create rule. Enter a Display name and Description. Under Rule conditions, set the following parameters: 

• Condition: Event type | Service name: Object Storage | Event type: Object - Create

• Condition: Attribute | Attribute name: resourceName | Attribute value: *.zip

• Condition: Attribute | Attribute name: bucketName | Attribute value:  STAGE_RODS

9. Set Action and Create Rule

In the Actions section, select Functions as the Action type. Choose the target Function compartment, Function application, and Function. Click Create rule. Once configured, the function will execute automatically whenever a new ZIP file is uploaded to the specified bucket.

Read More »

Oracle PLSQL buffer overflow error

Usually this error occurs when the total amount of text sent to DBMS_OUTPUT has exceeded the default limit of 20,000 bytes.

We can resolve this error by enabling the server output before executing PL/SQL objects.

SET SERVEROUTPUT ON SIZE UNLIMITED;

Read More »

Deploy Oracle AI Agent for end users

This aricle details the steps involved in creating a Guided Journey for an AI Agent, assigning it to the properties of a Redwood page using Visual Builder Studio (VBS), and deploying it for end users.

1. Navigate to My Client Groups à Show More à Journeys Setup à Guided Journey

2. Click on Create to start a new Guided Journey

3. Create a Draft by entering the Name and Code for the Journey

4. Add tasks to the Journey

Enter the task name, set the task type to Agent, Agent type to Workflow Agent and select the desired AI Agent to deploy for end users.

5. Activate the Guided Journey

Verify the status of the newly created Guided Journey changes to Active.

 

6. Navigate to Order Management à Order Management (New) (Redwood Page)

7. Navigate to Settings & Actions à Administration à Edit page in Visual Builder Studio

8. Select the appropriate extension project.

9. Assign the newly created Guided Journey code to the “Journey Code” page property.

10. Preview the application in Visual Builder Studio, verify the appearance of the “Ask Oracle” button with the Agent Name and publish the changes.

11. Click “Ask Oracle” to open the AI Agent chatbot panel and inquire about order details by providing an order number.

12. Inquire about the order lines details for the same order number.

Read More »

Create Business Object to create Sales Order via Oracle AI Agent

Navigation: Menu --> Tools --> AI Agent Studio --> Business Object

Click on the Add button to start creating Business Object.

Fill out the following details.

• Family: SCM
• Product: Order Management
• Name: HP Create Sales Order
• Code: Populates automatically
• Resource type: Monolith
• Resource Path: Populates automatically
• Description: Provide an understandable description

Scroll down and click on + plus button to add the business function.

Add the correct resource path "/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub" and set operation type to "POST" in Business Object Function.

Toggle the native authentication header and provide the payload as follows or as required.

{

  "SourceTransactionSystem": "PS",

  "SourceTransactionId": "{p_SourceTransactionId}",

  "SourceTransactionNumber": "{p_SourceTransactionNumber}",

  "TransactionalCurrencyCode": "USD",

  "BusinessUnitId": 300000001921096,

  "BuyingPartyNumber": "{p_BuyingPartyNumber}",

  "TransactionTypeCode": "REGULAR",

  "RequestedShipDate": "{p_RequestedShipDate}",

  "SubmittedFlag": false,

  "FreezePriceFlag": false,

  "FreezeShippingChargeFlag": false, 

  "FreezeTaxFlag": false,

  "RequestingBusinessUnitId": 300000001921096,

  "CustomerPONumber": "{p_CustomerPONumber}",

  "billToCustomer": [

    {

      "CustomerAccountId": {p_CustomerAccountId},

      "SiteUseId": {p_SiteUseId}

    }

  ],

  "shipToCustomer": [

    {

      "PartyId": {p_PartyId},

      "SiteId": {p_SiteId}

    }

  ],

  "lines": {p_Lines}

}

Add a Header with content type set to application/json. The parameters will auto populte based on defined payload inputs.

Add an example payload; This helps AI agent understand and map the fields as required.

All set;  just save your progress, use the business object within the Oracle AI agent and ensure that you map the payload parameters correctly in the prompt.

Read More »

Enable Business Objects for Order EFF tables in Oracle RODS Data Extraction

By default the Extension Flex Field Business Objects are not enabled in the Oracle RODS, New data extraction tool. We need to deploy the flex fields and publish them to enable them.

 Go to Setup and Maintenance

Search for the task Manage Order Extensible Flexfields.

Search for the Flexfield Code DOO_FULFILL_LINES_ADD_INFO and deploy it (Deploy Offline).

Navigate to Tools > Scheduled Processes.

Submit a new process named Publish Extensible Flexfield Attributes.

Ensure that the process completes Successfully.

Review the log and output files to verify there are no errors during the flexfield publishing process.

You should now be able to view the EFF business objects in RODS.

Read More »