category assignment api in oracle apps

• Site-Wide Activity

by oracleguru

Item Category Assignment Open Interface

NAME: Item Category Assignment Open Interface SHORT CODE: INV_ITEM_CAT_ASSIGN_OI MODULE: Oracle Inventory

Description: Import item category assignments from the Open Interface table Navigation: Oracle Inventory Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_rec_set_id : Record set to be processed
• p_upload_rec_flag : Upload processed records
• p_delete_rec_flag : Delete processed records

Tags: INV_ITEM_CAT_ASSIGN_OI  

Leave a reply Cancel reply

Your email address will not be published. Required fields are marked *

All copy rights reserved by oracleappscommunity.com

Oracle Application's Blog

The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Contact us for Oracle Applications Job Support , Project Support and any other freelancing work.

• Fusion E-Books
• Fusion Technical
• Fusion Financial

Sunday 2 September 2018

Item category conversion in oracle apps r12.

Sample code of Using item category conversion in oracle apps r12

0 comments:, post a comment, contact us for any collaboration, project support & on job support work.

Know More About Us

• Products & Offerings

Learn Fusion Financials' (Online Book)

Oracle Fusion Self Paced Trainings in Discounted Prices

Buy Oracle Cloud Instance Access (Click to Know More)

Oracle Fusion/EBS Interview's Question Answer Series

• Top 33 Oracle Fusion Order Management Interview Questions
• TOP 31 Oracle Fusion SCM Cloud Interview Questions
• TOP 21 Oracle Fusion HCM Interview Questions
• Complete Tax Setups in Oracle Fusion
• Top 50 oracle reports interview questions
• 33 Most Important Oracle Fusion fixed assets interview questions
• TOP 33 Most Important Oracle Apps Technical Interview Questions
• 25 Most Important Oracle receivable interview questions
• 21 Most Important Oracle r12 Payables Interview Questions
• TOP 20 general ledger interview questions in oracle apps r12
• TOP 23 Most Important Oracle Fusion Interview Questions
• TOP 23 Most Important oaf interview questions

Online Oracle Courses (Free of Cost)

• Learn Tax Implementation in Oracle Fusion
• Learn P2P Cycle in Oracle Fusion
• Learn Oracle Reports XML Tutorial
• Learn Oracle Fusion Custom Roles Tutorial
• Learn Oracle Fusion Technical Online
• Learn Oracle Fusion/cloud Financials Online
• Learn Oracle Cloud BPM Online
• Learn Complete OAF Step by Step Online
• Learn Oracle Workflow Builder Online

Online Fusion Application Composer/Customization Book

Oracle Fusion Technical Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Most Viewed Posts

R12 – Assign Inventory Item to an Child Organization using API

• P_API_VERSION – A decimal number indicating major and minor revisions to the API. Pass 1.0 unless otherwise indicated in the API parameter list.
• P_INIT_MSG_LIST – A one-character flag indicating whether to initialize the FND_MSG_PUB package’s message stack at the beginning of API processing (and thus remove any messages that may exist on the stack from prior processing in the same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
• P_COMMIT – A one-character flag indicating whether to commit work at the end of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
• P_INVENTORY_ITEM_ID – Inventory Item Id of the Item
• P_ITEM_NUMBER – Segment1 of the Item
• P_ORGANIZATION_ID – Organization Id of the Organization to whom Item must be assigned
• P_ORGANIZATION_CODE – 3 character Organization Code of the Organization to whom Item must be assigned
• P_PRIMARY_UOM_CODE – Primary Unit of Measure of the item.
• X_RETURN_STATUS – A one-character code indicating whether any errors occurred during processing (in which case error messages will be present on the FND_MSG_PUB package’s message stack). Valid values are FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.
• X_MSG_COUNT – An integer indicating the number of messages on the FND_MSG_PUB package’s message stack at the end of API processing.

Share this:

Leave a reply, leave a reply cancel reply, recent comments.

• Guru on R12 Supplier Contact creation API
• himanshu dawra on Oracle E-Business Suite 12 Free Vision Instance
• Saqib ali Ali Khan on FRM-92050 Failed to Connect to Server
• Swapnil Dandgvhal on Inventory Organization and corresponding Operating Unit, Ledger and Legal Entity
• Sakshi Dhokale on HZ tables in Oracle Receivables

Latest Posts

• R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERP August 25, 2023 - 1:20 pm
• R12 – How to Delete Oracle AR Transactions March 22, 2019 - 8:37 pm
• How to Define Custom Key Flexfield (KFF) in R12 January 19, 2018 - 5:43 pm
• AutoLock Box Concepts In R12 November 10, 2017 - 8:30 am
• R12 – java.sql.SQLException: Invalid column type in OAF September 15, 2017 - 9:39 am

Ads Blocker Detected!!!

This site uses cookies and other tracking technologies to assist with navigation and your ability to provide feedback, analyse your use of our services, and provide content from third parties. By continuing to browse the site, you are agreeing to our use of cookies.

Cookie and Privacy Settings

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.

If you do not want that we track your visit to our site you can disable tracking in your browser here:

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

The following cookies are also needed - You can choose if you want to allow them:

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

Fixed Assets - EBS (MOSC)

Discussions

Is there any API to load Asset category in Oracle EBS?? I have to load thousands asset categories..

I have thousands data of Asset Categories that must be to load..but I done have enought time to do it with Data Loader.. Is there any API to load Asset Categories in Oracle EBS?? Or maybe with something else??

• EBS_FA_Assets
• EBS_FA_WebADI

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Instructions for posting

1. Select a discussion category from the picklist.

2. Enter a title that clearly identifies the subject of your question.

3. In the body, insert detailed information, including Oracle product and version.

Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).

Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .

