Table of Contents

Getting Started - Introduction/Overview

Unlock the Admin Panel

Complete Connection Setup

Set Up BI Reports using Excel

Add Environments using Mobile App

Set Up BI Reports using Mobile App

Set Up Roles and Privileges

Complete User Registration

  1. Get User Registration Lookup Type
  2. Complete Users Registration

Transactional Mobile App Setup

  1. Configure app fields
    - Available fields in Transactional apps
    - Preferences
    - Defaulting field values
  2. Setup FieldsSetupVersion preference

You are now ready to use the Mobile app!

Getting Started - Introduction/Overview

Simplified Loader offers two ranges of the mobile app: Transactional and Dashboard. The Transactional range includes apps that enable users to complete real-time transactions from their mobile, whereas the Dashboard app allows them to view and drill down on data stored in Oracle Fusion.

Simplified Loader offers two methods to set up a mobile app. These methods vary based on setup for a subscribed app vs trial mode.

 

1. Configuration steps for the subscribed app using the Company Code and Passcode: Setup performed using this method allows the user to control users and app behaviour centrally. To complete setup using Company Code and Passcode, you will need an Excel template corresponding to the mobile app Excel. Please follow the steps below to complete setup using Company Code and Passcode. It is recommended that the steps are carried out in the order presented.

Step 1. Unlock the Admin Panel (Step performed using corresponding Excel template)

Step 2. Complete Connection Setup (Step performed using corresponding Excel template)

Step 3. Set Up BI Reports using Excel (Step performed using corresponding Excel template)

Step 4. Set Up Roles and Privileges

Step 5. Complete User Registration

 

2. Configuration steps for the trial version using Oracle Fusion URL: Using this method, the user can perform all setup steps from within the mobile app. The pre-requite to set up the mobile app using this method are login credential with access to BI Administration role.

Step 1. Add Environments using Mobile App

Step 2. Set Up BI Reports using Mobile App

Step 3. Set Up Roles and Privileges

Unlock the Admin Panel

Step performed using corresponding Excel template.

The first step in setting up a Simplified Loader Template is to unlock the Admin Panel, located in the Setup section of the Simplified Loader toolbar.

The Admin Panel contains a number of the operations required to set up the Template. These operations are password protected as they need to be completed by the user responsible for the initial set up of the Template and therefore should not be available for modification by day-to-day users.

1. Navigate to the Simplified Loader Admin Panel button in the Setup section of the Simplified Loader toolbar.

2. By default, the Admin Panel is protected by a password.

The Admin Password is required to make any updates to either the Admin Panel or the About worksheet.

The default password is admin. To change the password, enter the current password and new password and then click the Change Password button.

3. To use the features available in the Admin Panel, unlock the Template by entering the Current Password and click the Unlock Template button.

After unlocking the Template, the user receives the following message

Clicking OK on this window will close the message and the Admin Panel.

4. Click on the Admin Panel menu option again to reopen. This will enable all options available to use. If required, changes can now be made to the About sheet. Once the Template is unlocked, it remains unlocked for the session.

5. Whenever the Admin Panel has been unlocked, closing the Template will result in the following message.

This is a reminder to the administrator that they need to save the file to ensure that the Admin Panel is locked before exiting the Template.

Click OK to make the window disappear. The following message will then appear.

6. Click on the Save button before exiting the Template.

Complete Connection Setup

Step performed using corresponding Excel template.

Simplified Loader templates exchange data with Oracle Fusion. The method used by Excel to do so can differ from one PC to another. The Simplified Loader Connection Wizard helps identify the appropriate configuration for the Simplified Loader template to ensure a seamless data exchange with the Oracle Fusion applications. Follow the steps below to locate and store the appropriate connection setting within the Simplified Loader template:

1. Click on User Preferences in the Setup section of the Simplified Loader toolbar to open the User Setup panel

2. In the Connection Setup section of the User Preferences panel, select an Oracle Fusion environment from the Environment URL drop-down list and click the Launch Connection Wizard button. This will start the connection wizard to identify the best connection method to connect to the selected environment.

3. To test connectivity, Connection Wizard will attempt to connect to the selected environment. The test is performed without a username and password. Therefore, it is likely that a pop-up message (screenshot below) will appear asking for a username and password. If this happens, it means that the Template received a successful response from Fusion. Acknowledge the message by clicking the Cancel button.

4. When Connection Wizard finds an appropriate connection type, it displays one of the following messages. Click OK to complete the Connection Setup step.


Set Up BI Reports using Excel

Step performed using corresponding Excel template.

Simplified Loader templates use BI Reports to retrieve data from Oracle Fusion. BI Reports need to be set up once for each mobile app for each environment. Only users that have been allocated the BI Administrator role can complete the BI Report setup.

1. Navigate to Admin Panel

2. Under the BI Report section, select the environment and enter the Username and login password of the user with BI Administrator Role access.

3. Click the “Create the BI report in the selected environment” button to create BI reports. The following message will appear after the successful creation of BI Reports.

4. After receiving the confirmation message, the BI Administrator can review the reports in the /Custom/SL_Template folder in Oracle Fusion.

5. The BI Administrator can optionally set the SL_Template folder property to Hidden (shown below). This will ensure that all users do not access the Simplified Loader reports. The user will not be executing the reports directly from BI.


