Best Of
Re: Dual Unit of measure for non stock part without maintaining the UoM conversions
From Oracle Support: thank you for the post Balaji.
This is working as I would expect - if the system cannot locate any conversion, then it cannot calculate the appropriate values. I tested here with an EA to CA Primary/Secondary, and with no conversion, when I raise an order with 4EA and 1 CA, it reverts the CA value to 4, the same as the EA. The same results you see.
If you do not want an item-based conversion, can you set a standard conversion (P41003) for the Meter/JT ?
WIth regards,
-Matt
Re: Configuring Data Guard Redo Transport on separate network.
Unless you use the GRID Infrastructure to manage the listener associated with the second network, you will need to implement the second network using VIP's.
Re: Why EXPDP suddenly takes too long than usual? How to resolve this?
Hello,
Please follow next steps
- Configure stream_pool_size, e.g. set streams_pool_size (the internal mechanism of Data Pump is using streams ) I would recommend setting the STREAMS_POOL_SIZE to the value returned by the result set of the following query.
select 'ALTER SYSTEM SET STREAMS_POOL_SIZE='||(max(to_number(trim(c.ksppstvl)))+67108864)||' SCOPE=SPFILE;'
from sys.x$ksppi a, sys.x$ksppcv b, sys.x$ksppsv c
where a.indx = b.indx and a.indx = c.indx and lower(a.ksppinm) in ('__streams_pool_size','streams_pool_size');
- Collect Dictionary Statistics:
SQL> connect / as sysdba
SQL> exec dbms_stats.gather_dictionary_stats;
SQL> exec dbms_stats.lock_table_stats (null,'X$KCCLH');
SQL> exec dbms_stats.gather_fixed_objects_stats;
- then stop the current impdp and eliminate the orphaned data pumps jobs as per steps from How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ? (Doc ID 336014.1)
- re-run the export adding the EXCLUDE=STATISTICS parameter. The statistics can be collected after the import will finish
Also please follow the recommendations from next document:
Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) (Doc ID 453895.1)
Best regards,
George
How can we restrict the Price once the modifier is applied.
Hi,
Scenario:
There are 3 lines on a sales order with the same item with different schedule ship date.
A modifier is applied on a sales order lines and the price is modified accordingly based on the qty ordered. Two lines got shipped to customer.
Price is getting changed when the user tries to decrease the qty on the third line.
Could you help in restricting the change in price as the customer wants the order lines to be shipped on the price applied by a modifier.
Billing - Adjust Entire Bill
Hello,
Im trying to adjust a entire bill and when after entering the details under Adjust Entire bill page, im able to see the adjustment bill Id under "Bill Inquiry" page after this what are the steps to post the entry to GL ?
Im looking to create a reversal of the original bill and post it to GL
Thanks
Re: ORA-01403: no data found in bulk collect
Hi User_D9VNV,
The "ORA-01403: no data found" is raised probably because no record is found at index position 3 of the collection variable 'test_head_stg' while the INSERT is executed.
You have accidentally used same index variable('i) for accessing the elements from both 'test_head_stg' and 'test_cur_stg' inside the INSERT INTO VALUES statement. The test_cur_stg.COUNT() returns 3 implies there exists three records in test_cur_stg but the same may not be true for 'test_head_stg'.
Use different index variable for accessing the elements from the collection variables 'test_head_stg' and 'test_cur_stg'. This should fix the problem.
Thanks,
Kaushik.
Re: ORA-01403: no data found in bulk collect
Hi,
It seems you're using the same variable "i" for browsing 2 different cursors:
VALUES
(test_head_stg(i).run_id,
lv_invoice_id_seq,
test_cur_stg(i).LINE_NUMBER,
So it probably fails when trying to access test_head_stg(i).
I suggest you use different name to avoid confusion (i and j for example).
Some remarks:
- you're using a LIMIT clause so I expect to see 2 loops : one main to browse the whole dataset, one inner to browse the LIMITed data
- Instead of using single INSERT statements, use a FORALL instructions.
GregV
Re: Secure 2.0 Act - PeopleSoft Enterprise HCM - PUM 47
Hi there-are there any updates on enhancements for section 603 of the SECURE Act 'Age 50 Catch-Up Contributions Must be Roth for Certain Participants'?
MaraLCRA
Re: What is the purpose of the offer expiration date?
Hi,
Yes, when the offer has expired based on the date, the offer becomes Display Only so you cannot keep using it or accept it. For reference on the Job Offer page fields, please see PeopleBooks at:
Regards,
Ben
Re: How can we specify a particular e-mail id in the FROM and BCC Address in JDE.
Hi
When using standard JDE functionality, e.g. Message requests, BIP, etc, the "From" email address is taken from the Email Configuration settings in Server Manager for the Enterprise Server:
To get around the issue of not being able to specify the "From" address in a Message request and to be able to add attachments to the email (our TR version didn't allow it) I wrote a SendEmail Custom script which:
- Accepts parameters for email addresses, subject, content, attachment and mime types
- Allows multiple to, cc and bcc addresses separated by a comma
- Overrides email addresses and subject if running in non-PD environment
- Connects to SMTP Relay server
- Attaches any attachment prior to sending the email
I then use a separate Custom script to set the input variables and map them in the script transformations.
Cheers
Jonathan
MasonJo