EAM: Unable to Create an Asset Using Excel to CI, for ASSET_ENTRY Component, Error "XXXXXX.AM_DOC_SEQ(1).BOOK} IS REQUIRED(15,54)". (Doc ID 3000864.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

Document sequencing is enabled for the Asset Management business unit and an asset is being created using Excel to CI(Component Interface). The CI is created on top of the Express add component( ASSET_ENTRY)

The required information to create the asset is stagged along with the document sequencing information  i.e. AM_DOC_SEQ fields are selected as input, and on the data input sheet All the details mentioned below were provided:

When the data is stagged and submitted, the following error:

Steps to replicate:

1) Enable document sequencing at the instillation option (Main Menu > Setup Financials Supply Chain > Install > Installation Options)

2) Enable doc sequencing at GL BU level (Main Menu > Setup Financials Supply Chain > Business Unit Related > General Ledger > General Ledger Definition

3) log in to Application designer.

4) Create a new component interface for the component ASSET_ENTRY.

5) Select yes when the system prompts "Do you want to default the properties based on the underlying Component definition, ASSET_ENTRY? (123,12)".

6) Save the Component interface

7) Now navigate to Main Menu > PeopleTools > Security > Permissions and Roles > Permission Lists.

8) Search for the permission list "ALLPAGES"

9) Add the component interface "AM_EXPRESS_TST" with full access.

10) Fetch the Excel to CI File and its macro from PS_HOME.

11) Provide the stage and Submit the data. The above mentioned error occurs.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.