Add Environments using Mobile App

This step is required when setting up a Mobile app using Oracle Fusion URL. Add the target Oracle Fusion environment to which you wish to connect using the Simplified Loader mobile app. Environment setup is a one-time configuration:

1. Navigate to the Settings page

2. Under the Environment setup section, enter the environment identifier in the Alias field and the environment URL in the URL field. Ensure to include https:// in the URL. The best source to obtain the environment URL is the Oracle Fusion login page.

3. Click the Add Environment button to save the environment Alias and URL. The following confirmation message will appear after the environment is successfully added.

4. More than one environment can be added if desired. To do so, repeat steps 1 to 3 above.

Set Up BI Reports using Mobile App

This step is required when setting up a Mobile app using Oracle Fusion URL. Simplified Loader Mobile App use BI Reports to retrieve data from Oracle Fusion. BI Reports need to be set up once for each mobile app for each environment. Only users that have been allocated the BI Administrator role can complete the BI Report setup.

1. Navigate to the Setting page

2. Under the Environment Setup section, click the Setup BI Report button.

3. Select the environment and enter the Username and password of the user with BI Administrator Role access.

4. Click the “Create BI Report” button to create BI reports in the selected environment. The following message will appear after the successful creation of BI Reports.

Set Up Roles and Privileges

This step is required when setting up transactional mobile apps only. Skip this step if you are setting up the Dashboard app and go directly to Step 5.

To transact using mobile app, the users require specific Privileges to be assigned to them in Oracle Fusion. Privileges can be assigned using an existing role or a new role. Below are the steps to assign privilege using a new role.

1. Log in to Oracle Fusion with the user having access to the IT Security Manager role.

2. From Oracle Fusion’s SpringBoard. Select Tools and then the Security Console.

3. In the Roles page, click Create Role.

NOTE: You can add Privileges to a new or existing Role. Based on your organization’s security policies, either create a new Role or use an existing Role to add required privileges.

4. Enter details of the new Role and click Next.

5. In the Function Security Policies page, click Add Function Security Policy.

6. Search for the required privilege, highlight the record and click Add Privilege to Role.

NOTE: Refer to the Template or App page to get the list of required privileges.

7. Review all security Policies in the “Function Security Policies” page and click Next.

8. On the Data Security Policies page, click Next.

9. In the Role Hierarchy page, click Next.

10. Add users to the Role and click Next. Alternatively, Roles can be assigned to the users in the Users page found within the Security Console.

11. Search and add users

12. Review users and click Next

13. In the Summary and Impact Report page, click Save and Close.

14. From Navigator, select Scheduled Processes within the Tools section.

15. Execute the following Please wait for the first process to complete successfully before submitting the next process:

  • Retrieve Latest LDAP Changes
  • Import User and Role Application Security Data

Complete User Registration

The user registration for Simplified Loader is administered using Oracle Lookups functionality. To set up Lookup codes, the System Administrator within your organization needs to define the app-specific Lookup Type in Oracle Fusion. Setting up Lookup Type is a two steps process:

  1. Get User Registration Lookup Type
  2. Complete Users registration

Get User Registration Lookup Type

To complete this step, you need the Connection URL, Company Code, and Passcode.

1. Download the app from Google Play or iOS App store.

2. Launch the app and navigate to the Settings screen

3. Scroll to the Connection Setup section and enter Connection URL, Company Code and click Get Details.

4. Enter Passcode and click OK.

5. This will populate details in the Environment Details section and App Details section

6. Get Lookup Type name populated in the App Details section

Complete Users Registration

Complete these steps in all the environments to which you wish to connect.

1. Log in to Oracle Fusion from your PC or laptop and navigate to Setup and Maintenance

2. Select “Search” from the Tasks menu

3. Search Task “Manage Common Lookups”

4. Click the Plus (+) icon in the Search section to define a new Lookup

5. Enter the following details:

Lookup Type : {Value obtained from App Details section of mobile app}
Meaning : Simplified Loader - User registration for {App Name} mobile app
Description : Leave blank. This field is used to support custom validations.
Module : Common Lookups
Lookup Configuration Level : User
REST Access Secured : Secure

6. Save the record

7. Add user names, as lookup codes, of those users to which access to the Simplified Loader App is to be provided.

Lookup Code : Enter the user name Example: James@Abc.com
Display Sequence : Leave blank
Enabled : Ticked
Start Date : Start date from which the user has access. The Start Date field can be left blank.
End Date : End date to which the user has access. The End Date field can be left blank.
Meaning : Enter user name. NOTE: The Template performs user validation using the value in the Meaning field.
Description : Leave blank. This field is used to support custom validations.
Tag : Leave blank

8. Save the record

Transactional Mobile App Setup

To set up the Simplified Loader transactional mobile apps, perform the following two steps in addition to the steps mentioned above. These steps need executing for SL Requisitioning and SL AP Invoices app only.

Step 1. Configure fields displayed in the mobile app

The transactional mobile app gives administrator ability to define fields to display in the mobile app. The administrator controls field behaviour using Preferences. The fields displayed in the mobile app are defined in the following lookup types

Lookup Type to control fields displayed in the app
App Name Lookup Type
SL Requisitioning   :   SL_REQUISITIONING_FIELDS_SETUP
SL AP Invoices   :   SL_AP_INVOICE_FIELDS_SETUP

 

