Home » Applications » Oracle Fusion Apps & E-Business Suite » Failed to Create Supplier in Oracle EBS using API (3 merged)
Failed to Create Supplier in Oracle EBS using API (3 merged) [message #684570] Wed, 30 June 2021 05:24 Go to next message
QT
Messages: 3
Registered: June 2021
Junior Member
Hi,

We are using R12.2.9 and trying to create supplier by using API.

I have tried to call the API AP_VENDOR_PUB_PKG.create_vendor or pos_vendor_pub.Create_Vendor for creating a supplier but always failed with 36 errors. Please advise if anyone has idea how to resolve it.

If I login with same responsibility and user in system, I can create the supplier without any issue. However, I cannot do it by calling the API. However, I tried to update the Vendor API is work fine but just not work for create vendor API.

Here is the error after running the attached Create Vendor API in sql/develoepr.
1. The API call failed with error You must specify a valid, enabled currency.
2. The API call failed with error Invoice Currency is invalid
3. The API call failed with error ONE_TIME_FLAG is invalid
4. The API call failed with error One Time flag is invalid
5. The API call failed with error SUMMARY_FLAG is invalid
6. The API call failed with error Summary flag is invalid
7. The API call failed with error ENABLED_FLAG is invalid
8. The API call failed with error Enabled flag is invalid
9. The API call failed with error PAY_DATE_BASIS_LOOKUP_CODE is invalid
10. The API call failed with error Pay Date Basis is invalid
11. The API call failed with error PAY_GROUP_LOOKUP_CODE is invalid
12. The API call failed with error Pay Group is invalid
13. The API call failed with error TERMS_DATE_BASIS is invalid
14. The API call failed with error Terms Date Basis is invalid
15. The API call failed with error FEDERAL_REPORTABLE_FLAG is invalid
16. The API call failed with error Federally Reportable flag is invalid
17. The API call failed with error AUTO_CALCULATE_INTEREST_FLAG is invalid
18. The API call failed with error Auto Calculate Interest flag is invalid
19. The API call failed with error EXCLUDE_FREIGHT_FROM_DISCOUNT is invalid
20. The API call failed with error Exclude Freight from Discount flag is invalid
21. The API call failed with error HOLD_UNMATCHED_INVOICES_FLAG is invalid
22. The API call failed with error Hold Unmatched Invoice flag is invalid
23. The API call failed with error HOLD_FLAG is invalid
24. The API call failed with error Hold flag is invalid
25. The API call failed with error SMALL_BUSINESS_FLAG is invalid
26. The API call failed with error Small Business flag is invalid
27. The API call failed with error WOMEN_OWNED_FLAG is invalid
28. The API call failed with error Women Owned flag is invalid
29. The API call failed with error HOLD_FUTURE_PAYMENTS_FLAG is invalid
30. The API call failed with error Hold Future Payments flag is invalid
31. The API call failed with error HOLD_ALL_PAYMENTS_FLAG is invalid
32. The API call failed with error Hold All Payments flag is invalid
33. The API call failed with error ALWAYS_TAKE_DISC_FLAG is invalid
34. The API call failed with error Always Take Discount flag is invalid
35. The API call failed with error TERMS_ID is invalid
36. The API call failed with error Payment Term is inconsistent



[Updated on: Wed, 30 June 2021 05:46]

Report message to a moderator

Failed to Create Supplier in Oracle EBS using API [message #684571 is a reply to message #684570] Wed, 30 June 2021 05:45 Go to previous messageGo to next message
QT
Messages: 3
Registered: June 2021
Junior Member
Hi,

We are using R12.2.9 and trying to create supplier by using API.

I have tried to call the API AP_VENDOR_PUB_PKG.create_vendor or pos_vendor_pub.Create_Vendor for creating a supplier but always failed with 36 errors. Please advise if anyone has idea how to resolve it.

If I login with same responsibility and user in system, I can create the supplier without any issue. However, I cannot do it by calling the API. However, I tried to update the Vendor API is work fine but just not work for create vendor API.

Here is the error after running the attached Create Vendor API in sql/develoepr.
1. The API call failed with error You must specify a valid, enabled currency.
2. The API call failed with error Invoice Currency is invalid
3. The API call failed with error ONE_TIME_FLAG is invalid
4. The API call failed with error One Time flag is invalid
5. The API call failed with error SUMMARY_FLAG is invalid
6. The API call failed with error Summary flag is invalid
7. The API call failed with error ENABLED_FLAG is invalid
8. The API call failed with error Enabled flag is invalid
9. The API call failed with error PAY_DATE_BASIS_LOOKUP_CODE is invalid
10. The API call failed with error Pay Date Basis is invalid
11. The API call failed with error PAY_GROUP_LOOKUP_CODE is invalid
12. The API call failed with error Pay Group is invalid
13. The API call failed with error TERMS_DATE_BASIS is invalid
14. The API call failed with error Terms Date Basis is invalid
15. The API call failed with error FEDERAL_REPORTABLE_FLAG is invalid
16. The API call failed with error Federally Reportable flag is invalid
17. The API call failed with error AUTO_CALCULATE_INTEREST_FLAG is invalid
18. The API call failed with error Auto Calculate Interest flag is invalid
19. The API call failed with error EXCLUDE_FREIGHT_FROM_DISCOUNT is invalid
20. The API call failed with error Exclude Freight from Discount flag is invalid
21. The API call failed with error HOLD_UNMATCHED_INVOICES_FLAG is invalid
22. The API call failed with error Hold Unmatched Invoice flag is invalid
23. The API call failed with error HOLD_FLAG is invalid
24. The API call failed with error Hold flag is invalid
25. The API call failed with error SMALL_BUSINESS_FLAG is invalid
26. The API call failed with error Small Business flag is invalid
27. The API call failed with error WOMEN_OWNED_FLAG is invalid
28. The API call failed with error Women Owned flag is invalid
29. The API call failed with error HOLD_FUTURE_PAYMENTS_FLAG is invalid
30. The API call failed with error Hold Future Payments flag is invalid
31. The API call failed with error HOLD_ALL_PAYMENTS_FLAG is invalid
32. The API call failed with error Hold All Payments flag is invalid
33. The API call failed with error ALWAYS_TAKE_DISC_FLAG is invalid
34. The API call failed with error Always Take Discount flag is invalid
35. The API call failed with error TERMS_ID is invalid
36. The API call failed with error Payment Term is inconsistent
Failed to Create Supplier in Oracle EBS using API [message #684572 is a reply to message #684570] Wed, 30 June 2021 05:46 Go to previous message
QT
Messages: 3
Registered: June 2021
Junior Member
Hi,

We are using R12.2.9 and trying to create supplier by using API.

I have tried to call the API AP_VENDOR_PUB_PKG.create_vendor or pos_vendor_pub.Create_Vendor for creating a supplier but always failed with 36 errors. Please advise if anyone has idea how to resolve it.

If I login with same responsibility and user in system, I can create the supplier without any issue. However, I cannot do it by calling the API. However, I tried to update the Vendor API is work fine but just not work for create vendor API.

Here is the error after running the attached Create Vendor API in sql/develoepr.
1. The API call failed with error You must specify a valid, enabled currency.
2. The API call failed with error Invoice Currency is invalid
3. The API call failed with error ONE_TIME_FLAG is invalid
4. The API call failed with error One Time flag is invalid
5. The API call failed with error SUMMARY_FLAG is invalid
6. The API call failed with error Summary flag is invalid
7. The API call failed with error ENABLED_FLAG is invalid
8. The API call failed with error Enabled flag is invalid
9. The API call failed with error PAY_DATE_BASIS_LOOKUP_CODE is invalid
10. The API call failed with error Pay Date Basis is invalid
11. The API call failed with error PAY_GROUP_LOOKUP_CODE is invalid
12. The API call failed with error Pay Group is invalid
13. The API call failed with error TERMS_DATE_BASIS is invalid
14. The API call failed with error Terms Date Basis is invalid
15. The API call failed with error FEDERAL_REPORTABLE_FLAG is invalid
16. The API call failed with error Federally Reportable flag is invalid
17. The API call failed with error AUTO_CALCULATE_INTEREST_FLAG is invalid
18. The API call failed with error Auto Calculate Interest flag is invalid
19. The API call failed with error EXCLUDE_FREIGHT_FROM_DISCOUNT is invalid
20. The API call failed with error Exclude Freight from Discount flag is invalid
21. The API call failed with error HOLD_UNMATCHED_INVOICES_FLAG is invalid
22. The API call failed with error Hold Unmatched Invoice flag is invalid
23. The API call failed with error HOLD_FLAG is invalid
24. The API call failed with error Hold flag is invalid
25. The API call failed with error SMALL_BUSINESS_FLAG is invalid
26. The API call failed with error Small Business flag is invalid
27. The API call failed with error WOMEN_OWNED_FLAG is invalid
28. The API call failed with error Women Owned flag is invalid
29. The API call failed with error HOLD_FUTURE_PAYMENTS_FLAG is invalid
30. The API call failed with error Hold Future Payments flag is invalid
31. The API call failed with error HOLD_ALL_PAYMENTS_FLAG is invalid
32. The API call failed with error Hold All Payments flag is invalid
33. The API call failed with error ALWAYS_TAKE_DISC_FLAG is invalid
34. The API call failed with error Always Take Discount flag is invalid
35. The API call failed with error TERMS_ID is invalid
36. The API call failed with error Payment Term is inconsistent
Previous Topic: Upgrade Process from R12.1.3 with 19c upgrade to R12.2.
Next Topic: Create .ldt for registering concurrent in request group
Goto Forum:
  


Current Time: Wed Dec 08 16:51:15 CST 2021