Hi,I am looking for a procedure that will refresh the plsql security. Unfortunately, the following entry adds or edits a row in the cache_management_tab table.Begin CACHE_MANAGEMENT_API.Refresh_Cache ('Security');END;
Thank you very much. That was exactly what it was about.
Hi,How to properly configure so that if the customer exceeds the credit limit, the customer's order will be blocked or a notification will be displayed.
Thank you for the information. They are clear at this stage. However, I am missing something. I filled in the credit details of PLN 1 and was still able to issue customer orders.
Thank you very much everyone. That's exactly what it was about. I have one more question. Where you can set permissions to unlock a customer's over-limit order.
All clear. Thank you for your time and knowledge.
This is what I was looking for. Thank you very much.
Not a transaction code. How to find inventory transactions (transaction_id) with sales invoice number?
There is no direct connection. You can go via OUTSTANDING_SALES to CUSTOMER_ORDER_DELIVERY. But to explain more in detail, what is the purpose for doing this? What are you trying to achieve? Thank you, that was it. I didn't notice the source_ref5 = deliv_no binding. Goal achieved, having the invoice number I can identify warehouse transactions. select * from INVENTORY_TRANSACTION_HIST2 ithleft join CUSTOMER_ORDER_DELIVERY cod on source_ref5=cod.deliv_noleft join OUTSTANDING_SALES os on os.deliv_no=cod.deliv_noleft join CUST_ORDER_INV_ITEM_UIV_ALL coi on os.invoice_id=coi.invoice_id and os.item_id=coi.item_idwhere coi.invoice_id='358073' and coi.item_id like '%'
Ok, thank you, this is the second place, but the "Reference" field in our database is empty in all clients. Despite this, the system completes the default value on the invoice.
Thank you for your tips.I found. The field retrieves the value from the customer order / Coordinator. I have corrected the default values in Sites per User.
Already have an account? Login
No account yet? Create an account
Enter your 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.