In the absence of the above lookup, the app will display the following fields.

App NameDisplay SequenceMeaning (User Field Name)Description (Preference)
SL Requisitioning5Requisition NumberShowByDefault[Y] | UserOverride[N] | Mandatory[N]
SL Requisitioning10Requisition Business UnitShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning20Requisition Business Unit IDShowByDefault[N] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning30DescriptionShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning40Preparer EmailShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultFromSQL[PREPARER_EMAIL]
SL Requisitioning50Initiate Approval After Requisition ImportShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultValue[Y]
SL Requisitioning60Document Status CodeShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultValue[INCOMPLETE]
SL Requisitioning70Taxation Country CodeShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning90Interface Source CodeShowByDefault[Y] | UserOverride[Y] | Mandatory[Y] | DefaultValue[Simplified Loader]
SL Requisitioning100Externally Managed FlagShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultValue[N]
SL Requisitioning110Product Type NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning120Requester NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y] | DefaultFromSQL[PREPARER_NAME]
SL Requisitioning130Requester EmailShowByDefault[Y] | UserOverride[Y] | Mandatory[Y] | DefaultFromSQL[PREPARER_EMAIL]
SL Requisitioning140Deliver To Location CodeShowByDefault[Y] | UserOverride[Y] | Mandatory[Y] | DefaultFromSQL[DELIVER_TO_LOCATION_CODE]
SL Requisitioning150Line TypeShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning160Category NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning170Supplier NumberShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning180Supplier NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning190Supplier Site NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning200Supplier Contact NameShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning210Supplier Item NumberShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning220Item DescriptionShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning230QuantityShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning240Unit Of MeasureShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning250PriceShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning255AmountShowByDefault[Y] | UserOverride[Y] | Mandatory[N]
SL Requisitioning260Destination Type CodeShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning270Negotiation Required FlagShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultValue[N]
SL Requisitioning280Negotiated By Preparer FlagShowByDefault[N] | UserOverride[N] | Mandatory[Y] | DefaultValue[Y]
SL Requisitioning290Buyer NameShowByDefault[Y] | UserOverride[Y] | Mandatory[Y]
SL Requisitioning300PercentShowByDefault[Y] | UserOverride[Y] | Mandatory[Y] | DefaultValue[100]
SL Requisitioning310Charge Account Segment1ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT1]
SL Requisitioning320Charge Account Segment2ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT2]
SL Requisitioning330Charge Account Segment3ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT3]
SL Requisitioning340Charge Account Segment4ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT4]
SL Requisitioning350Charge Account Segment5ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT5]
SL Requisitioning360Charge Account Segment6ShowByDefault[Y] | UserOverride[Y] | Mandatory[N] | DefaultFromSQL[GL_SEGMENT6]

 

Set up the lookup type to define default fields and controls field behaviour displayed in the app. These lookup type defines fields to display in the mobile app and Preferences against each field to control field behaviour.

1. Navigate to Setup and Maintenance and search task Manage Common Lookups.

2. Create a new Lookup Type

Lookup Type : Lookup Type
Meaning : Simplified Loader {Mobile app} app fields setup
Description : Leave blank
Module : Common Lookups
Lookup Configuration Level : User
REST Access Secured : Secure

 

3. Enter Requisition field details in the Lookup Code section:

Lookup Code : Enter the same value as used in the Meaning field. In case the length of the Meaning field contains more than 30 characters, then use any value in the Lookup Code field
Display Sequence : The sequence in which field will display in the mobile app
Enabled : Indicate if a field is enabled for mobile app
Start Date : Leave blank
End Date : Leave blank
Meaning : Enter the field name that gets displayed to the user. Select the field name from the table of allowed field names
Description : Preferences related to Requisitioning fields
Tag : Leave blank

 

Available fields in Transactional apps

Transactional mobile app support fields mentioned in the following table. To define a field for the transactional app, add the value from the User Field Name column to the Meaning field in the Lookup Code section of the Display Fields [link] Lookup Type. Other fields (Section Name, Data Type, and User Field Description) are for information purposes only.