New to My Oracle Support Community? Visit our Welcome Center

Video Hub App for Oracle Content Management

Introduction

Video Hub is a pre-built application for Oracle Content Management (OCM) which enables you to easily organize, sort, browse, and search your collection of advanced videos hosted in Oracle Content Management.

Video Hub is a sample web application developed with reusable Oracle JET and Preact components and Oracle Content Management as the CMS. The app uses the REST API for Content Delivery to fetch the Video Plus assets from your Oracle Content Management instance.

The application framework and demo apps, including Video Hub, are not available in the Starter Edition of Oracle Content Management.

Prerequisites

To install and configure the Video Hub app, you need the following:

• an Oracle Content Management Premium Edition subscription
• Enterprise user (CECEnterpriseUser)
• Service administrator (CECServiceAdministrator)
• Content administrator (CECContentAdministrator)
• Sites administrator (CECSitesAdministrator)
• Repository administrator (CECRepositoryAdministrator)
• access to an Oracle Content Management instance with the advanced video features (Video Plus) enabled
• a configured video management environment in Oracle Content Management

Configure Oracle Content Management

Before installing and configuring the Video Hub app, you first need to configure some things in Oracle Content Management:

Enable Video Plus

• Create a publishing channel
• Create a taxonomy with categories
• Create an asset repository

To create publishing channels, taxonomies, and asset repositories in Oracle Content Management, you need to have the repository administrator and content administrator roles (CECRepositoryAdministrator and CECContentAdministrator).

The Video Hub app uses advanced video management features in Oracle Content Management, which means you must first enable Video Plus :

Sign in to the Oracle Content Management web interface as an administrator.

Choose Integrations in the left navigation menu. If you don’t see this option, then you don’t have the required user privileges.

On the Integrations page, choose Applications in the Integrations dropdown menu.

Under Other Integrations , make sure that Kaltura Video Management - Video Plus is enabled.

Create a Publishing Channel

After enabling Video Plus , you need to create a publishing channel for your Video Hub application:

Choose Content in the left navigation menu.

On the Content page, choose Publishing Channels in the Content dropdown menu.

On the Publishing Channels page, click Create .

Provide a name and, optionally, a description for the publishing channel, and set the other options to suit your needs.

Make sure that you select public access to published resources as Video Hub currently doesn’t support secure channels.

Click Save when you’re done.

The publishing channel is now available for use, but you do need to add it to a repository before users can publish to it.

You can use the same publishing channel for multiple Video Hub instances.

For more information on publishing channels, see Managing Assets with Oracle Content Management .

Create a Taxonomy with Categories

Next, create a taxonomy so your videos can be categorized. The categories you add to the taxonomy will be displayed as options in the Video Hub navigation menu, so users can filter the videos they see.

On the Content page, choose Taxonomies in the Content dropdown menu.

On the Taxonomies page, click Create .

Provide a name, an abbreviation, and, optionally, a description for the taxonomy, and click Save .

Add categories to your taxonomy that suit your needs. Optionally, edit any of the category properties. You can create hierarchical categories to fine-tune how your videos will be grouped. Click Done when you’re done.

On the main Taxonomies page, select the taxonomy you just created and click Promote in the actions bar. This makes the taxonomy available for use in your asset repositories.

