Hi GuysI’ve created a Custom api (using PLSQL Developer) and trying to setup a Database Task Schedule using same. Normally, i create DB task using PLSQL developer only but this time change of approach and thought of trying Schedule DB task.Following below process:Created a Package and made sure it got Module_ and lu_name_ declared within header (as suggested by @durette )Step 1: create or replace package CB_MS_LEVEL_1_API is module_ CONSTANT VARCHAR2(25) := 'FNDBAS'; lu_name_ CONSTANT VARCHAR2(25) := 'CbMsLevel1Api';Step 2: Refreshed the Dictionary CacheStep 3: Granted access to ifssys as well as to public GRANT EXECUTE ON cb_ms_level_1_api TO ifssys;Step 4: Granted access to FND_USER BEGIN security_sys.grant_package('cb_ms_level_1_api','FND_ENDUSER'); END;Still when re-logged into IFS and checked Task Name within New Database Task Schedule i can’t trace the api.What am i missing, any suggestions? Thanks in advan
Hi Everyone,Wondering if someone can help me with a migration job issue.I am trying to update a field within a Custom page. In below screenshot I need to update last column called Exported as YES (which can be a Custom enumeration or simple text). Please note, there can be multiple rows. Jobs worked absolutely fine when there is only one row. But if more than one, it’s throwing below error:Below are the Job details: Question is what to update in the job to modify same Column on multiple rows? Above example I tried on Apps9 environment. Thanks in advance/D
Hi Guys Wondering if someone can help me with a data migration query.Scenario:As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery and Document which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE) Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below) Migration job works fine and creates first default value i.e. Pay But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice? Thanks in advance/D
Hi All,Does anyone knows if there any limitation on number of rows we can add under DB/Client value within Custom enumeration please?I know it’s not advisable to use lengthy lists but just wondering about the limitation. Started getting below after certain rows: ThanksDinesh
Hi folks,Wondering if anyone can help with an api grant issue i‘m stuck with? Created few procedures within a package on test db, one named as drop_table_ as below (meant for deleting a temporary table content, not dropping as name suggest )Create or replace package body CB_SALES_QUOTATION_API is procedure drop_table_ IS Begin EXECUTE IMMEDIATE 'DELETE FROM ifsapp.CB_NOTE_TEXT_TAB where CF$_NOTE_TEXT is not null'; end drop_table_;Executing this package via Custom menu rmb which works well with IFSAPP schema .But when i tried executing as a end user i get below message: So far:Granted Package access to the user: Grant execute on ifsapp.CB_SALES_QUOTATION_API to XXX; Also, Grant execute on ifsapp.CB_SALES_QUOTATION_API to PUBLIC;Granted table access to the user: Grant all on ifsapp.CB_NOTE_TEXT_TAB to XXX; Re-logged in as user but still getting above error message on IFS.Strangely, when i use PLSQL dev,logged in as same user i can execute the api and als
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.