App NameSection NameUser Field NameData TypeField Description
SL RequisitioningNoneRequisition TitleCharacterTitle to identify Requisition in your mobile device. This is a reserved field and should not be used in SL_REQUISITIONING_FIELDS_SETUP Lookup Type.
SL RequisitioningNoneLoad StatusCharacterRequisition upload status. This is a reserved field and should not be used in SL_REQUISITIONING_FIELDS_SETUP Lookup Type.
SL RequisitioningNoneError MessageCharacterRequisition upload error message. This is a reserved field and should not be used in SL_REQUISITIONING_FIELDS_SETUP Lookup Type.
SL RequisitioningHeaderInterface Header KeyCharacterThe cloud interface alternate header key code, for integrating applications to be able to identify the requisition header data loaded in the interface table.
SL RequisitioningHeaderRequisition NumberCharacterThe display number used to identify a requisition.
SL RequisitioningHeaderRequisition Business Unit IDCharacterThe unique identifier of a requisitioning business unit.
SL RequisitioningHeaderRequisition Business UnitCharacterThe display name of a requisitioning business unit.
SL RequisitioningHeaderInterface Source CodeCharacterA code indicating the outside source that the data was imported from. Reserved values for internal use include ORA_FUSION_DOO, ORA_FUSION_SCO, ORA_FUSION_INV.
SL RequisitioningHeaderDescriptionCharacterA text description capturing the purpose of the requisition.
SL RequisitioningHeaderDocument Status CodeCharacterA code indicating the status of the requisition. Valid values include incomplete and approved.
SL RequisitioningHeaderPreparer IDCharacterThe unique identifier of the requisition preparer that maps to the person ID within Oracle Fusion Applications.
SL RequisitioningHeaderPreparer EmailCharacterThe e-mail address for the requisition preparer.
SL RequisitioningHeaderInitiate Approval After Requisition ImportCharacterFlag to indicate whether to Requisition for approval after a successful import.
SL RequisitioningHeaderEmergency PO NumberCharacterThe display number used to identify a purchase order number reserved in advanced for an emergency requisition.
SL RequisitioningHeaderJustificationCharacterA text description capturing the reason for the requisition.
SL RequisitioningHeaderTaxation Country CodeCharacterA code indicating the country where the transaction is deemed to have taken place for taxation purposes.
SL RequisitioningHeaderTaxation TerritoryCharacterA code indicating the territory where the transaction is deemed to have taken place for taxation purposes.
SL RequisitioningHeaderDocument Fiscal Classification CodeCharacterA classification used by a tax authority to categorize a document associated with a transaction for a tax.
SL RequisitioningHeaderDocument Fiscal ClassificationCharacterA classification used by a tax authority to categorize a document associated with a transaction for a tax.
SL RequisitioningHeaderSold To Legal Entity IDCharacterThe unique identifier of the legal entity that is liable for the purchase order amount.
SL RequisitioningHeaderSold To Legal Entity NameCharacterThe name of the legal entity that is liable for the purchase order amount.
SL RequisitioningHeaderApprover EmailCharacterThe e-mail address of the requisition approver.
SL RequisitioningHeaderApprover IDCharacterThe unique identifier of the requisition approver.
SL RequisitioningHeaderInterface Source Line IDCharacterThe unique identifier of the source transaction.
SL RequisitioningHeaderExternally Managed FlagY / NIndicates whether or not the requisition line is externally managed.
SL RequisitioningHeaderHeader Attribute CategoryCharacterThe user descriptive flexfield structure.
SL RequisitioningLineInterface Line KeyCharacterThe cloud interface alternate line key code, for integrating applications to be able to identify the requisition line data loaded in the interface table.
SL RequisitioningLineLine TypeCharacterThe display name of a line type that indicates whether a purchase is for goods or services.
SL RequisitioningLineLine Type IDCharacterThe unique identifier of a type to indicate whether a purchasing document line is for goods or services, as well as to default some attributes associated with the line.
SL RequisitioningLineCategory IDCharacterThe unique identifier of the code used to group items with similar characteristics.
SL RequisitioningLineCategory NameCharacterThe display name of a category used to group items with similar characteristics.
SL RequisitioningLineDestination Type CodeCharacterA code indicating if the item should be charged to an inventory or should be expensed.
SL RequisitioningLineDestination SubinventoryCharacterThe display name of a subinventory to which the requested item should be delivered.
SL RequisitioningLineCurrency CodeCharacterA code indicating the three-letter ISO code associated with a currency.
SL RequisitioningLineAmountCharacterThe total amount according to the quantities and prices of the goods and service items specified on the requisition line.
SL RequisitioningLinePriceCharacterThe price of the item on the requisition line.
SL RequisitioningLineQuantityCharacterThe quantity for the item to be added to the requisition.
SL RequisitioningLineUnit Of Measure CodeCharacterA code indicating the division of quantity defined as a standard of measurement or exchange.
SL RequisitioningLineUnit Of MeasureCharacterA division of quantity defined as a standard of measurement or exchange.
SL RequisitioningLineSecondary QuantityCharacterThe quantity converted in the secondary unit of measure of a dual UOM controlled item.
SL RequisitioningLineSecondary UOM CodeCharacterA code indicating the alternative unit of measure that is allowed to quantify a dual UOM controlled item.
SL RequisitioningLineSecondary UOMCharacterAn alternative unit of measure that is allowed to quantify a dual UOM controlled item.
SL RequisitioningLineProcurement Business Unit IDCharacterThe unique identifier of a procurement business unit.
SL RequisitioningLineProcurement Business Unit NameCharacterThe display name of a procurement business unit.
SL RequisitioningLineRateCharacterThe ratio at which the principal unit of one currency can be converted into another currency.
SL RequisitioningLineRate DateDateThe date as of which a conversion rate is used to convert an amount into another currency.
SL RequisitioningLineRate TypeCharacterThe source of a currency conversion rate, such as user defined, spot, or corporate. For user-defined rate, provide USER in the rate type.
SL RequisitioningLineRequester IDCharacterThe unique identifier of a requester.
SL RequisitioningLineRequester EmailCharacterThe e-mail address for a requester.
SL RequisitioningLineProduct CategoryCharacterA code indicating the type of product fiscal classification used to classify products.
SL RequisitioningLineProduct Category NameCharacterThe display name of a product fiscal classification type used to classify products.
SL RequisitioningLineProduct TypeCharacterA code indicating the type of product fiscal classification used to classify products. Related term(s) product fiscal classification.
SL RequisitioningLineProduct Type NameCharacterThe display name of a product fiscal classification type used to classify products.
SL RequisitioningLineUrgent Requisition Line FlagY / NIndicates whether the requisition is urgent or not.
SL RequisitioningLineNote To BuyerCharacterA text description capturing the instructions to the buyer when processing the requisition line.
SL RequisitioningLineNote To SupplierCharacterA text description capturing the instructions to the supplier.
SL RequisitioningLineNote To ReceiverCharacterA text description capturing the instructions to the receiver in the docking area to be reviewed while performing the receipt.
SL RequisitioningLineBuyer IDCharacterThe unique identifier of the buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.
SL RequisitioningLineBuyer NameCharacterThe display name of a buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.
SL RequisitioningLineBuyer EmailCharacterThe e-mail address of the buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.
SL RequisitioningLineNew Supplier FlagY / NIndicates whether or not the supplier is new.
SL RequisitioningLineSupplier Item NumberCharacterThe display name of a suppliers identification number or code for the goods ordered on your order line.
SL RequisitioningLineSupplier IDCharacterThe unique identifier of an organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.
SL RequisitioningLineSupplier NameCharacterThe display name of an organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.
SL RequisitioningLineSupplier Site IDCharacterThe unique identifier of an entity that models how the buying organization conducts business with the supplier.
SL RequisitioningLineSupplier Site NameCharacterThe display name of an entity that models how the buying organization conducts business with the supplier.
SL RequisitioningLineSupplier Contact IDCharacterThe unique identifier of a supplier employee who represents the supplier in communications with the buying organization.
SL RequisitioningLineSupplier Contact NameCharacterThe display name of a supplier employee who represents the supplier in communications with the buying organization.
SL RequisitioningLineSupplier Contact EmailCharacterThe e-mail address for a supplier employee who represents the supplier in communications with the buying organization.
SL RequisitioningLineSupplier Contact FaxCharacterThe fax number for a supplier employee who represents the supplier in communications with the buying organization.
SL RequisitioningLineSupplier Contact PhoneCharacterThe phone number for a supplier employee who represents the supplier in communications with the buying organization.
SL RequisitioningLineSource Agreement IDCharacterThe unique identifier of a purchase agreement against which this purchase order line is released.
SL RequisitioningLineSource Agreement NumberCharacterThe display number used to identify a purchase agreement against which this purchase order line is released.
SL RequisitioningLineSource Agreement Line IDCharacterThe unique identifier of a purchase agreement line against which this purchase order line is released.
SL RequisitioningLineSource Agreement Line NumberCharacterThe display number used to identify a purchase agreement line against which this purchase order line is released.
SL RequisitioningLineItem IDCharacterThe unique identifier of an item.
SL RequisitioningLineItem DescriptionCharacterA text description capturing details about the item being purchased.
SL RequisitioningLineItem NumberCharacterThe display name of an item representing anything you make, purchase, or sell, including components, subassemblies, finished products, or supplies.
SL RequisitioningLineItem RevisionCharacterIdentifier that indicates version of inventory item being referenced on the order line.
SL RequisitioningLineBase Model IDCharacterThe unique identifier of a model from which an ATO configuration was created.
SL RequisitioningLineBase Model NumberCharacterThe display name of a model from which an ATO configuration was created.
SL RequisitioningLineBase Model PriceCharacterThe model price from which an ATO configuration was created.
SL RequisitioningLineFirst Party Tax Registration IDCharacterThe unique identifier of the tax registration record corresponding to the sold-to legal entity on the purchase order.
SL RequisitioningLineFirst Party Tax Registration NumberCharacterThe unique display number assigned to the sold-to legal entity by a tax authority in order to manage tax liabilities.
SL RequisitioningLineLine Intended Use IDCharacterThe unique identifier of a tax classification that is based on the purpose for which a product is used.
SL RequisitioningLineLine Intended UseCharacterA code indicating the type of the tax classification that is based on the purpose for which a product is used.
SL RequisitioningLineLine Intended Use NameCharacterThe display name of a tax classification that is based on the purpose for which a product is used.
SL RequisitioningLineAssessable AmountCharacterThe price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities.
SL RequisitioningLineTax Classification CodeCharacterA code indicating the group of taxes for reporting and processing purposes.
SL RequisitioningLineTax Classification NameCharacterThe display name of a group of taxes for reporting and processing purposes.
SL RequisitioningLineThird Party Tax Registration IDCharacterA unique identifier of the registration number assigned to the supplier or supplier site, when it is registered by a tax authority, and by which the party or party site registration will be identified.
SL RequisitioningLineThird Party Tax Registration NumberCharacterA unique sequence of letters and/or numbers assigned to the supplier or supplier site, when it is registered by a tax authority, and by which the party or party site registration will be identified.
SL RequisitioningLineProduct Fiscal Classification IDCharacterThe unique identifier of a classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.
SL RequisitioningLineProduct Fiscal ClassificationCharacterA code indicating the classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.
SL RequisitioningLineProduct Fiscal Classification NameCharacterThe display name of a classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.
SL RequisitioningLineUser Defined Fiscal ClassificationCharacterA coding indicating the classification for any tax requirement that you cannot define using the existing fiscal classification types.
SL RequisitioningLineUser Defined Fiscal Classification NameCharacterThe display name of a classification for any tax requirement that you cannot define using the existing fiscal classification types.
SL RequisitioningLineTransaction Business CategoryCharacterA code indicating the business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction.
SL RequisitioningLineTransaction Business Category NameCharacterThe display name of a business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction.
SL RequisitioningLineNegotiated By Preparer FlagY / NIndicates whether or not the requested item is negotiated with the supplier.
SL RequisitioningLineNegotiation Required FlagY / NIndicates whether or not a negotiation is required for the requested item.
SL RequisitioningLineService Level CodeCharacterA code indicating the priority of transportation that affects how quickly goods are transported. Applicable values are all codes of the lookup Carrier Service Levels.
SL RequisitioningLineHazard Class IDCharacterThe unique identifier of a classification of hazardous materials, to facilitate safety regulations compliance.
SL RequisitioningLineHazard ClassCharacterThe display name of a classification of hazardous materials, to facilitate safety regulations compliance.
SL RequisitioningLineUN Number IDCharacterThe unique identifier of a United Nations identification number for the hazardous material.
SL RequisitioningLineUN NumberCharacterThe display name of a United Nations identification number for the hazardous material.
SL RequisitioningLineCustomer Item NumberCharacterThe display name of a customers identification number or code for the goods ordered on your order line.
SL RequisitioningLineCustomer Item DescriptionCharacterA text description capturing a customers identification number or code for the goods ordered on your order line.
SL RequisitioningLineCustomer PO Line NumberCharacterThe display number used to identify a purchase order line from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.
SL RequisitioningLineCustomer PO NumberCharacterThe display number used to identify a purchase order from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.
SL RequisitioningLineCustomer PO Schedule NumberCharacterThe display number used to identify a purchase order schedule from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.
SL RequisitioningLineDeliver To Customer Contact IDCharacterThe unique identifier of a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Contact NameCharacterThe display name of a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Contact NumberCharacterThe display number used to identify a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Contact EmailCharacterThe e-mail for a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer IDCharacterThe unique identifier of a customer to which materials, being procured in a drop ship or back to back arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer NameCharacterThe display name of a customer to which materials, being procured in a drop ship or back to back arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer NumberCharacterThe display number used to identify a customer to which materials, being procured in a drop ship or a back to back arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Location CLLI CodeCharacterThe CLLI code for the customer location to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Location Original System ReferenceCharacterThe original system reference for the customer location to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Customer Location IDCharacterThe unique identifier of a customer location to which materials, being procured in a drop ship arrangement, need to be delivered.
SL RequisitioningLineDeliver To Location CodeCharacterA code indicating the final delivery location for goods previously received from a supplier.
SL RequisitioningLineDeliver To Location IDCharacterThe unique identifier of a final delivery location for goods previously received from a supplier.
SL RequisitioningLineDeliver To Organization CodeCharacterA code indicating the organization to which the requested item should be delivered.
SL RequisitioningLineDeliver To Organization IDCharacterThe unique identifier of a organization to which the requested item should be delivered.
SL RequisitioningLineShip To Customer Contact IDCharacterThe unique identifier of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Contact NameCharacterThe display name of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Contact NumberCharacterThe display number used to identify a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Contact EmailCharacterThe e-mail address of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer IDCharacterThe unique identifier of a customer to whom materials, being procured in a drop ship or a back to back arrangement need to be shipped.
SL RequisitioningLineShip To Customer NameCharacterThe display name of a customer to whom materials, being procured in a drop ship or a back to back arrangement, need to be shipped.
SL RequisitioningLineShip To Customer NumberCharacterThe display number used to identify a customer to whom materials, being procured in a drop ship or a back to back arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Location CLLI CodeCharacterThe CLLI Code for the customer location where materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Location Original System ReferenceCharacterThe original system reference for the customer location where materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineShip To Customer Location IDCharacterThe unique identifier of a customer location where materials, being procured in a drop ship arrangement, need to be shipped.
SL RequisitioningLineSales Order NumberCharacterThe display number used to identify a backing customer sales order number.
SL RequisitioningLineSales Order Line NumberCharacterThe display number used to identify a backing customer sales order line number.
SL RequisitioningLineSales Order Schedule NumberCharacterThe display number used to identify a backing customer sales order schedule number.
SL RequisitioningLineWork Order IDCharacterThe unique identifier of a contract manufacturing work order.
SL RequisitioningLineWork Order NumberCharacterThe display number used to identify the finished goods product of a contract manufacturing work order.
SL RequisitioningLineWork Order ProductCharacterThe display name of the finished goods product of the contract manufacturing work order.
SL RequisitioningLineWork Order Operation IDCharacterThe unique identifier of a contract manufacturing work order operation.
SL RequisitioningLineWork Order Operation SequenceCharacterThe sequence number of work order operation.
SL RequisitioningLineWork Order Sub Type CodeCharacterThe code of the work order sub type.
SL RequisitioningLineLocation Of Final Discharge IDCharacterThe unique identifier of a final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location.
SL RequisitioningLineLocation Of Final Discharge CodeCharacterA code indicating the final destination location for the purchases made by the customer. The location of the final customer, or where the goods would be used, is not necessarily the same as the initial ship-to location.
SL RequisitioningLineMode Of Transport CodeCharacterThe display name of a mode of transportation used to describe the movement of goods.
SL RequisitioningLineCarrier IDCharacterThe unique identifier of the company that transports goods from one point to another by land, sea, or air.
SL RequisitioningLineCarrierCharacterThe display name of the company that transports goods from one point to another by land, sea, or air.
SL RequisitioningLineRequested Ship DateDateThe date when the buying company has requested the ordered item is ready to be shipped.
SL RequisitioningLineRequested Delivery DateDateThe date when the buying company has requested the ordered item or service to be delivered.
SL RequisitioningLineDays Early Receipt AllowedCharacterThe maximum acceptable number of days early for receipts.
SL RequisitioningLineDays Late Receipt AllowedCharacterThe maximum acceptable number of days late for receipts.
SL RequisitioningLineConfigured Item FlagY / NIndicates whether the requisition line is for a configured item and configuration details might exist.
SL RequisitioningLineOrchestration CodeCharacterA code indicating if the integrating application is synchronizing changes between their application and Oracle Fusion Procurement. Example values include DOO_TRACKED and SCO_TRACKED.
SL RequisitioningLineGroup CodeCharacterA code indicating the option by which the requisition lines are grouped when they are being processed by the import program. Requisition lines that are grouped together will be put on the same requisition header. Valid values include none, buyer, category, item, location, and supplier.
SL RequisitioningLineOver Receipt Tolerance PercentCharacterThe tolerance that allows a purchase order schedule to receive more than ordered quantity or amount without triggering the over-receipt action.
SL RequisitioningLineBack To Back FlagY / NIndicates whether the purchase order schedule has a backing sales order that is fulfilled using a back to back order.
SL RequisitioningLineAutosource FlagY / NIndicates whether supplier and price information is derived from source purchase agreements.
SL RequisitioningLineLine Attribute CategoryCharacterThe user descriptive flexfield structure.
SL RequisitioningDistributionInterface Distribution KeyCharacterThe cloud interface alternate distribution key code, for integrating applications to be able to identify the requisition distribution data loaded in the interface table.
SL RequisitioningDistributionPercentCharacterThe percentage of the requisition distribution.
SL RequisitioningDistributionDistribution AmountCharacterThe total amount of the distribution according to the distribution quantity and requisition line price.
SL RequisitioningDistributionDistribution QuantityCharacterThe quantity for the requisition distribution.
SL RequisitioningDistributionBudget DateDateThe date used to derive the budget period from which budget is consumed.
SL RequisitioningDistributionCharge Account IDCharacterThe unique identifier of the General Ledger charge account.
SL RequisitioningDistributionCharge Account Segment1CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment2CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment3CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment4CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment5CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment6CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment7CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment8CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment9CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment10CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment11CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment12CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment13CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment14CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment15CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment16CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment17CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment18CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment19CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment20CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment21CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment22CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment23CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment24CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment25CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment26CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment27CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment28CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment29CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionCharge Account Segment30CharacterThe charge account key flexfield segment.
SL RequisitioningDistributionProject IDCharacterThe unique identifier of a project.
SL RequisitioningDistributionProject NumberCharacterThe number assigned to a project. A project is a finite endeavor (having specific start and finish dates) undertaken to create a product or provide a service.
SL RequisitioningDistributionProject NameCharacterThe display name of a project. A project is a finite endeavor (having specific start and finish dates) undertaken to create a product or provide a service.
SL RequisitioningDistributionProject Task IDCharacterThe unique identifier of the number of a task which is a subdivision of project work.
SL RequisitioningDistributionProject Task NameCharacterThe display name of a task which is a subdivision of project work.
SL RequisitioningDistributionProject Organization IDCharacterThe unique identifier of the organization that incurred the cost on the expenditure item.
SL RequisitioningDistributionProject Organization NameCharacterThe display name of the organization that incurred the cost on the expenditure item.
SL RequisitioningDistributionProject Expenditure Item DateDateThe specified day when the expenditure item was incurred.
SL RequisitioningDistributionProject Expenditure Type IDCharacterThe unique identifier of a classification of cost that is assigned to each expenditure item. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories).
SL RequisitioningDistributionProject Expenditure Type NameCharacterThe display name of a classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups and revenue groups.
SL RequisitioningDistributionProject Capitalizable FlagY / NIndicates whether or not the expenditure item is capitalizable after it is fully processed. The debit amount for a capitalizable transaction is generally made to a construction in progress account.
SL RequisitioningDistributionProject Work Type IDCharacterThe unique identifier of a classification of the work associated with a task.
SL RequisitioningDistributionProject Work Type NameCharacterThe display name of a classification of the work associated with a task.
SL RequisitioningDistributionProject Billable FlagY / NIndicates whether or not the expenditure item is billable after it is fully processed.
SL RequisitioningDistributionProject Funding Allocation IDCharacterThe unique identifier of the project funding override. This attribute is used when Oracle Fusion Project Billing or Oracle Fusion Grants Management is installed.
SL RequisitioningDistributionProject Funding Source NameCharacterThe display name used to identify the funding source associated with a sponsored project.
SL RequisitioningDistributionProject Context CategoryCharacterAn attribute that determines which contextual segments of a descriptive flexfield to display for a transaction. For example, an expense report transaction may have different descriptive flexfield segments defined as compared to a time card transaction.
SL RequisitioningDistributionProject Contract IDCharacterThe unique identifier of the contract. This attribute is used when Oracle Fusion Project Billing or Oracle Fusion Grants Management is installed.
SL RequisitioningDistributionProject Contract NameCharacterName of the contract. This attribute is used when Oracle Fusion Project Billing or Oracle Fusion Grants Management is installed.
SL RequisitioningDistributionProject Contract NumberCharacterNumber of the contract. This attribute is used when Oracle Fusion Project Billing or Oracle Fusion Grants Management is installed.
SL RequisitioningDistributionProject Contract Line IDCharacterThe unique identifier of the contract line. This attribute is used when Oracle Fusion Project Billing or Oracle Fusion Grants Management is installed.
SL RequisitioningDistributionProject Reserved Attribute1CharacterThe reserved descriptive flexfield segment for future project related functionality.
SL RequisitioningDistributionDistribution Attribute CategoryCharacterThe user descriptive flexfield structure.