Select the Allow publishing of this taxonomy and Confirm to proceed check boxes, and click Promote .

After promoting the taxonomy, select the taxonomy again and click Publish in the actions bar. Select the publishing channel you created for Video Hub, select Confirm to proceed , and click Publish . This makes the taxonomy available through the REST API for Content Delivery .

You can use the same taxonomy for multiple Video Hub instances.

For more information on taxonomies, see Managing Assets with Oracle Content Management .

Create an Asset Repository

Finally, create an asset repository that will store your videos:

On the Content page, choose Repositories in the Content dropdown menu.

On the Repositories page, click Create . Make sure to create an asset repository , not a business repository.

Provide a name and, optionally, a description for the repository.

Under Asset Types , select Video-Plus . You can start typing to narrow down the list of options.

Under Publishing Channel , select the publishing channel you created earlier. You can start typing to narrow down the list of options.

Under Taxonomies , select the taxonomy you created earlier. You can start typing to narrow down the list of options.

The repository is now available for use.

You can use only one Video Hub instance with a repository. If you want to install multiple Video Hub instances to create several galleries, then you’ll have to use separate repositories for each of them.

For more information on repositories, see Managing Assets with Oracle Content Management .

After you’ve configured Oracle Content Management, you can add videos to Oracle Content Management for use with Video Hub. On the Assets page, upload new videos or choose ones already in Oracle Content Management.

For full details on adding and managing digital assets such as videos, see Managing Assets with Oracle Content Management .

Please note the following:

• Make sure the asset type is set to ‘Video-Plus’.
• Assign the videos to the public publishing channel that you created for your video gallery. (Video Hub currently doesn’t support secure channels.)
• Assign taxonomy categories to make sure the videos are grouped and displayed as expected.
• After uploading new videos, make sure to publish them. If you don’t, they won’t show up in your video gallery.
• If you modify any properties of existing videos, make sure to publish the videos again. Otherwise the new properties won’t take effect.
• Newly published videos won’t appear in your video gallery instantly due to asset caching. To make videos appear immediately, set the default asset caching age to zero days. In the Oracle Content Management web interface, click System in the left navigation menu (under Administration), choose Assets from the dropdown menu, and set the Default asset caching age to 0 days.

After uploading the videos, make sure to assign the correct categories to them, so they’re grouped correctly in your video gallery.

As a final step, don’t forget to publish the videos. Otherwise they won’t show up in your video gallery.

Install the App

After configuring Oracle Content Management and adding videos , you can install the Video Hub app:

In the Oracle Content Management web interface, click Applications in the left navigation menu (under ADMINISTRATION ). If you don’t see this option, then you don’t have the required user privileges to install apps.

On the Applications page, open the Discover tab.

Click Video Hub .

On the application overview page, click Install .

Provide a name for your Video Hub instance, and select the asset repository that you created earlier to store your videos, then click Confirm .

The application is now installed.

You can see your installed Video Hub instance by opening the Applications page, then clicking Installed Apps , and then View instances in the Video Hub tile.

If you uninstall the Video Hub app, its associated repository, publishing channel, taxonomy, and uploaded videos will remain in the system. They’re not removed automatically with the app.

Configure the App

After installing the Video Hub app, configure it to suit your needs:

In the Oracle Content Management web interface, open the Applications page and then click Installed Apps .

In the Video Hub App tile, click View instances . This opens the Instances panel on the right.

In the Site Config section of the application configuration window, provide the following information:

• the publishing channel that your published videos were assigned to
• the URL for the application logo
• the title of the application, which is shown in the video gallery header
• the taxonomy that you created to define the navigation menu
• the URL for the app background image
• the footer content (for example, copyright information).

Click Submit when you’re done.

Move to the Video Configuration section and configure these settings:

• Select three featured videos that will be highlighted on the home page. The dropdown lists include all videos in Oracle Content Management that have been configured for your video gallery.
• Choose whether the built-in video player should start automatically, be muted, and/or loop by default.

Use the App

You may see two site names in the list: one for the public version and one for the private (authenticated) version.

This opens the video gallery, showing all videos in Oracle Content Management that have been configured to be included.

The menu at the top is based on the taxonomy categories that you created earlier. Click any category to see all videos that have been tagged as such. You can also search for videos, apply filters to narrow down the list of videos, or change the display mode or sort order.

Share Your Galleries

