Hello,I have a problem with the integration of some data from an Oracle database into IFS. I have succeeded to insert information about supplier into SUPPLIER_INFO_GENERAL table, but fail to do so for IDENTITY_INVOICE_INFO.The error i get is : Catch : ORA-20110: Group 0 does not exist.On the other hand i have group 0 both in tables INVOICE_SUPPLIER_TYPE_GROUP and INVOICE_PARTY_TYPE_GROUP_TAB Any idea please ?
Hello All, I want to create a custom read-only field on the lines of the "Purchase order delivery status" screen (Procurement > order > Analysis > Purchase order delivery status, ( see attachement below ) to display the Receipt Note corresponding to each line (content of the Note field of the "Receipt" screen) (see attachement ). The screen where we have to get the information notes: If there are multiple receptions for the same line, the different notes will be separated by a semi-colon . I have tested a select query but it didn’t work, should i pass by Pl-SQL in this case ? Thank you.
Hello ALL We are working on a migration ERP TO IFS , and we have to migrate our tables to IFS . For example for suppliers , we shoud migrate all the informations we have in the actual ERP into all the tabs on IFS and the under tabs. But i don’t know the order of logical units to follow to migrate infomations for suppliers ? please someone knows how we can get the order of migration of the logical units ? : The first one we shouls start with , the second , third . . . , because informations are linked. Thank you so much.
HELLO it’s first time i create a lobby, and i need help please. The need is to create a lobby displaying the list of purchase requisitions to be processed by a Buyer ( approvisionneur) This lobby will allow you to access the relevant requisition lines with a click. Thank you in advance
Hello All I have granted acces on a permisseion set that i have created with only Gant query ( view only) ( in projects). But when i go to check the gants in the concerned screen, i found that i can modify too. IS it an IFS bug ? Someone has already have this problem ? ( i notice that i granted FND_ENDUSER, FND_CONNECT with this permission set ) Thank you ,
Hello everyone I have updated the purchase Order view by error , and the rowkey Activited is not checked also Prompt has been updated, It is an error due to this SQL Request : ( the error is in the end of the request on comment on table “'LU=PurchaseRequisition^PROMPT=*lobby IFS-83^TABLE=SAV_PURCHASE_REQUISITION^MODULE=PURCH^';”) , LU is SAV_PURCHASE_REQUISITION and not PURCHASE_REQUISTION) CREATE OR REPLACE VIEW SAV_PURCHASE_REQUISITION ASSELECTCOUNT(*)OVER(PARTITION BY requisitioner_code, objstate) AS nombre,requisition_no,requisitioner_code,objstateFROMpurchase_requisitionWHEREobjstate = 'Released'AND requisitioner_code NOT IN ( 'INV', 'MRP', 'OE', 'INT', 'MS','WO' )ORDER BYrequisitioner_code ASC,objstateWITH READ ONLY; COMMENT ON TABLE "IFSAPP"."SAV_PURCHASE_REQUISITION" IS 'LU=PurchaseRequisition^PROMPT=*lobby IFS-83^TABLE=SAV_PURCHASE_REQUISITION^MODULE=PURCH^'; does someone know how to initialize the LU PURCHASE_REQUISTION PLEASE ? Thank you in Advance.
Hello Please i want to know if we can Create a lobby via Query Builder usint a count ? Because i didn’i found how to do a count Using SQL, so it is possible to create it using Query Builder ? Thank you.
Hello I created a custom field in Suppliers screen, and i want to make it Unique, is it possible ? Thank you
Hello Please anyone knows how can we sychronize data in a custom LU ? does someone here use ARMONY DATA to migrate datas? Thank you
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.