Preferences

The transactional mobile app allows defining the following preferences to control the field behaviour. Preferences are entered in the Description field of the Lookup Code section. The format to enter Preference and its value is

PreferenceName[PreferenceValue]

 

The preference value is specified within the square brackets. The administrator can choose to use one or more preferences. When using multiple preferences, enter pipe (|) delimiter between preferences.

Mandatory

The Mandatory Preference is used to specify a field as mandatory. Mandatory Preference allows Y or N value. Enter Mandatory[Y] to indicate a field required in the mobile app. By default, all fields are set as non-mandatory.

The Mandatory field validation is performed when the user tries to submit the transaction for creation.

UserOverride

The administrator can set up fields such that the user cannot override the administrator’s default values. UserOverride Preference allows Y or N value. When using UserOverride[N] preference, the administrator must specify a default value using DefaultValue or DefaultFromSQL preferences. By default, all fields are set as UserOverride[Y].

ShowByDefault

The ShowByDefault preference defines whether a field gets displayed while entering a transaction in the mobile app. ShowByDefault Preference allows Y or N value. Using ShowByDefault preference, the administrator can determine fields that the user should see when entering a transaction. When using ShowByDefault[N] preference, the administrator must specify a default value using DefaultValue or DefaultFromSQL preferences. By default, all fields are set as ShowByDefault[Y].