You can share the URL of a video gallery with other users so they can view and filter the videos. To find the URL, launch the gallery and copy the URL in the address bar of your web browser.

For anyone to access a Video Hub gallery, they need to have a user account to the Oracle Content Management instance that the video gallery is running on, but they don’t need to be part of the video repository or have any special privileges. (In other words, any enterprise user can view video galleries.)

If you want to add videos to the gallery, you do need direct access to the asset repository.

Copyright ©  2021, 2023, Oracle and/or its affiliates.

Primary Author: Oracle Corporation

Oracle Apps Knowledge Sharing

Meant for sharing our knowledge related to Oracle E-Business Suite

• TECHNICAL TUTORIALS
• USEFUL LINKS
• ARTICLE INDEX
• VIDEO INDEX

Wednesday, June 2, 2010

Api for deleting the category assignment to an item (inv_item_category_pub.delete_category_assignment).

Below script will help you delete category assignment of an item through API INV_ITEM_CATEGORY_PUB . DELETE_CATEGORY_ASSIGNMENT This script was tested in R12.1.1 DECLARE   v_return_status      VARCHAR2 ( 1 ) := NULL;   v_msg_count          NUMBER       := 0 ;   v_msg_data           VARCHAR2 ( 2000 );   v_errorcode          VARCHAR2 ( 1000 );   v_category_id        NUMBER ;     v_category_set_id    NUMBER ;     v_inventory_item_id  NUMBER ;     v_organization_id    NUMBER ;   v_context            VARCHAR2 ( 2 );   FUNCTION set_context ( i_user_name    IN   VARCHAR2                        , i_resp_name    IN   VARCHAR2                        , i_org_id       IN   NUMBER )   RETURN VARCHAR2   IS   BEGIN   NULL; -- In order to reduce the content of the post I moved the implementation part of this function to another post and it is   available   h e r e       END set_context ;   BEGIN v_context := set_context ( '&user' , '&responsibility' , 2038 ); IF v_context = 'F'    THEN    DBMS_OUTPUT . put_line ( 'Error while setting the context' ); END IF; --- context done ------------ v_category_id        := 13125 ;   v_category_set_id    := 1 ; v_inventory_item_id  := 66003 ; v_organization_id    := 103 ; INV_ITEM_CATEGORY_PUB . DELETE_CATEGORY_ASSIGNMENT         (   p_api_version        => 1.0 ,              p_init_msg_list      => FND_API . G_TRUE ,              p_commit             => FND_API . G_FALSE ,              x_return_status      => v_return_status ,              x_errorcode          => v_errorcode ,              x_msg_count          => v_msg_count ,              x_msg_data           => v_msg_data ,              p_category_id        => v_category_id ,              p_category_set_id    => v_category_set_id ,              p_inventory_item_id  => v_inventory_item_id ,              p_organization_id    => v_organization_id ); IF v_return_status = fnd_api . g_ret_sts_success THEN     COMMIT;     DBMS_OUTPUT . put_line ( 'The Deletion of category assignment is Sucessfull : ' ||v_category_id ); ELSE     DBMS_OUTPUT . put_line ( 'The Deletion of category assignment failed:' ||v_msg_data );     ROLLBACK;     FOR i IN 1 .. v_msg_count     LOOP       v_msg_data := oe_msg_pub . get ( p_msg_index => i , p_encoded => 'F' );       dbms_output . put_line ( i|| ') ' || v_msg_data );     END LOOP ; END IF; END;

Do you think this Article is useful?

1 Responses to “API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT)”

Good to know it is not read protected.

Post a Comment

Stay connected.

Popular Posts

• Query to fetch Purchase Receipt and its related Purchase order, Vendor details in Oracle Apps R12 (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES)
• Query to Fetch Employee Details in Oracle Apps R12 (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_ALL_POSITIONS, PER_PHONES)
• Query to get basic AP Invoice and Payment information from Oracle Apps R12
• WSH_DELIVERY_DETAILS.RELEASED_STATUS ( Pick Release Status)
• Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)
• How to find Order types in R12 (Script for Order types)
• How to get Oracle Application User Password from database - oracle.apps.fnd.security.WebSessionManagerProc.decrypt
• Query to fetch Purchase Requisition, BPA, Purchase Order and Vendor Details in Oracle Apps R12 (PO_REQUISITION_HEADERS_ALL, PO_HEADERS_ALL)
• Query To Fetch Customer Account/Site Contact Details in R12
• Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v

Blog Archive

shareoracleapps.com

Site Stats (Last 30 Days)