The user can override ShowByDefault Preference using the Field Setup section in the mobile app.

The usage of this Preference is to define fields like Business Unit, which should not be displayed to the user when they enter a transaction.

DefaultValue

The DefaultValue Preference defines a static default value of a field. The default value is specified within the square brackets. For example, to default the value “INCOMPLETE” in the Document Status Code field, set DefaultValue[INCOMPLETE] as Preference.

To define a default value for fields having Y / N data type, specify value true or false in the Preference.

By default, the user can override the default value in the mobile app. To stop the users from the overriding default value, use preference UserOverride.

DefaultFromSQL

The DefaultFromSQL Preference defines a default value based on the SQL select statement. Configuring DefaultFromSQL is a two-step process

a. Define the SQL to fetch data based on user:

  1. Navigate to BI Report /custom/SL_Templates/Mobile{app name}/UserSQLDefaultsReport
  2. Add an SQL statement that must return a single row with two columns, SQL_OUTPUT and FIELD_VALUE. Specify the field name in the SQL_OUTPUT column. The field name specified as SQL_OUTPUT is used as DefaultFromSQL preference value. FIELD_VALUE column contains the value that gets defaulted in the app.
  3. If required, use parameter SL_USER_NAME to filter records using username accessing the mobile app.
  4. NOTE: The SQL query specified in /custom/SL_Templates/Mobile{app name}/UserSQLDefaultsReport gets executed when the user logs in to the app.

b. Specify Preference using DefaultFromSQL: Enter the value of SQL_OUTPUT field in the DefaultFromSQL Preference. For example, if the value of the SQL_OUTPUT field is PREPARER_NAME, enter DefaultFromSQL[PREPARER_NAME] as the field Preference.

In the Fields Setup section of the mobile app, the value in DefaultFromSQL Preference appears with “SQL:” prefix. For example, the user sees SQL:PREPARER_NAME as the field value. When the user creates a Requisition, they see the actual value fetched from the SQL statement.

By default, the user can override the default value in the mobile app. To stop the users from the overriding default value, use preference UserOverride.

Defaulting field values

The following data flow demonstrates how field values gets defaulted in the mobile app.

Step 2. Setup FieldsSetupVersion preference

After configuring Lookup Type linked with the mobile app for user validation, it is mandatory to set up FieldsSetupVersion preference in the lookup. FieldsSetupVersion preference value is used to control if Requisition fields setup should refresh in the mobile app using the latest configuration in Display Fields Lookup Type. The following flow highlights how FieldsSetupVersion preference triggers the operation to refresh fields from Display Fields Lookup Type in the mobile app.

You are now ready to use the Mobile app!

After completing the above setup steps, the user can use the mobile app. You will find more information on how to use the app in the User Guide.